Fundamentals of Data Analysis in Excel ON DEMAND

Overview

Excel is the most widely used analysis tool in the world and a great starting point for diving into data analysis. In this course, you’ll apply Excel’s native tools to structure your data into spreadsheets and tables. You’ll then analyze and produce insights from that data using pivot tables. Finally, you’ll visualize those insights by building a dashboard in Excel. You’ll apply these skills using modern functionality like dynamic array formulas, linked data types, Power Query, and Power Pivot. You’ll work hands-on with real-world scenarios, using datasets pulled from financial statements and retail sales.

Highlights

Analyze a dataset using native Excel tools. Apply Excel tools and formulas to transform and structure your data. Create pivot tables to slice and dice your data. Visualize data with pivot charts and Excel Charts. Explore the landscape of data analysis and visualization.

Prerequisites

Attendees should have a basic understanding of accounting fundamentals and Excel.

Designed For

Anyone using Excel.

Objectives

Pull and visualize insights from your data using data analysis tools. Apply best practices for data structuring, analysis, and visualizations. Discover modern Excel functionality like dynamic array formulas, linked data types, and more.

Preparation

None.

Notice

None.