Concatenate | Hunting Training

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

Concatenate

Complete and Continue