Training Doyens

Your business landscape might be exacting but you don’t have to compromise on your aspirations. Just brush up your skills with our upcoming webinar. 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. Join the webinar to learn how to build appealing pivot tables and reports. Key points to be covered in the webinar: ·          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 advanced excel course LEARNING OBJECTIVES In this Microsoft Excel training, you'll learn How to create a pivot table report in just 6 clicks! How to change the layout and appearance of the report to make it inviting to read How to display data in differen...

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

This webinar will help you with a solid foundation that you can use to build yourown dashboards and reports. The following areas will be covered in this webinar – ·          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 Excel Online Training LEARNING OBJECTIVES This training focuses on what you need to know to create an interactive professional-looking dashboard using Excel. You'll ...

VLOOKUP formula is one of the most popularformulas in Excel. In this webinar Excel expert Dennis Taylor discusses the use and limitations of VLOOKUP to help you expand your use of this function. Join the webinar and upgrade your skills. Thursday, December 21st, 2017 01:00 PM E S T | 10:00 AM P S T Duration: 90 minutes VLOOKUP Excel Training AREAS COVERED Perform dual lookups, where you look across columns and down rows to cross reference the data you need See how to arrange two worksheets from within the same workbook onscreen at the same time See why the MATCH and INDEX combination is often superior to the VLOOKUP or HLOOKUP function Uncover the limitations of VLOOKUP, along with alternatives Use the SUMIFS function to sum value based on multiple criteria LEARNING OBJECTIVES Understand how to use VLOOKUP to perform both exact and approximate matches Use the MATCH function to overcome a data integrity risk with VL...

Pivot Table is an Excel functionality that’sbeen around since 1993 or, we can say, since Excel 5. It’s one of the most powerful tools for data analysis . Our upcoming webinar is focused on improving your knowledge and proficiency of working with Pivot Tables. Mike Thomas has worked in the IT training business since 1989. He is a subject matter expert in a range of technologies including Microsoft Office and Apple Mac. LEARNING OBJECTIVES In this Microsoft Excel training , you'll learn  How to create a pivot table report in just 6 clicks!  How to change the layout and appearance of the report to make it inviting to read How to display data in different ways, for example, sales grouped by month or top 10 customers and finally  How to display the pivot table data as a chart/graph pivot table tutorial excel WHO WILL BENEFIT You should attend this training if you need to use Excel to quickly build reports and summaries or...

OVERVIEW Lookup formulas such as VLOOKUP allow you to return data from other locations in your spreadsheets without linking to individual worksheet cells. However, VLOOKUP can't always return the data that you need.  In this webinar, Excel expert Dennis Taylor explores the nuances and limitations of VLOOKUP, helps you expand your use of this function, and then presents you with a handful of alternatives. Vlookup Formula WHY SHOULD YOU ATTEND Compare and contrast IFNA, IFERROR, and ISERROR, and see which versions of Microsoft Excel support these worksheet functions Discover how to use wildcards and multiple criteria within lookup formulas Don't be caught off-guard by the new IFNA function available to Excel 2013 users Improve the integrity of spreadsheets with Excel's VLOOKUP function Master the versatile SUMIF and SUMIFS functions AREAS COVERED Perform dual lookups, where you look across columns and down rows to cross refer...

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

OVERVIEW Learning how to use efficiently use Excel is so critical in manyof 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. Excel Top 10 Functions 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 an...