Microsoft Excel: Advanced Training Course

This course is tailored for professionals who need to leverage advanced Excel capabilities to drive efficiency and make informed decisions. If you're looking to:

• Automate repetitive tasks: Create macros to streamline your workflow and save valuable time.
• Collaborate seamlessly: Master tools for effective teamwork on shared workbooks.
• Ensure data integrity: Learn advanced auditing and analysis techniques for accurate reporting.
• Integrate diverse data sources: Import and export data from various applications to create comprehensive reports.

To ensure your success, we recommend you first take the following courses or have equivalent knowledge: Microsoft Office Excel Basic and Microsoft Office Excel Intermediate

Lesson 1:Working with Multiple Worksheets and Workbooks

• • Use Links and External References
  • Use 3-D References
  • Consolidate Data

Lesson 2: Using Lookup Functions and Formula Auditing

• • Use Lookup Functions
  • Trace Cells
  • Watch and Evaluate Formulas

Lesson 3: Sharing and Protecting Workbooks

• • Collaborate on a Workbook
  • Protect Worksheets and Workbooks

Lesson 4: Automating Workbook Functionality

• • Apply Data Validation
  • Search for Invalid Data and Formulas with Errors
  • Work with Macros

Lesson 5: Creating Sparklines and Mapping Data

• • Create Sparklines
  • Map Data

Lesson 6: Forecasting Data

• • Determine Potential Outcomes Using Data Tables
  • Determine Potential Outcomes Using Scenarios
  • Use the Goal Seek Feature
  • Forecasting Data Trends