# Advanced Analytics & Visualization in Excel

Canonical URL: <https://training-nyc.com/courses/excel-visualization>

## Overview

Multi-day deep dive course in Excel, weaving in important analytics and visualization topics including dashboards, interactive decision support, data visualization theory and applications, advanced charting, and predictive analytics. 

Learn to make faster and better business decisions using data with predictive analytics and dashboards. Build interactive elements and dashboards without coding. Mine insights, find trends, and forecast with native Excel features.

Our training is perfect for experienced business teams familiar with Excel. People whose roles are business analyst, data analyst, financial analyst, analytics manager, program or project manager and similar will feel very comfortable with the course content, pace, and challenge. This is not an introductory course nor should it be considered on a scale from beginner to advanced. This course is designed for business teams to gain immediate and practical skills to solve pressing business problems.

## What you'll learn

- Advanced Lookup functions
- Dynamic tables
- Interactive elements
- Dashboards
- Data visualization principles
- Advanced charts
- Predictive analytics

## Prerequisites

Students should have Excel proficiency equivalent to our [Advanced Excel course](/courses/advanced-excel), including VLOOKUP, MATCH, Pivot Tables, and nested functions.

## Curriculum

### Day 1: Excel Interactivity and Dashboards

#### Advanced Lookup and Array Formulas

- Refresher on lookup functions and taking them to the next level into array formulas to faster calculation with larger datasets

#### Excel Tables and Structured References

- Name tables for easier usage and create dynamic ranges for scale

#### Error Checking and Prevention

- Learn to deal with errors in your workbooks to speed up your workbooks

#### Building Interactive Elements

- Use scroll bars and checkboxes to create interactivity in your workbook without using VBA, the foundation of dashboards

#### Dashboards – Visualizing Data for Decision Makers

- Using the above knowledge, learn to create dashboards that you can take with you to your job to enable quicker decision-making

### Day 2: Analytics Theory and Applications

#### Data Visualization Principles

- In this section, we’ll talk about fundamental data visualization principles and how can Excel help us solve business problems

#### Infographics

- Learn how to create infographics in Excel, even if you’re not a designer

#### Advanced Excel Charts – Building Charts Not in Excel’s Library

- Learn to create charts like heatmaps, control charts for benchmarking, and bullet charts

#### Exploratory Data Analysis

- Use Excel’s native features to answer open-ended questions, find underlying trends, and opportunities in your data

#### Predictive Analytics – Forecasting Models

- Learn to use Excel’s forecasting tool for basic predictive modeling

## Pricing

**Tuition:** $649