Advanced Excel Training
The Advanced Excel class is designed for everyday users of Excel, who want to take their skills to the next level. Advanced Excel training covers more intricate formulas, creating validations, writing macros , embedding other documents, and protecting your data in Excel. The class includes useful functions for various business applications, as well as how to combine them with other functions.
Training Class Goal
In the Advanced Excel class students will come from this class feeling confident using many advanced features within Microsoft Excel, including nested IF statements, VLookups, Hlookups, Macros, and Validations. The largest focus of the Advanced Excel training is around formulas, specifically functions and how to nest them with other functions for more advanced automation. Tools for making your spreadsheets easier for others to use and view, are also included. These include validations, custom views, protecting worksheets, and embedding other documents or spreadsheets in your workbook.
Understanding of Excel fundamentals including formatting, navigation, basic formulas, basic functions. Students should be comfortable with basic IF statements.
- Viewing available Excel functions
- Basic text functions
- Basic “IF” conditional formulas
- Nesting “IF” statements
- Concatenate and “IF” statements with concatenate
- ISBLANK Function
- COUNTBLANK Function
- Using name ranges in formulas
- Other classes covering Formulas and Functions
Look Ups and Other Functions
- Lookups and Lookup functions
- Calculating days of the week
- Calculating number of weekdays from a date
- Calculating months between 2 dates
- SUMIF Function
- Other classes covering Lookups
Data Views, Layouts, and Rules
- Transposing Data
- Validations for length and drop-down lists
- Custom Views
Introduction to Macros
- Developer Tools
- Saving Macros
- Absolute vs Relative Macros
- Recording Macros
- Creating Macro buttons
Additional Tools in Advanced Excel
- Embedding and linking
- Editing and embedded object
- Editing a linked object
- Linking as an icon
- Protecting worksheets
- Locking cells
- Protecting a workbook
The advanced excel training helps students learn new functions to enhance their spreadsheets as well as tools to make their spreadsheets easier to share with added automation.
Bookings are closed for this class.
Live & In-Person
All of the classes on this page are taught by live instructors who are present in the classroom.
Retake any public class up to 6 months after original class date....Read more
Interactive classes allow you to immediately try out new skills....Read more
Live instructors deliver our classes in an engaging and interactive way....Read more
Classes limited to 12 students for more individual attention....Read more