About This Course
Course Curriculum
-
Use Links and External References
00:12:00 -
Use 3-D References
00:06:00 -
Consolidate Data
00:05:00
-
Use Lookup Functions
00:12:00 -
Trace Cells
00:09:00 -
Watch and Evaluate Formulas
00:08:00
-
Collaborate on a Workbook
00:19:00 -
Protect Worksheets and Workbooks
00:08:00
-
Apply Data Validation
00:13:00 -
Search for Invalid Data and Formulas with Errors
00:04:00 -
Work with Macros
00:18:00
-
Create Sparklines
00:07:00 -
MapData
00:07:00
-
Determine Potential Outcomes Using Data Tables
00:08:00 -
Determine Potential Outcomes Using Scenarios
00:09:00 -
Use the Goal Seek Feature
00:04:00 -
Forecasting Data Trends
00:05:00
-
Integrate Pictures and Text
00:15:00 -
Adjust Image Appearance
00:09:00 -
Insert Other Media Elements
00:02:00
-
Create Text Boxes and Pull Quotes
00:06:00 -
Add WordArt and Other Text Effects
00:05:00 -
Draw Shapes
00:07:00 -
Create Complex Illustrations with SmartArt
00:08:00
-
Prepare a Document for Collaboration
00:09:00 -
Mark Up a Document
00:06:00 -
Review Markups
00:04:00 -
Merge Changes from Other Documents
00:06:00
-
Add Captions
00:06:00 -
Add Cross References
00:08:00 -
Add Bookmarks
00:05:00 -
Add Hyperlinks
00:06:00 -
Insert Footnotes and Endnotes
00:05:00 -
Add Citations and a Bibliography
00:11:00
-
Suppress Information
00:07:00 -
Set Formatting and Editing Restrictions
00:06:00 -
Restrict Document Access
00:02:00 -
Add a Digital Signature to a Document
00:04:00
-
Create Forms
00:09:00 -
Modify Forms
00:03:00
-
Automate Tasks by Using Macros
00:10:00 -
Create a Macro
00:19:00
-
Customize the User Interface
00:19:00 -
Set PowerPoint 2016 Options
00:07:00 -
Modify Slide Masters and Slide Layouts
00:16:00 -
Add Headers and Footers
00:05:00 -
Modify the Notes Master and the Handout Master
00:04:00 -
Create SmartArt
00:09:00 -
Modify SmartArt
00:05:00 -
Write Math Equations
00:07:00 -
Add Audio to a Presentation
00:09:00 -
Add Video to a Presentation
00:10:00 -
Customize Animations and Transitions
00:14:00 -
Review a Presentation
00:15:00 -
Store and Share Presentations on the Web
00:06:00 -
Annotate a Presentation
00:07:00 -
Set Up a Slide Show
00:08:00 -
Create a Custom Slide Show
00:03:00 -
Add Hyperlinks and Action Buttons
00:07:00 -
Record a Presentation
00:05:00 -
Secure a Presentation
00:11:00 -
Broadcast a Slide Show
00:07:00 -
Create a Video or a CD
00:08:00
-
Add Controls to Forms
00:11:00 -
Enhance Navigation and Organization of Forms
00:14:00 -
Apply Conditional Formatting
00:04:00 -
Import Data into Access
00:08:00 -
Export Access Data
00:06:00 -
Link Tables to External Data Sources
00:05:00 -
Create a Mail Merge
00:02:00 -
Create a Macro
00:08:00 -
Restrict Records by Using a Condition
00:04:00 -
Validate Data by Using a Macro
00:05:00 -
Automate Data Entry by Using a Macro
00:04:00 -
Manage a Database
00:08:00 -
Determine Object Dependency
00:04:00 -
Manage a Database
00:07:00 -
Document a Database
00:04:00 -
Splitting a Database for Multiple User Access
00:05:00 -
Implement Security
00:03:00 -
Convert an Access Database to an ACCDE File
00:04:00 -
Package a Database with a Digital Signature
00:01:00 -
Create a Database Switchboard
00:05:00 -
Modify a Database Switchboard
00:02:00 -
Set Start up Options
00:04:00