The objective 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 as the instructor – with the objective of being able to use the features on their own.
Course Objectives:
• 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.
Course Outline:
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
What You Get:
• 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.
• Live Q&A Session with our Expert
• Participation Certificate
• Access to Signup Community (Optional)
• Reward Points
Who Will Benefit:
You should attend this training if you need to use Excel to quickly build reports and summaries or if you simply want to learn how to create Pivot Tables to improve your knowledge of Excel.
• Accountants
• CPAs
• CFOs
• Financial Consultants
• Controllers
• Banking
• Finance
• Insurance
• Education
• Telecom
• IT
• Marketing
• Sales
• Investments
• Pharmaceutical
• Medical Devices
• FDA
• Aviation
• Energy
• Retail
• Human Resource
• Logistics & Supply Chain
• Accounts
• Audit
Microsoft Excel ChatGPT PivotTables Advanced Data Management Functions and Much More
Get Instant Access 90 Minutes View Program |
Filtering Techniques for Microsoft Excel Data
Get Instant Access 90 Minutes View Program |
Analyzing Data using Microsoft Excel Pivot Tables
Get Instant Access 90 Minutes View Program |
Formulas & Functions in Microsoft Excel: Solving Your Data Challenges
Get Instant Access 60 Minutes View Program |
Lookup Function Essentials in Microsoft Excel
Get Instant Access 60 Minutes View Program |
Get Instant Access On-Demand Access
Preparing for the ICE Storm: What to Do During I 9 Audits and ICE Raids
Janette S. Levey
Human Resources
Get Instant Access On-Demand Access
OSHA Inspections and Investigations-How to Manage Them
Irwin Dobrushin
Environment Health and Safety | OSHA
Get Instant Access On-Demand Access
29 CFR 1904: OSHA's New Injury Recordkeeping E-Submission Rule
Occupational Safety and Health Administration
Get Instant Access On-Demand Access
Working with Excel Databases: Sort, Filter, Subtotal and More
Cathy Horwitz
Cross Industry | Skill Enhancement
Get Instant Access On-Demand Access
Writing Audit Reports
Jonnie T. Keith CIA, CFE, CGAP, CICA
Governance, Risk and Compliance
Get Instant Access On-Demand Access
BSA Reporting Requirements
Banking and Financial Services Industry
Get Instant Access On-Demand Access
Human Factors-Usability Based on ISO 62366
Medical Device | Diagnostic | Pharmaceutical | Biologics fields
Get Instant Access On-Demand Access
Chat GPT for Project Managers
Charles H. Paul
All FDA Regulated Industry