Training Doyens

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