3-Hour Excel Automation Boot Camp: Top Ten Excel Functions, Lookup Functions (VLOOKUP, HLOOKUP, MATCH, INDEX), Basics of Excel Macros with an Introduction to VBA
OVERVIEW Excel functions can greatly enhance your ability to perform tasks in day to day activities in Excel. While there are hundreds of functions available, there are 10 functions that all Excel users should know. Whether you are an office worker, or a small business owner using Excel to keep track of your finances or just the casual user, these Excel functions can be very important time savers and enhance your ability to create better performing spreadsheets! Learning about the lookup functions in Excel will allow you to match data between databases. VLOOKUP enables you to quickly and easily look for a value down a column of data and return a value from the same row in a different column. Perfect for when working with large tabular data. INDEX and MATCH work in a similar way but provide more flexibility. You’ll learn how to create a macro the easy way by using the built-in macro recorder. You’ll then progress on to learn how to make simple changes to a macro using the built-i