Training Doyens

PowerPivot is a modern superpower for Microsoft Excel Pivot Tables that can make your analysis faster, easier, and more powerful. Our upcoming webinar discusses how Power Pivot eliminates the limitations of Pivot Tables and helps in analyzing data across multiple tables and creating more sophisticated calculations. The webinar covers the following key areas: ·          Using Power Pivot to establish relationships between data tables ·          Creating advanced calculations with DAX in Power Pivot ·          Creating advanced data visualizations using Power Pivot calculations LEARNING OBJECTIVES Pivot Tables are a powerful, dynamic way to analyze and visualize data in Microsoft Excel, but they have their limitations. The two big concerns are analyzing data across multiple tables, and creating more sophisticated calculations – and those are exactly the...

OVERVIEW Power Pivot is a new Add-In for Microsoft Excel that gives you sophisticated Data Modeling tools. Bringing in data from different tabs, files, or even databases, you can establish relationships between those sources. For example, you can connect a list of customers from a spreadsheet to your sales database, or connect a list of employees to their completed training courses. With those relationships established, our Pivot Table can now calculate and filter information from these connected sources with no additional effort. Additionally, this data model provides an entire suite of calculations that use those relationships to create filtered reports in a flash. These calculations – like CALCULATE and ALL – give Pivot Tables all the tools users have been looking for in the last 20 years. WHY SHOULD YOU ATTEND Unlike many webinars, Neil’s sessions are 100% hands-on real-world examples of the skills he’s presenting. After this Power Pivot tutorial, you’ll have a screens...

In business, the data we base our decisions on is kept in databases and spreadsheets and they are not very valuable unless converted into summaries, reports, and visualizations. Our upcoming webinar discusses how Excel PivotTable serves as an incredibly dynamic and easy-to-use tool for this kind of reporting and data visualization. The webinar covers the following key areas: ·          Formatting data as a Table and creating charts to illustrate your insights ·          Formatting and creating a presentation ·          Linking multiple tables through relationships LEARNING OBJECTIVES In business, the data we base our decisions on is kept in databases and spreadsheets in list form. The list by itself is essential, but useless without summaries, reports, and visualizations. A Microsoft Excel Pivot Table is an incredibly dynamic and easy-to-use tool fo...

OVERVIEW Microsoft Excel Pivot Tables are one of the most powerful and easy-to-use features in Excel, but most people are intimidated by them. These tables allow users to take a large set of data – rows of data about things like customers, products, sales, locations, employees, anything at all – and build reports to make real business decisions. But how exactly do you make a powerful Pivot Table? In this session, we’ll review everything from the fundamentals like how to create pivot table in Excel to techniques that allow them to be used for dashboards and other visualizations. Neil will help you analyze and visualize essentially any kind of data in Microsoft Excel. He will share how Pivot Tables can immediately give you an insight into any part of your business. With just a couple of clicks, you can build a report and charts around your employees, your sales, your tasks – anything that’s relevant to you. WHY SHOULD YOU ATTEND Unlike many webinars, Neil’s sessions are 1...

Mike Thomas Mike Thomas IT Training Specialist, The Excel Trainer Years of Experience:  30+ years Areas of Expertise:  Microsoft Office and Apple Mac 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 . In 2012, he founded theexceltrainer.co.uk where he has produced nearly  200  written and video-based Excel tutorials. He has recorded several Excel training courses for pluralsight.com and in his career delivered hundreds of courses and webinars on a variety of Excel topics. Mr. Thomas is a Fellow of The Learning and Performance Institute  and has worked with and for a large number of global and UK-based companies and organizations across a diverse range of sectors. In addition to training, he also designs and develops  Microsoft Office-based  solutions that automate key business tasks and processes.

Cathy Horwitz Cathy Horwitz Microsoft Office Instructor & Consultant Years of Experience:  44+ years Areas of Expertise:  Microsoft Office Cathy Horwitz  is an independent consultant specializing in Microsoft Office instruction.  She has over 30 years of experience as a Microsoft Office instructor.  Cathy is proficient in all levels of Excel, Word, PowerPoint, Outlook and Access.  Cathy holds a degree in Psychology and a Master in Business Administration degree with an emphasis in Human Resources. Cathy worked for Zenith Data Systems for 17 years.  She worked for a Zenith distributor when personal computers were first introduced.  Zenith established a computer division and began manufacturing and selling personal computers.  Cathy was involved in software training from the very beginning.  She has been training as an independent consultant since 1993.   Cathy’s strengths include customizing classes based o...

OVERVIEW Microsoft Excel Pivot Tables are one of the most powerful and easy-to-use features in Excel but not all know the fundamentals of making powerful pivot tables.   Join our upcoming webinar to be presented by Neil Malek to better understand the use of Pivot Table, an incredibly dynamic and easy-to-use tool, for reporting and data visualization. Webinar Highlights ·          How to create Pivot Table in Excel ·          Calculating sums, averages, counts, and more ·          Filtering by date, region, or other relevant factors LEARNING OBJECTIVES In business, the data we base our decisions on is kept in databases and spreadsheets in list form. The list by itself is essential, but useless without summaries, reports, and visualizations. A Pivot Table is an incredibly dynamic and easy-to-use tool for this kind of reporting and data vi...

OVERVIEW Microsoft Excel Pivot Tables are one of the most powerful and easy-to-use features in Excel, but most people are intimidated by them. These tables allow users to take a large set of data – rows of data about things like customers, products, sales, locations, employees, anything at all – and build reports to make real business decisions. But how exactly do you make a powerful Pivot Table? In this session, we’ll review everything from the fundamentals of using Pivot Tables to techniques that allow them to be used for dashboards and other visualizations. Neil will help you analyze and visualize essentially any kind of data in Microsoft Excel. He will share how Pivot Tables can immediately give you an insight into any part of your business. With just a couple of clicks, you can build a report and charts around your employees, your sales, your tasks – anything that’s relevant to you. WHY SHOULD YOU ATTEND Unlike many webinars, Neil’s sessions are 100% hands-on real-wo...