Training Doyens

Where the macro recorder's functionality ends, VBA takes over enabling you to build your own worksheet functions, create automated workflows and control and interact with other applications. Our upcoming webinar discusses how to get started with VBA and how it automates at a more advanced level. The webinar covers the following key areas: ·          Understanding VBA jargon such as procedures, modules, methods and properties ·          How to edit an existing macro in spreadsheets ·          How to write a simple macro from scratch using VBA LEARNING OBJECTIVES This webinar helps you in getting started with VBA in Excel. It's aimed at advanced users of Excel, with little or no programming experience, who wish to take their level of automation knowledge beyond the macro recorder. The advanced Excel training will be delivered using the latest version o...

OVERVIEW Do you find yourself repeatedly performing the same actions or tasks in your spreadsheets? If the answer is "Yes", it’s time to learn how to create a macro in Excel. VBA is the programming language that is built in to Excel (and the other applications in the MS Office Suite). VBA is used to automate tasks that would otherwise have to be performed manually by pressing keys and selecting items with the mouse - and if that sounds like a macro - well it is. Although Excel has a macro recorder, there's a limit to what it can do. So, where the macro recorder's functionality ends, VBA takes over. At a more advanced level, VBA enables you to, amongst other things, build your own worksheet functions, create automated workflows and control and interact with other applications. This webinar is aimed at advanced users of Excel, with little or no programming experience, who wish to "dip their toe into the VBA water" WHY SHOULD YOU ATTEND VBA is ...

Where the macro recorder's functionality ends, VBA takes over enabling you to build your own worksheet functions, create automated workflows and control and interact with other applications. Our upcoming webinar discusses how to get started with VBA and how it automates at a more advanced level. The webinar covers the following key areas: ·          Understanding VBA jargon such as procedures, modules, methods and properties ·          How to edit an existing macro in spreadsheets ·          How to write a simple macro from scratch using VBA LEARNING OBJECTIVES This webinar helps you in getting started with VBA in Excel. It's aimed at advanced users of Excel, with little or no programming experience, who wish to take their level of automation knowledge beyond the macro recorder. The advanced Excel training will be delivered using the latest version...

OVERVIEW Do you find yourself repeatedly performing the same actions or tasks in your spreadsheets? If the answer is "Yes", it’s time to learn how to create a macro in Excel . VBA is the programming language that is built in to Excel (and the other applications in the MS Office Suite). VBA is used to automate tasks that would otherwise have to be performed manually by pressing keys and selecting items with the mouse - and if that sounds like a macro - well it is. Although Excel has a macro recorder, there's a limit to what it can do. So, where the macro recorder's functionality ends, VBA takes over. At a more advanced level, VBA enables you to, amongst other things, build your own worksheet functions, create automated workflows and control and interact with other applications. This webinar is aimed at advanced users of Excel, with little or no programming experience, who wish to "dip their toe into the VBA water" WHY SHOULD YOU ATTEND VBA ...

OVERVIEW Learning how to create Pivot Tables in Excel is one of the must-have skills for anyone who needs to use Excel to build business reports and summaries. Our upcoming webinar discusses how to quickly and easily build reports and charts that help in spotting trends and making crucial business decisions. The webinar covers the following key areas: ·          Calculating month-on-month difference and using conditional formatting ·          Using formulas to create additional calculated items ·          How to create Pivot Table in Excel from multiple tables or multiple data sources LEARNING OBJECTIVES In this advanced Excel training, you'll learn how to calculate differences (e.g. month-on-month, quarter-on quarter) and running/cumulative totals. You'll learn how to display a unique count (e.g. number of customers, not number of orders) and ...

Advanced Pivot Tables OVERVIEW Pivot Tables are one of the most powerful tools in  Excel’s Data Analysis  and  Business Intelligence (BI)  armory. With just a few clicks of the mouse (and no complicated formulas!) you can quickly and easily build reports and charts that summarize and analyze large amounts of raw data and help you spot trends and get answers to the important questions on which you base your key business decisions. WHY SHOULD YOU ATTEND Learning how to create Pivot Table in Excel is one of the must-have skills for anyone who needs to use Excel to quickly build reports and summaries. This Excel Pivot Table training will enable anyone who is familiar with the basics of Pivot Tables to take their skills and knowledge to the next level. AREAS COVERED Calculating month-on-month difference Calculating a running/cumulative total Displaying a unique count Using formulas to create additional calculated items Slicers ...

OVERVIEW Join Mike Thomas for an informative webinar to learn how to quickly and easily build reports and charts in Excel that summarize and analyze large amounts of raw data and help you to spot trends and get answers to the important questions. In this insightful webinar you’ll learn: ·          Calculating month-on-month difference ·          Calculating a running/cumulative total ·          Displaying a unique count LEARNING OBJECTIVES In this advanced Excel training , you'll learn how to calculate differences (e.g. month-on-month, quarter-on quarter) and running/cumulative totals. You'll learn how to display a unique count (e.g. number of customers, not number of orders) and how to use formulas to create additional calculated items. You'll learn how to create Slicers which are the new visual way to filter a pivot table. You'll also learn...

OVERVIEW Pivot Tables are one of the most powerful tools in Excel’s data analysis and BusinessIntelligence (BI) armoury. With just a few clicks of the mouse (and no complicated formulas!) you can quickly and easily build reports and charts that summarise and analyse large amounts of raw data and help you to spot trends and get answers to the important questions on which you base your key business decisions. WHY SHOULD YOU ATTEND Learning how to create pivot table in Excel is one of the must have skills for anyone who needs to use Excel to quickly build reports and summaries. This Excel pivot table training will enable anyone who is familiar with the basics of pivot tables to take their skills and knowledge to the next level. AREAS COVERED Calculating month-on-month difference Calculating a running/cumulative total Displaying a unique count Using formulas to create additional calculated items Slicers – the new visual way to filter a pivot tabl...

OVERVIEW Do you find yourself repeatedly performing the same actions or tasks in your spreadsheets? If yes then it’s time to learn how to create a macro. Join our upcoming webinar to learn the techniques for creating a macro and how to make simple changes to a macro using the built-in programming language called VBA. Key points to be covered in the webinar: ·          Introduction to VBA & Excel macros ·          Using the Macro Recorder to create a macro ·          Saving a file as a macro enabled Excel workbook LEARNING OBJECTIVES In this advanced excel training you will learn how to create and edit macros in Excel using both the Macro recorder and the VBA Editor. WHO WILL BENEFIT This webinar gets you started with macros and VBA. It's aimed at intermediate-to-advanced users of Excel and is relevant to all industries and job roles....