DATA MANAGEMENT AND ANALYSIS USING ADVANCED EXCEL
The ability to analyse data is a powerful skill that helps you make better decisions. Microsoft Advanced Excel is one of the top tools for data analysis and the built-in features like What-if-Analysis, Pivot tables & Pivot Charts are arguably the most popular analytic tool. In this training, you will learn how to perform data analysis using Excel's most popular features. Pivots are used in many different industries by millions of users who share the goal of reporting the performance of companies and organizations. In addition, Excel formulas can be used to aggregate data to create meaningful reports.
The course outline is as follows: -File conversion and compatibility.
Add-in and automation functions.
Summarizing, consolidating, and outlining data.
Importing & exporting data from other sources.
Creating & working with what-if analysis tools.
Working with Illustrations.
Conditional Formatting.
Dynamic Charts, Rolling Charts, Formatting Charts, Format as Table.
Working with all the categories of Formulas.
Pivot Table & Pivot Chart
Many more .....