## Course description

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

•     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

• 2

• 3

### Protecting Worksheets and Workbooks

• Protecting Cells in a Worksheet

• Protecting the Workbook Structure

• 4

### Conditional Formulas

• Name Ranges

• Simple IF Function

• IF, AND

• IF, OR

• Nested Formulas

• CountIF and CountIFs

• SumIF and SumIFs

• 5

• IF and IS Error - Part 1

• IF and IS Error - Part 2

• 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

• 7

### What IF Tools

• Goal Seek

• Data Tables

• Scenarios

• Solver

• 8

• 9

### Bonus # 1 - Advanced Pivot Tables

• Building a Mini Dashboard

Andries Nienaber
Office 365 - Engineer

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 Rights (PLR)

This course is available with Private Label Rights (PLR).

When you buy a course with private label rights on Uthena, the author of the course gives you permission to download the course and sell it as your own on your website according to the terms of the PLR license included.

See a sample of the PLR license.

You have the option to buy Master Resell Rights (MRR) to this course, which allows your customers to have the right to sell the course as well.

See a sample of the MRR license.

## Take this course today!

"Learn to use Microsoft Excel like a Pro - Advanced Level"

• \$37.81

• \$197.81

Course + Master Resell Rights

• \$67.81

Course + Private Label Rights

## More courses

You may like these other courses by Andries Nienaber.