Excel for Data Analysis
Course Overview
This course will introduce students to Microsoft Excel 2016 data analysis, including functions and formulas, lookups and data tables, PivotTables, and analytical tools.
Courses Outline
- Chapter 1 – Functions and Formulas
- Chapter 2 – Lookups and Data Tables
- Chapter 3 – PivotTables
- Chapter 4 – Analytical Tools
Chapter 01 – Getting Started with Microsoft Office Excel 2016
Chapter 02 – Performing Calculations
Chapter 03 – Modifying a Worksheet
Chapter 04 – Formatting a Worksheet
Chapter 05 – Printing Workbooks
Chapter 06 – Managing Workbooks
Chapter 01 – Working with Functions
Chapter 02 – Working with Lists
Chapter 03 – Analyzing Data
Chapter 04 – Visualizing Data with Charts
Chapter 05 – Using PivotTables and PivotCharts
Chapter 06 – Working with Graphical Objects
Chapter 07 – Using Array Formulas
Chapter 01 – Working with Multiple Worksheets and Workbooks
Chapter 02 – Using Lookup Functions and Formula Auditing
Chapter 03 – Sharing and Protecting Workbooks
Chapter 04 – Automating Workbook Functionality
Chapter 05 – Creating Sparklines and Mapping Data
Chapter 06 – Forecasting Data
- Chapter 1 – Functions and Formulas
- Chapter 2 – Lookups and Data Tables
- Chapter 3 – PivotTables
- Chapter 4 – Analytical Tools