Training Doyens

With Excel Pivot Tables you can quickly and easily build business reports, dashboards and charts that help you summarize, analyze, interpret and understand your data which in turn helps you in making key business decisions. Our upcoming webinar discusses how to build your own Pivot Tables to turn raw data into meaningful and insightful reports. best way to learn excel quickly The webinar covers the following key areas: ·          Structure your raw data in the right way ·          Design and format your Pivot Table reports so that they are easy to read and understand ·          Convert a Pivot Table into a chart LEARNING OBJECTIVES Use Pivot Table in Excel to turn raw data into meaningful and insightful reports Structure your raw data in the right way Design and format your Pivot Table reports so that they are easy to read and understand ...

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 VLOOKUP retrieves one result to a match request, if that match can be found in the leftmost column of a large dataset. If the data is not laid out properly, or if the data is held as the wrong type, everything crumbles in the spreadsheet. Instead, you can expand your horizons with text, logical, lookup, and math functions – as well as new ways of referencing the data. This webinar will explore many of the most powerful, dynamic functions available in Excel. All too often, we get our data from clients that don’t understand how to use Excel , or databases that weren’t set up with our goals in mind. We can spend far too long trying to make the data just right, instead of pulling out the right tool from the toolbox. Integrating IFERROR, ISERROR, and IFNA with VLOOKUP immediately makes it more forgiving, and using MATCH with it makes it more flexible. You can replace VLOOKUP entirely, sometimes with INDEX and MATCH, and other times with functions you wouldn’t assume, like MA...

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