Channel: Simon Sez IT

Category: Science & Technology

Tags: excel tutorialoffice 2019excel crash courseword 2019microsoft powerpointoffice for beginnersoutlook tips and tricksoffice 2019 tutorialpowerpoint 2019learn word 2019how to use outlookexcel for beginnerspowerpointoutlook 2019powerpoint tutorialmicrosoft office tutorialmicrosoft wordmicrosoft excelmicrosoft officemicrosoft excel tutorialexcel 2019outlook tutorialword 2019 tips and tricksmicrosoft outlookword tutorialoutlook

Description: Download and complete the exercises ►simonsezit.com/office-2019-exercise-files-ultimate-course-12hrs In this huge 12-hour Microsoft Office beginner course, we give you a solid background in using Microsoft Excel, Microsoft PowerPoint, Microsoft Word, and Microsoft Outlook. Use the downloadable exercises to complete the activities in this Ultimate Microsoft Office Training Tutorial. Simon Sez "Practice makes perfect!" This class is taught using Office 2019 and applies to Office 365 users. We cover Word 2019 tips and tricks, likewise for Excel 2019, Outlook 2019 and PowerPoint. This ultimate tutorial is from our full courses offered at SimonSez IT ► simonsezit.com Excel: 0:00:00 - Intro to Excel 0:01:19 - What's New in Excel 0:09:12 - Course Overview 0:10:29 - Overview of the Excel Window 0:18:55 - Mouse Features 0:22:08 - BackStage View in Excel 0:24:46 - Text and Numbers 0:29:18 - Creating Basic Formulas 0:36:06 - Relative References 0:39:08 - Order of Operations 0:43:56 - Working with Ranges 0:48:29 - Practice Exercise 0:50:05 - Working with Save and Save As Commands 0:54:38 - File Extensions, Share, Exports & Publish Files 0:58:24 - Practice Exercise 0:59:21 - Opening a File 1:04:54 - Working with Larger Files 1:10:28 - Freeze Panes 1:13:44 - Split Screen 1:17:07 - Practice Exercise 1:19:57 - Headers & Footers 1:27:20 - Print Titles 1:30:13 - Comments in Excel 1:35:36 - Page Setup Options 1:43:06 - Fit to Print on One Page 1:47:05 - Printing Workbooks 1:51:03 - Practice Exercise 1:52:54 - Adding and Deleting Cells 1:59:06 - Chaing Column and Row Widths 2:02:54 - Practice Exercise 2:04:04 - Cut, Copy and Paste 2:11:11 - Copying Formulas 2:16:22 - Practice Exercise 2:17:42 - Overview of Formulas 2:20:29 - Create Formulas Using Functions Part 1 2:30:33 - Create Formulas Using Functions Part 2 2:35:58 - Absolute Values 2:41:16 - Practice Exercise 2:42:35 - Adding, Deleting, and Remaining Sheets 2:46:44 - Additional Sheet Tab Options 2:52:03 - Dimensional Functions 2:57:19 - Practice Exercise PowerPoint: 2:58:52 - PowerPoint Welcome and Overview 3:02:11 - Navigating a PowerPoint Presentation 3:13:57 - Overview of the Screen and the Views 3:26:14 - PowerPoint Exercise 01 3:27:27 - Presentation Tips and Guidelines 3:35:37 - Creating New Presentation 3:40:24 - Working with Slides 3:47:25 - Saving Presentation 3:53:54 - PowerPoint Exercise 02 3:55:59 - Formatting Text 4:06:56 - Working with Bullets and Numbered Lists 4:17:47 - PowerPoint Exercise 03 4:19:14 - Inserting Shapes 4:31:27 - Inserting Graphics 4:37:23 - Inserting Icons and 3D Models 4:43:47 - Inserting Pictures 4:50:29 - PowerPoint Exercise 04 4:51:44 - Selecting Objects 4:55:22 - Editing Objects 4:59:59 - Formatting Objects - Part 1 5:12:50 - Formatting Objects - Part 2 5:21:53 - Arranging Objects 5:31:35 - Grouping Objects 5:38:02 - PowerPoint Exercise 05 5:30:29 - Picture Options 5:45:32 - Cropping Pictures 5:52:23 - Formatting Pictures 5:59:43 - Things You Can Do with Pictures 6:09:13 - PowerPoint Exercise 06 6:10:22 - Creating SmartArt 6:18:37 - Modifying SmartArt 6:24:43 - Creating a Flow Chart Word: 6:29:58 - Word Course Overview 6:32:36 - Word Screen 6:40:13 - Backstage View 6:48:46 - Creating a New Document 6:57:42 - Non-printing Characters and Line Spacing 7:06:11 - Saving a Document 7:12:50 - Opening a Document 7:19:44 - Navigating a Document 7:23:42 - GoTo, Find and Replace 7:31:12 - Editing a Document 7:34:35 - Section 2 Practice Exercise 7:35:35 - AutoCorrect Options 7:44:07 - Selecting Text 7:49:27 - Cut, Copy and Paste 7:57:39 - Character Formatting Options 8:05:43 - Format Painter 8:09:11 - Working with Numbers 8:17:14 - Working with Bullets 8:24:15 - Creating an Outline 8:29:52 - Section 3 Practice Exercise 8:31:55 - Alignment Options 8:35:15 - Line Spacing Options 8:39:59 - Working with Indents 8:45:17 - Working with Tabs 8:57:33 - Section 4 Practice Exercise 8:58:41 - Sorting a List Outlook: 9:04:14 - An Overview of Outlook 2019 9:07:39 - Outlook 2019 vs Outlook Online in Office 365 9:12:52 - What to Expect from this Course 9:17:09 - Getting Help with Outlook 2019 9:23:00 - Keyboard Shortcuts in Outlook 9:28:19 - Navigating the Outlook Interface 9:41:47 - The Ribbons and the Quick Access Toolbar 9:50:33 - Adding an Email Account in Outlook 9:57:01 - Sending and Receiving Mail in Outlook 10:11:19 - Focused Inbox in Outlook 10:15:27 - Customizing the Inbox in Outlook 10:32:15 - Saving Attachments in Outlook 10:36:57 - Customizing Mail Views in Outlook 10:48:16 - Searching Mail in Outlook 11:01:01 - Creating Search Folders in Outlook 11:09:16 - Ignoring Conversations in Outlook 11:13:29 - Deleting, Archiving and Restoring Mail in Outlook 11:22:40 - Cleaning Up Conversations in Outlook 11:27:17 - Using Follow Up Flags and Categories in Outlook 11:39:32 - Organizing Mail with Folders and Subfolders in Outlook 11:46:17 - Using Quick Steps to Process Mail in Outlook