Embark on a comprehensive 9-hour journey through Microsoft Office 2021/365, mastering Excel, Word, and PowerPoint essentials. Learn fundamental formulas and functions in Excel, discover time-saving tips and tricks in Word, and explore best practices for creating impactful presentations in PowerPoint. Download course files to practice alongside the instructor, covering topics such as interface navigation, data entry, formatting, templates, and advanced features specific to each application. Gain practical skills through hands-on exercises and benefit from expert guidance on creating visually stunning presentations, utilizing keyboard shortcuts, and leveraging powerful tools like AutoSum, Flash Fill, and the Eyedropper. Perfect for beginners seeking a solid foundation in Microsoft Office, this course equips you with the knowledge to efficiently use these essential productivity tools in your personal or professional life.
Overview
Syllabus
- Simon Sez IT Intro
- Excel 2021 Course Introduction
- Excel 2021 vs. Excel 365
- Launching Excel
- The Start Screen
- Exploring the Interface
- Ribbons, Tabs, and Menus
- The Backstage Area
- Quick Access Toolbar
- Useful Keyboard Shortcuts
- Getting Help
- Exercise 01
- Working with Templates
- Workbooks and Worksheets
- Saving Workbooks
- Entering and Editing Data
- Cells, Rows, and Columns
- Exercise 02
- Formulas and Functions Explained
- SUM Function
- Counting Values and Blanks
- AVERAGE Function
- MIN and MAX Functions
- Handling Errors in Calculations
- Absolute vs Relative Referencing
- Autosum and AutoFill
- Flash Fill
- Word 2021 Course Introduction
- Exercise 01
- The Start Screeen
- Exploring the Word Interface
- Rulers and Zoom
- Check Spelling and Grammar
- Quick Access Toolbar
- Keyboard Shortcuts
- Screentips, Contextual Menus, and Ribbons
- Get Help
- Exercise 02
- Create and Save a Document
- Open Existing Documents
- Create a Document from a Template
- Navigate Around a Document
- Find Tools in Word
- Exercise 03
- Switch Document Views
- Immersive Reader and Focus
- Dark Mode
- Exercise 04
- Enter Text and Apply Basic Formatting
- Making Selections
- Advanced Text Formatting
- Move Text with Cut, Copy, and Paste
- Format Painter
- Paste Options
- Find and Replace
- Intro to PowerPoint 2021
- Creating Visually Stunning Presentations
- Presentation Tips and Best Practice
- Free Resources and Inspiration
- Exercise 01
- PowerPoint Interface
- Quick Access Toolbar
- Opening, Closing, and Saving Presentations
- Using Templates
- PowerPoint Options
- Exercise 02
- Slide Layouts
- Adding and Duplicating Slides
- Reusing Slides from Other Presentations
- Creating Sldes from an Outline
- Slide Themes and Backgrounds
- Exercise 01
- Resizing Background Image: Crop and Fill
- Transparent and Shape Overlays
- Drawing and Formatting Shapes
- Locking Shapes and Setting a Default Shape
- Merging Shapes
- Inserting a Logo: Filling Shapes with Images
- Adding Title and Subtitle
- Eyedropper Tool
- Exercise 04
- Selecting Objects
- Renaming and Changing the Z-Order
Taught by
Simon Sez IT
Related Courses
-
Complete Microsoft Office Bootcamp
-
Microsoft Office Training : Master Excel, PowerPoint & Word
-
Complete Microsoft Word Excel PowerPoint Course
-
Mastering Microsoft Office 2021-365: Word, Excel, PowerPoint
-
Microsoft Office 365 | Ultimate Bootcamp 2023
-
Microsoft Excel, PowerPoint and Word 2016 for Beginners
Reviews
5.0 rating, based on 1 Class Central review
-
Kishor Thapait is very good lession . it helps me a revision a class for me thank you and i wish your lession gave me very good oppertunity for me in future .
