Completed
Subtotal Advanced
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Microsoft Excel Tutorial for Beginners - Full Course
Automatically move to the next video in the Classroom when playback concludes
- 1 Intro
- 2 Startup Screen
- 3 Increase Screen Size
- 4 Quick Access Toolbar
- 5 Ribbon
- 6 Common Shortcuts
- 7 Newline in Cell
- 8 Sheets
- 9 Formula Bar / Cells
- 10 Views
- 11 Formatting
- 12 Alignment
- 13 Dates / Custom Dates
- 14 Formulas
- 15 Auto Sum
- 16 Percentages
- 17 Relative / Absolute References
- 18 Date Calculation Error
- 19 Formula Omits Adjacent Cells
- 20 Order of Operation
- 21 Superscript
- 22 Common Functions
- 23 Average
- 24 Count
- 25 Max
- 26 Min
- 27 If
- 28 Concatenate
- 29 Vlookup
- 30 Index
- 31 Subtotal
- 32 Search for Function / Help
- 33 Modulus
- 34 Power
- 35 Ceiling
- 36 Floor
- 37 Length
- 38 Replace
- 39 Substitute
- 40 Changing Case
- 41 Date / Time Functions
- 42 Templates
- 43 Design Attractive Worksheets
- 44 Themes
- 45 Moving Tables
- 46 Merge Cells
- 47 Borders
- 48 Currency Formatting
- 49 Percentage Formatting
- 50 Format Painter
- 51 Create Custom Style
- 52 Change Style
- 53 Accent Rows
- 54 Conditional Formatting
- 55 Import Images
- 56 Import Shapes
- 57 Import Icons
- 58 3D Models
- 59 Charts
- 60 Recommend Chart
- 61 Filter Chart
- 62 Move Chart
- 63 Pie Charts
- 64 Printing Options
- 65 Page Layout
- 66 Move Page Cutoff
- 67 Create Template
- 68 Fixing Errors
- 69 IFERROR Don’t Show Formula Errors
- 70 Change Formula in Whole Column
- 71 Save Template
- 72 Import CSV
- 73 See All Sheets
- 74 Add Row
- 75 Sorting
- 76 Multi Column Sort
- 77 Sort by Month
- 78 Filter
- 79 Subtotal Advanced
- 80 Find Duplicates
- 81 Tables
- 82 Table Design Remove Duplicates
- 83 Sum vs. Subtotal
- 84 DSUM Database Sum
- 85 Calculations based on Conditions
- 86 DCOUNT Database Count
- 87 Export Data
- 88 Validating Data
- 89 Defined Minimum Length
- 90 Verify Email ISNUMBER REGEX
- 91 Valid Options from List / Data Validation
- 92 Data Validation Defined Length
- 93 Validation Custom Error Message
- 94 Split Column by Delimiter
- 95 Convert Date into Month
- 96 RANDBETWEEN Randomly Generate Values
- 97 Pivot Tables
- 98 Grouping
- 99 Formatting Pivot Tables
- 100 Showing Average
- 101 Value Field Settings
- 102 Pivot Charts
- 103 Slicer
- 104 Power Pivot
- 105 Link Tables
- 106 Using Calculations in Power Pivot
- 107 KPI Key Performance Indicator
- 108 Fixing the Budget Template
- 109 Named Ranges
- 110 Named Range Negative
- 111 Fixing Strange Excel Errors
- 112 Jump to Named Ranges
- 113 Name Manager
- 114 Conditional Characters
- 115 IF
- 116 OR
- 117 COUNTIF
- 118 Trace Precedents / Dependence
- 119 Show Formulas
- 120 Use Values from One Worksheet in Another
- 121 Watch Window
- 122 Password Protecting Worksheets
- 123 Turn Off Protection
- 124 Error Checking
- 125 Goal Seek
- 126 Paying off a Loan
- 127 Formula Dialog
- 128 How to Become a Millionaire
- 129 FV Future Value
- 130 Data Table
- 131 Solver
- 132 Maximize Profit Inventory Management
- 133 SUMPRODUCT
- 134 Scenarios
- 135 Gross Profit Scenarios
- 136 Macros
- 137 Create a Macro
- 138 Edit a Macro
- 139 Visual Basic for Applications
- 140 Create Macro Button
