Training Doyens

Excel PivotTables enable quick exploration of business data and produce valuable insights from the accumulated data. Our upcoming webinar discusses how to produce meaningful, impactful and insightful reports using PivotTables in the shortest time possible for making better business decisions. The webinar covers the following key areas: ·          How to create a PivotTable in Excel and modify its structure ·          Filter and sort the data and change the PivotTable calculations ·          Use Slicers to make filtering a PivotTable simple LEARNING OBJECTIVES The ability to analyze data is a powerful skill that helps make better decisions. Microsoft Excel is one of the top tools for data analysis and PivotTables in Excel are arguably the most popular analytic tool. The power of Excel PivotTables and their ability to summarize data in flexible ways...

OVERVIEW A macro is an action or a set of actions that you can use to automate routine tasks. Macros are recorded in the Visual Basic for Applications programming language The easiest way to create a macros in excel for beginners is to record the steps. Excel stores information about each step you take as you perform a series of commands. The steps you do are saved in Visual Basic code. You then run the macro to repeat, or "play back," the commands. WHY SHOULD YOU ATTEND In this Excel macro tutorial you will learn how to create and edit macros, create macros that can be re-used across multiple files and create macros that run by clicking on buttons that you create. 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 programming language called Excel VBA. AREAS COVERED Using the macro recorder to create a macro Saving a file a...