Completed
- Overview of Formulas
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Microsoft Office Tutorial - Learn Excel, PowerPoint and Word
Automatically move to the next video in the Classroom when playback concludes
- 1 - Intro to Excel
- 2 - What's New in Excel
- 3 - Course Overview
- 4 - Overview of the Excel Window
- 5 - Mouse Features
- 6 - BackStage View in Excel
- 7 - Text and Numbers
- 8 - Creating Basic Formulas
- 9 - Relative References
- 10 - Order of Operations
- 11 - Working with Ranges
- 12 - Practice Exercise
- 13 - Working with Save and Save As Commands
- 14 - File Extensions, Share, Exports & Publish Files
- 15 - Practice Exercise
- 16 - Opening a File
- 17 - Working with Larger Files
- 18 - Freeze Panes
- 19 - Split Screen
- 20 - Practice Exercise
- 21 - Headers & Footers
- 22 - Print Titles
- 23 - Comments in Excel
- 24 - Page Setup Options
- 25 - Fit to Print on One Page
- 26 - Printing Workbooks
- 27 - Practice Exercise
- 28 - Adding and Deleting Cells
- 29 - Chaing Column and Row Widths
- 30 - Practice Exercise
- 31 - Cut, Copy and Paste
- 32 - Copying Formulas
- 33 - Practice Exercise
- 34 - Overview of Formulas
- 35 - Create Formulas Using Functions Part 1
- 36 - Create Formulas Using Functions Part 2
- 37 - Absolute Values
- 38 - Practice Exercise
- 39 - Adding, Deleting, and Remaining Sheets
- 40 - Additional Sheet Tab Options
- 41 - Dimensional Functions
- 42 - Practice Exercise
- 43 - PowerPoint Welcome and Overview
- 44 - Navigating a PowerPoint Presentation
- 45 - Overview of the Screen and the Views
- 46 - PowerPoint Exercise 01
- 47 - Presentation Tips and Guidelines
- 48 - Creating New Presentation
- 49 - Working with Slides
- 50 - Saving Presentation
- 51 - PowerPoint Exercise 02
- 52 - Formatting Text
- 53 - Working with Bullets and Numbered Lists
- 54 - PowerPoint Exercise 03
- 55 - Inserting Shapes
- 56 - Inserting Graphics
- 57 - Inserting Icons and 3D Models
- 58 - Inserting Pictures
- 59 - PowerPoint Exercise 04
- 60 - Selecting Objects
- 61 - Editing Objects
- 62 - Formatting Objects - Part 1
- 63 - Formatting Objects - Part 2
- 64 - Arranging Objects
- 65 - Grouping Objects
- 66 - PowerPoint Exercise 05
- 67 - Picture Options
- 68 - Cropping Pictures
- 69 - Formatting Pictures
- 70 - Things You Can Do with Pictures
- 71 - PowerPoint Exercise 06
- 72 - Creating SmartArt
- 73 - Modifying SmartArt
- 74 - Creating a Flow Chart
- 75 - Word Course Overview
- 76 - Word Screen
- 77 - Backstage View
- 78 - Creating a New Document
- 79 - Non-printing Characters and Line Spacing
- 80 - Saving a Document
- 81 - Opening a Document
- 82 - Navigating a Document
- 83 - GoTo, Find and Replace
- 84 - Editing a Document
- 85 - Section 2 Practice Exercise
- 86 - AutoCorrect Options
- 87 - Selecting Text
- 88 - Cut, Copy and Paste
- 89 - Character Formatting Options
- 90 - Format Painter
- 91 - Working with Numbers
- 92 - Working with Bullets
- 93 - Creating an Outline
- 94 - Section 3 Practice Exercise
- 95 - Alignment Options
- 96 - Line Spacing Options
- 97 - Working with Indents
- 98 - Working with Tabs
- 99 - Section 4 Practice Exercise
- 100 - Sorting a List
