Udemy, Coursera, 2U/edX Face Lawsuits Over Meta Pixel Use

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Microsoft Office for Beginners - Excel, Word, and PowerPoint Training

Simon Sez IT via YouTube

Start learning Write review

Overview

This course provides a comprehensive introduction to Microsoft Office 2021/365, covering Excel, Word, and PowerPoint. By the end of the course, learners will have a solid understanding of basic formulas and functions in Excel, tips and tricks in Word, and best practices in PowerPoint. The course includes hands-on exercises and downloadable files for practice. The intended audience for this course is beginners who are new to Microsoft Office and want to build a foundational knowledge of these essential tools.

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

Reviews

5.0 rating, based on 1 Class Central review

Start your review of Microsoft Office for Beginners - Excel, Word, and PowerPoint Training

  • Profile image for Kishor Thapa
    Kishor Thapa
    it 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 .
Start learning

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.