inquire@insightsmanila.com
0977.103.1800
MS Excel: Data Analytics Tool
This training includes a thorough review of the use of MS Excel in connecting and transforming data, performing basic DAX calculations, and presenting in charts. Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Office 365, Microsoft 365 I. Using MS Excel Functions and Tools for Data Analytics Review of Excel Functions • Text Functions • Logical Functions • Math and Statistical Functions • Lookup Functions Data Tab Tools • Conditional Formatting • Subtotal Tool II. Using Charts and Pivot Tables to Create Dashboards • Review of Charts • Creating Advanced Charts • Pivot Table Features • Grouping • Slicers • Calculated Fields • Using “Show Values As” • Pivot Charts • Creating Dashboards • Using Get Data Tool III. What If Analysis Tools
IV. Forecasting Tools
V. Data Modeling using PowerPivot Importing Data using PowerPivot Essential Power Query Tools Data Modeling in PowerPivot Creating PivotTables and PivotCharts in PowerPivot Creating Measures and KPIs |
Related Courses |