Completed
Start
Class Central Classrooms beta
YouTube playlists curated by Class Central.
Classroom Contents
Office 2021 Basics - Excel & PowerPoint
Automatically move to the next video in the Classroom when playback concludes
- 1 Start
- 2 Introduction
- 3 Excel Basics Overview
- 4 Opening Excel and Selecting the Blank Workbook Template
- 5 Excel Interface
- 6 Entering Data and Using AutoFill
- 7 Numbers
- 8 Sorting Lists and Saving Files
- 9 Basic Formulas
- 10 Basic Functions
- 11 SUM Function and Function Arguments
- 12 AutoSum
- 13 Average
- 14 MAX and MIN Functions
- 15 COUNT Function
- 16 IF Function
- 17 Relative and Absolute Cell References
- 18 Nested IF Functions
- 19 Adjusting Column Widths and Formatting Numbers
- 20 Using Cell Styles to Format Data
- 21 Inserting and Hiding Rows and Columns
- 22 Cutting, Copying, and Pasting Data
- 23 Inserting New Worksheets, Renaming Tabs, and Printing
- 24 Excel Basics Recap
- 25 PowerPoint Basics Overview
- 26 PowerPoint Interface
- 27 Creating Slides
- 28 Duplicating and Deleting Slides
- 29 SmartArt
- 30 Moving Slides
- 31 Keyboard Shortcuts
- 32 Formatting Graphics and Saving Presentations
- 33 Formatting Text and Using the Format Painter
- 34 Duplicating Slides and Updating Text
- 35 Inserting Images
- 36 Formatting Images
- 37 Inserting Shapes
- 38 Formatting and Aligning Shapes
- 39 Grouping Shapes
- 40 Animation
- 41 Themes
- 42 Reviewing with Spell Check and Rehearsing
- 43 PowerPoint Takeaways
- 44 PowerPoint Basics Recap
- 45 Conclusion