Completed
- Formulas and Functions Explained
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Microsoft Excel Tutorial - Getting Started in Microsoft Excel 2021
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 - Working with Rows and Columns
- 39 - Deleting and Clearing Cells
- 40 - Aligning Text and Numbers
- 41 - Applying Themes and Styles
