This class is for people who use Excel everyday. It is aimed towards users who want to learn a few more functional skills
We will cover:
- Keyboard shortcuts
- Absolute and Relative referencing, including when using Tables
- Some useful formulas including VLookup and the new XLookup
- Delimiters
- Data Validation
- Conditional Formatting
- Dealing with raw data
- Inserting Tables
- Inserting Slicers
- Nested IF Statements
- OR Statements
- AND Statements
Bonus Videos:
- Using Logic to fill in missing values
- Inserting rows beneath alternating rows
Viewer request:
- Pivot Tables
- Multi Column Comparison
New videos are uploaded occasionally, so please keep an eye out for updated content.
Please let me know if you have any requests about a particular feature of Excel you would like to know more about.
Download Resources Here.