Microsoft Excel Training Course

What Will You Learn?

• 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.