Training Doyens

OVERVIEW MS Excel PivotTable can help you sort and sift through large data sets to focus quickly on just the data elements that matter most to your specific needs.  In just one fast-paced and informative Excel PivotTable tutorial, you’ll learn how do PivotTables work and how to use it to sort your data more efficiently, create multiple customized reports in a few easy steps and gain a powerful new tool to help you make better business decisions.  In addition, you’ll get tips on the easiest way to group your data. Most importantly, when you use the power of PivotTables in Excel, you’ll be saving time and making your job easier. WHY SHOULD YOU ATTEND As an intermediate-level user of Excel, not only do you want to take your knowledge and skills to the next level, you want to produce meaningful, impactful and insightful reports in the shortest time possible. These features of the application will help you to do just that. AREAS COVERED ·  How to create a P...

Pivot Tables are one of the most powerful tools in Excel but they have a reputation for being complicated and scary. Our upcomingwebinar discusses how to use Pivot Tables to turn raw data into meaningful andinsightful reports quickly and easily. 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 ·          Summarize your data in different ways including totals, counts and percentages LEARNING OBJECTIVES Use Microsoft Excel Pivot Tables 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 Summarize your data in different ways including totals, counts and percentages Use Excel ...

OVERVIEW If you work with data, you’re likely already familiar with common frustrations with Microsoft Excel like size limitations and manually entering data from multiple sources. Luckily there are two Microsofttools- Excel PowerPivot and PowerQuery —that solve ALL of these issues, right inside Excel. No Access databases or IT department help needed. With imports of 1-million-plus rows of data sets from virtually any source and the ability to save query definitions, you can completely overhaul your reporting and analysis workflow. WHY SHOULD YOU ATTEND Attend the webinar if you use Microsoft Excel on a regular basis, and want to be more efficient and productive. AREAS COVERED How to activate/install Excel PowerPivot and PowerQuery—free tools from Microsoft Learn about Data Models Creating relationships between different datasets in PowerPivot Importing data into excel from an array of external sources Learn about DAX formulas Cleaning, transforming a...

OVERVIEW Are you a Pivot Table Power User? Are you frustrated by the limitations of Pivot Tables such as lack of support for multiple tables, limited support for complex calculations, no support for "Big Data"?  If you ever need to create pivot tables from multiple datasets, Power Pivot is your friend. No more vlookup. No more multiple consolidation ranges.  If you’ve been frustrated by other limitations of pivot tables then Power Pivot is for you. Simply put, Power Pivot takes pivot tables and data analysis to the next level.  If you’re a fan of pivot tables, you’ll love Power Pivot. Pivot Table Training WHY SHOULD YOU ATTEND If you work with, analyze and generate reports from large datasets in Excel, having a good understanding and working knowledge of Power Pivot is a must! AREAS COVERED Importing your data into Power Pivot Using the Data Model to create and manage relationships Hierarchies in PowerPivot Creating a pivot table from related ...

OVERVIEW Many people struggle with how to create Pivot Tables , or maybe they don’t even know what they can do, or maybe they think they are too difficult. I’m going to show you what they, how to use them, and that they are not difficult, and they can give you tremendous results. We will then make Pivot Charts, to graphically show the data. Then, we will add sorts, filters, slicers, and timelines to create a very easy-to-use, but very powerful dashboard that can give you instant results, and allow you to slice and dice your data any which way. You and your staff will be instantly more productive in Excel. These techniques will work cross-industry, with any type of data. You will find it to be clear and concise and right to the point, and you will be able to apply these techniques to your own data immediately after the session. WHY SHOULD YOU ATTEND Attend this webinar if you use Microsoft Excel on a regular basis and want to take your knowledge to the next level. AREAS COV...

OVERVIEW Pivot Tables are one of the most powerful tools in Excel’s data analysis and Business Intelligence (BI) armoury.  With just a few clicks of the mouse (and no complicated formulas!) you can quickly and easily build the reports, dashboards and charts that help you to summarise,  analyse, interpret and understand your data which in turn helps you to spot trends and get answers to the important questions on which you base your key business decisions. WHY SHOULD YOU ATTEND From global enterprises to early-stage startups and small businesses, people everywhere use Pivot Tables to see and understand their data. 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 enable anyone who is familiar with the basics of pivot tables to take their skills and knowledge to the next level. How To Create Pivot Table In Excel AREAS COVERED Calculating m...

PowerPivot is an Excel add-in that can be used to perform powerful data analysis and create sophisticated data models. Join our upcoming webinar to gain a good understanding about Power Pivot that takes pivot tables and data analysis to the next level.   AREAS COVERED Session highlights include… Importing your data into Power Pivot Using the Data Model to create and manage relationships Hierarchies in PowerPivot Creating a pivot table from related Excel tables Creating a pivot table from related data sources (including external sources) Creating calculated fields (measures) An introduction to the DAX formula language to create simple calculated columns Creating KPI’s Excel Pivot Table Training LEARNING OBJECTIVES You will learn, using practical examples, how the add-in provides Business Intelligence functionality & reporting within the familiar environment of Excel. Speaker Profile Mike Thomas has worked in the IT training bu...