Microsoft Office for Beginners - Excel, Word, and PowerPoint Training
Simon Sez IT via YouTube
-
17
-
- Write review
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
Reviews
5.0 rating, based on 1 Class Central review
-
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 .