Embark on a comprehensive 12-hour training journey covering Excel, PowerPoint, and Word in Microsoft Office 365. Master essential skills through hands-on exercises and practical demonstrations. Begin with Excel, learning interface navigation, formula creation, data formatting, and table management. Transition to PowerPoint, exploring presentation design principles, slide creation, object manipulation, and chart integration. Conclude with Word, covering document creation, text formatting, style application, and advanced features like dictation. Gain proficiency in these powerful productivity tools, enhancing your ability to create professional spreadsheets, engaging presentations, and polished documents.
Overview
Syllabus
- Course Introduction
- Excel 365 Online Portal
- Exercise 01
- Launch Excel
- Explore the Interface
- Contextual Menus and Ribbons
- The Quick Access Toolbar
- Keyboard Shortcuts
- Exercise 02
- Excel Templates
- Work with Workbooks and Worksheets
- Save Workbooks to OneDrive
- Enter Text, Numbers, and Dates
- Custom Lists
- Exercise 03
- Order of Operations
- A Simple Formula
- The 'Big 6' Functions
- Absolute vs Relative Referencing
- Quick Calculations with Autosum
- Autofill and Flash Fill
- Exercise 04
- What are Names Ranges?
- Create Named Ranges
- Use Named Ranges in Formulas
- Exercise 05
- Apply Number Formats
- Format Cells, Rows and Columns
- AutoFormat
- Find and Replace Formatting
- Format Painter
- Clear Cells
- Exercise 06
- Tables Explained
- Format as Table
- Table Reference in Formulas
- Exercise 07
- Work with Columns and Rows
- Align Text and Numbers
- Merge Cells vs Center Across Selection
- Apply Themes and Styles
- Exercise 08
- Excel 365 Course Close
- Powerpoint 365 Course Introduction
- PowerPoint Online vs Powerpoint Desktop
- Exercise 01
- The Golden Rules of Good Presentation Design
- FREE Resources and Inspiration
- Exercise 02
- Start Quickly with Themes and Templates
- Quick Starter Outline Slides
- Save Presentations to the Cloud OneDrive
- Exercise 03
- Understand the Interface
- Add Commands to the Quick Access Toolbar
- Keyboard Shortcuts and KeyTips + Copilot for Bing
- Exercise 04
- Slide Layouts
- Organize Slides
- Change the Slide Background
- Add a Transparent Shape Overlay
- AI in PowerPoint: Designer
- Change Multiple Slides: Slide Master
- Work with Text Boxes
- Add Sections
- Find and Replace Fonts
- Copy Slides Between Presentations
- Exercise 05
- Add Images to a Presentation
- Work with Shapes
- Align and Group Objects
- Z-Order and Selection Pane
- Fill Shapes with Images
- Format and Add Effects to Objects
- Copy Formatting: Format Painter and Eyedropper
- Remove the Background from Pictures
- Insert and Customize Icons and Other Graphics
- Exercise 06
- Fill Text with an Image
- Text Effect with Layers
- Create Gradient Filled Text
- Exercise 07
- Create & Format Charts
- Use SmartArt to Create Diagrams
- Insert Screenshots and Clippings
- Exercise 08
- PowerPoint 365 Course Close
- Word 365 Course Introduction
- Word Online vs Word Desktop
- Exercise 01
- Launch Word and the Start Screen
- Word Interface
- Ribbons, Tabs and Menus
- Quick Access Toolbar
- Useful Keyboard Shortcuts
- Check Spelling and Grammar as You Type
- Exercise 02
- Word Templates
- Create and Save a Document
- Save Documents to OneDrive
- Recover Unsaved Documents
- Navigate Around a Document
- Find Tools in Word
- Exercise 03
- Switch Document Views
- Immersive Reader and Focus
- Arrange Documents and Zoom
- Exercise 04
- Enter and Format Text
- Copy, Cut and Paste
- Work with the Clipboard
- Format Painter
- Paste Options
- Find and Replace
- Dictate and Transcribe
- Exercise 05
- Format Paragraphs and Alignment
- Line and Paragraph Spacing
- Show/Hide Markers
- Bullets and Numbered Lists
- Indent Paragraphs
- Align Text with Tabs
- Exercise 06
- Word Themes Explained
- Custom Theme
- Exercise 07
- Word Styles Explained
- Modify Styles
- Reset to Default Styles
- Custom Style
- Exercise 08
- Word 365 Course Close
Taught by
Simon Sez IT
