Our Introduction to Excel course teaches Excel basics. Learn time saving techniques to navigate, create new models, create basic formulas (Sum, Average, Count), format and print your data, make charts and use Excel’s database features (sort, filter, subtotal). To help students review the class we include an online video library!
Our Advanced Microsoft Excel Training covers topics like advanced functions (Vlookup, If/Then, Index/Match, DSum, arrays, formula auditing techniques), what-if data-analysis techniques like goal seek, pivot tables, scenarios, forecasting), database features (validations, extract unique values), advanced macros (with light VBA programming) and collaboration techniques.
Our Excel VBA training teaches the strengths and weaknesses of recording macros, how to create, instantiate, and pass variables, conditional controls like if/then, loops like for/next and do/while. You will also learn how to call functions, how to write your own functions, how to create forms, how to use workbook events, how to customize the ribbon, and how to connect to a database.