Microsoft Excel Training Course

Introduction to Microsoft Excel training empowers participants with key skills to create and edit worksheets, implement formulas and functions, and sort and filter detailed data with tables and slicers. Visualize the numbers in a consumable and professional format analyzing data with charting, conditional formatting, sparklines, and pivot tables.

Microsoft Excel Training Delivery Methods

• In-Person

• Online

Microsoft Excel Training Information

In this Microsoft Excel training, you will learn to:

• Efficiently navigate and manipulate worksheets and workbooks.
• Implement an income and expense statement with formulas, functions, and names.
• Design a reusable data entry template that protects formulas.
• Implement conditional formatting to analyze sales information.
• Connect, prepare, and validate data employing editing tools, formulas, and Flash Fill.
• Identify, sort, and select detailed data with tables and slicers.
• Present and analyze data with conditional formatting, charting, sparklines, and printing parameters.
• Construct IF functions that make decisions - present results visually.
• Combine data with 3-D formulas.
• Analyze summary data with PivotTables and implement a quick dashboard.
• Leverage continued support with after-course one-on-one instructor coaching and computing sandbox.

Prerequisites

None.

Microsoft Excel Training Exam Information

• Learning Tree end-of-course exam included