Learn Excel from the Basics to the Advanced. A systematic, logical story about Excel that explains from the beginning theories of how to construct efficient systems of spreadsheets and then points you towards the Beautiful Excel infinity at the other end! The story tries to not leave holes at any point in the story so that when you are done, you have a solid foundation to complete most tasks in Excel! Excel Tutorial, Excel How To, Excel Lessons, Learn Excel, Beginning Excel, Excel Basics
About this course
- Videos:
- 44
- Duration:
- 8 hours
Excel Basics Series 2007 (1 to 23) & 2010 (20 to 40)
Lectures in this course (44)
-
Office 2010 Class #20 What Is Excel?, Editing Ribbons & Quick Access Toolbar, File Extensions
19:53
Download files at: http://people.highline.edu/mgirvin/ExcelIsFun.htm The Excel 2010 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 ...
76,596 views
-
Office 2010 Class #21: Excel Formulas & Functions: Formula Inputs Numbers or Cell References?
31:27
Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn216.htm The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end. Topics Covered In Video: 1. Equal Sign 2. Use Ce...
86,970 views
-
Office 2010 Class #22: Excel Formulas: Math Operators and Order Of Operations
8:40
Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn216.htm The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end. Topics Covered In Video: 1) Excel operator symbol...
30,178 views
-
Office 2010 Class #23: Excel Functions & Defined Names, SUM, COUNT, COUNTA, SUMIF, COUNTIF
22:32
The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end. Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn216.htm 1. Topics Covered In Video: 2. Functions: 3. SUM...
39,244 views
-
Office 2010 Class #24: Excel Functions COUNTIF & SUMIF Count and Add with one Condition (Criteria)
17:22
The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end. Download files at: http://people.highline.edu/mgirvin/excelisfun.htm or https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn216.htm...
34,499 views
-
Office 2010 Class #25: Excel Cell References: Relative, Absolute, Mixed
34:29
Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn216.htm The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end. Topics Covered In Video: 1. Learn how to create a...
28,622 views
-
Office 2010 Class #26: Excel Assumption Tables (Formula Inputs) & Cell Ranges in Functions
21:18
Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn216.htm The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end. Topics Covered In Video: 1. Orientating Assumptio...
18,838 views
-
Office 2010 Class #27: Excel Stylistic Formatting & Page Setup For Reports
15:24
Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn216.htm The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end. Topics Covered In Video: 1. Center Across Selecti...
15,206 views
-
Office 2010 Class #28: Excel Number Formatting: Formatting As Façade
23:11
Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn216.htm The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end. Topics Covered In Video: 1. Number Formatting as ...
12,404 views
-
Office 2010 Class #29: Excel ROUND Function How And When To Use It.
12:25
Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn216.htm The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end. Topics Covered In Video: 1. When and how to use t...
16,325 views
-
Office 2010 Class #30: Excel Date Formulas: Days Invoice Past Due, Loan Maturity Date, Project Days
3:52
Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn216.htm The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end. Topics Covered In Video: 1. Date Number Format (S...
18,119 views
-
Office 2010 Class #31: Excel Time Number Format & Payroll Time Sheet Calculations
8:47
Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn216.htm The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end. Topics Covered In Video: 1. Learn about Time Numb...
25,122 views
-
Office 2010 Class #32: Excel Percentage Number Format (6 Examples)
6:37
Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn216.htm The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end. Topics Covered In Video: 1. Situation 1: Type .03...
16,029 views
-
Office 2010 Class #33: Excel Charts: Column, Bar, Pie, Line, X-Y Scatter, Sparklines Formatting
34:06
Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn216.htm The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end. Topics Covered In Video: 1. Column Charts 2. For...
44,183 views
-
Office 2010 Class #34: How Data Must Be Setup To Use Excel Data Analysis Features
5:22
Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn216.htm The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end. Topics Covered In Video: How Data Must Be Setup T...
15,381 views
-
Office 2010 Class #35: Excel Sort and Filter (Data Analysis)
18:26
Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn216.htm The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end. Topics Covered In Video: 1. Sort with Buttons 2....
38,814 views
-
Office 2010 Class #36: Excel PivotTables Pivot Tables 15 examples (Data Analysis)
24:09
Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn216.htm The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end. Topics Covered In Video: 1. PivotTables are easy:...
160,150 views
-
Office 2010 Class #37: Excel Table Feature For Dynamic Ranges in Functions, Charts, PivotTables
5:39
Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn216.htm The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end. Topics Covered In Video: 1. Learn how to use the ...
19,711 views
-
Office 2010 Class #38: Excel IF Function Formula Made Easy (7 examples)
12:20
Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn216.htm The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end. Topics Covered In Video: 1. Use IF function to pu...
92,658 views
-
Office 2010 Class #39: Excel VLOOKUP Function Formula Made Easy (3 Examples)
14:54
Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn216.htm The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end. Topics Covered In Video: 1. See how to use the VL...
62,857 views
-
Office 2010 Class #40: Excel SUM Function Keyboard Shortcut for 5000 Rows of Data
2:25
Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn216.htm The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end. Topics Covered In Video: 1. Learn Excel's best Ke...
15,954 views
-
Excel Basics #1: What Is Excel?
10:36
Download file (Excel Basics): http://people.highline.edu/mgirvin/ExcelIsFun.htm 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 Ana...
459,946 views
-
Excel Basics #2: Keyboard Shortcuts
9:57
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 Screen Tips with keyboard shortcuts 5)Ctrl + F2 = Print Pr...
186,677 views
-
Excel Basics #3: Formulas w Cell References
10:31
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 cell references 7)...
190,485 views
-
Excel Basics #4: Formulas and Functions
10:13
The Excel Basics Series shows a systematic description of what Excel can do from beginning to end. #4 Video topics: 1)Formulas with cell references 2)Formula efficiency rule: Numbers that can change go in cells and numbers that do not change ca...
171,397 views
-
Excel Basics #5: Formulas Operators and Math
6:34
The Excel Basics Series shows a systematic description of what Excel can do from beginning to end. #5 Video topics: 1)Excel operator symbols 2)Parenthesis is () 3)Exponent is ^ 4)Multiplication is * 5)Division is / 6)Adding is + 7)Subtract...
102,226 views
-
Excel Basics #6: Names Cell Ranges and Functions
10:33
The Excel Basics Series shows a systematic description of what Excel can do from beginning to end. #6 Video topics: 1)Name a range of cells 2)Name box 3)COUNT function 4)MAX function 5)MIN function 6)SUM function 7)COUNTIF function 8)SUMI...
77,026 views
-
Excel Basics #7: Range Functions
3:34
The Excel Basics Series shows a systematic description of what Excel can do from beginning to end. #7 Video topics: 1)See how a range function is more efficient than a formula without a range function 2)=SUM(A13:A18) is better than =A13+A14+A16...
80,481 views
-
Excel Basics #8: Cell References Relative & Absolute
10:03
The Excel Basics Series shows a systematic description of what Excel can do from beginning to end. #8 Video topics: 1)Cell references in formulas 2)F4 key to select the type of cell reference 3)Relative Cell Reference 4)Absolute Cell Referenc...
153,296 views
-
Excel Basics #9: Mixed Cell References in Formulas
6:42
The Excel Basics Series shows a systematic description of what Excel can do from beginning to end. #9 Video topics: 1)Learn about Mixed Cell References in Formulas from this simple example. 2)See how to create 144 formulas with just one formula...
57,125 views
-
Excel Basics #10: Formulas: Copy Vs. Cut
3:13
The Excel Basics Series shows a systematic description of what Excel can do from beginning to end. #10 Video topics: 1)See the differences between Copy a Formula and Cutting a Formula 2)Copy formula: Rules of Cell Reference Apply 3)Cut a Formu...
50,666 views
-
Excel Basics #11: Spreadsheet Setup & Cell References
10:26
The Excel Basics Series shows a systematic description of what Excel can do from beginning to end. #11 Video topics: 1)Mixed Cell References, Assumption Table Orientation, Range Functions and Inserting columns 2)Mixed Cell References in Formula...
63,045 views
-
Excel Basics #12: Stylistic & Number Formatting
10:22
The Excel Basics Series shows a systematic description of what Excel can do from beginning to end. #12 Video topics: 1)Learn about the Format Cells Dialog Box: Ctrl + 1 2)See the Number, Alignment, Font, Borders, Fill (Patterns) Tabs in the for...
42,352 views
-
Excel Basics #13: Percentage Number Format
4:28
The Excel Basics Series shows a systematic description of what Excel can do from beginning to end. #13 Video topics: 1)Learn how to not get tricked Percent Number Formatting! 2)3.00% is really the number 0.03 to Excel 3)Learn to format as you ...
45,695 views
-
Excel Basics #14: ROUND function & Number Formatting
10:07
The Excel Basics Series shows a systematic description of what Excel can do from beginning to end. #14 Video topics: 1)Number formatting only makes it look like numbers are ROUNDED. 2)The ROUND function will round your numbers so that the forma...
46,320 views
-
Excel Basics #15: Date & Time Format & Calculations
7:51
The Excel Basics Series shows a systematic description of what Excel can do from beginning to end. #15 Video topics: 1)Excel Date Calculations and Format 2)Excel Time Calculations and Format 3)Date Format Math for formulas 4)Time Format Math ...
106,236 views
-
Excel Basics #16: Chart Basics - Excel Charts
10:31
The Excel Basics Series shows a systematic description of what Excel can do from beginning to end. #16 Video topics: 1)Link Chart labels to cells using the F2 key and the equal sign 2)See chart Basics for Excel 2007 3)Column Chart Graph 4)Ba...
70,585 views
-
Excel Basics #17: Page Setup
6:59
The Excel Basics Series shows a systematic description of what Excel can do from beginning to end. #17 Video topics: 1)Fix Column Widths 2)Print Preview (Ctrl + F2) 3)Page Setup (2007: Alt + P + S + P; 2003; Alt + F + U) 4)Print Larger 5)Mar...
35,138 views
-
Excel Basics #18: Data Analysis Sort
5:31
The Excel Basics Series shows a systematic description of what Excel can do from beginning to end. #18 Video topics: 1)How to Sort a column of data 2)Sort button 3)Sort dialog box 4)Sort Left to Right 5)Excel List Table Database format is re...
87,252 views
-
Excel Basics #19: Data Analysis Subtotals
5:49
The Excel Basics Series shows a systematic description of what Excel can do from beginning to end. #19 Video topics: 1)Subtotals 2)See how to sort first and then do Subtotals 3)Major Key Field Subtotals first and then secondary field with the ...
46,124 views
-
Excel Basics #20: Data Analysis Pivot Tables PivotTables
10:23
The Excel Basics Series shows a systematic description of what Excel can do from beginning to end. #20 Video topics: 1)PivotTables Pivot Tables Basics 2)Most Powerful Excel feature for summarizing data 3)Summarize Data Quickly 4)Group By Date...
277,216 views
-
Excel Basics #21: Data Analysis Filter &Dynamic Ranges
6:02
The Excel Basics Series shows a systematic description of what Excel can do from beginning to end. #21 Video topics: 1)Filter Text 2)Filter Number 3)Filter Date 4)Filter by color 5)Sort by color 6)Excel Table or List Sort Filter Dynamic Ran...
70,157 views
-
Excel Basics #22: IF function formula made easy!
9:41
The Excel Basics Series shows a systematic description of what Excel can do from beginning to end. #22 Video topics: 1)Formula for bonus 2)TRUE FALSE formula 3)IF function formula for bonus 4)Put one of two numbers in a cell 5)Formula to check whe...
191,705 views
-
Excel Basics #23: VLOOKUP function formula
8:14
The Excel Basics Series shows a systematic description of what Excel can do from beginning to end. #23 Video topics: 1)VLOOKUP function formula 2)Data Validation List 3)VLOOKUP for Exact Match 4)VLOOKUP for Approximate Match 5)Lookup Product...
192,304 views