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

OVERVIEW 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. Excel can create an incredible assortment of chart and visualization types, far beyond the bar charts and pie charts you’ve seen a thousand times. Join the webinar to learn how to create icon- and map-based visuals, as well as dynamic dashboards that update as your data changes. Key points to be covered in the webinar: ·          Data visualization tools in Excel and creating graphical charts with symbols, pictures, maps, and more ·          Highlighting relevant data dynamically with conditionally formatted charts ·          Isolating critical points with logical functions LEARNING OBJECTIVES Excel can create an incredible assortment of chart and visualization types, far beyond the bar ch...

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 As we hurtle toward 2020, every list of essential job skills and core competencies contains the following ideas: Data Analytics, Data Visualization, and Communication . While there are certainly a host of new tools and technologies to help us with that, the tools we already know and use daily have vast untapped potential. Microsoft Excel, certainly, gets a bad rap when it comes to ‘data visualization,’ but that’s almost entirely because people don’t know how to use the tools in the box! In this webinar, we’ll highlight a number of professional and compelling techniques for analyzing and visualizing data with Excel. These can be used to build Excel infographics, slide decks, reports, or any other sort of communication medium. You don’t need to invest money in new software – Excel can handle nearly anything. When you can visualize and communicate the important insights in your business, you are far ahead in many different areas. Market your ideas to a new audience wi...

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