Intermediate Data Analysis with MS Excel

Service Description

Intermediate Data Analysis with MS Excel is intended to provide participants with MS Excel knowledge to transform and visualize data using Excel. This course provides participants with practical Excel knowledge about formulas, formatting, PivotTables, and other excel features to analyze and visualize data in Excel. Topics • Working efficiently in Excel (Shortcuts & other tips) • Novel Excel Features (Flash Fill & Quick Analysis) • Sorting & Filtering • Calculations: Basic Formulas & Operators • Conditional formatting • Data Validation • Managing Comments • Creating and formatting charts • Data Analysis with PivotTables Important: * Participants should have basic experience using MS Excel (At least 6 months). * Participants should have Excel 2013, latest versions, or Office 365.