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

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