Curriculum
7 Sections
19 Lessons
8 Hours
Expand all sections
Collapse all sections
1- INTRO
0
2- WORKING WITH MULTIPLE WORKSHEETS AND WORKBOOKS
3
2.1
Use Links and External References
2.2
Use 3-D References
2.3
Combine and consolidate data from multiple sources
3- SHARING AND PROTECTING WORKBOOKS
2
3.1
Collaborate on a Workbook
3.2
Protect Worksheets and Workbooks
4- AUTOMATING WORKBOOK FUNCTIONALITY
3
4.1
Apply Data Validation
4.2
Search for Invalid Data and Formulas with Errors
4.3
Automate repetitive actions with Recorded Macros
5- USING LOOKUP FUNCTIONS, DYNAMIC ARRAYS, AND FORMULA AUDITING
4
5.1
Use Lookup Functions to retrieve data
5.2
Use Dynamic Arrays and Dynamic Array Functions
5.3
Trace Cell relationships and troubleshoot formulas
5.4
Monitor calculations with the Watch Window and Evaluate Formulas
6- PREDICTING AND FORECASTING DATA TRENDS
4
6.1
Determine Potential Outcomes Using Data Tables
6.2
Determine Potential Outcomes Using Scenarios
6.3
Use the Goal Seek Feature to backtrack solutions
6.4
Forecast Data Trends
7- VISUALIZING DATA WITH SPARKLINES AND MAPS
3
7.1
Create Sparkline & Summarize Trends inside cells
7.2
Create basic Geographic Maps to display Data Visually
7.3
CONGRATULATIONS & NEXT STEPS
Excel Advanced Training
Curriculum
This content is protected, please
login
and enroll in the course to view this content!
Home
Courses
Search
Search
Account
Login with your site account
Lost your password?
Remember Me
Not a member yet?
Register now
Register a new account
Are you a member?
Login now
Modal title
Main Content