PowerPoint 2016 - Insert Excel in PPT - How to Link Sheet in Presentation - Create & Add Attach File
HTML-код
- Опубликовано: 19 авг 2024
- This Microsoft PowerPoint 2016 tutorial shows you how to embed and link MS Excel 365 content into your PowerPoint Presentation Slides. I also show you the difference between embedding and linking content and how you're able to edit and update the data.
Here is a full list of tutorial videos available on my channel:
Windows 10:
Perform Basic Mouse Operations
Create Folders
Explore the Windows 10 Desktop, Taskbar, and Start Menu
Select Multiple Files and Folders
Download a File From a Website
Use File Explorer to Access OneDrive and Upload Student Data Files
Capture an Image of the Entire Screen
Explore the Control Panel and the Settings App
Personalize the Desktop
Modify Screen Brightness and Resolution
Explore the Control Panel and the Settings App
Personalize the Desktop
Adjust the Sound
Plan the Organization of Files and Folders
Run an App
Word 2016:
Create a New Document and Insert Text
Insert and Format Graphics
Insert and Modify Text Boxes
Create a Table
Format a Table
Present a Word Document Online
Create a Research Paper in MLA Format
Insert Footnotes in a Research Paper
Create Citations and a Bibliography
Save a Document
Correct Errors as You Type
How to Format a Document in APA Format
Convert Word Document to a PDF File
Microsoft Office Specialist Certification Exam Practice Study Guide
APA Format from Default Formatting
Table of Contents Tutorial
Format Paragraphs
Create a Custom Word Template
Preview and Print a Document
Change Document and Paragraph Layout
Use AutoComplete and AutoCorrect
Correct and Reorganize Text
Header and Footer Tutorial
Page Numbers Tutorial
Captions in Word
Review Document Headings in the Navigation Pane
Reorganize Document Text Using the Navigation Pane
Collapse and Expand Body Text in a Document
Use Continuous Section Breaks for Page Layout
Insert Page Numbers Starting from a Specific Page
Format Text
Undo and redo Commands or Actions
Modify a Style
Excel 2016:
Create, Save, and Navigate an Excel Workbook
Enter Data in a Worksheet
How do you Export Access to Excel and Apply Conditional Formatting
Use Flash Fill, SUM, Average, Median, and MAX Functions and Formulas
Move Data and Rotate Text
Graph Data with a Pie Chart
Format a Pie Chart
MOS Prep - Basic Certification Exam Practice Study Guide
Change Fonts, Font Style, and Font Color
The NOW Function
Export Excel Spreadsheet to Access Table
The VLookup Function
The MIN or MINIMUM Function
Histogram Charts
Use the Sum Button to Sum a Range of Cells
Enter Formulas Using the Keyboard
Format Cells with Merge & Center, Cell Styles, and Themes
Chart Data to Create a Column Chart & Insert Sparklines
Select Cells and Ranges
Use CountIF and IF Functions and Apply Conditional Formatting
Use Date &Time Functions and Freeze Panes
Use Goal Seek to Perform What-if Analysis
Add Fill Colors and a Background Image
Insert Functions from the Formula Library
Use the PMT Function to Calculate a Loan Payment
Describe the Excel Worksheet
Enter Formulas Using Point Mode
Access 2016:
Identify Good Database Design
Create a Table and Define Fields in a Blank Desktop Database
The Primary Key
Import Excel Spreadsheet into Access
Create a Table in Design View
Modify the Structure of a Table
Create a Subform
MOS Prep - Basic Certification Exam Practice Study Guide
Add Existing Fields to a Form
Create a Query, Form, and Report
How To Use the Property Sheet
Open and Save an Existing Database
Create Table Relationships
Learn Basic Database Concepts and Terms
Create and Use a Form to Add and Delete Records
Learn the Guidelines for Designing Databases and Setting Field Properties
Find, Modify, and Delete Records in a Table
Create a Form Using the Form Wizard
PowerPoint 2016:
Create a New Presentation
Edit a Presentation in Normal View
Add Pictures to a Presentation
Format Numbered and Bulleted Lists
Customize Slide Backgrounds and Themes
Animate a Slide Show
Apply a Theme Used in Another Presentation
Search for and Download an Online Theme
Microsoft Office Specialist Exam Certification
Print and View a Presentation
Lighten Background Images in Microsoft Office
Edit an Existing Presentation
Insert Online Pictures
Create a Title Slide and Slides With Lists
Select and Change a Document Theme and Variant
Insert and Format Pictures
Insert Shapes
Insert a Video
Outlook 2016
Basic Tutorial
Office 2016:
Identify the Components of the Microsoft Office Ribbon
Computer Fundamentals:
Computer Case Types - Dell Inspiron AMD 3656
Printer Ports and Types
The Boot Up Process
How to Get Your Computer Questions Answered
Undo Your Mistakes on Windows 10 or Apple Mac
Routers vs. Modems
What is the Cloud? Storage as a Service
Types of Internet Services on Google Android or Apple iPhone
Browsing the Web
Why Use the Cloud?
Microsoft OneDrive - Creating Uploading Downloading and Syncing
Explain the Importance of File Management
Troubleshoot Common Computer Problems
Microsoft Publisher 2016 Full Playlist
I have been looking for someone to explain PowerPoint and I finally found you. The first impression that makes me want to watch more is how quickly you dive into an explanation. No need to ramble on and beat about the bush. I appreciate that and the way you also focus on the screen instead of yourself as you speak. Great job! I will save your info and look forward to learning more from you.
Adam, you are made to mentor. Super clear, calm, professional, - great information. Thanks for the knowledge it's appreciated. My end of month reports will become far less of a chore now!
I have to make several management presentations... never new my life can be so easy by this amazing option... thanks man YOUR'E AWESOME
I'm glad this will help you out with your presentations, Farhan. Thank you for watching and have a great day.
This is fantastic. I never leave comments but this is a game changer for my ppts, many thanks
Hey thanks for commenting, I appreciate it Karl.
I can't believe this video has been seen more than 300K, I thought there was sth special about it
After a long time here come my savior. Thanks sir for the content. Really help me alot. God bless you.
Awesome Video Adam... Made my work simple and easy... the way u explained the problem and how to overcome is awesome in the video
Glad it helped! Thanks for watching, Pranay.
God Bless You Brother. I went through so many ridiculous videos before chancing upon your video ... to the point and precise. Great work !!! 👌👏👍
Thank you so much. It was so helpful. I'm unable to express how helpful it was to me!
You my friend, are a dead set fucking legend...I don't want to begin telling you how complicated everyone makes it out to be (and trust me, I've tried them all over 4 years!) only to find they don't work and you have just nailed it in a simple fucking format...AND IT FUCKING WORKS!!!....Mate you deserve the woman (or man) of your dreams and your balls should be coated in gold!....(On second thoughts, that wouldnt be that comfortable)...maybe just the girl (or guy)
Hey Investor HQ,
I am glad this video helped you out, I'm sorry it took so long to find. I appreciate the kind words, have a great day and thanks for watching!
Thanks for this tip! I used it in a PowerPoint template my whole office will use.
Before watching this i thought it is difficult now its super. Easy
Thank you
Thank you professor! Initially i didn't like the video, but later i got a better understanding. Thanks for being so detailed!
Simple and easy advice. Thanks Adam.
Glad you liked it!
Very helpful...I'm glad I watched it
I like that you get into the point right away,
Thank you. Learned something to help some one because of your video tutorial.
I swear I watch this video at least 4 times every year.
Brain just exploded. Thank you for this! You walk on water my friend.
Your video is a mind blowing discovery for me. Your video is saved, pinned shared and absolutely loved. Thanks alot!!
Probably an old thought (just ran across your tutorial)... You can set print area in excel before you insert as an object, thus avoiding the cropping ~ at least it worked for me. And I'm an idiot. thanks.
Very helpful. Just solved my problem on my mobile phone Powerpoint. Thank you very much, Adam.
I learn more from this professor than my own😅😂
This was very helpful! I was able to help a coworker with this info.
I have seen complete video. It is very informative and useful to me. But add into it "How to embed excel sheet data" into it so that it is complete literature for beginners
Thank you for watching, Dipak. I appreciate it!
Thank You Prof. Adam, I am from Bangaladesh.
Last option, very useful 👌🏾
WOOOO. .........You'RE great brother....thanks for sharing valuable point with us.
No problem, Shivam. Thanks for watching!
Really thank you for the useful knowledge.
That was really helpful! Thanks Adams!
THANK YOU! Super helpful "paste special" tip!
Good explanation given there.
You are the best my friend
Thank you for watching, Shakti!
Awesome!! this helps me so much with my presentation for my school work. you are an amazing teacher!!!
Thanks dear you are simply awesome
So nice of you, thanks for watching!
duuuuuuude you just made my life so much easier
You deserve a thumbs up
make more videos like this please, they are so helpful. Thank you
Very very much helpful. Thank you for doing this kind of content!
Excellent. Thank you.
Glad you enjoyed it! Thanks for watching, Oyeoluwa.
This is very useful, many thanks..!!
So cool! We have a formal cycle of presentations needing annual updates. Until now, we've been copy+pasting to build new static tables every time. This will save me a ton of time - thank you!
Hi Morgan... Great work which made my life easier... Thanks a lot!
what a great tutorial you made. thank a million!
Glad you enjoyed it! Thanks for watching, Jarco!
Thank you professor . Awesome .This video is Very helpful for me .
thank you so much, It's very helpful
so helpful!!! million thanks
Great super quick tutorial!
Glad you liked it. Thank you for watching!
Very helpful!!!! THANK YOU :)
So helpful. Glad I landed on your channel. New subbie :)
This is exactly what I needed! Thank you, Thank you Thank you
omG! makes life so easier....thank you thank you
You're welcome! Thanks for watching, Maud!
Thanks. Very helpful.
Excellent video! Thanks for sharing, Adam.
Thank you for watching, Andrei. I appreciate it!
Thanks for helping !!
Happy to help! Thank you for watching!
wow...super thanks...very helpful
You are a legend.
thank you !!!!! from ontario California
Thanks for watching! I appreciate it, Gus!
To link from excel to PP this is how I always have done it. BUT now it doesn't give you the alternative "Link" on Mac Office??
Thanks for the video!
Clear straight to the point
Awesome. Linking tables was hard to find.
I'm glad this video was able to help you out. Sorry it was hard to find, hopefully it'll populate higher in the searches one day.
Thank you so much brother. This was so helpful for me to update my reports.
This was super helpful
Glad it was helpful! Thanks for watching, Edward.
Thanks, Adam!
thank helped me a lot thank you thank you thank you thank you thank you
wow thanks a lot. u made my day
Was super helpful.
Glad it was helpful! Thanks for watching.
Great!! Thank you for sharing your knowledge...
My pleasure! Thank you for watching, Gustavo!
Thank you. This video is very helpful.
Very helpful!
Great video! Clear and helpful.
thank you so much prof, i might need this later!
Very Helpful
How do you insert a Shared Excel in PPT. You video showed how to insert just a standard excel file.
Thank you Sir!
Thank you so much.
Jesus bless you my friend!! Thank You!
Thank you for the video, which was very useful…but I personally have the problem the Excel resize in powerpoint does not really work, since I cannot read the fonts, and theye ven look “stretched”…what is the work around for this issue?
Problem solved. Thank you so much!
Glad it helped! Thanks for watching, Jacquelyn.
Really good!!
Thanks!!
Glad you like it! Thanks for watching, Emanuel.
hi excellent video tutorial , however can you please guide if the embedded object can be edited after saving as standalone ppt
a lot of thanks
No problem, Pankaj! Thank you for watching!
Execellent tutorials
Excellent video, thank you. One question. I have a table in Excel with a slicer that I want to paste and link in Powerpoint. Is there any way I can bring the slicer into Powerpoint so that I can manipulate the table showing in the PowerPoint presentation? i.e. have the table and slicer in PowerPoint and change the table using the slicer!
Thanks a lot Adam.
My pleasure!
Thank you very much
Lot's of love dear.....
Thanks a million
Great content !!!
Super helpful! Thank you so much!
How do you create your presentations? I like to see the camera while you move from one software to another. I would like to create similar presentations. The one object that I could not link and edit was an Autocad file. From a larger cad file I made several smaller with specific windows and I zoom to extents prior to saving. In PP I inserted the cad object and it shows the right link but open its own cad that I can edit but it is not the one that I had saved originally. I asked about this topic in an architectural group and nobody had an answer. Only delete and reinsert.
Thanks for your video. I was able to do what I needed for my homework today. Good to have short and specific videos.
Hi Gilberto,
I use a program called OBS (Open Broadcast Software) to do all of my videos. It's free and easy to use. I hope that you enjoy using it. Thank you for watching my video, and have a nice day.
Excellent. Appreciate you. Thanks a million. :-)
Glad it helped! Thanks for watching, Elaare!
thank you for this. this is brilliant
is there a way to maintain font formatting?
want to follow brand guidlines in it
great help thanks alot
Thank you!
Hi there! This was a great video! I do have a question. Is there a way to set up parameters so that others can see the excel file once imbedded on power point but cannot edit or make changes to the file. Only I can make changes to the working document for the life of the project but others can just view?
Thanks- super helpful!
No problem Shayna, thank you for watching. I am glad you found it helpful.
thanks buddy
You're welcome! Thanks for watching.
Niceee !! Thanks for the video!!