<commit_before>---
layout: course
title: Advanced Excel
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.
prerequisites: None
length: 2
series:
  - Excel
subjects:
  - Analysis
  - Visualization
team_members:
  - david-weinzimmer
  - sam-abbott
course_materials_link: 'https://drive.google.com/folderview?id=0BwRgeGq-b8f9bHp1UUtqNWJMTjA&usp=sharing'
order: 3
---


## About this course

This classroom based workshop is the third 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.

&nbsp;

## What you’ll learn

Please click the below links to access how-to guides from Lynda.com! &nbsp;[Click here](https://drive.google.com/file/d/0BwRgeGq-b8f9eVNXQU9BNEJJVHc/view?usp=sharing) to find out how to sign up for a free account.

* Automation tools
  * [Recording and using macros](http://www.lynda.com/Excel-tutorials/Reviewing-recording-method/74463/79053-4.html)
* Analysis tools
  * [Statistical tests using the analysis toolpak](http://www.lynda.com/Excel-tutorials/Excel-Analysis-ToolPak/422098/459827-4.html)
  * [What-if analysis](http://www.lynda.com/Excel-tutorials/Finding-target-value-using-Goal-Seek/150165/159913-4.html)
  * PowerPivot
  * [Data Tables](http://www.lynda.com/Excel-tutorials/Using-data-tables/376986/431781-4.html?srchtrk=index%3a1%0alinktypeid%3a2%0aq%3adennis+taylor%0apage%3a1%0as%3arelevance%0asa%3atrue%0aproducttypeid%3a2)
* Auditing tools
  * [Formula auditing](http://www.lynda.com/Excel-tutorials/Auditing/363001/460714-4.html)
  * [Precedents/dependents](http://www.lynda.com/Excel-tutorials/Auditing/363001/460714-4.html)
  * [Conditional formatting](http://www.lynda.com/Excel-tutorials/Applying-conditional-formatting-across-rows-data/363001/408645-4.html)<commit_msg>Updated '/academy/_posts/2016-03-05-advanced-excel.md' via CloudCannon<commit_after>---
layout: course
title: Advanced Excel
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.
prerequisites: None
length: 2
series:
  - Excel
subjects:
  - Excel
  - Analysis
team_members:
  - david-weinzimmer
  - sam-abbott
course_materials_link: 'https://drive.google.com/folderview?id=0BwRgeGq-b8f9bHp1UUtqNWJMTjA&usp=sharing'
order: 3
---


## About this course

This classroom based workshop is the third 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

Please click the below links to access how-to guides from Lynda.com!  [Click here](https://drive.google.com/file/d/0BwRgeGq-b8f9eVNXQU9BNEJJVHc/view?usp=sharing) to find out how to sign up for a free account.

* Automation tools
  * [Recording and using macros](http://www.lynda.com/Excel-tutorials/Reviewing-recording-method/74463/79053-4.html)
* Analysis tools
  * [Statistical tests using the analysis toolpak](http://www.lynda.com/Excel-tutorials/Excel-Analysis-ToolPak/422098/459827-4.html)
  * [What-if analysis](http://www.lynda.com/Excel-tutorials/Finding-target-value-using-Goal-Seek/150165/159913-4.html)
  * PowerPivot
  * [Data Tables](http://www.lynda.com/Excel-tutorials/Using-data-tables/376986/431781-4.html?srchtrk=index%3a1%0alinktypeid%3a2%0aq%3adennis+taylor%0apage%3a1%0as%3arelevance%0asa%3atrue%0aproducttypeid%3a2)
* Auditing tools
  * [Formula auditing](http://www.lynda.com/Excel-tutorials/Auditing/363001/460714-4.html)
  * [Precedents/dependents](http://www.lynda.com/Excel-tutorials/Auditing/363001/460714-4.html)
  * [Conditional formatting](http://www.lynda.com/Excel-tutorials/Applying-conditional-formatting-across-rows-data/363001/408645-4.html)
{'fraction_non_alphanumeric': 0.11642821904292057, 'fraction_numerical': 0.05920078934385792, 'mean_word_length': 4.937042459736457, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 4, 'lorem ipsum': 0, 'www.': 14, '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': '122140', 'n_tokens_mistral': 1637, 'n_tokens_neox': 1424, 'n_words': 303}