|
Excel Dynamic Chart #10: OFFSET Function Dynamic Range
Excel Dynamic Chart #10: OFFSET Function Dynamic Range
See how to use the OFFSET function for two different types of dynamic ranges for a chart: 1)Dynamic Range that adds latest records 2)Dynamic Range that shows only last 4 Months of data Learn [...]
|
|
Excel Magic Trick 465: Lookup Entire Row with INDEX for Cake Manufacturing Calculation
Excel Magic Trick 465: Lookup Entire Row with INDEX for Cake Manufacturing Calculation
Cake Difficulty Score Calculations for manufacturing company. Learn three important tricks for SUMPROCDUCT and INDEX functions: 1.If you put a zero into the column_num argument in INDEX, it will [...]
|
|
Excel Basics #1: What Is Excel?
Excel Basics #1: What Is Excel?
The Excel Basics Series shows a systematic description of what Excel can do from beginning to end. #1 Video topics: 1)What is Excel? Calculating formulas and Data Analysis 2)Rows, Columns, Cells, Worksheets, Sheet Tab Names, Workbook [...]
|
|
Excel Basics #2: Keyboard Shortcuts
Excel Basics #2: Keyboard Shortcuts
The Excel Basics Series shows a systematic description of what Excel can do from beginning to end. #2 Video topics: 1)Ctrl + C = Copy 2)Ctrl + V = Paste 3)Ctrl + X = Cut 4)Excel 2007 [...]
|
|
Excel Basics #3: Formulas w Cell References
Excel Basics #3: Formulas w Cell References
The Excel Basics Series shows a systematic description of what Excel can do from beginning to end. #3 Video topics: 1)Formulas 2)Equal sign = 3)Ampersand & 4)Formulas with Mouse 5)Formulas with Arrow Keys 6)Formulas with [...]
|
|
Excel Lookup Series #1: VLOOKUP Function 1st Example
Excel Lookup Series #1: VLOOKUP Function 1st Example
See how to use the VLOOKUP function to deliver a value to cell: 1) Find approximate value from column 2 of lookup table. 2) Find exact value from column 2 of lookup table. Use [...]
|
|
Microsoft Excel Tutorial for Beginners #1 - Overview
Microsoft Excel Tutorial for Beginners #1 - Overview
A quick look at setting up a simple spreadsheet in Excel complete with a chart. More tutorials to follow that will go into more detail on how to use the different features of MS [...]
|
|
VLOOKUP in Excel 2007
VLOOKUP in Excel 2007
Several examples of using the VLOOKUP function in Excel 2007
From:
rrphillips
Views:
306711
348
ratings [...]
|
|
Excel Trick
Excel Trick
Easily compare numbers in Microsoft Excel.
From:
Silverado31
Views:
262724
186
ratings
Time: [...]
|
|
Making a Gantt Chart with Excel
Making a Gantt Chart with Excel
Use Excel to create a project management Gantt chart. An Excel 2007 version of this video is also in my channel.
From:
rrphillips
Views:
535535
[...]
|
