Earn a Certificate
Add this certificate to your resume to showcase your skills and increase your chances of getting noticed.
Our Excel Course
Zero to Hero
Try it FREE for 7 days.
$199.97 $800.00 with a 7-Day free trial
Go from a complete beginner to an advanced Excel user.
Whether you’re starting from scratch or looking to improve your Excel skills, we’ll guide you through the most essential features of Excel, step-by-step.
Best part about it all? It’s FREE! You can try our course at no risk for 7 days.
- Beginner -> Advanced
- 100+ Lessons
- Free Templates and Cheat Sheets
Earn a certificate
Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.
Course Content
1.
Course Introduction
Module 1
-
Welcome to “Zero to Hero”
01:59 -
Your Excel Journey
01:59 -
Course Guide
00:00 -
You’re Not Alone!
00:00 -
Excel Through Commitment
2. Excel Foundations
-
Test Quiz
-
What is Excel?
00:00 -
Excel’s Uses and Benefits
00:00 -
Why Excel is a Powerful Tool
00:00 -
How to Open Excel
00:00 -
Workbooks
00:00 -
Worksheets
00:00 -
Rows & Columns
00:00 -
Cells
00:00 -
Ribbon
00:00 -
Quick Access Toolbar
00:00 -
Formula Bar
00:00 -
Excel in a Nutshell
00:00 -
Excel Foundations
-
Foundations Cheat Sheet
00:00
3. Data
-
What is Data?
00:00 -
How to Enter Data
00:00 -
Understanding Data Types
00:00 -
Introduction to Data Formatting
00:00 -
Font Changes
00:00 -
Cell Styles
00:00 -
Format Painter
00:00 -
Number Formatting
00:00 -
Real World Formatting
00:00 -
Using your Data
00:00 -
Conditional Formatting
00:00
4. Formulas
-
Video Lecture 1: Introduction to Formulas: Your Key to Calculations
00:00 -
Video Lecture 2: Common Arithmetic Formulas
00:00 -
Reading: Delving into Common Functions and Formulas
00:00 -
Video Lecture 3: Date and Time Functions in Excel
00:00 -
Introduction to data series and lists
-
Interactive Exercise: Formula Crafting Workshop
-
Video Lecture 4: Troubleshooting Formulas: Avoiding Common Pitfalls
00:00 -
Real-World Application: Calculating Monthly Expenses
-
Quiz: Formula Fundamentals
-
Community Engagement: Share your formula success stories and challenges.
-
Additional Resource: Essential: Formulas and Functions Cheat Sheet
5. Organization and Analysis
-
Video Lecture 1: Sorting and Filtering: Making Sense of Data
00:00 -
Video Lecture 2: Data Validation: Keeping Your Data Clean
00:00 -
Reading: Further Exploration of Data Organization Techniques
00:00 -
Interactive Exercise: Organizing and Analyzing Data
00:00 -
Real-World Application: Organizing a Contact List
00:00 -
Quiz: Data Organization and Analysis
-
Community Engagement: Discuss how proper data organization affects analysis.
-
Additional Resource: Essential: Data Organization Toolkit
00:00
6. Data Visualization
-
Video Lecture 1: Making Data Beautiful: Intro to Visualization
00:00 -
Video Lecture 2: Your First Charts: A Picture is Worth a Thousand Cells
00:00 -
Reading: Diving Deeper into Data Visualization Tools
00:00 -
Introduction to tables and structured references
-
Interactive Exercise: Visualization Creation
-
Real-World Application: Visualizing Personal Fitness Progress
-
Quiz: Visualization Mastery
-
Community Engagement: Share your visualization creations and discuss their impact.
-
Additional Resource: Essential: Visualization Tools Guide
00:00
7. PivotTables
-
Video Lecture 1: PivotTables: Simplifying Data Analysis
00:00 -
Video Lecture 2: Your First PivotTable: It’s Easier Than You Think!
00:00 -
Reading: Unpacking Advanced PivotTable Techniques
00:00 -
Interactive Exercise: PivotTable Practice
-
Real-World Application: Analyzing Weekly Spending Habits
-
Quiz: PivotTable Prodigy
-
Community Engagement: Discuss how PivotTables have enhanced your data analysis capabilities.
-
Additional Resource: Essential: PivotTables Handbook
00:00
8. Automation
-
Video Lecture 1: Introduction to Macros: Saving Time with Automation
00:00 -
Video Lecture 2: Your First Macro: It’s a Piece of Cake!
00:00 -
Reading: A Closer Look at Macros and VBA
00:00 -
Interactive Exercise: Macro Magic Workshop
-
Real-World Application: Automating Repetitive Tasks
-
Quiz: Macro Maestro
-
Community Engagement: Share your macro creations and discuss their time-saving benefits.
-
Additional Resource: Essential: Macros and VBA Guide
00:00
9. Collaboration and Integrations
-
Video Lecture 1: Excel and Friends: Integration Basics
00:00 -
Video Lecture 2: Playing Well with Others: Excel and Other Applications
00:00 -
Reading: Exploring Excel Integration Possibilities
00:00 -
Interactive Exercise: Integration Innovation
-
Real-World Application: Planning a Small Event
-
Quiz: Integration Illumination
-
Additional Resource: Essential: Integration Tools and Techniques
10. Security
-
Video Lecture 1: Keeping It Safe: Excel Security Basics
00:00 -
Video Lecture 2: Teamwork Makes the Dream Work: Collaborative Features of Excel
00:00 -
Reading: Delving into Security and Collaboration Features
00:00 -
Interactive Exercise: Secure and Collaborative Exercise
-
Real-World Application: Collaborative Project Planning
-
Quiz: Security and Collaboration Capstone
-
Community Engagement: Discuss the importance of security and collaboration in your Excel projects.
-
Additional Resource: Essential: Security and Collaboration Toolkit
00:00
11. Career Preparation
-
Video Lecture 1: Leveraging Excel in Your Career
00:00 -
Interactive Exercise: Portfolio Project Workshop
-
Real-World Application: Job Search Strategy and Networking
-
Quiz: Career Preparation Quiz
-
Community Engagement: Share your Excel portfolio projects and discuss how you plan to leverage your Excel skills in your career.
-
Additional Resource: Job Interview Preparation Guide
00:00
12. Graduation
-
Video Lecture 1: Preparing for the Final ExaminationOverview of exam format, coverage, and expectations.
00:00 -
Final Examination: Comprehensive Exam: A blend of multiple-choice questions, short answer questions, practical Excel tasks, and problem-solving scenarios covering all modules.
-
Video Lecture 2: Final Exam ReviewDiscussion of common mistakes and the correct approaches to solving exam questions.
00:00 -
Community Engagement: Final Exam ReflectionShare experiences, challenges faced during the exam, and areas of strength or improvement.
-
Additional Resource:Final Exam Answer Key and Explanation Document: Detailed answers and explanations for the exam questions to facilitate self-assessment and understanding.
00:00 -
Feedback Survey:Exam Experience Feedback: Collect feedback on the examination experience to improve future course examinations.
