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.
The class project is to follow along with the video. If you feel especially proud of your dashboard upon completion, please post a screenshot of it in the project section.
You can use the download to practice these skills and refer to them in the future.
