April 2021
This video below provides a review of the topics covered. See the video chapter topic title at the bottom right to help navigate topic sections of the video:
- Introduction to class 1 of 2 at time 0:0:0 (hours:minutes:seconds)
- vLookup function examples at 4:26 (minutes:seconds)
- Pivot Table at 2:00:44 (hours:minutes:seconds)
- vLookup function examples at 2:08:32 (hours:minutes:seconds)
- Macro example at 2:37:39 (hours:minutes:seconds)
- Wrap up and items for class 2 of 2 at 2:48:02 (hours:minutes:seconds).
I look forward to adding more videos based on the needs of my students!!
Juan Hinojosa Easy Excel Learning Excel Workshop Instructor and Excel VBA programmer
www.EasyExcelLearning.com
Data Files
Document for April 24, 2021
April 2020
I hope you are doing well. Below are videos from our third Advanced Microsoft Excel session. I hope you join us for more classes!
Review of hLookup and absolute reference
Using the Index function with nested Match function to look up information from a data set
Advanced Excel Class overview
- The vlookup function is a built-in algorithm to cross-reference information from the desired data set. The use of the vlookup function can:
- Replace the need for manual looking up and copying and pasting.
- Compare two large data sets column by column.
- Macros in Excel enable you to record what you do with your mouse and keyboard (into computer code) in Excel. Then you can run those recorded steps to facilitate automation. If you can identify Excel tasks you do repetitively, you can apply the macro record/play feature to save time.
- Nested if functions enable you to leverage more complex function usage and enable flow chart/path/branching decision-making.