Excel 2010: How you can easily master complex functions.
2.8 (2 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.
7 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel 2010: How you can easily master complex functions. to your Wishlist.

Add to Wishlist

Excel 2010: How you can easily master complex functions.

Follow along as I show you how to make Excel do all the fetching of data for you! Bonus Excel shortcut videos included!
2.8 (2 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.
7 students enrolled
Created by Hunting Training
Last updated 2/2016
English
Current price: $10 Original price: $200 Discount: 95% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • 3 Articles
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Create charts to present data in a more fun and easy-to-understand way
  • Review the charts created to check if there are no human errors, to make them more accurate
  • Filter data so that you can focus on the most important data and make quicker decisions
  • Sort data from A to Z or from Z to A to make its analysis quicker and save valuable time
  • Learn how to create one of Excel's most popular and useful tools: Pivot tables
  • Create pivot tables and let Excel do all the work for you to summarize data so that you don't spend hours and hours of your time manually organizing data
  • Update pivot tables when you data changes and have Excel re-organize your data in a matter of seconds
  • Learn how to use probably the most used function in Microsoft Excel, the Vlookup function
  • Master the vlookup function to compare two sets of data and look up matching information and let Excel fetch that information for you
  • Learn how to handle the vlookup errors and fix them easily
  • Master the much talked about and difficult function: the IF function
  • Learn how to use the IF function to easily solve every day problems
  • Save plenty of your precious time by using the TRIM function to easily shave off your armpits... umm, I meant the extra spaces in data cells
  • Learn how to join two cells together into one cell, not by manually typing the contents, but by using the CONCATENATE function
View Curriculum
Requirements
  • You will need Excel 2010 or later installed on your computer.
  • You should have the basic computer skills.
  • You will need to download the training files provided, in order to follow along.
  • You should have the basic knowledge of Excel.
Description

In this course, you'll learn how to master Microsoft Excel 2010 for insurance, master complex functions and save hours and hours of work by using Excel's built-in tools.

I have seen many of my friends working with large amounts of data in Excel and hating their work. You know why? They would rather watch movies and TV shows on Netflix and DSTV at home. Their work is tedious, boring and unchallenging. It takes ages to complete the every day tasks that are given to them. Basically they just go to work 'cos they have to pay their bills. They do their 9 to 5 and nothing more.

That can change! By learning new skills in this course, you won't need to be like them! You can make your work exciting by making Excel sweat for you and make you look professional at the same time. YOU take all the credit. How? Let me tell ya...

By using pivot tables, Excel will do all the hard work for you by organizing the data you give to it in the most accurate and neat way! You will easily see which of your sales representatives is bringing in the most business in the company. By using the Vlookup function, you will match 2 sets of data, fetch the data you are looking for and complete the data you need to work, all accurately and in seconds. By using the IF function, you can have Excel give one answer if data says one thing and automatically give you a different answer if the data changes. It's all done by Excel, as long as you give it the correct instructions on what to do! I will show exactly you how to do all these things (and more) in this course.

Topics in this course include:

  • CONCATENATE function.
  • IF function.
  • TRIM function.
  • Create a Vlookup function.
  • Create a Pivot table.
  • Rules before sorting data.
  • Updating charts.

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

Benefits:
  • Take this course in order to let Excel help you by summarizing data accurately and quickly by creating pivot tables.
  • By using the Excel 2010 for insurance, you learn how to quickly and efficiently check which of your clients generate the highest gross premium for your business.
  • You will impress yourself when you start creating accurate reports, including charts for you to easily make decisions on business.
  • You'll make your work more exciting by changing the way you do things from now on. You will no longer have to do things manually. Excel is here to help you: let it!
  • You will no longer have to get scared of the complex functions such as IF, VLOOKUP and CONCATENATE. They are your friends, my friend! I'm here to take that fear away from you by helping you understand them and use them to speed up your work and bring back the fun in your work!


BONUS:

  • A FREE PDF listing all the Excel 2010 keyboard shortcuts.
  • A FREE PDF listing other important Excel 2010 keyboard shortcuts.
  • FREE 10 videos (worth $30) showing the top 10 keyboard shortcuts that every Excel user must know.

Take the course now!


Who is the target audience?
  • This Advanced Microsoft Excel course is meant for the guys and girls who have the basic and intermediary Excel skills
  • This Excel 2010 advanced course is aimed at the dudes who already have the basic computer skills
  • If you want to understand the most useful functions used by many Excel users today such as the IF, CONCATENATE and VLOOKUP function, this course is definitely for you!
  • If you want to master the creation of charts and want to present data in a friendlier and more presentable way, you should take this course
  • This Excel course is meant to help you if you want to save hours of your time and eliminate the possibility of making more human errors when preparing data
  • This Excel course for you if you want to solve your reporting problems when preparing the insurance reports such as annual financial statements (AFS), management accounts and statutory reports. But the skills you'll be learning here can be applied in any industry.
  • This course is NOT for you if you are just starting out to learn a computer and starting to learn Excel
Students Who Viewed This Course Also Viewed
Curriculum For This Course
56 Lectures
02:35:12
+
Introduction
3 Lectures 01:54

About the training files
00:28

Training files
2.2 MB
+
Simple functions
10 Lectures 35:42
What are formulas and functions
03:37

About formulas and functions
01:15

Rules in creating functions
05:28

Sum functions
05:30

Dividing multiplying and subtracting
02:50

Formulas using brackets
02:08


Count function
04:46

Min and max functions
03:07

Anchors
03:42
+
Complex functions
4 Lectures 12:39
Left and right functions
02:12


Trim function
02:10

If function
04:46
+
Looking up data
5 Lectures 18:26
About vlookup
01:27

Rules when using vlookup
03:32


Testing the vlookup results
03:25

Handling vlookup errors
06:11
+
Pivot tables
6 Lectures 16:54
About pivot tables
02:40

Rules when creating pivot tables
01:54

Creating a pivot table
07:37

Checking the calculation type in the values area
01:03


Checking results given by a pivot table
01:35
+
Sorting data
3 Lectures 08:19
About sorting data
03:20

Rules before sorting data
01:12

Sorting data
03:47
+
Filtering data
5 Lectures 15:04
About data filtering
02:00

Rules when filtering data
00:44

Creating filters
05:37

Checking the results of the filtered data
02:48

Copying filtered data somewhere else
03:55
+
Charts
5 Lectures 15:17
About charts
02:18

Rules in creating charts
01:08

Creating charts
04:17

Checking the results created in charts
03:42

Updating charts
03:52
+
Bonus
13 Lectures 26:16
BONUS Excel 2010 keyboard shortcut list
2 pages

BONUS Excel 2010 keyboard shortcuts other
2 pages

BONUS video lessons below: Top ten shortcuts that you must know
00:11

Saving your work
02:07

Cut, copy, paste
02:59

Undo and Redo
02:10

Print preview and print
02:19

Check spelling
02:55

Creating tables
02:28

Filtering data
01:44

Autosum function
03:10

Format painter
04:29

Creating charts quickly
01:44
+
Conclusion
2 Lectures 00:40
Goodbye and thanks
00:29

Please rate this course!
00:11
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!