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 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 personal macros ·     ...

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, a small business owner or just the casual user, knowing the advanced Excel features can be very important time savers and enhance your ability to create better performing spreadsheets. Our upcoming boot camp discusses the Excel advanced features that provide automation within the application and some must-have skills for Excel power users. The boot camp covers the following key areas: ·          Change the way data is calculated in a PivotTable ·          Learn many functions to manipulate text once imported including LEFT, RIGHT, LEN, TRIM and CONCATENATE ·          Learn the difference between workbook macros and personal macros ·          Learn many statistical functions including SUM, AVERAGE, MAX, MIN and COUNT ·          ...

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

What will be discussed? Microsoft Excel is one of the most commonly used tools in organizations and knowing the advanced techniques for data reporting and analysis can help professionals gain an edge in the industry. Our upcoming boot camp on automation in Excel discusses building insightful reports with Pivot Tables, using Excel functions and formulas , creating and editing macros and more. What you’ll learn? ·          Format a PivotTable report for greater appeal and change the way data is calculated in a PivotTable ·          Learn many statistical functions including SUM, AVERAGE, MAX, MIN and COUNT ·          Learn the difference between workbook macros and personal macros ·          Learn many functions to manipulate text once imported including LEFT, RIGHT, LEN, TRIM and CONCATENATE ·    ...

OVERVIEW PivotTables can help you sort and sift through large data sets to focus quickly on just the data elements that matter most to your specific needs. In addition, you’ll get tips on the easiest way to group your data. Most importantly, when you use the power of Microsoft Excel PivotTables , you’ll be saving time and making your job easier. 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! 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-in progr...