Loading...

Course Description

Most organizations rely heavily on Microsoft Excel to consolidate, analyze, and report financial information and other important data. Your company is probably no exception. If you work with data of any kind, learning Excel's advanced functions to taking on greater responsibilities in your organization.

This course will help you master many features in Microsoft Excel 2019/Office 365 that most users don't know exist. You will learn the secret to using formula-based conditional formatting as a creative solution to common issues. You will also learn how to leverage Excel's Power Query tool to import and transform data from about any data source. By the time you finish this course, you will have mastered Microsoft Excel 2019/Office 365 and will be able to better serve your company's data management needs.

Course Outline

  • Customizing Excel
  • Table Management
  • Data Validation
  • Custom Controls
  • Conditional Formatting
  • Consolidating and Outlining
  • Excel Functions and Nesting
  • Import External Data
  • Data Tables
  • What-If Analysis Tools
  • Advanced PivotTables
  • Analysis ToolPak, Advanced Filter, Array Formulas
  •  
Loading...
Thank you for your interest in this course. Unfortunately, the course you have selected is currently not open for enrollment. Please complete a Course Inquiry so that we may promptly notify you when enrollment opens.
Required fields are indicated by .