Training Doyens

Excel has many built-in functions that help you deal with a large amount of data in an efficient manner. Join our upcoming webinar to learn howto turn the data into meaningful information and then provide the answers that you need for yourself, your boss, or your organization. Key points to be covered in the webinar: ·          Relative Formulas and Absolute Formulas ·          Vlookup and Hlookup ·          Sumif and Countif Online Excel Training LEARNING OBJECTIVES If you handle large amounts of data in Excel, this webinar will help you tremendously. 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 productive Accountants CPAs Controllers Financial Consultants IT Prof...

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

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