Search 6,000+ CA Community College Courses
Excel for Accounting - Formulas, VLOOKUP & INDEX, PivotTables, Recorded Macros, Charts, Keyboards

Excel for Accounting - Formulas, VLOOKUP & INDEX, PivotTables, Recorded Macros, Charts, Keyboards

ExcelIsFun via YouTube Direct link

Page Setup: Alt, P, S, P

11 of 98
Previous
Next

11 of 98

Page Setup: Alt, P, S, P

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Excel for Accounting - Formulas, VLOOKUP & INDEX, PivotTables, Recorded Macros, Charts, Keyboards

Automatically move to the next video in the Classroom when playback concludes
  1. 1 Keyboards
  2. 2 Jump: Ctrl + Arrow
  3. 3 Go To Cell A1: Ctrl + Home
  4. 4 Format Cells dialog box or in a chart Format Chart dialog box: Ctrl + 1
  5. 5 Currency Number Format: Ctrl + Shift + 4
  6. 6 Highlight column: Ctrl + Shift + Arrow
  7. 7 Currency Vs Accounting Number Format
  8. 8 Alt keys:
  9. 9 PivotTable: Alt, N, V, T
  10. 10 PivotTable 2003: Alt, D, P
  11. 11 Page Setup: Alt, P, S, P
  12. 12 SUM: Alt + =
  13. 13 "Put thing in cell and move selected cell up": Shift + Enter
  14. 14 "Put thing in cell and keep cell selected": Ctrl + Enter
  15. 15 Select sheet to right: Ctrl + PageDown
  16. 16 Select sheet to left: Ctrl + PageUp
  17. 17 Number Formatting As Façade:
  18. 18 Decimal Number Format
  19. 19 Date Number Format
  20. 20 Keyboard for today's hard caded date:
  21. 21 Time Number Format
  22. 22 Percentage Number Format
  23. 23 Efficient Formula Creation
  24. 24 Excel's Golden Rule: If a formula input can vary, put it in a cell and refer to it in the formula with a cell reference
  25. 25 Formula elements, types of formulas, types of data
  26. 26 Monthly Allocation Formula: illustrate formula input that can be hard coded into formula
  27. 27 Tax inefficient formula: illustrate formula input that can should NOT hard coded into formula
  28. 28 Tax efficient formula: illustrate Golden Rule
  29. 29 Net Cash In formula: illustrate Golden Rule
  30. 30 Net Income formula: illustrate formula with built-in function within a larger formula
  31. 31 In Balance? formula: illustrate Logical formula
  32. 32 First & Last Name Join Formula: illustrate Text formula
  33. 33 COUNTIF formula: illustrate counting with criteria
  34. 34 COUNTIF & Label formula: illustrate counting with criteria and how the join symbol is used with criteria
  35. 35 Clear Formatting
  36. 36 SUMIFS to add with two criteria
  37. 37 SUMIFS to add between 2 dates
  38. 38 Count workdays formula to illustrate new Excel 2010 function NETWORKDAYS.INTL
  39. 39 Relative and Absolute Cell References
  40. 40 Mixed cell references in budget formula
  41. 41 Lookup Formulas
  42. 42 VLOOKUP to lookup product price: illustrate Exact Match lookup
  43. 43 Data Validation List:
  44. 44 VLOOKUP and IFERROR
  45. 45 VLOOKUP to lookup commission rate: illustrate Approximate Match lookup
  46. 46 Retrieve record 2-way lookup with VLOOKUP and MATCH
  47. 47 MATCH, ISNA and ISNUMBER functions to compare 2 lists
  48. 48 INDEX and MATCH to lookup Left
  49. 49 Pivot Tables
  50. 50 Proper Data Set
  51. 51 PivotTables Pivot Tables are Easy
  52. 52 Visualize Table First
  53. 53 Adding with One or Two Conditions Criteria
  54. 54 Report Layout
  55. 55 Number Formatting
  56. 56 Style Formatting, Create Your Own
  57. 57 Pivoting
  58. 58 Listing Two Fields in Row Labels
  59. 59 Collapsing Pivot Table Row
  60. 60 Changing Calculation: SUM to AVERAGE
  61. 61 Adding with Three Criteria
  62. 62 Filtering a Row Show Top Two Regions, Clear Filter
  63. 63 Filter whole report with Report Filter
  64. 64 Show Report Filter Pages 30 PivotTables with 1 click
  65. 65 Filter whole report with Report Filter or Slicer
  66. 66 Compare Formulas and PivotTables
  67. 67 Grouping Dates in PivotTables
  68. 68 Difference between Grouping Integers and Grouping Decimals
  69. 69 Pivot Chart
  70. 70 Show Values As:
  71. 71 Copy PivotTable
  72. 72 Running Totals & % Running Totals
  73. 73 % of Grand Totals, % of Column Total, % of Row Total
  74. 74 Difference From, % Difference From
  75. 75 Multiple Calculation in one PivotTable
  76. 76 Creating Second PivotTable from Second Cache of data using Excel 2003 keyboard shortcut for 3-step Wizard
  77. 77 Blank in number field causes PivotTable to Count by Default
  78. 78 Text in Date field prohibits Grouping of Dates
  79. 79 Basic Recorded Macro
  80. 80 Absolute References and save in Personal Workbook
  81. 81 How to trick the Macro Recorder into seeing a variable height report using Relative References
  82. 82 Rearrange records from vertical orientation to proper table using Relative References
  83. 83 Charts
  84. 84 Chart Types
  85. 85 Column Chart and How The Chart Wizard Interprets Data From Cells
  86. 86 Chart keyboards Create Default Chart
  87. 87 Select Data Source Dialog Box
  88. 88 Linking Chart Title to Cells
  89. 89 Saving Chart Templates
  90. 90 Setting Default Charts
  91. 91 Copy Charts
  92. 92 Bar and Stacked Bar charts
  93. 93 Line Chart & Change Source Data
  94. 94 Number Formatting to show "K" or "M"
  95. 95 Line Chart vs. X Y Chart
  96. 96 X Y Scatter
  97. 97 X Y Scatter Line Break Even Analysis Chart
  98. 98 Multiple chart types

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.