Learn to use Microsoft Excel (2026) like a Pro – Intermediate Level
Move from basic spreadsheets into data analysis and reporting with Excel 2026 Intermediate.
$84.97 Buy this course
- Format
- Course
- Lessons
- 49
- License
- PLR

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.
Uthena newsletter
Get 10% off this course
Join the newsletter for new courses and deals. Your code shows right after you sign up.
Curriculum
Excel – Intermediate
- Video lesson: Microsoft Excel 365 OverviewFree preview5m
- Lesson: Essential Keyboard Shortcuts
Lists
- Lesson: What Are Lists
- Lesson: Sorting A List
- Lesson: Advanced Multi-Level Sorting
- Lesson: Custom Sort Options
- Lesson: Filtering Data
- Lesson: Converting Lists To Tables
DataBase Functions
- Lesson: Introduction To Database Functions
- Lesson: Dsum
- Lesson: Dsum With Single Criteria
- Lesson: Dsum With Multiple Criteria
- Lesson: Daverage
- Lesson: Dcount
- Lesson: Subtotal
Data Validation
- Lesson: Dropdown Lists
- Lesson: Decimal And Numeric Rules
- Lesson: Input And Error Alerts
Importing and Exporting
- Lesson: Importing Text And Csv Files
- Lesson: Importing Data From Ms Access And Other Sources
- Lesson: Exporting Data To Text Files
Creating Basic Charts
- Lesson: Building Basic Charts
- Lesson: Chart Tools And Ribbon
- Lesson: Editing Chart Data
- Lesson: Chart Formatting
Pivot Tables
- Lesson: Understanding Pivottables
- Lesson: Creating Pivottables
- Lesson: Pivot Calculations
- Lesson: Grouping Data
- Lesson: Formatting Pivottables
- Lesson: Drill Down Analysis
- Lesson: Pivotcharts
- Lesson: Filtering Pivottable Data
- Lesson: Pivottables And Slicers
Working with Large Data
- Lesson: Grouping Rows And Columns
- Lesson: Data Consolidation
LookUp Functions
- Lesson: Vlookup
- Lesson: Hlookup
- Lesson: Index And Match
- Lesson: Xlookup
Advanced Functions
- Lesson: Fv (Future Value)
- Lesson: Pmt
- Lesson: Hyperlinks
- Lesson: Text To Columns
Excel Intermediate – Conclusion
- Lesson: Course Wrap Up
Excel Intermediate Resources
- Lesson: Exercises – Importing & Exporting Data – Nails Sales Data
- Lesson: Resources
Marketing Videos
- Lesson: Advanced
- Lesson: In Todays Modern World
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
| 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
| 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.