Uthena is completely renewed!

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

Discover our newest courses view courses

Popular right now
Lots of people have looked at this recently
Andries Nienaber  |  SKU: UTLEA537THICOU25

Learn to use Microsoft Excel like a Pro - Advanced Level

Awesome, let’s wrap up with some industry nuances!

$37.81
License

Choose for a PLR license and you can modify the course to your needs ánd retain 100% of revenue when you sell the course.

About 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.

Curriculum

1. Excel - Advanced
- Excel Advanced Introduction
- Advanced Shortcut Keys

2. Working with Multiple Workbooks
- Tracing Precedents
- Tracing Dependants
- Watch Window
- Show Formulas

3. Protecting Worksheets and Workbooks
- Protecting Cells in a Worksheet
- Protecting the Workbook Structure
- Encryption with Passwords

4. Conditional Formulas
- Name Ranges
- Simple IF Function
- IF, AND
- IF, OR
- Nested Formulas
- CountIF and CountIFs
- SumIF and SumIFs

5. Advanced Functions
- IF and IS Error - Part 1
- IF and IS Error - Part 2
- Advanced VLookUp
- Advanced Index Match
- Dates - Part 1
- Dates - Part 2
- Replace and Substitute - Part 1
- Replace and Substitute - Part 2

6. Text Based Functions
- Left, Right and Mid Function
- Search Function
- Concatenate and Search
- Indirect - Static
- Indirect - Dynamic

Payment & Security

Payment methods

  • American Express
  • Apple Pay
  • Google Pay
  • Maestro
  • Mastercard
  • Shop Pay
  • Union Pay
  • Visa

Your payment information is processed securely. We do not store credit card details nor have access to your credit card information.

Learn to use Microsoft Excel like a Pro - Advanced Level

I you already have some intermediate knowledge of Microsoft Excel, or just completed the "Learn to use Microsoft Excel like a Pro" at the Intermediate Level, take this course "Learn to use Microsoft Excel like a Pro" at the Advanced Level to:

    Learn To Use Excel Like The Professionals

    VLookUp and Advanced VLookUps.

    Index and Match and Advanced Index and Match

    Track workbooks between teams

    Automate, streamline, and completely revolutionize your workflow with Excel


Who this course is for:

Students and Corporate employees wanting to improve their Excel skills

Course curriculum

1. Excel - Advanced
- Excel Advanced Introduction
- Advanced Shortcut Keys

2. Working with Multiple Workbooks
- Tracing Precedents
- Tracing Dependants
- Watch Window
- Show Formulas

3. Protecting Worksheets and Workbooks
- Protecting Cells in a Worksheet
- Protecting the Workbook Structure
- Encryption with Passwords

4. Conditional Formulas
- Name Ranges
- Simple IF Function
- IF, AND
- IF, OR
- Nested Formulas
- CountIF and CountIFs
- SumIF and SumIFs

5. Advanced Functions
- IF and IS Error - Part 1
- IF and IS Error - Part 2
- Advanced VLookUp
- Advanced Index Match
- Dates - Part 1
- Dates - Part 2
- Replace and Substitute - Part 1
- Replace and Substitute - Part 2

6. Text Based Functions
- Left, Right and Mid Function
- Search Function
- Concatenate and Search
- Indirect - Static
- Indirect - Dynamic

About the instructor

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.

Andries Nienaber

What can you do with PLR/MRR license for Learn to use Microsoft Excel like a Pro - Advanced Level

  • Private Label Right License (PLR)

    With a PLR license for the course: Learn to use Microsoft Excel like a Pro - Advanced Level you can do several things. The main benefits include the option to modify the content, as well as selling the course and keeping the income for yourself.

    [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

  • Master Resell Rights License (MRR)

    With a MRR license for the course: Learn to use Microsoft Excel like a Pro - Advanced Level you can do several things. The main benefit compared to a PLR license include the option to offer resell rights.

    [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
    [YES] 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