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.
1 student 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.
1 student enrolled
Created by Hunting Training
Last updated 6/2017
English
Current price: $10 Original price: $200 Discount: 95% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 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
Requirements
  • 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.
Description

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.

BONUS:

  • 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
03:32:59
+
Introduction
3 Lectures 04:09

What you need to know for this course
01:21

Training files
00:02
+
Styles
8 Lectures 24:59
Highlight cells rules part 1
04:35

Highlight cells rules part 2
03:22


Data bars
01:39

Color scales
01:16

Icon sets
01:46

Creating new rules part 1
03:40

Creating new rules part 2
04:29
+
Working with data
14 Lectures 01:02:31
Working with external data
05:46

Connections
03:25

Advanced filters
04:22



Data validation lists
02:42

Data validation other
03:42

Consolidate data
06:45

What if analysis goal seek
03:58

What if analysis scenario manager part 1
03:14

What if analysis scenario manager part 2
05:19

What if analysis data table
04:00

Working with outlines group
06:05

Working with outlines subtotal
03:22
+
The famous IF function
4 Lectures 14:23
What is the IF function
02:26


Working with text
02:22

Multiple statements
05:28
+
Vlookup function
5 Lectures 19:02

Rules when using vlookup
03:38

Creating a vlookup formula
04:14

Testing the vlookup results
03:07

Handling vlookup errors
06:33
+
Other Common Functions
4 Lectures 10:38
Text function
02:06

Len function
02:17

Concatenate function
04:45

Date function
01:30
+
Pivot tables
6 Lectures 18:19
About pivot tables
03:08

Rules when creating pivot tables
02:01

Creating a pivot table part 1
05:15

Creating a pivot table part 2
03:55

Updating data on a pivot table
02:12

Checking results given by a pivot table
01:48
+
Charts
3 Lectures 12:19
Different chart types part 1
03:40

Different chart types part 2
03:52

Creating pivot charts
04:47
+
Protecting your work
5 Lectures 20:44
Why protect your workbook
01:53

Preparing for protection
03:07

Protecting a worksheet
04:14

Protecting a workbook
06:02

Unprotecting worksheets and workbooks
05:28
+
Introducing macros
5 Lectures 20:04
What is a macro
01:29

Before recording a macro
03:12

Recording a macro part 1
04:53

Recording a macro part 2
04:49

Editing a macro
05:41
2 More Sections
About the Instructor
Hunting Training
4.3 Average rating
9 Reviews
640 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!