Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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:
Free Training files are included which you should use to follow along. You may download the training files for free to your computer.
Take the course now!
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introduction|
Welcome to the Excel 2010 Advanced for insurance course!Preview
About the training files
|Section 2: Simple functions|
What are formulas and functions
About formulas and functions
Rules in creating functions
Dividing multiplying and subtracting
Formulas using brackets
Min and max functions
|Section 3: Complex functions|
Left and right functions
|Section 4: Looking up data|
Rules when using vlookup
Creating a vlookup functionPreview
Testing the vlookup results
Handling vlookup errors
|Section 5: Pivot tables|
About pivot tables
Rules when creating pivot tables
Creating a pivot table
Checking the calculation type in the values area
Updating data in a pivot tablePreview
Checking results given by a pivot table
|Section 6: Sorting data|
About sorting data
Rules before sorting data
|Section 7: Filtering data|
About data filtering
Rules when filtering data
Checking the results of the filtered data
Copying filtered data somewhere else
|Section 8: Charts|
Rules in creating charts
Checking the results created in charts
|Section 9: Bonus|
BONUS Excel 2010 keyboard shortcut list
BONUS Excel 2010 keyboard shortcuts other
BONUS video lessons below: Top ten shortcuts that you must know
Saving your work
Cut, copy, paste
Undo and Redo
Print preview and print
Creating charts quickly
|Section 10: Conclusion|
Goodbye and thanks
Please rate this course!
Walter Mogane - Trainer and author
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.
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.
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.
In my spare time I enjoy going to the gym, playing tennis, table tennis, swimming, listening to Rap, Soul and R & B music. 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!