Save 40% on Coursera Plus Annual
Excel Basics Series - Complete Guide for Excel 2007, 2010, and 2013

Excel Basics Series - Complete Guide for Excel 2007, 2010, and 2013

ExcelIsFun via YouTube Direct link

Office 2013 Class #20: Excel Basics 02: Formula Inputs For Formulas and Charts & Excel's Golden Rule

2 of 71
Previous
Next

2 of 71

Office 2013 Class #20: Excel Basics 02: Formula Inputs For Formulas and Charts & Excel's Golden Rule

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Excel Basics Series - Complete Guide for Excel 2007, 2010, and 2013

Automatically move to the next video in the Classroom when playback concludes
  1. 1 Office 2013 Class #19: Excel Basics 1: Excel Grid, Formatting, Formulas, Cell References, Page Setup
  2. 2 Office 2013 Class #20: Excel Basics 02: Formula Inputs For Formulas and Charts & Excel's Golden Rule
  3. 3 Office 2013 Class #21: Excel Basics 03: Count & Add: COUNT, COUNTA, SUM, COUNTIFS, SUMIFS functions
  4. 4 Office 2013 Class #22: Excel Basics 04: PivotTables Are Easy! SUMIFS or PivotTable for Region Report
  5. 5 Office 2013 Class #23: Excel Basics 05: Customize the Quick Access Toolbar and Ribbon
  6. 6 Office 2013 Class #24: Excel Basics 6: Excel Keyboard Shortcuts Are Fast! 10 Examples.
  7. 7 Office 2013 Class #25: Excel Basics 07: What Excel Does: Calculations and Data Analysis
  8. 8 Office 2013 Class #26: Excel Basics 08: Default Alignment In Excel. Numbers stored As Text Trouble
  9. 9 Office 2013 Class #27: Excel Basics 09: Keeping Data in Excel: Proper Data Set or Excel Table
  10. 10 Office 2013 Class #28: Excel Basics 10: Style Formatting: By Hand, Cell, Table & Conditional Format
  11. 11 Office 2013 Class #29: Excel Basics 11: Number Formatting & Formulas Don't Get Tricked By The Façade
  12. 12 Office 2013 Class #30: Excel Basics 12: ROUND function: When and How to use it in Business
  13. 13 Office 2013 Class #31: Excel Basics 13: Examples of Excel Formulas & Formula Elements
  14. 14 Office 2013 Class #32: Excel Basics 14: Math and Order of Operations in Excel Formulas
  15. 15 Office 2013 Class #33: Excel Basics 15: Entering Cell References in Formulas & Edit Mode Status Bar
  16. 16 Office 2013 Class #34: Excel Basics 16: Flash Fill To Combine or Extract Text
  17. 17 Office 2013 Class #35: Excel Basics 17: Search for Excel Functions: PMT & MEDIAN Functions
  18. 18 Office 2013 Class #36: Excel Basics 18: Excel Defined Names & Built-in Functions
  19. 19 Office 2013 Class #37: Excel Basics 19: SUMIFS, COUNTIFS: Add & Count with Criteria/Conditions
  20. 20 Office 2013 Class #38: Excel Basics 20: Relative, Absolute and Mixed Cell References
  21. 21 Office 2013 Class #39: Excel Basics 21: Orientate Formula Inputs To Allow Mixed Cell References
  22. 22 Office 2013 Class #40: Excel Basics 22: Don't Violate Excel's Golden Rule
  23. 23 Office 2013 Class #41: Excel Basics 23: Sort and Filter, Basic Data Analysis (24 Examples)
  24. 24 Office 2013 Class #42: Excel Basics 24: Pivot Tables for Data Analysis (21 Examples)
  25. 25 Office 2013 Class 43, Excel Basics 25, Excel 2013 Charts: Chart Types, Chart Formatting, more
  26. 26 Office 2013 Class #44, Excel Basics 26: IF Function Made Easy 8 Examples
  27. 27 Office 2013 Class #45, Excel Basics 27: VLOOKUP Function Made Easy 24 Examples - How To Use VLOOKUP
  28. 28 Office 2010 Class #20 What Is Excel?, Editing Ribbons & Quick Access Toolbar, File Extensions
  29. 29 Office 2010 Class #21: Excel Formulas & Functions: Formula Inputs Numbers or Cell References?
  30. 30 Office 2010 Class #22: Excel Formulas: Math Operators and Order Of Operations
  31. 31 Office 2010 Class #23: Excel Functions & Defined Names, SUM, COUNT, COUNTA, SUMIF, COUNTIF
  32. 32 Office 2010 Class #24: Excel Functions COUNTIF & SUMIF Count and Add with one Condition (Criteria)
  33. 33 Office 2010 Class #25: Excel Cell References: Relative, Absolute, Mixed
  34. 34 Office 2010 Class #26: Excel Assumption Tables (Formula Inputs) & Cell Ranges in Functions
  35. 35 Office 2010 Class #27: Excel Stylistic Formatting & Page Setup For Reports
  36. 36 Office 2010 Class #28: Excel Number Formatting: Formatting As Façade
  37. 37 Office 2010 Class #29: Excel ROUND Function How And When To Use It.
  38. 38 Office 2010 Class #30: Excel Date Formulas: Days Invoice Past Due, Loan Maturity Date, Project Days
  39. 39 Office 2010 Class #31: Excel Time Number Format & Payroll Time Sheet Calculations
  40. 40 Office 2010 Class #32: Excel Percentage Number Format (6 Examples)
  41. 41 Office 2010 Class #33: Excel Charts: Column, Bar, Pie, Line, X-Y Scatter, Sparklines Formatting
  42. 42 Office 2010 Class #34: How Data Must Be Setup To Use Excel Data Analysis Features
  43. 43 Office 2010 Class #35: Excel Sort and Filter (Data Analysis)
  44. 44 Office 2010 Class #36: Excel PivotTables Pivot Tables 15 examples (Data Analysis)
  45. 45 Office 2010 Class #37: Excel Table Feature For Dynamic Ranges in Functions, Charts, PivotTables
  46. 46 Office 2010 Class #38: Excel IF Function Formula Made Easy (7 examples)
  47. 47 Office 2010 Class #39: Excel VLOOKUP Function Formula Made Easy (3 Examples)
  48. 48 Office 2010 Class #40: Excel SUM Function Keyboard Shortcut for 5000 Rows of Data
  49. 49 Excel Basics #1: What Is Excel?
  50. 50 Excel Basics #2: Keyboard Shortcuts
  51. 51 Excel Basics #3: Formulas w Cell References
  52. 52 Excel Basics #4: Formulas and Functions
  53. 53 Excel Basics #5: Formulas Operators and Math
  54. 54 Excel Basics #6: Names Cell Ranges and Functions
  55. 55 Excel Basics #7: Range Functions
  56. 56 Excel Basics #8: Cell References Relative & Absolute
  57. 57 Excel Basics #9: Mixed Cell References in Formulas
  58. 58 Excel Basics #10: Formulas: Copy Vs. Cut
  59. 59 Excel Basics #11: Spreadsheet Setup & Cell References
  60. 60 Excel Basics #12: Stylistic & Number Formatting
  61. 61 Excel Basics #13: Percentage Number Format
  62. 62 Excel Basics #14: ROUND function & Number Formatting
  63. 63 Excel Basics #15: Date & Time Format & Calculations
  64. 64 Excel Basics #16: Chart Basics - Excel Charts
  65. 65 Excel Basics #17: Page Setup
  66. 66 Excel Basics #18: Data Analysis Sort
  67. 67 Excel Basics #19: Data Analysis Subtotals
  68. 68 Excel Basics #20: Data Analysis Pivot Tables PivotTables
  69. 69 Excel Basics #21: Data Analysis Filter &Dynamic Ranges
  70. 70 Excel Basics #22: IF function formula made easy!
  71. 71 Excel Basics #23: VLOOKUP function formula

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.