Master Advanced Excel skills in a few hours. Begin now!
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Master Advanced Excel skills in a few hours. Begin now! to your Wishlist.

Add to Wishlist

Master Advanced Excel skills in a few hours. Begin now!

Be the master of Advanced Excel. Learn all the most useful skills. Free training files and bonus videos included!
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2 students enrolled
Created by Hunting Training
Last updated 6/2017
Current price: $10 Original price: $200 Discount: 95% off
5 hours left at this price!
30-Day Money-Back Guarantee
  • 3.5 hours on-demand video
  • 2 Articles
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Use the IF function to check if a client is profitable or not
  • Use a value in one sheet to fetch data from another sheet in seconds
  • Use pivot tables to easily summarize data in one sheet
  • Use charts to see visually see data and make great decisions
  • Protect cells in a sheet to prevent users from accidentally deleting important data
View Curriculum
  • You need to have the Microsoft Excel 2007 (or later) program installed on your computer.
  • Download the course training files to follow along.
  • You should have the basic computer skills.
  • You should have the basic Excel skills.

Become an expert in the most relevant advanced topics of Microsoft Excel in a few hours, increase your speed of working and sip your coffee (and relax) and by letting macros do all the work for you, and learn how to use pivot tables to easily and accurately summarize data, in a matter of seconds. And many, many more!

Although this Advanced course is for Excel 2007, you can still use the skills you learn here for the later versions of Excel, including Excel 2010, 2013 and 2016.

If you have the basic skills of using Excel, then this a perfectly logical step to take to increase your Excel skills to complete the whole picture. Master the topics in this course, and you can conquer the world. No one can tell you that you lack the most popular and most relevant advanced skills that you need in Excel. The next logical step is to start today to learn the advanced skills of Excel. And in this course, you will learn exactly that.

Topics in this course include:

  • Use macros to automate the routine tasks.
  • Use charts to visually analyse data and take corrective actions.
  • Link Excel data with outside data including Access database.
  • Workbook and worksheet protection.
  • VLOOKUP function.

Free Training Files are included which you should use to follow along. You may download the training files for free to your computer.

  • By taking this course, you will learn how to use styles to highlight cells that meet a certain criteria, such as top ten clients in terms of revenue.
  • Learn how to use the IF function to let Excel work out which reps get the highest commission and which get the lowest commission.
  • Use the VLOOKUP function to use a unique value to fetch data for you from another sheet quickly and easily.
  • Do not count how many characters there are in a cell: instead, use the LEN function to do that for you accurately and quickly.
  • Use the CONCATENATE function to join two or more cells into one cell.


  • FREE 2 videos (worth $10) showing how to expand the formula bar for those times when you have long formulas and functions, as well as summing up named ranges.

Get ready to upgrade your skills to the Advanced level of Excel today! If you change nothing, then nothing will change...

Take the course now!

Who is the target audience?
  • Users who already have the basic Excel skills and want to upgrade their skills to the advanced level
  • Data analysts who want to speed up the analysis of work
  • Accountants who want to speed the production of reports
  • Managers who don't have time to analyse data one item at a time, and who want to use graphs to quickly see the trends and make informative decisions
  • Not for users who have not used a computer before and just starting out.
  • Not for users who do not have basic Excel skills
Students Who Viewed This Course Also Viewed
Curriculum For This Course
61 Lectures
3 Lectures 04:09

What you need to know for this course

Training files
8 Lectures 24:59
Highlight cells rules part 1

Highlight cells rules part 2

Data bars

Color scales

Icon sets

Creating new rules part 1

Creating new rules part 2
Working with data
14 Lectures 01:02:31
Working with external data


Advanced filters

Data validation lists

Data validation other

Consolidate data

What if analysis goal seek

What if analysis scenario manager part 1

What if analysis scenario manager part 2

What if analysis data table

Working with outlines group

Working with outlines subtotal
The famous IF function
4 Lectures 14:23
What is the IF function

Working with text

Multiple statements
Vlookup function
5 Lectures 19:02

Rules when using vlookup

Creating a vlookup formula

Testing the vlookup results

Handling vlookup errors
Other Common Functions
4 Lectures 10:38
Text function

Len function

Concatenate function

Date function
Pivot tables
6 Lectures 18:19
About pivot tables

Rules when creating pivot tables

Creating a pivot table part 1

Creating a pivot table part 2

Updating data on a pivot table

Checking results given by a pivot table
3 Lectures 12:19
Different chart types part 1

Different chart types part 2

Creating pivot charts
Protecting your work
5 Lectures 20:44
Why protect your workbook

Preparing for protection

Protecting a worksheet

Protecting a workbook

Unprotecting worksheets and workbooks
Introducing macros
5 Lectures 20:04
What is a macro

Before recording a macro

Recording a macro part 1

Recording a macro part 2

Editing a macro
2 More Sections
About the Instructor
Hunting Training
4.3 Average rating
9 Reviews
642 Students
5 Courses
Active investor. Experienced Trainer. Qualified Accountant.

Walter Mogane

Experienced investor
I have been investing in property for more than 9 years. I have been fortunate enough to be able to own 5 properties which are worth over R5.5 million Rands (about $420 000). I have been receiving steady positive cash flow over these years from these properties. I also invest in commodities. 

I previously bought Krugerrands (gold coins) and sold them at a profit to have a deposit for one of the properties I mentioned. 

I currently have Silver coins and planning to get more as the price of them decreases. I'm an active investor. 

This is the knowledge and experience that I would like to share with the world and show people that it can be done, and why saving is outdated. I also love guiding people on how to change the financial path to make their lives easier and not waste their hard-earned cash.

Experienced Trainer
As an Excel trainer I love teaching Excel to students, business men and women or just the guys working for an employer. I emphasize how important it is to apply the Excel knowledge you will have gained in your every day job. That way you truly become more productive. 

I have been teaching Excel and other Microsoft suite programs for over 15 years and have received diplomas in Basic, Intermediary and Advanced Microsoft courses. I also received an outstanding achievement award for the Advanced Excel course I completed. 

Qualified Accountant
I'm a qualified accountant by profession. I have been working as an accountant for more 20 years in different companies. I have extended experience and knowledge in the accounting field for over 20 years. Some of the knowledge comes in handy when I make investment decisions regarding whether or not to buy property. Yep, you can also call me a number cruncher ;)

General information about the courses
You can do the sections in any order you like. I don't believe that you have to do the sections in a forced order. This also is very helpful if you just want to dive into a particular section, without having to do the other sections first. Having said that, I do recommend that you do the sections in the order they are available in the course.

I believe that it is vital that you do the quizzes for each lesson as you progress to test your understanding. If you get some questions incorrect in a quiz, don't worry, just try again until you come right.

Other facts about myself!
In my spare time I enjoy going to the gym, playing tennis, table tennis, swimming, listening to Rap, Soul and R & B music. I also enjoy reading inspirational books. Sometimes I just generally enjoy coming up with solutions to some of the world problems. I believe that's my entrepreneurial spirit talking. Oh well... there I said it!

I also enjoy spending time with my family watching family movies although my kids and my loved one always sleep halfway through the movies. So, well, I ended up watching the movies alone. Sniff, sniff!