Who should attend
This live online Excel: Intro to Data Analysis course is for data analysts and all Excel users who need to analyze, manipulate and visualize data. Knowledge of Excel Introduction preferred.
Microsoft Excel includes several tools that allow one to analyze large amounts of data… Master the use of these tools and you change the way you do business. Making sense of your data is essential in making key decisions for your organization.
This course will teach you how to use some of the tools built into Excel that enable you to mine the answers hidden in your data records and unlock the analysis power of Excel.
1. Be able to identify a well-defined list and convert to Tables for advanced analysis techniques
2. Use excel’s summary functions to find high level values within data (total Sales, Total cost, etc)
3. Display Data in summarized formats with visuals using pivot Tables and Pivot Charts
Analyzing Data in Lists and Tables
Summary Based IF Functions
Building and Working with Pivot Tables