Uploaded videos
1-10 of 19-
Excel VLOOKUP Function
ExcelFormulas
1,648 views
The VLOOKUP function is an extremely useful function. It allows you to lookup details about an item as long as you know the item id. Well worth learning.
-
Relative and Absolute Cell references in Microsoft Excel
ExcelFormulas
1,610 views
Understanding cell references is a must if you ever want to write worthwhile formulas in Excel. This video shows how and when to use each type of cell reference.
-
Excel SUM Function
ExcelFormulas
3,045 views
This video shows how to use Excel's SUM function.
-
Excel Min Function
ExcelFormulas
517 views
This video demonstrates how to use Excel's MIN function.
-
Excel MAX Function
ExcelFormulas
732 views
This video shows how to use Excel's MAX function. It also demonstrates how to combine it with conditional formatting.
-
Linking Data from Different Excel Sheets and Workbooks
ExcelFormulas
23,632 views
This video shows how to link data from different sheets and even different workbooks in Excel. It shows the linking notation and how to go about linking without having to w...
-
Excel Logical Expressions
ExcelFormulas
941 views
The most important function in Excel is the IF function and the heart of the IF function is the 'logical expression'. This video will familiarize you with the 'logical expr...
-
Introduction to Pivot Tables
ExcelFormulas
664 views
Pivot tables are just awesome. Whenever anyone says 'how much' or 'how many' combined with 'for each' or 'for every' I let go of formulas and create a pivot table for him. ...
-
Introduction to Excel Date Functions
ExcelFormulas
1,709 views
Date functions are perhaps the most feared group of functions in Excel. But when you familiarize yourself with this group of function you see that the devil ain't that bad ...
-
Introduction to Conditional Formatting
ExcelFormulas
2,064 views
This is a primer for Excel's amazing conditional formatting feature
Advertisement










Play all(19)