Completed
- Exercise 03
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel Tutorial - Beginner to Advanced
Automatically move to the next video in the Classroom when playback concludes
- 1 - Introduction
- 2 - Course Intro
- 3 - Excel 2021 vs Excel 365
- 4 - Launching Excel
- 5 - The Start Screen
- 6 - Exploring the Interface
- 7 - Ribbons, Tabs and Menus
- 8 - Backstage Area
- 9 - Quick Access Toolbar
- 10 - Useful Keyboard Shortcuts
- 11 - Getting Help
- 12 - Exercise 01
- 13 - Working with Templates
- 14 - Workbooks and Worksheets
- 15 - Saving Workbooks
- 16 - Entering and Editing Data
- 17 - Navigating and Selecting Cells, Rows and Columns
- 18 - Exercise 02
- 19 - Formulas and Functions Explained
- 20 - SUM Function
- 21 - COUNT Function
- 22 - AVERAGE Function
- 23 - MIN and MAX Function
- 24 - Handling Errors in Calculations
- 25 - Absolute vs Relative Referencing
- 26 - Autosum and Autofill Options
- 27 - Flash Fill
- 28 - Exercise 03
- 29 - What are Named Ranges
- 30 - Managing Named Ranges
- 31 - Using Named Ranges
- 32 - Exercise 04
- 33 - Applying Number Formats
- 34 - Applying Date and Time Formats
- 35 - Formatting Cells, Rows and Columns
- 36 - Format Painter
- 37 - Exercise 05
- 38 - Intermediate Course Introduction
- 39 - Improve Readability with Cell Styles
- 40 - Controlling Data Input
- 41 - Adding Navigation Buttons
- 42 - Logical Functions
- 43 - The IF Function
- 44 - Nested IFs
- 45 - The IFs Function
- 46 - Conditional IFs
- 47 - Multiple Criteria
- 48 - Error Handling
- 49 - Exercise 01
- 50 - VLookup Exact Match
- 51 - VLookup Approximate Match
- 52 - HLookup
- 53 - INDEX and MATCH
- 54 - XLookup and XMatch
- 55 - OFFSET Function
- 56 - INDIRECT Function
- 57 - Exercise 02
- 58 - Sorting on Multiple Columns
- 59 - Soring Using a Custom List
- 60 - SORT and SORTBY Functions
- 61 - Advanced Filter
- 62 - UNIQUE Function
- 63 - FILTER Function
- 64 - Exercise 03
- 65 - How Date and Times are Stored
- 66 - Custom Data and Time Formats
- 67 - Time and Date Functions
- 68 - WORKDAY and WORKDAY.INTL Functions
- 69 - NETWORKDAYS and NETWORKDAYS.INTL Functions
- 70 - DATEDIF
- 71 - EDATE and EOMONTH
- 72 - Advanced Course Introduction
- 73 - Exercise 01
- 74 - Dynamic Arrays
- 75 - Spill and Arrays
- 76 - Extract and Count Unique Entries
- 77 - Unique vs. Distinct
- 78 - Unique with Multiple Criteria
- 79 - Unique Values by Column
- 80 - SORT Function
- 81 - Horizontal Sort
- 82 - SORTBY Function
- 83 - Horizontal SORTBY
- 84 - Sequence and Unstacking Records
- 85 - Filter Function
- 86 - Using Filter with Logic Plus Operator
- 87 - Using Filter with Logic Asterisk Operator
- 88 - Using Filter with Logic Equals Operator
- 89 - Using Filter with Logic Minus Operator
- 90 - RANDARRAY and RANDBETWEEN
- 91 - XLookUp
- 92 - XMatch
- 93 - Exercise 02
- 94 - Two-way Lookups
- 95 - CHOOSE Function
- 96 - SWITCH Function
- 97 - Exercise 03
- 98 - Median and Mode
- 99 - Using LARGE and SMALL
- 100 - Ranking Data
- 101 - COUNTBLANK Function
- 102 - Exercise 04
- 103 - Rounding Values
- 104 - Specialized Rounding
- 105 - Aggregate Function
- 106 - Exercise 05
