Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel 2010: How you can easily master complex functions.
Introduction
Welcome to the Excel 2010 Advanced for insurance course! (1:27)
About the training files
Training files
Simple functions
What are formulas and functions (3:38)
About formulas and functions (1:15)
Rules in creating functions (5:30)
Sum functions (5:32)
Dividing multiplying and subtracting (2:51)
Formulas using brackets (2:09)
Average function (3:20)
Count function (4:48)
Min and max functions (3:08)
Anchors (3:43)
Complex functions
Left and right functions (2:13)
Concatenate (3:32)
Trim function (2:11)
If function (4:48)
Looking up data
About vlookup (1:27)
Rules when using vlookup (3:33)
Creating a vlookup function (3:52)
Testing the vlookup results (3:26)
Handling vlookup errors (6:13)
Pivot tables
About pivot tables (2:41)
Rules when creating pivot tables (1:54)
Creating a pivot table (7:39)
Checking the calculation type in the values area (1:03)
Updating data in a pivot table (2:06)
Checking results given by a pivot table (1:35)
Sorting data
About sorting data (3:21)
Rules before sorting data (1:12)
Sorting data (3:48)
Filtering data
About data filtering (2:01)
Rules when filtering data (0:45)
Creating filters (5:39)
Checking the results of the filtered data (2:49)
Copying filtered data somewhere else (3:56)
Charts
About charts (2:19)
Rules in creating charts (1:08)
Creating charts (4:19)
Checking the results created in charts (3:43)
Updating charts (3:53)
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 (2:08)
Cut, copy, paste (3:00)
Undo and Redo (2:11)
Print preview and print (2:20)
Check spelling (2:56)
Creating tables (2:28)
Filtering data (1:45)
Autosum function (3:11)
Format painter (4:31)
Creating charts quickly (1:44)
Conclusion
Goodbye and thanks (0:29)
Please rate this course!
New Lecture
Teach online with
Creating charts
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock