Microsoft Excel

Microsoft Excel
Excel Presentation Standards
Excel Shortcuts & Features
Basic Excel
Advanced Excel

Chapter 1: Introduction to Microsoft Word

Understanding the Word interface

•  Understanding the Microsoft Word Interface in HTML
• Menu Bar
• Quick Access Toolbar
• Ribbon
• Document Area
• Status Bar
• Navigation pane
• Ruler

Launching and closing Word

•  How to Launch and Close Microsoft Word

Navigating the document

The ribbon and its components

•  Microsoft Word Ribbons and Functionality
• File Tab
• Home Tab
• Insert Tab
• Draw Tab
• Design Tab
• Layout Tab
• References Tab
• Mallings Tab
• Review Tab
• View Tab
• Developer Tab

What is Microsoft Word?

• Introduction
• uses and Benefits of MS Word for an Individual:

Introduction

• Creating a New Document in Microsoft Word
• On Windows & macOS:
• Typing and Editing Text in Microsoft Word
• Navigating Documents on Windows Using Scroll Bars
• Using the Scrll Bar
• Using the Scroll Wheel on Your Mouse
• Using the page up and Page Down Keys
• Using the Arrow Keys
• Using the Go To Feature
• Using the Navigation Pane
• Navigating Documents on macOS

Creating and Editing Documents

•  using Font Styles in Microsoft Word
• Basic Font Styles
• Font Selection and Size
• Advanced Font Styles (Font Dialog Box)
• using Font Sizes in Microsoft Word
• using the Font Size Dropdown
• using the Font Size Box
• Advanced Font Sizing (Font Dialog Box)
• Aligning Text in Microsoft Word: Windows and macOS
• Paragraph Alignment (Windows & macOS)
• Other Alignment Options (Windows macOS)
• Changing Paragraph Spacing in Microsoft Word
• using the Ribbon
• using the Paragraph Didog Box
• Line Spacing (Within Paragraphs)
• Keyboard Shortcuts

Text and Paragraph Formatting

• Case Study I

Case Study 1

• Case study 2

Case Study 2

• Assignment I

Chapter 2: Working with Paragraphs and Lines

Adding line breaks and page breaks

• Line Breaks and page Breaks in Microsoft Word
• Line Breaks
• page Breaks
• Managing Breaks
• Copying and pasting Text in Microsoft Word
• Basic Copy and Paste
• Paste Special
• Clipboard in MS Word
• Indenting Paragraphs
• Types of Indentation
• using the Ruler
• using the paragraph BOX
• Adding Bullet Points and Numbered Lists in Microsoft
• Creating Bullet Points
• Customizing Bullet Points
• Creating Numbered Lists
• Customizing Numbered Lists

Copying and pasting text

Indenting paragraphs

Using tabs for alignment

• Using Tabs for Alignment in Microsoft Word
• Understanding the Ruler and Tab Stops
• Setting Tab Stops
• Types of Tab Alignment
• using Tabs for Alignment
• Using Find and Replace in Microsoft Word
• Accessing Find and Replace
• Using the Find and Replace Dialog Box
• Advanced Find and Replace Options (using “More >>”)

Using the Find and Replace function

Paragraph Structure and Editing

• Case Study I

Text Alignment and Editing Tools

• Case Study 2

Case Study 1

• Assignment I

Chapter 3: Page Layout and Styles

Adding headers and footers

• Adding Headers and FooterAccessing the Header and Footer Area
• Adding Content to Headers and Footer
• Formatting Headers and Footers
• Different Headers and Footers for Odd and Even pages
•  Applying Page Number
•  Accessing the Page Numbering Options
•  Choosing a Page Number Location and Style
• Formatting Page Numbers
• Starting page Numbering on a Specific page
• S. Different Page Numbers for Odd and Even Pages
• Setting page Margins and Orientation
• Setting Page Margins
• Setting page Orientation

Creating and applying styles

• Creating and Applying Styles
• Creating a New Style
• Applying Styles
• Modifying Styes
• Style Types
• S. using Built-in Styles

Using templates

• using Templates
• Accessing Templates
• Choosing and Applying a Template
• Customizing Templates

Page Layout and Styles

• Case Study 1

Case Study 1

• Assignment I

Chapter 4: Adding Visual Elements

Adding charts and graphs

Creating and editing shapes

• Creating and Editing Shapes
• Inserting Shapes
• Editing Shapes
• Working With Multiple Shapes
• Adding Charts and Graphs
• Inserting a Chart
• Entering Data into the Spreadsheet
• Editing and Customizing Your Chart
• Inserting Images and Pictures
• Inserting Images from Your Computer
• Inserting Images from Online Sources
• Inserting Pictures from OneDrive or Other Cloud Services

Formatting images and objects

Inserting images and pictures

Working with tables

• Working With Tades
• Creating a Table
• Formatting Tables
• Manipulating Tables

Case Study 1

• Case Study 2

Assignment 1

• Assignment 2

Chapter 5: Advanced Features

Creating and using macros

• Creating and using Macros
• Recording a Macro
• Running a Macro
• Editing a Macro (VBA Code)
• Macro Security
• Setting up a Mail Merge
• Inserting Merge Fields
• Previewing and Completing the Merge
• Footnotes and Endnotes
• Inserting Footnotes and Endnotes
• Numbering and Formatting
• Deleting Footnotes and Endnotes
• Converting Footnotes to Endnotes (and vice versa)

Mail Merge

Using footnotes and endnotes

using the built-in dictionary and thesaurus

• Built-in Dictionary and Thesaurus
• Using the Dictionary
• using the Thesaurus
• Customizing Dictionary and Thesaurus Settings

Working with citations and bibliographies

• Working With Citations and Bibliographies
• Setting up a Citation Style
• Inserting Citations
• Bibliography
• Creating a Bibliography
• Updating Citations and Bibliography

Case study 1

• Case Study 1

Case Study 2

• Case Study 2

Assignment 1

• Assignment I

Chapter 6: Working with Files and Documents

Opening existing documents

Opening Existing Documents

• Using the “Open” Command
• Opening Documents from Cloud Storage
• Opening Documents from Network Locations

Saving Documents

• Saving a Document for the First Time
• Saving Changes to an Existing Document
• Saving in Different Formats

Printing documents

printing Documents

• Accessing the Print Dialog BOX
• Understanding Print Settings

Sharing and Collaborating on Documents

• Sharing via Cloud Storage (OneDrive, SharePoint, etc.)
• Sharing via Emai
• using the • Review • Tab for Collaboration

Saving documents

Sharing and collaborating on documents

Finding Help and Support

Accessing Microsoft Support

• using Word’s Built-in Help
• Accessing Microsoft Support Online

Finding Tutorials and Odine Resources

• utilizing Microsoft’s Official Support
• Leveraging Video Tutorials on YouTube and Other platforms
• Exploring Online Forums and Communities
• Utilizing Online Document and Tutorial Websites

Troubleshooting and Error Resolution

 Identifying and Resolving Errors

• Spelling and Grammar Errors
• File Corruption
• Font Errors
• Printing Errors

Using the Word Help System

• Accessing the Help System
• Searching for Help

Managing Document Files

Case Study I

• Resolving Spelling and Grammar Errors

printing and Sharing Documents

Case Study I

• Resolving Spelling and Grammar Errors

Case Study 1

• Assignment I