This workshop’s target is to gain new insights into the power of using Excel. You learn how to harness the incredible power of Excel in your day-to-day calculations; whether it is the area of decision-making and analysis, marketing, accounting or Finance.
This is a comprehensive coverage of Excel basics. When you complete this workshop, you will possess the necessary skill to use the software efficiently, use calculations, charts and even be able to use the statistical tools without have any statistics training.
This workshop covers many of the topics of my recent book: “Excel 2022 Pro 100 + PivotTables, Charts & Reports: Explore Excel 2022 with Graphs, Animations, Sparklines, Goal Seek, Histograms, Correlations, Dashboards”
Course Objectives:
• Excel efficiency.
• Calculations and cells addressing techniques
• Creating charts for different requirements and data visualization techniques.
• Text manipulations.
• Statistics for the non-statistician.
Course Outline:
PART 1 Introduction
1.1 Excel Efficiency
1.1.1 Auto Fill
1.1.2 Selecting in Excel
1.1.3 Selecting a section
1.1.4 Selection Shortcuts
1.1.5 Formulas, Functions and
Addressing
1.2 Renaming Cells and Ranges
PART 2 Excel Charts
2.1 Simple & Quick Charts
2.2 Creating a Chart Using theWizard
2.3 Advanced Charting techniques
PART 3 Text & AutoFill
3.1 Text manipulation
3.2 Auto-fill
PART 4 Statistics for non-statisticians
4.1 Descriptive statistics
4.2 Frequency Distributions
4.3 Data Analysis.
PART 5 Data and Data-mining
5.1 Sorting Data
5.2 Auto Filter
5.3 Grouping and Outlining Data
What You Get:
• Training Materials
• Live Q&A Session with our Expert
• Participation Certificate
• Access to Signup Community (Optional)
• Reward Points
Who Will Benefit:
This session is aimed at Excel users who wish to take their knowledge and understanding of the application to the next level.
Any person using Excel who wants to learn Excel skills. Whether you are a beginner of intermediate level user.
• 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
3 Hour Microsoft Excel Automation Boot Camp
Get Instant Access 180 Minutes View Program |
3 Hour Excel Automation Boot Camp: Sort and Filter Tools, Conditional Formatting, Data Validation and Visualizing Excel with Smart-Art and Charts
Get Instant Access 180 Minutes View Program |
3-Hour Excel Automation Boot Camp: Top Ten Excel Functions, Lookup Functions (VLOOKUP, HLOOKUP, MATCH, INDEX), Basics of Excel Macros with an Introduction to VBA
Get Instant Access 180 Minutes View Program |
3 Hour Excel Automation Boot Camp: Pivot Tables, Top 10 Functions & Formulas, Basics of Macros and VBA
Get Instant Access 180 Minutes View Program |
3-Hour Boot Camp on Mastering Excel Formulas and Functions
LIVE : Scheduled on
25-November-2026 :01:00 PM EST 180 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