BR
Upload
Thumbnail

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

About the creator

ExcelIsFun

  1. 2,031 videos
  2. 82,687 subscribers

Excel Basics Series 2007 (1 to 23) & 2010 (20 to 40)


Play all

Lectures in this course (44)

  1. Office 2010 Class #20 What Is Excel?, Editing Ribbons & Quick Access Toolbar, File Extensions

    Thumbnail 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

  2. Office 2010 Class #21: Excel Formulas & Functions: Formula Inputs Numbers or Cell References?

    Thumbnail 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

  3. Office 2010 Class #22: Excel Formulas: Math Operators and Order Of Operations

    Thumbnail 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

  4. Office 2010 Class #23: Excel Functions & Defined Names, SUM, COUNT, COUNTA, SUMIF, COUNTIF

    Thumbnail 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

  5. Office 2010 Class #24: Excel Functions COUNTIF & SUMIF Count and Add with one Condition (Criteria)

    Thumbnail 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

  6. Office 2010 Class #25: Excel Cell References: Relative, Absolute, Mixed

    Thumbnail 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

  7. Office 2010 Class #26: Excel Assumption Tables (Formula Inputs) & Cell Ranges in Functions

    Thumbnail 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

  8. Office 2010 Class #27: Excel Stylistic Formatting & Page Setup For Reports

    Thumbnail 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

  9. Office 2010 Class #28: Excel Number Formatting: Formatting As Façade

    Thumbnail 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

  10. Office 2010 Class #29: Excel ROUND Function How And When To Use It.

    Thumbnail 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

  11. Office 2010 Class #30: Excel Date Formulas: Days Invoice Past Due, Loan Maturity Date, Project Days

    Thumbnail 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

  12. Office 2010 Class #31: Excel Time Number Format & Payroll Time Sheet Calculations

    Thumbnail 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

  13. Office 2010 Class #32: Excel Percentage Number Format (6 Examples)

    Thumbnail 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

  14. Office 2010 Class #33: Excel Charts: Column, Bar, Pie, Line, X-Y Scatter, Sparklines Formatting

    Thumbnail 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

  15. Office 2010 Class #34: How Data Must Be Setup To Use Excel Data Analysis Features

    Thumbnail 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

  16. Office 2010 Class #35: Excel Sort and Filter (Data Analysis)

    Thumbnail 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

  17. Office 2010 Class #36: Excel PivotTables Pivot Tables 15 examples (Data Analysis)

    Thumbnail 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

  18. Office 2010 Class #37: Excel Table Feature For Dynamic Ranges in Functions, Charts, PivotTables

    Thumbnail 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

  19. Office 2010 Class #38: Excel IF Function Formula Made Easy (7 examples)

    Thumbnail 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

  20. Office 2010 Class #39: Excel VLOOKUP Function Formula Made Easy (3 Examples)

    Thumbnail 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

  21. Office 2010 Class #40: Excel SUM Function Keyboard Shortcut for 5000 Rows of Data

    Thumbnail 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

  22. Excel Basics #1: What Is Excel?

    Thumbnail 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

  23. Excel Basics #2: Keyboard Shortcuts

    Thumbnail 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

  24. Excel Basics #3: Formulas w Cell References

    Thumbnail 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

  25. Excel Basics #4: Formulas and Functions

    Thumbnail 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

  26. Excel Basics #5: Formulas Operators and Math

    Thumbnail 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

  27. Excel Basics #6: Names Cell Ranges and Functions

    Thumbnail 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

  28. Excel Basics #7: Range Functions

    Thumbnail 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

  29. Excel Basics #8: Cell References Relative & Absolute

    Thumbnail 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

  30. Excel Basics #9: Mixed Cell References in Formulas

    Thumbnail 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

  31. Excel Basics #10: Formulas: Copy Vs. Cut

    Thumbnail 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

  32. Excel Basics #11: Spreadsheet Setup & Cell References

    Thumbnail 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

  33. Excel Basics #12: Stylistic & Number Formatting

    Thumbnail 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

  34. Excel Basics #13: Percentage Number Format

    Thumbnail 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

  35. Excel Basics #14: ROUND function & Number Formatting

    Thumbnail 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

  36. Excel Basics #15: Date & Time Format & Calculations

    Thumbnail 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

  37. Excel Basics #16: Chart Basics - Excel Charts

    Thumbnail 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

  38. Excel Basics #17: Page Setup

    Thumbnail 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

  39. Excel Basics #18: Data Analysis Sort

    Thumbnail 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

  40. Excel Basics #19: Data Analysis Subtotals

    Thumbnail 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

  41. Excel Basics #20: Data Analysis Pivot Tables PivotTables

    Thumbnail 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

  42. Excel Basics #21: Data Analysis Filter &Dynamic Ranges

    Thumbnail 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

  43. Excel Basics #22: IF function formula made easy!

    Thumbnail 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

  44. Excel Basics #23: VLOOKUP function formula

    Thumbnail 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

to add this to Watch Later
Loading...
Working...