Microsoft Office Tutorial for Beginners - Learn Excel, PowerPoint, Word & Outlook
Simon Sez IT via YouTube
Overview
Syllabus
- Intro to Excel
- What's New in Excel
- Course Overview
- Overview of the Excel Window
- Mouse Features
- BackStage View in Excel
- Text and Numbers
- Creating Basic Formulas
- Relative References
- Order of Operations
- Working with Ranges
- Practice Exercise
- Working with Save and Save As Commands
- File Extensions, Share, Exports & Publish Files
- Practice Exercise
- Opening a File
- Working with Larger Files
- Freeze Panes
- Split Screen
- Practice Exercise
- Headers & Footers
- Print Titles
- Comments in Excel
- Page Setup Options
- Fit to Print on One Page
- Printing Workbooks
- Practice Exercise
- Adding and Deleting Cells
- Chaing Column and Row Widths
- Practice Exercise
- Cut, Copy and Paste
- Copying Formulas
- Practice Exercise
- Overview of Formulas
- Create Formulas Using Functions Part 1
- Create Formulas Using Functions Part 2
- Absolute Values
- Practice Exercise
- Adding, Deleting, and Remaining Sheets
- Additional Sheet Tab Options
- Dimensional Functions
- Practice Exercise
- PowerPoint Welcome and Overview
- Navigating a PowerPoint Presentation
- Overview of the Screen and the Views
- PowerPoint Exercise 01
- Presentation Tips and Guidelines
- Creating New Presentation
- Working with Slides
- Saving Presentation
- PowerPoint Exercise 02
- Formatting Text
- Working with Bullets and Numbered Lists
- PowerPoint Exercise 03
- Inserting Shapes
- Inserting Graphics
- Inserting Icons and 3D Models
- Inserting Pictures
- PowerPoint Exercise 04
- Selecting Objects
- Editing Objects
- Formatting Objects - Part 1
- Formatting Objects - Part 2
- Arranging Objects
- Grouping Objects
- PowerPoint Exercise 05
- Picture Options
- Cropping Pictures
- Formatting Pictures
- Things You Can Do with Pictures
- PowerPoint Exercise 06
- Creating SmartArt
- Modifying SmartArt
- Creating a Flow Chart
- Word Course Overview
- Word Screen
- Backstage View
- Creating a New Document
- Non-printing Characters and Line Spacing
- Saving a Document
- Opening a Document
- Navigating a Document
- GoTo, Find and Replace
- Editing a Document
- Section 2 Practice Exercise
- AutoCorrect Options
- Selecting Text
- Cut, Copy and Paste
- Character Formatting Options
- Format Painter
- Working with Numbers
- Working with Bullets
- Creating an Outline
- Section 3 Practice Exercise
- Alignment Options
- Line Spacing Options
- Working with Indents
- Working with Tabs
- Section 4 Practice Exercise
- Sorting a List
- An Overview of Outlook 2019
- Outlook 2019 vs Outlook Online in Office 365
- What to Expect from this Course
- Getting Help with Outlook 2019
- Keyboard Shortcuts in Outlook
- Navigating the Outlook Interface
- The Ribbons and the Quick Access Toolbar
- Adding an Email Account in Outlook
- Sending and Receiving Mail in Outlook
- Focused Inbox in Outlook
- Customizing the Inbox in Outlook
- Saving Attachments in Outlook
- Customizing Mail Views in Outlook
- Searching Mail in Outlook
- Creating Search Folders in Outlook
- Ignoring Conversations in Outlook
- Deleting, Archiving and Restoring Mail in Outlook
- Cleaning Up Conversations in Outlook
- Using Follow Up Flags and Categories in Outlook
- Organizing Mail with Folders and Subfolders in Outlook
- Using Quick Steps to Process Mail in Outlook
Taught by
Simon Sez IT