Become an affiliate and earn 20% commission -> Join program

Sign up and sell your own courses with PLR licenses learn more

Discover our newest courses view courses

Learn to use Microsoft Excel like a Pro - Intermediate Level

2.5 hours

Great now, let’s start with using a few clever formulas!

Get Private Label rights for this online course today and start selling it as your own!

License Type
$3781

Get a PLR License and:

✔ Whitelabel and brand as your own
✔ Modify and change to your needs
✔ Sell as your own and get 100% of earnings
✔ Make it a part of your product or offering
✔ Direct access after purchase

Preview Course

Specifications
  • Units
    45

Curriculum

1. Excel - Intermediate
- Excel Intermediate Introduction
- Intermediate Shortcut Keys
- Intermediate Shortcut Keys

2. Lists
- What are Lists
- Sorting a List
- Sorting - Multiple Criteria
- Custom Sort
- What are Filters
- Format a List as a Table

3. DataBase Functions
- Introduction to DataBase Functions
- DSum Function
- DSum Function - Single Criteria
- DSum Function - Multiple Criteria
- DAverage
- DCount Function
- Subtotal

4. Data Validation
- Data Validation - List
- Data Validation - Decimal
- Input and Error Messages

5. Importing and Exporting
- Importing Data from Text Files
- Importing Data from MS Access
- Exporting Data to a Text File

6. Creating Basic Charts
- Creating Basic Charts
- The Chart Ribbon
- Adding and Modifying Data on a Chart
- Formatting Charts

7. Pivot Tables
- Understanding Pivot Tables
- Creating Pivot Tables
- Pivot Table Calculations
- Grouping Pivot Table Data
- Formatting Pivot Table Data
- Drilling Down into Pivot Table Data
- Creating Pivot Charts
- Filtering Pivot Table Data
- Filtering using the Slicer

8. Working with Large Data
- Grouping Data
- Consolidating Data

9. LookUp Functions
- VLookUp
- HLookUp
- Index and Match

10. Advanced Functions
- FV Function
- PMT Function
- Hyperlinks
- Text to Columns

11. Excel Intermediate - Conclusion
- Excel Intermediate - Conclusion

  • Direct Access

    You will receive the download files directly after purchase

  • Make it your own

    Modify, improve and change the course to your liking.

  • 14 Day Return Right

    Not happy with the course? You can request a refund within 14 days.

Get Private Label Rights for this online course:

Learn to use Microsoft Excel like a Pro - Intermediate Level

Are you ready to elevate your Excel skills? With our course, Learn to use Microsoft Excel like a Pro - Intermediate Level, you'll take your foundational knowledge of Excel to the next level. This course is designed for those who have basic Excel skills or have just completed the Beginner Level course. Dive into the world of advanced Excel functionalities that will transform how you work with data.

Course Highlights:

  • Master essential Database functions, including SUMIFs, to analyze data efficiently.
  • Become an expert in Pivot Tables, allowing you to summarize and visualize your data effortlessly.
  • Learn to automate repetitive tasks, streamlining your workflow and saving you valuable time.
  • Gain insights into data management that can revolutionize how you handle information in Excel.

Who Should Enroll:

This course is perfect for students and corporate employees looking to enhance their Excel abilities. Whether you aim to improve your data analysis or optimize your reporting processes, this course will equip you with the tools you'll need to succeed.

Join us and learn to use Microsoft Excel like a Pro - Intermediate Level today, and unlock the full potential of this powerful tool for your professional and personal growth!

About the instructor

Andries Nienaber

Hi there, my name is Andries and I have been working with Excel for over 20 years. I have worked with major corporate companies such as Nespresso and various Banks.

I currently am one of the preferred in classroom trainers for Office and I am dedicated to helping you create outstanding tools and reports in Excel. Our courses are for those who want to learn Excel, accelerate your careers and achieve more in less time.

For over 20 years I have worked in the Finance and IT departments implementing reporting systems based on SQL and XML. All the while using Excel VBA to automate and improve processes.

Our courses include examples based on real-life experience as well as the consulting work I have done for many international companies.

I place great value on keeping my Excel courses not only informative but also engaging. For this reason, students will find enough challenges, exercises, and downloadable files to practice so they can maximize the value gained from each course.

  • Private Label Right License (PLR) for the course: Learn to use Microsoft Excel like a Pro - Intermediate Level

    With a PLR license you can modify and change a course to your needs. Next to this, you can keep 100% of the income if you sell the course as a part of your own products. This is what you can do:

    [YES] 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 added to paid membership sites
    [YES] Can add bonuses to the Product for sale
    [YES] Can be sold as a physical product
    [YES] Can be sold as a digital product
    [YES] 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] Can be used to build a list

    [NO] Can offer Resale Rights
    [NO] 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 Udemy, Skillshare, or other course platforms you don't own
    [NO] Can offer Master Resale Rights
    [NO] Can offer Private Label Rights

Back to top