Training Doyens

Whether you are an office worker or a small business owner using Excel to keep track of your finances or just the casual user, tools for automation in Excel can be very important time savers and enhance your ability to create better performing spreadsheets. Our upcoming boot camp discusses the advanced features of Excel that provide automation within the application like Excel functions andformulas, Macros, VBA and more. The boot camp covers the following key areas: ·          Learn many statistical functions including SUM, AVERAGE, MAX, MIN and COUNT ·          Learn many functions to manipulate text once imported including LEFT, RIGHT, LEN, TRIM and CONCATENATE ·          Learn why the INDEX and MATCH combination often is superior to VLOOKUP or HLOOKUP ·          Learn the difference between workbook macros and p...

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 bu...

Whether you are an office worker, or a small business owner using Excel to keep track of your finances or just the casual user, tools for automation in Excel can be very important time savers and enhance your ability to create better performing spreadsheets. Our upcoming boot camp discusses the advanced features of Excel that provide automation within the application like Excel functions and formulas, Macros, VBA and more. The boot camp covers the following key areas: ·          Learn many statistical functions including SUM, AVERAGE, MAX, MIN and COUNT ·          Learn many functions to manipulate text once imported including LEFT, RIGHT, LEN, TRIM and CONCATENATE ·          Learn why the INDEX and MATCH combination often is superior to VLOOKUP or HLOOKUP ·          Learn the difference between workbook macros and p...

Whether you are an office worker or a small business owner using Excel or just the casual user, Excel functions can be very important time savers and enhance your ability to create better performing spreadsheets. Our upcoming boot camp discusses top ten Excel functions, Lookup functions and basics of Excel Macros. The boot camp covers the following key areas: ·          Statistical functions including SUM, AVERAGE, MAX, MIN and COUNT ·          Learn why the INDEX and MATCH combination often is superior to VLOOKUP or HLOOKUP ·          Learn the difference between workbook macros and personal macros ·          Use VLOOKUP to look up data from another workbook ·          View the recorded macro in VBA LEARNING OBJECTIVES This Microsoft Excel training session cover...