Excel - Level 3

Course Description

Excel - Level 3 is an advanced, instructor-led Microsoft course designed for individuals who want to reduce repetitive tasks, solve Excel challenges faster, and focus on higher-value work. Ideal for learners pursuing accounting, administration, data analytics, finance, marketing, project management, and related careers. This hands-on course builds advanced Microsoft Excel skills used in today’s workplace. This practical course covers:

• Managing Multiple Worksheets and Workbooks
• Sharing and Protecting Workbooks
• Automating Workbook Functionality
• Using Lookup Functions, Dynamic Arrays, and Formula Auditing
• Forecasting Data
• Creating Sparklines and Mapping Data

Through live instruction and hands-on practice, participants gain advanced spreadsheet skills that boost Microsoft Office proficiency and enhance career growth in a data-driven world.

Participant Outcomes

Upon successful completion of this course, you will be able to:

• Manage Multiple Worksheets & Workbooks: Organize and navigate your files efficiently.
• Share & Protect Workbooks: Collaborate safely with your team and keep data secure.
• Automate Tasks: Use Excel tools to save time on repetitive work.
• Use Advanced Formulas: Apply Lookup functions, dynamic arrays, and formula auditing to get answers faster.
• Forecast Data: Predict trends and plan ahead using Excel’s forecasting tools.
• Visualize Data: Create sparklines and maps to show insights at a glance.

Course Content

Lesson 1: Working with Multiple Worksheets and Workbooks

• Use Links & External References: Connect data across different sheets and files.
• Use 3-D References: Reference the same cell or range across multiple worksheets.
• Consolidate Data: Combine information from several sheets into one place.

Lesson 2: Sharing and Protecting Workbooks

• Collaborate on Workbooks: Work together with your team in the same Excel file.
• Protect Your Work: Keep worksheets and workbooks secure from unwanted changes.

Lesson 3: Automating Workbook Functionality

• Apply Data Validation: Make sure the right type of information is entered.
• Find Errors Quickly: Spot invalid data and formulas with mistakes.
• Use Macros: Automate repetitive tasks to save time.

Lesson 4: Using Lookup Functions, Dynamic Arrays, and Formula Auditing

• Use Lookup Functions: Quickly find and reference data in your worksheets.
• Work with Dynamic Arrays: Handle multiple results and modern Excel functions.
• Trace and Evaluate Formulas: Follow your formulas step by step and check results.

Lesson 5: Forecasting Data

• Use Data Tables & Scenarios: Explore “what-if” situations and potential outcomes.
• Use Goal Seek: Find the input needed to reach a specific goal.
• Forecast Trends: Predict future data patterns based on historical information.

Lesson 6: Creating Sparklines and Mapping Data

• Create Sparklines: Add mini charts inside cells to show trends at a glance.
• Map Your Data: Visualize information geographically to see patterns and insights.