Excel Advanced (part 1)
In my Day to day, I use Microsoft Excel extensively. I have team members here requesting my assistance often and have begun teaching a weekly course on usage. This is not intended to cover basic excel formulas such as Average or Sum. Rather it is intended to make Excel faster to use, give better insights, and help describe some design principals that I use.
The Agenda includes
Static Vs Dynamic cell References ( Using the $ to it's fullest)
Naming Ranges ( How we can make our formulas easier to update with new Data as well as readable )
Pointing Cells: Using Indirect, Offset, Row, and Column formulas to show the data you want.
Text Manipulation
Time formulas
Logical Statements
The power of IF and Choose
Errors: How to hide, and when to intentionally create one.
Custom Text/Number Formatting
Graphing Data
Types of Graphs and their use.
Data Tables, labels, and Titles -- Oh my!
Setting axis and chart titles dynamically.
Pivot Tables:
Pivot Basics, The look and Feel
Rows Vs Columns and Values
Adding Slicers
Changing position of the Values field.
(WIP) Understanding the Pivot Table/Slicer Cache Systerm
Data Validation in Cells
Using Data Validation to return Dynamic Selection options.
Array Formulas
Using an array to parse errors
Returning multiple lookup values
As the weeks go by, I will create new posts and add hyperlinks to the Index above. Please reach out to me if you have questions on any of the information presented, or have an Idea on something that you would like to see covered.
