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

OVERVIEW There is a saying, “a picture is worth a thousand words”. In Excel that means finding ways to represent numerical data pictorially so that your audience can quickly and easily understand it. It's often easier to look at a chart, a graph or something visual than to just look at a set of figures. WHY SHOULD YOU ATTEND Until a few years ago it was enough to take a set of numbers and create a bar chart or pie chart. Although in the right situation these traditional charts are still appropriate, things have moved on and we're constantly hearing words like Data Visualizationand Infographic . It's time to get your Excel-related business and communication skills up to date and learn how to use it to present data in the modern world. AREAS COVERED •  Charting 101 - create a basic chart •  From drab to fab - enhance and customize a basic chart •  Combination charts - line and bar in a single chart •  Dynamic charts - automate adding new data to a ...

No matter what business you are in, a dashboard is a critical tool in your communication armory. Mike discusses how to create an interactive professional-looking dashboard using Excel. The webinar provides a clear and deep understanding about: ·          Using PivotTables to summarize data ·          Visual communication using charts ·          Using formulas to create KPI summaries   Independence Day Sale Offer LEARNING OBJECTIVES This training will provide you with a solid foundation that you can use to build your own dashboards and reports. WHO WILL BENEFIT This webinar is for any user of Excel who wants to learn how to create Excel dashboards. You should have an intermediate level of Excel knowledge and preferably know how to create a basic pivot table. The training will be delivered using Excel 2016 for Windows. However, much ...

OVERVIEW Pivot Tables are one of the most powerful tools in Excel’s dataanalysis 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 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 Tables is one of the must have skills for anyone who needs to use Excel to quickly build reports and summaries. This training will provide you with a solid foundation that you can use to build your own pivot tables and reports. Excel Online Training By Mike Thomas AREAS COVERED What is a pivot table – a few examples of pivot tables Creating a simple pivot table in 6 clicks Sum, count and percent – how to change what is displayed Making a pivot table report eye-catching appealing Changing the layout of a p...

Excel experts believe that pivot tablesare one of the most powerful tools in Excel. And, knowing how to create pivot tables is an important skill for quickly building reports and summaries. Join our upcoming webinar to learn the features and functions of pivot tables.  WHY SHOULD YOU ATTEND Learning how to create Pivot Tables is one of the must have skills for anyone who needs to use Excel to quickly build reports and summaries. This training will provide you with a solid foundation that you can use to build your own pivot tables and reports. Excel Training Classes Online AREAS COVERED What is a pivot table – a few examples of pivot tables Creating a simple pivot table in 6 clicks Sum, count and percent – how to change what is displayed Making a pivot table report eye-catching appealing Changing the layout of a pivot table Displaying the data in a pivot table in alphabetical or numerical order Using filters to display specific items in a ...

OVERVIEW Pivot Tables are one of the most powerful tools in Excel’s dataanalysis 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 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 Tables is one of the must have skills for anyone who needs to use Excel to quickly build reports and summaries. This training will provide you with a solid foundation that you can use to build your own pivot tables and reports. excel training courses AREAS COVERED What is a pivot table – a few examples of pivot tables Creating a simple pivot table in 6 clicks Sum, count and percent – how to change what is displayed Making a pivot table report eye-catching appealing Changing the layout of a pivot table Dis...

OVERVIEW Learning how to use efficiently use Excel isso critical in many of today’s office jobs. Many people know the basics of Excel. This webinar will show you how to use some of the advanced functions of Excel to really help get the most out of your data be more efficient, and get the information that you are looking for. WHY SHOULD YOU ATTEND This webinar is for someone who uses Microsoft Excel on a regular basis, and wants to be more efficient in using the program, or who wants to get more out of it. Power Map for Excel AREAS COVERED IF, including the nested if, the AND, and the OR functions for more complicated If statements. Vlookup Hlookup Sumif and Sumifs Countif and Countifs Averageif and averageifs Match and Index WHO WILL BENEFIT Business owners CEO's / CFO's / CTO's Managers of all levels Anybody with large amounts of data Anybody who uses Microsoft Access/Excel on a regular basis, and wants to be more efficient and ...

OVERVIEW A dashboard is a critical tool in yourcommunication armory and as with any communication tool , presentation is everything. Although there are many tools that can be used to create a dashboard, Excel is commonly used due to its power, its flexibility and the fact that most people have it installed on their computer. WHY SHOULD YOU ATTEND In this Microsoft Excel training, you'll learn how to create a stunning, interactive professional-looking dashboard using Excel. This training will provide you with a solid foundation that you can use to build your own dashboards and reports. excel training online AREAS COVERED Best practice for setting up data sources Using Pivot Tables to summarize data Visual communication using charts Using formulas to create KPI summaries Creating interactive filters with Slicers Automating the dashboard with a simple macro Using protection to prevent accidental changes WHO WILL BENEFIT This ...