Excel 2010: How you can easily master complex functions. هذه الدورة تدرس باللغة الإنجليزية

تفاصيل الدورة

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.

• 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!