What you'll learn
- Develop a thorough understanding of Excel's graphical user interface.
- Discover the most often used Excel functions in business.
- Create required reports by utilizing basic to advanced layout options.
- Excel 2016's secret settings can be unlocked.
- Keep big data sets in tables or lists.
- Excel's most significant talent for establishing and managing business requirements is designing professional and appealing charts for reporting purposes.
Who is this course for
- Excel users who desire to be proficient at the beginner, intermediate, and advanced levels
- Any Excel user entrusted with preparing data for further analysis and visualizations.
- People who are learning Microsoft Excel for reporting purposes
After completing this course, you will be a pro at operating excel sheets.
With this, you can get free access to
- Course Materials for Life
- Expertise in anything related to Excel Sheet
About Us
Over 100,000 students have received instruction from this online academy in topics including Lift Style, Fitness Training, Cyber Security, Ethical Hacking, Facebook Ads, SEO, Email Marketing, eCommerce, Business Investing, Social Media Marketing, Launching Your Own Business, and Marketing/Ad Agency!
We provide a wide variety of top-notch online courses that educate through real-world examples from subject matter experts and tried-and-true research, all supported by top-notch, studio vocally narrated videos! Teaching practical life skills, which are crucial in today's environment, is the focus.
Every course offered by this online learning academy is instructed by subject-matter specialists who genuinely love what they do and want to share it with others.
Course Curriculum
- excel-essentials - 01 - Week 1 Introduction (2:50)
- excel-essentials - 02 - Week 1 Discussion (3:39)
- excel-essentials - 03 - Practice Video Taking Charge of Excel (7:07)
- excel-essentials - 04 - Practice Video Navigating and Selecting (5:36)
- excel-essentials - 05 - Practice Video View Options (5:29)
- excel-essentials - 06 - Practice Video Data Entry, Data Types, Editing and Deleting (6:46)
- excel-essentials - 07 - Practice Video Fill Handle (5:30)
- excel-essentials - 08 - Week 1 Wrap-up (1:41)
- excel-essentials - 09 - Copy and Paste (5:01)
- excel-essentials - 10 - Templates (2:29)
- excel-essentials - 11 - Week 2 Introduction (2:21)
- excel-essentials - 12 - Week 2 Discussion (4:39)
- excel-essentials - 13 - Practice Video Formulas (3:32)
- excel-essentials - 14 - Practice Video Formulas in Context (4:19)
- excel-essentials - 15 - Practice Video Functions I SUM and AUTOSUM (4:19)
- excel-essentials - 16 - Practice Video Functions II AVERAGE, MIN and MAX (4:21)
- excel-essentials - 17 - Discussion Absolute Cell References (4:09)
- excel-essentials - 18 - Practice Video Absolute Cell References (3:51)
- excel-essentials - 19 - Practice Video Calculations across sheets (4:51)
- excel-essentials - 20 - Week 2 Wrap-up (1:30)
- excel-essentials - 21 - Excel Options (6:07)
- excel-essentials - 22 - Week 3 Introduction (2:42)
- excel-essentials - 23 - Week 3 Discussion (3:47)
- excel-essentials - 24 - Practice Video Formatting (3:40)
- excel-essentials - 25 - Practice Video Borders (3:54)
- excel-essentials - 26 - Practice Video Alignment Tools (4:00)
- excel-essentials - 27 - Practice Video Format Painter (3:35)
- excel-essentials - 28 - Practice Video Number Formats (5:31)
- excel-essentials - 29 - Practice Video Styles and Themes (5:05)
- excel-essentials - 30 - Week 3 Wrap-up (1:21)
- excel-essentials - 31 - Graphics (6:32)
- excel-essentials - 32 - Week 4 Introduction (1:51)
- excel-essentials - 33 - Week 4 Discussion (3:40)
- excel-essentials - 34 - Practice Video Managing Rows and Columns (4:05)
- excel-essentials - 35 - Practice Video Find and Replace (3:19)
- excel-essentials - 36 - Practice Video Filtering (6:10)
- excel-essentials - 37 - Practice Video Sorting (3:43)
- excel-essentials - 38 - Practice Video Conditional Formatting (5:46)
- excel-essentials - 39 - Week 4 Wrap-up (1:25)
- excel-essentials - 40 - Accessibility (5:21)
- excel-essentials - 41 - Week 5 Introduction (2:04)
- excel-essentials - 42 - Week 5 Discussion (3:18)
- excel-essentials - 43 - Practice Video Print Preview (4:16)
- excel-essentials - 44 - Practice Video Orientation, Margins and Scale (4:50)
- excel-essentials - 45 - Practice Video Page Breaks (5:25)
- excel-essentials - 46 - Practice Video Print Titles (4:16)
- excel-essentials - 47 - Practice Video Headers and Footers (4:37)
- excel-essentials - 48 - Week 5 Wrap-up (1:19)
- excel-essentials - 49 - Save Options (5:02)
- excel-essentials - 50 - Week 6 Introduction (2:05)
- excel-essentials - 51 - Week 6 Discussion (4:58)
- excel-essentials - 52 - Practice Video Basic Chart Types Pie, Column and Line Charts (6:13)
- excel-essentials - 53 - Practice Video Move and Resize Charts (6:04)
- excel-essentials - 54 - Practice Video Change Chart Style & Type (4:32)
- excel-essentials - 55 - Practice Video Modify Chart Elements (4:47)
- excel-essentials - 56 - Week 6 Wrap-up (1:26)
- excel-essentials - 57 - Sharing Charts (4:56)
- excel-intermediate-1 - 01 - Week 1 Introduction (2:16)
- excel-intermediate-1 - 02 - Week 1 Discussion (4:55)
- excel-intermediate-1 - 03 - Practice Video Multiple Worksheets (6:24)
- excel-intermediate-1 - 04 - Practice Video 3D Formulas (5:16)
- excel-intermediate-1 - 05 - Practice Video Linking Workbooks (6:46)
- excel-intermediate-1 - 06 - Practice Video Consolidating by Position (5:58)
- excel-intermediate-1 - 07 - Practice Video Consolidating by Category (Reference) (3:58)
- excel-intermediate-1 - 08 - Week 1 Wrap-Up (1:27)
- excel-intermediate-1 - 09 - Week 2 Introduction (2:07)
- excel-intermediate-1 - 10 - Week 2 Discussion (5:44)
- excel-intermediate-1 - 11 - Practice Video Combining Text (CONCAT, &) (4:17)
- excel-intermediate-1 - 12 - Practice Video Changing Text Case (UPPER, LOWER, PROPER) (4:34)
- excel-intermediate-1 - 13 - Practice Video Extracting Text (LEFT, MID, RIGHT) (3:55)
- excel-intermediate-1 - 14 - Practice Video Finding Text (FIND) (5:03)
- excel-intermediate-1 - 15 - Practice Video Date Calculations (NOW, TODAY, YEARFRAC) (3:52)
- excel-intermediate-1 - 16 - Week 2 Wrap-Up (1:21)
- excel-intermediate-1 - 17 - Week 3 Introduction (2:04)
- excel-intermediate-1 - 18 - Week 3 Discussion (2:57)
- excel-intermediate-1 - 19 - Practice Video Introducing Named Ranges (5:17)
- excel-intermediate-1 - 20 - Practice Video Creating Named Ranges (5:01)
- excel-intermediate-1 - 21 - Practice Video Managing Named Ranges (4:18)
- excel-intermediate-1 - 22 - Practice Video Named Ranges in Formulas (5:06)
- excel-intermediate-1 - 23 - Practice Video Apply Names (5:17)
- excel-intermediate-1 - 24 - Week 3 Wrap-Up (1:16)
- excel-intermediate-1 - 25 - Week 4 Introduction (2:01)
- excel-intermediate-1 - 26 - Week 4 Discussion (3:56)
- excel-intermediate-1 - 27 - Practice Video COUNT functions (4:26)
- excel-intermediate-1 - 28 - Practice Video Counting with Criteria (COUNTIFS) (5:10)
- excel-intermediate-1 - 29 - Practice Video Adding with Criteria (SUMIFS) (6:04)
- excel-intermediate-1 - 30 - Practice Video Sparklines (4:24)
- excel-intermediate-1 - 31 - Practice Video Advanced Charting (5:16)
- excel-intermediate-1 - 32 - Practice Video Trendlines (4:26)
- excel-intermediate-1 - 33 - Week 4 Wrap-Up (1:12)
- excel-intermediate-1 - 34 - Week 5 Introduction (2:13)
- excel-intermediate-1 - 35 - Week 5 Discussion (4:24)
- excel-intermediate-1 - 36 - Practice Video Creating and Formatting Tables (5:06)
- excel-intermediate-1 - 37 - Practice Video Working with Tables (5:53)
- excel-intermediate-1 - 38 - Practice Video Sorting and Filtering in Tables (6:06)
- excel-intermediate-1 - 39 - Practice Video Automation with Tables (5:17)
- excel-intermediate-1 - 40 - Practice Video Converting to Range and Subtotaling (5:19)
- excel-intermediate-1 - 41 - Week 5 Wrap-Up (1:28)
- excel-intermediate-1 - 42 - Week 6 Introduction (2:16)
- excel-intermediate-1 - 43 - Week 6 Discussion (2:51)
- excel-intermediate-1 - 44 - Practice Video Creating and Modifying a Pivot Table (5:58)
- excel-intermediate-1 - 45 - Practice Video Value Field Settings (5:55)
- excel-intermediate-1 - 46 - Practice Video Sorting and Filtering a Pivot Table (5:20)
- excel-intermediate-1 - 47 - Practice Video Reporting Filter Pages (6:49)
- excel-intermediate-1 - 48 - Practice Video Pivoting Charts (5:33)
- excel-intermediate-1 - 49 - Practice Video Pivoting Slicers (6:00)
- excel-intermediate-1 - 50 - Week 6 Wrap-Up (1:25)
- excel-intermediate-2 - 01 - Week 1 Introduction (2:22)
- excel-intermediate-2 - 02 - Week 1 Discussion (4:29)
- excel-intermediate-2 - 03 - Practice Video Data Validation (6:58)
- excel-intermediate-2 - 04 - Practice Video Creating Drop-down Lists (6:29)
- excel-intermediate-2 - 05 - Practice Video Using Formulas in Data Validation (7:01)
- excel-intermediate-2 - 06 - Practice Video Working with Data Validation (7:38)
- excel-intermediate-2 - 07 - Practice Video Advanced Conditional Formatting (5:20)
- excel-intermediate-2 - 08 - Week 1 Wrap-Up (2:09)
- excel-intermediate-2 - 09 - Week 2 Introduction (2:53)
- excel-intermediate-2 - 10 - Week 2 Discussion (4:05)
- excel-intermediate-2 - 11 - Practice Video Logical Functions I IF (7:30)
- excel-intermediate-2 - 12 - Practice Video Logical Functions II AND, OR (5:41)
- excel-intermediate-2 - 13 - Practice Video Combining Logical Functions I IF, AND, OR (5:09)
- excel-intermediate-2 - 14 - Practice Video Combining Logical Functions II Nested IFs (5:35)
- excel-intermediate-2 - 15 - Practice Video Handling Errors IFERROR, IFNA (6:21)
- excel-intermediate-2 - 16 - Week 2 Wrap-Up (1:47)
- excel-intermediate-2 - 17 - Week 3 Introduction (2:43)
- excel-intermediate-2 - 18 - Week 3 Discussion (4:59)
- excel-intermediate-2 - 19 - Practice Video Introduction to Lookups CHOOSE (3:45)
- excel-intermediate-2 - 20 - Practice Video Approximate Matches Range VLOOKUP (5:17)
- excel-intermediate-2 - 21 - Practice Video Exact Matches Exact Match VLOOKUP (6:40)
- excel-intermediate-2 - 22 - Practice Video Finding a Position MATCH (7:28)
- excel-intermediate-2 - 23 - Practice Video Dynamic Lookups INDEX, MATCH (7:06)
- excel-intermediate-2 - 24 - Week 3 Wrap-Up (1:28)
- excel-intermediate-2 - 25 - Week 4 Introduction (2:46)
- excel-intermediate-2 - 26 - Week 4 Discussion (3:47)
- excel-intermediate-2 - 27 - Practice Video Error Checking (9:20)
- excel-intermediate-2 - 28 - Practice Video Formula Calculation Options (6:28)
- excel-intermediate-2 - 29 - Practice Video Trace Precedents and Dependents (5:23)
- excel-intermediate-2 - 30 - Practice Video Evaluate Formula, Watch Window (8:51)
- excel-intermediate-2 - 31 - Practice Video Protecting Workbooks and Worksheets (9:37)
- excel-intermediate-2 - 32 - Week 4 Wrap-Up (1:24)
- excel-intermediate-2 - 33 - Week 5 Introduction (2:38)
- excel-intermediate-2 - 34 - Week 5 Discussion (4:08)
- excel-intermediate-2 - 35 - Practice Video Modelling Functions SUMPRODUCT (5:50)
- excel-intermediate-2 - 36 - Practice Video Data Tables (7:01)
- excel-intermediate-2 - 37 - Practice Video Goal Seek (5:12)
- excel-intermediate-2 - 38 - Practice Video Scenario Manager (8:50)
- excel-intermediate-2 - 39 - Practice Video Solver (9:48)
- excel-intermediate-2 - 40 - Week 5 Wrap-Up (1:30)
- excel-intermediate-2 - 41 - Week 6 Introduction (2:09)
- excel-intermediate-2 - 42 - Week 6 Discussion (3:39)
- excel-intermediate-2 - 43 - Practice Video Record a Macro (7:36)
- excel-intermediate-2 - 44 - Practice Video Run a Macro (5:56)
- excel-intermediate-2 - 45 - Practice Video Edit a Macro (7:05)
- excel-intermediate-2 - 46 - Practice Video Working with Macros (5:46)
- excel-intermediate-2 - 47 - Practice Video Relative Reference Macros (8:03)
- excel-intermediate-2 - 48 - Week 6 Wrap-Up (1:53)
- excel-advanced - 01 - Week 1 Introduction (2:42)
- excel-advanced - 02 - Week 1 Discussion (4:44)
- excel-advanced - 03 - Practice Video Spreadsheet Design Principles (12:49)
- excel-advanced - 04 - Practice Video Calculations (14:25)
- excel-advanced - 05 - Practice Video Formatting (11:52)
- excel-advanced - 06 - Practice Video Documentation (10:03)
- excel-advanced - 07 - Practice Video Interface and Navigation (12:39)
- excel-advanced - 08 - Week 2 Introduction (3:19)
- excel-advanced - 09 - Week 2 Discussion (4:26)
- excel-advanced - 10 - Practice Video Tables and Structured Referencing (9:43)
- excel-advanced - 11 - Practice Video Using Functions to Sort Data (8:30)
- excel-advanced - 12 - Practice Video Introduction to Array Formulas (5:26)
- excel-advanced - 13 - Practice Video Working with an Array Function (TRANSPOSE) (4:41)
- excel-advanced - 14 - Practice Video Solving Problems with Array Formulas (4:37)
- excel-advanced - 15 - Week 3 Introduction (2:11)
- excel-advanced - 16 - Week 3 Discussion (4:50)
- excel-advanced - 17 - Practice Video Replace blanks with repeating values (5:41)
- excel-advanced - 18 - Practice Video Fix Dates (DATE, MONTH, YEAR, DAY, TEXT) (6:21)
- excel-advanced - 19 - Practice Video Remove Unwanted Spaces (TRIM, CLEAN) (4:42)
- excel-advanced - 20 - Practice Video Diagnostic Tools (ISNUMBER, LEN, CODE) (7:21)
- excel-advanced - 21 - Practice Video Remove Unwanted Characters (SUBSTITUTE, CHAR, VALUE) (6:12)
- excel-advanced - 22 - Week 4 Introduction (2:13)
- excel-advanced - 23 - Week 4 Discussion (6:19)
- excel-advanced - 24 - Practice Video Working with Dates (EOMONTH, EDATE, WORKDAY.INTL) (5:47)
- excel-advanced - 25 - Practice Video Financial Functions (FV, PV, PMT) (8:22)
- excel-advanced - 26 - Practice Video Loan Schedule (PMT, EDATE) (10:49)
- excel-advanced - 27 - Practice Video Net Present Value and Internal Rate of Return (NPV, IRR) (7:47)
- excel-advanced - 28 - Practice Video Depreciation Functions (SLN, SYD, DDB) (6:29)
- excel-advanced - 29 - Week 5 Introduction (2:45)
- excel-advanced - 30 - Week 5 Discussion (5:40)
- excel-advanced - 31 - Practice Video INDIRECT (9:39)
- excel-advanced - 32 - Practice Video ADDRESS (6:19)
- excel-advanced - 33 - Practice Video Introduction to OFFSET (7:17)
- excel-advanced - 34 - Practice Video Solving Problems with OFFSET (12:17)
- excel-advanced - 35 - Week 6 Introduction (2:55)
- excel-advanced - 36 - Week 6 Discussion (4:04)
- excel-advanced - 37 - Practice Video Dashboard Design (9:49)
- excel-advanced - 38 - Practice Video Prepare Data (8:42)
- excel-advanced - 39 - Practice Video Construct Dashboard (11:05)
- excel-advanced - 40 - Practice Video Creative Charting (11:08)
- excel-advanced - 41 - Practice Video Interactive Dashboard (9:05)
Frequently Asked Questions
When does the course start and finish?
The course has begun and will never stop! You set the start and end dates for this entirely self-paced online course.
How long do I have access to the course?
Lifetime access—how does that sound? You receive unrestricted access to this course after registering for as long as you like, on any device you own.
Do I get a certificate?
Yes, when you complete the course, you will receive a certificate of completion which you can happily add to your resume or LinkedIn profile.
Can I cancel my subscription?
Yes you can. You have a 15-days money-back guarantee.