The era of big data has exploded due to the rise of cloud computing, which provides an abundance of computational power and storage, allowing organizations of all sorts to capture and store data. Leveraging data effectively can provide timely insights and competitive advantage. Data analysts, in all varieties of roles, must be able to effectively present and communicate their findings in visually compelling ways. Microsoft© Excel© is designed for this purpose.

Excel© can connect to a wide range of data sources, perform robust data analysis, and create diverse and robust data backed visualizations to show insights, trends, and create reports. These capabilities enable people who use Excel© for data analysis to turn data into thoughtful action.

In this course you will reinforce your understanding of Excel© through activities that will expand your skills.

You will learn:

• Data Analysis Fundamentals
• How to Visualize Data in Excel
• Using Formulas and Functions to Analyze Data
• Analyzing data with PivotTables
• Presenting Dashboards
• Creating Geospatial Visualizations
• Statistical Analysis
• Getting and Transforming Data
• Modelling Data with Power Pivot
• Presenting Insight with Reports

CEUs are awarded based on the number of scheduled contact hours.