80 likes | 249 Views
Advanced Excel Class. Glenn Harris Microsoft Certified Trainer Office Master Instructor Excel Class NYC. Topics:. Review Formulas and Functions Data Analysis Macros Databases Collaboration. Review. Autosum Autofill Absolute References Data Sort Data Subtotal Keyboard Shortcuts
E N D
Advanced Excel Class Glenn Harris Microsoft Certified Trainer Office Master Instructor Excel Class NYC
Topics: • Review • Formulas and Functions • Data Analysis • Macros • Databases • Collaboration
Review • Autosum • Autofill • Absolute References • Data Sort • Data Subtotal • Keyboard Shortcuts • New Features • Tables
Formulas and Functions • Named Ranges • Vlookup • If / then / else • IsError / IfError • SumIfs / Countifs • Index / Match • DSum
Data Analysis • Goal Seek • Pivot Tables • Scenarios • Forecasting • Solver
Macros • Create a Macro • Edit a Macro
Databases • Validation • Delete Duplicates • Data Consolidate vs 3-D Functions
Collaboration • Passwords • Ranges • Workbook • Comments • Track Changes