Log in

Business Courses

Learn to use Microsoft Excel (2026) like a Pro – Intermediate Level

By Andries Nienaber

Move from basic spreadsheets into data analysis and reporting with Excel 2026 Intermediate.

$84.97 Buy this course

Format
Course
Lessons
49
License
PLR
Learn to use Microsoft Excel (2026) like a Pro - Intermediate Level

What's in the PLR package

  • Excel – Intermediate.zip 742.3 MB
  • Sales copy (Word document) Description 14 KB

Download links unlock in your account right after purchase.

Curriculum

Watch a free lessonMicrosoft Excel 365 OverviewFree · 5 min · no account neededPlay
Excel – Intermediate 2 lessons
  1. Video lesson: Microsoft Excel 365 OverviewFree preview5m
  2. Lesson: Essential Keyboard Shortcuts
Lists 6 lessons
  1. Lesson: What Are Lists
  2. Lesson: Sorting A List
  3. Lesson: Advanced Multi-Level Sorting
  4. Lesson: Custom Sort Options
  5. Lesson: Filtering Data
  6. Lesson: Converting Lists To Tables
DataBase Functions 7 lessons
  1. Lesson: Introduction To Database Functions
  2. Lesson: Dsum
  3. Lesson: Dsum With Single Criteria
  4. Lesson: Dsum With Multiple Criteria
  5. Lesson: Daverage
  6. Lesson: Dcount
  7. Lesson: Subtotal
Data Validation 3 lessons
  1. Lesson: Dropdown Lists
  2. Lesson: Decimal And Numeric Rules
  3. Lesson: Input And Error Alerts
Importing and Exporting 3 lessons
  1. Lesson: Importing Text And Csv Files
  2. Lesson: Importing Data From Ms Access And Other Sources
  3. Lesson: Exporting Data To Text Files
Creating Basic Charts 4 lessons
  1. Lesson: Building Basic Charts
  2. Lesson: Chart Tools And Ribbon
  3. Lesson: Editing Chart Data
  4. Lesson: Chart Formatting
Pivot Tables 9 lessons
  1. Lesson: Understanding Pivottables
  2. Lesson: Creating Pivottables
  3. Lesson: Pivot Calculations
  4. Lesson: Grouping Data
  5. Lesson: Formatting Pivottables
  6. Lesson: Drill Down Analysis
  7. Lesson: Pivotcharts
  8. Lesson: Filtering Pivottable Data
  9. Lesson: Pivottables And Slicers
Working with Large Data 2 lessons
  1. Lesson: Grouping Rows And Columns
  2. Lesson: Data Consolidation
LookUp Functions 4 lessons
  1. Lesson: Vlookup
  2. Lesson: Hlookup
  3. Lesson: Index And Match
  4. Lesson: Xlookup
Advanced Functions 4 lessons
  1. Lesson: Fv (Future Value)
  2. Lesson: Pmt
  3. Lesson: Hyperlinks
  4. Lesson: Text To Columns
Excel Intermediate – Conclusion 1 lesson
  1. Lesson: Course Wrap Up
Excel Intermediate Resources 2 lessons
  1. Lesson: Exercises – Importing & Exporting Data – Nails Sales Data
  2. Lesson: Resources
Marketing Videos 2 lessons
  1. Lesson: Advanced
  2. Lesson: In Todays Modern World
Free lesson

Free preview: Microsoft Excel 365 Overview

Loading the video…

Like what you see? Rebrand it, sell it, keep 100% of the income.

Get resell rights · $84.97

What you'll learn

  • Work efficiently with structured data using lists and Excel Tables
  • Apply advanced sorting and filtering techniques, including multi-level and custom rules
  • Use database-style functions (DSUM, DAVERAGE, DCOUNT, SUBTOTAL) to analyse data based on criteria
  • Control data entry with dropdown lists, validation rules, and error alerts
  • Import, clean, and export data from text files, CSVs, Access, and other sources
  • Create clear, professional charts and keep them dynamically updated
  • Build powerful PivotTables and PivotCharts to summarise and explore large datasets
  • Use slicers, grouping, and drill-down tools for interactive analysis
  • Manage and consolidate large datasets across multiple worksheets or workbooks
  • Master essential lookup functions, including VLOOKUP, HLOOKUP, INDEX & MATCH, and XLOOKUP

About this course

Move from basic spreadsheets into data analysis and reporting with Excel 2026 Intermediate. This course is intended for learners who already understand Excel basics and want to examine lists, tables and reporting tools in more detail.

Sorting, multilevel and custom sorts, filtering and converting lists into tables provide the starting point. Database-style functions, including DSUM, DAVERAGE, DCOUNT and SUBTOTAL, introduce analysis based on criteria.

Manage the data entering the workbook

Dropdowns, validation rules and error alerts connect data entry with the structure of a sheet. Importing and exporting covers text, CSV, Access and other sources, with further attention to working across larger datasets.

Build reports and explore the results

Charts, PivotTables and PivotCharts provide reporting contexts. Grouping, slicers and drill-down extend the analysis, while consolidation brings information from multiple places together.

Lookup coverage includes VLOOKUP, HLOOKUP, INDEX with MATCH and XLOOKUP. FV, PMT, hyperlinks and text-to-columns add further functions and tools. The material is relevant to office users, analysts and entrepreneurs working with recurring reports and lists.

Adapt for intermediate spreadsheet training

With PLR, you can modify, rebrand and resell the course. You could tailor it as the middle stage of an Excel learning offer or organize it around your audience’s reporting needs. Review the recorded interface and use your own data examples where they help connect the tools with familiar tasks.

Who this course is for

  • Excel users who have completed a beginner-level course and want to progress
  • Professionals working with reports, lists, or datasets in Excel 365
  • Entrepreneurs, analysts, and office users who want faster, more reliable data analysis
  • Anyone looking to gain confidence working with larger and more complex spreadsheets

License rights

License rights
Right PLR
Selling the course
Product may be sold separately YES
Product may be bundled with other products YES
Product can be a bonus for another product YES
Can be sold as a physical product YES
Can be sold as a digital product YES
Passing on rights
Can offer Resale Rights NO
Can offer Master Resale Rights NO
Can offer Private Label Rights NO
Show all 23 rights Show fewer rights
License rights, continued
Right PLR
Memberships, bonuses and lists
Can be added to paid membership sites YES
Can add bonuses to the Product for sale YES
Can be used to build a list YES
Rebranding and editing
You may put your own name on the sales letter YES
You may rename the product YES
You may edit the sales material YES
You may edit the content of the product YES
You may use the source code/material to create new products YES
You may use the name(s) of the author/creator/seller of the Product YES
Can translate the course into other languages YES
Not allowed with any license
Can be used for YouTube or other free video sites NO
Can be added to free membership sites NO
Can be given away for free NO
Can be used or sold on Uthena NO
Can be used or sold on Soofos, Udemy, Skillshare or other course marketplaces you don't own NO

Questions

What do I receive with a PLR or MRR license?

Downloadable package available; online curriculum listed. Check the file list and curriculum below for contents. PLR and MRR include a license key. Sales copy, editable formats and extras depend on the supplied package; check the listed contents.

What does lifetime access mean?

You can follow the course online for as long as it is available on Uthena. Downloadable files are guaranteed for 12 months from your purchase, so download them and keep your own copy.

Can I cancel my order?

Yes, within 7 days of your purchase: request a refund from your Uthena account. After 7 days an order can no longer be cancelled.

What if I want to speak to someone?

Email info@uthena.com, or support@uthena.com about an order, or use the contact form. We reply within two business days.

Read all questions