<commit_before>---
layout: course
description: "This classroom based workshop is the fourth in a series of workshops on Excel offered by the Data Academy.  It provides the Data Academy's most advanced level of Excel training."
prereq: Intermediate Excel II or strong working knowledge of Excel
length: 2
subject: 
  - analysis
  - visualization
instructors: 
  - sam_dorward
  - david_weinzimmer
published: false
title: Advanced Excel
series: Excel
---

## About this course
This classroom based workshop is the fourth in a series of workshops on Excel offered by the Data Academy.  It provides the Data Academy's most advanced level of Excel training.  

We encourage experienced Excel users to register for this fast-paced course.

## What you'll learn

- Automation tools
	- Recording and using macros
- Analysis tools:
	- Statistical tests using the analysis toolpak
	- What-if analysis	
	- PowerPivot
- Auditing tools
	- Formula auditing
	- Precedents/dependents
	- Conditional formatting
    - Testing<commit_msg>Update 2016-03-10-advanced-excel.md<commit_after>---
layout: course
description: "This classroom based workshop is the fourth in a series of workshops on Excel offered by the Data Academy.  It provides the Data Academy's most advanced level of Excel training."
prereq: Intermediate Excel II or strong working knowledge of Excel
length: 2
published: false
title: Advanced Excel
series: Excel
---

## About this course
This classroom based workshop is the fourth in a series of workshops on Excel offered by the Data Academy.  It provides the Data Academy's most advanced level of Excel training.  

We encourage experienced Excel users to register for this fast-paced course.

## What you'll learn

- Automation tools
- Recording and using macros
- Analysis tools:
- Statistical tests using the analysis toolpak
- What-if analysis	
- PowerPivot
- Auditing tools
- Formula auditing
- Precedents/dependents
- Conditional formatting
- Testing
{'fraction_non_alphanumeric': 0.0516096065406234, 'fraction_numerical': 0.005109862033725089, 'mean_word_length': 4.072538860103627, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '5990219', 'n_tokens_mistral': 534, 'n_tokens_neox': 482, 'n_words': 256}