About This Course
Course Curriculum
-
Use Links and External References00:12:00
-
Use 3-D References00:06:00
-
Consolidate Data00:05:00
-
Use Lookup Functions00:12:00
-
Trace Cells00:09:00
-
Watch and Evaluate Formulas00:08:00
-
Collaborate on a Workbook00:19:00
-
Protect Worksheets and Workbooks00:08:00
-
Apply Data Validation00:13:00
-
Search for Invalid Data and Formulas with Errors00:04:00
-
Work with Macros00:18:00
-
Create Sparklines00:07:00
-
MapData00:07:00
-
Determine Potential Outcomes Using Data Tables00:08:00
-
Determine Potential Outcomes Using Scenarios00:09:00
-
Use the Goal Seek Feature00:04:00
-
Forecasting Data Trends00:05:00
-
Integrate Pictures and Text00:15:00
-
Adjust Image Appearance00:09:00
-
Insert Other Media Elements00:02:00
-
Create Text Boxes and Pull Quotes00:06:00
-
Add WordArt and Other Text Effects00:05:00
-
Draw Shapes00:07:00
-
Create Complex Illustrations with SmartArt00:08:00
-
Prepare a Document for Collaboration00:09:00
-
Mark Up a Document00:06:00
-
Review Markups00:04:00
-
Merge Changes from Other Documents00:06:00
-
Add Captions00:06:00
-
Add Cross References00:08:00
-
Add Bookmarks00:05:00
-
Add Hyperlinks00:06:00
-
Insert Footnotes and Endnotes00:05:00
-
Add Citations and a Bibliography00:11:00
-
Suppress Information00:07:00
-
Set Formatting and Editing Restrictions00:06:00
-
Restrict Document Access00:02:00
-
Add a Digital Signature to a Document00:04:00
-
Create Forms00:09:00
-
Modify Forms00:03:00
-
Automate Tasks by Using Macros00:10:00
-
Create a Macro00:19:00
-
Customize the User Interface00:19:00
-
Set PowerPoint 2016 Options00:07:00
-
Modify Slide Masters and Slide Layouts00:16:00
-
Add Headers and Footers00:05:00
-
Modify the Notes Master and the Handout Master00:04:00
-
Create SmartArt00:09:00
-
Modify SmartArt00:05:00
-
Write Math Equations00:07:00
-
Add Audio to a Presentation00:09:00
-
Add Video to a Presentation00:10:00
-
Customize Animations and Transitions00:14:00
-
Review a Presentation00:15:00
-
Store and Share Presentations on the Web00:06:00
-
Annotate a Presentation00:07:00
-
Set Up a Slide Show00:08:00
-
Create a Custom Slide Show00:03:00
-
Add Hyperlinks and Action Buttons00:07:00
-
Record a Presentation00:05:00
-
Secure a Presentation00:11:00
-
Broadcast a Slide Show00:07:00
-
Create a Video or a CD00:08:00
-
Add Controls to Forms00:11:00
-
Enhance Navigation and Organization of Forms00:14:00
-
Apply Conditional Formatting00:04:00
-
Import Data into Access00:08:00
-
Export Access Data00:06:00
-
Link Tables to External Data Sources00:05:00
-
Create a Mail Merge00:02:00
-
Create a Macro00:08:00
-
Restrict Records by Using a Condition00:04:00
-
Validate Data by Using a Macro00:05:00
-
Automate Data Entry by Using a Macro00:04:00
-
Manage a Database00:08:00
-
Determine Object Dependency00:04:00
-
Manage a Database00:07:00
-
Document a Database00:04:00
-
Splitting a Database for Multiple User Access00:05:00
-
Implement Security00:03:00
-
Convert an Access Database to an ACCDE File00:04:00
-
Package a Database with a Digital Signature00:01:00
-
Create a Database Switchboard00:05:00
-
Modify a Database Switchboard00:02:00
-
Set Start up Options00:04:00