Excel 2010: How you can easily master complex functions

MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 2.5 Hours | 601 MB

Genre: eLearning | Language: English

Follow along as I show you how make Excel do all the fetching of data for you! Bonus Excel shortcut videos included!

Thereafter, the price will go to the normal price of $149.

In this course, you'll learn the 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.