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
-
Mock Exam – Advanced MS Office Excel Course
00:20:00