Learn to use Microsoft Excel like a Pro

Learn to use Microsoft Excel like a Pro - Intermediate Level

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

Course description

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

Work with DataBase functions
SumIFs
Be a master with Pivot Tables
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 - Intermediate
- Excel Intermediate Introduction
  FREE PREVIEW
- Intermediate Shortcut Keys
  FREE PREVIEW
- Intermediate Shortcut Keys
2

Lists
- What are Lists
  FREE PREVIEW
- 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

Meet your instructor!

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.

If you would like to know more about the license terms, please visit this page.

After purchasing, you will have access to the course on Uthena and you will receive the PLR license with a download link and a special bonus.