Excel Advanced Training
Excel Advanced Training
Class Duration: 4 hours
Format: Virtual classroom live training
This 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 these with other functions. Our instructors will be on hand to answer any questions you have and lead you to a thorough understanding of Excel at an advanced level.
Training Class Goal
In the Advanced Excel class students will come from this class feeling confident using many of the advanced features within Microsoft Excel, including nested IF statements, VLookups, HLookups, macros, and validations. The primary focus of the Advanced Excel training course is on 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 within your workbook.
Prerequisites
Students should have a firm understanding of Excel fundamentals, including formatting, navigation, basic formulas, and basic functions. Students should be comfortable with basic IF statements. This Advanced Excel class builds upon knowledge gained in the Intermediate Excel course. Students should have a reasonable comfort level working in Excel at an intermediate proficiency before taking this course.
Topics Covered
Advanced Formulas
Viewing available Excel functions
Basic text functions
Basic “IF” conditional formulas
Nesting “IF” statements
Concatenate and “IF” statements with concatenate
ISBLANK Function
COUNTBLANK Function
Arrays
Using name ranges in formulas
Look Ups and Other Functions
Lookups and Lookup functions
HLookup
VLookup
Calculating days of the week
Calculating number of weekdays from a date
Calculating months between 2 dates
SUMIF Function
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
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. AdvantEdge Training’s Advanced Excel class will give you a mastery of the functions of this important business application. Our courses are designed specifically for companies and their employees.