ExcelChamp Online Courses For You
We offer online courses via recorded session, and live sessions via Zoom. Simply tell us what you want to learn, and we will be able to get you started on your learning journey.
ExcelChamp Training Courses
- Become from Excel Novice to Excel Ninja in Just 2 Hours
- Over 60 Byte Sized Lessons,
- Sample Exercise File Provided for Practicing with the videos,
- Over 2 Hours of Video Lessons.
- Learn at your own Pace. Study Anytime, Anywhere!
- Start Now
Become Good With Everyday Excel Tasks:
From Navigation to Formatting to Formulas & Functions, to Analyzing Data With Pivot Tables
- Quickly navigate Excel,
- Customize Excel,
- Create, rename worksheets and workbooks,
- Use Keyboard Shortcuts,
- Write Formulas and Functions,
- Master VLOOKUP & XLOOKUP,
- Use Tables in Excel,
- Sort & Filter data confidently,
- Pivot Tables to summarize and analyze data quickly.
- & Much More…
- ONLINE TRAINING
- Start Anytime
- Free Training
In this Excel Crash Course, You will learn:
You have data to summarize. You don’t know how and where to get started…
Excel has multiple ways to summarize Data Quickly & Easily
From simple Point & Click Techniques to Advanced Formulas, Pivot Tables & the Data Analysis Toolpak.
Now is Your Chance to Learn ALL The 10 Ways To Summarize Data With Excel.
- Pre Recorded Video
- Learn at your own Pace
- Free Training
Benefits of Learning Pivot Tables:
- Quickly Summarize Data so you can Save Time
- Analyze Data as and when needed
- Show your technical competence and expertise to the management and colleagues
- Create Management Reports, Dashboards with Summary information from Pivot Tables
- Find answers to complex questions within minutes through Pivot Table Slicing & Filtering
- Be seen as the expert in your department and company, improving your status
- It is easier to get hired and be promoted to higher roles when you have better analytical skills
- Hone your analytical skills to understand and interpret business better
- Understand the underlying trends and decide on the future course of action based on pure data insights instead of just a “gut-feel” reaction.
- Begins Mar 6, 2024
- One Module is released each week
- View all Lessons, Download All videos
- Practice with Exercise Files.
- Learn at your own Pace. Over 15 Hours of Video Lessons
Benefits of Learning Pivot Tables:
- Section 1: Before You Dive In
- Section 2: Quick Tour of Excel
- Section 3: Data Input & Hidden Features to Save Time
- Section 4: Worksheet Navigation, Copying and Protecting
- Section 5: Excel Formulas & What to be Aware of
- Section 6: Important Excel Functions (Everything you need to become Pro)
- Section 7: Data Cleaning & Management: Sorting, Filtering & Replacing data
- Section 8: Formatting including Conditional & Number Formatting in Excel
- Section 9: Printing Excel Files & Saving as PDF
- Section 10: Workbook Design Principles
- Section 11: Working With Excel Charts
- Section 12: Quick Insights with Excel Pivot Tables
- Section 13: Next Steps
- 4 Hours over 2 DAYS
- ONLINE TRAINING via ZOOM
- (Nov 18 & 19, 2023)
- Only $25 For Live Coaching
- 2 Hours each Day
In this Excel Crash Course, You will learn:
- What are the Key Excel Shortcuts?
- How to Organize data in Excel
- Absolute & Relative Referencing
- Excel Functions to to clean dirty data
- Identifying & Removing Duplicates
- Handling Dates in Excel
- Creating & Using Excel Tables
- Lookup Functions like Vlookup, Hlookup, XLookup
- Data Analysis Functions in Excel
- Introduction to Pivot Tables
- Data Analysis With Excel Pivot Tables
- Creating Excel Charts
- Refreshing Pivot Tables
- Resources to learn more
- Q&A with You
