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