The Data Ribbon and PivotTables

  • 6
  • December 2024
    Friday
  • 10:00 AM PST | 01:00 PM EST

    Duration:  90  Mins

Level

Basic & Intermediate & Advanced

Webinar ID

IQW24L1241

  • Learn activate of the data ribbon menus.
  • Use the Filters menus to understand the date.
  • Learn the features of subtotal and grouping.
  • Master the use of PivotTables, charts and filters.

Overview of the webinar

The purpose of this workshop is to use the features of the data ribbon and the PivotTable of Excel for what we call datamining. Using the process of extracting and discovering patterns in small and large data sets involving methods like sorting, filtering and other Excel tools – is what we call data mining. 

When you complete this workshop – you will be able to use all the data features of Excel; sorting, filtering, using the subtotal and manipulating the data with PivotTable and PivotCharts. The attendees will be using the same Excel files that the instructor uses – with the objective of being able to use the features on their own.

Who should attend?

Any Excel user that wants to improve their day to days skills and deals with small and large databases.

Why should you attend?

The workshop is based on the instructor’s recent book.

“Excel 2022 Pro 100 + PivotTables, Charts & Reports: Explore Excel 2022 with Graphs, Animations, Sparklines, Goal Seek, Histograms, Correlations, Dashboards”

The Data Ribbon has a number of tools that will be covered

  • Sorting Data with a single or multiple variables
  • Auto Filter and other filter techniques
  • Grouping and Outlining Data – including subtotals.
  • Subtotals

The PivotTable and chart are the tools for data mining.

Pivot Tables and PivotTable Examples

  • Simple Pivot Tables
  • Advance Pivot Tables and Data Mining
  • Pivot Table Slicers for filtering the tables
  • PivotTable Timelines

You will receive all the Excel files before the workshop – so that you can practice all these techniques during the workshop and on you own.

Faculty - Dr.Isaac Gottlieb

For more than 25 years Dr. Isaac Gottlieb has been teaching Excel workshops for MBA students in a number of universities, including, Columbia, NYU, Rutgers and others in the US and other countries.  In addition, he taught courses of Management Science and Statistics for Managers (always) using Excel. Over 100,000 students have attended his workshops and courses over the past 25 years.

He received the Microsoft MVP – Most Valuable Professional – award for the years 2014-6. “A Microsoft Most Valuable Professional (MVP) is an award for individuals who have exhibited exceptional technical expertise and a talent for sharing knowledge within their technical community.”  (From Microsoft’s site.)

Isaac Gottlieb has taught how to use Excel—and how to apply it effectively to various business disciplines—to thousands corporate professionals from leading multinational companies as well as small private business corporations. Among them are Johnson & Johnson, Merck, Pfizer, Procter & Gamble, Caterpillar, Vornado, El-Al Airlines, Microsoft, Intel, Boeing, NCR, Chrysler, Sealed Air, JPMorgan, Morgan Stanley, 3M, H-P, and the New York City Economic Development Corporation.

What if you miss the Live Webinar?
Don't worry! Pay only $29 & get the full Recording.

100% MONEY BACK GUARANTEED

Refund / Cancellation policy
For group or any booking support, contact: