Microsoft Office Basics
=====
—–
* Course Id : OTHR-MSOF
* Duration : 32 Hours
Overview
—–
* In this course you will learn the key techniques for using the four primary Microsoft office applications
* Microsoft Word used to create consistent,formatted documents
* Microsoft Excel used to create spreadsheets that make use of formulae and functions
* Microsoft PowerPoint used to create slideshows with transition effects and animations
* Microsoft Outlook used to send and receive emails,manage contacts and organize calender
Pre-Requisites
—–
* Students should have the ability to use a mouse and the ability to type on a keyboard
Training Objectives
—–
* Understand how to create a basic Word document with edits and formatting
* Learn how to start a text slide in PowerPoint
* Learn how to create, modify, save and print an excel worksheet
* Understand how to format text on a PowerPoint slide
* Understand how to customize PowerPoint for greater productivity by customizing the Microsoft Office Ribbon
* Learn how to controll page appearance including using columns, indents, footers, borders and watermarks
* Learn to create many types of documents
* How to create a mail merge
* Printing envelopes and labels
* Understand different page setup options
* Learn how to spell check your documents
* How to insert pictures and graphics in Word document
* Understand how to insert and edit tables
* Learn how to work with and analyze data using data slicers, PivotTables, Power Query and PivotCharts
* Understand Setting up email accounts
* Understand using Outlook on a touch device
* Understand creating and sending email messages
* Understand organizing email
* Learn Calendar appointments and attachments
* Create and manage meetings
* Learn adding email signatures
* Understand how to archive email
Course Structure
——-
* We provide more focus on hands-on in our technical courses (typically 80% hands-on/20% theory)
* Students get the capability to apply the material they learn to real-world problems
Materials Provided
—–
* PDF of slides and hands-on exercises
* Access to instance with lab environment
Software Requirements
—–
Any of the following
* Any current internet browser
* vnc client
* rdp client
Hardware Requirements
—–
* Processor: 1.2 GHz
* RAM: 512 MB
* Disk space: 1 GB
* Network Connection with low latency (<250ms) to Internet
## Daywise Course Outline
—–
## Day 1
—–
* Unit 1 : Microsoft Word Basics
* Unit 2 : Microsoft Word Advanced
## Day 2
—–
* Unit 3 : Microsoft Excel Basics
* Unit 4 : Microsoft Excel Advanced
## Day 3
—–
* Unit 5 : Microsoft PowerPoint Basics
* Unit 6 : Microsoft PowerPoint Advanced
## Day 2
—–
* Unit 7 : Microsoft Outlook Basics
* Unit 8 : Microsoft Outlook Advanced
## Detailed Course Outline
—–
Unit 1 : Microsoft Word Basics
—–
* The Word window
* New documents
* Navigating
* Undo and redo
* Automated tasks
* Editing text
* Moving and copying text
* Finding and replacing text
Unit 2 : Microsoft Word Advanced
—–
* Character and paragraph formatting
* Using tabs
* Basic tables
* Spelling and grammar
* Previewing and printing
* Margins
* Page breaks
* Tabs
Unit 3 : Microsoft Excel Basics
—–
* Navigating to accomplish tasks
* Sorting data
* Hiding columns and rows
* Entering data
* Date and time formatting
* Spell check
* Undo and redo
* Inserting and deleting rows and columns
Unit 4 : Microsoft Excel Advanced
—–
* Basic formulas
* Simple cell references
* Functions
* AutoSum and AutoCalculate
* Cutting, copying, and pasting data
* Pasting values and formulas
* Filling series
* AutoFill
* Copying
* Formatting spreadsheets
* Margins, headers and footers
* Print options, setting print areas
* Repeating headings
* Adjusting column widths
* Number formatting with toolbar buttons
* Working with text in spreadsheets
* Formatting, wrapping, aligning, paragraph returns, merging and centering
Unit 5 : Microsoft PowerPoint Basics
—–
* Views, navigation
* Using outline view
* Changing indent levels
* Adding and formatting text
* Applying design styles
* Setting font styles
* Auto-layouts
* Using the Slide Master
Unit 6 : Microsoft PowerPoint Advanced
—–
* Adding and formatting pictures
* Creating auto-shapes
* Image layering
* Creating organizational charts and formatting
* Working with text placeholders
* Drawing shapes
* Using transitions and animation
* Duplicating and rearranging slides
* Viewing and navigating in the presentation
Unit 7 : Microsoft Outlook Basics
—–
* Setting preferences
* Customizing views
* Signatures
* Auto archiving
* Out of office reply
* Advanced toolbar
* Viewing e-mails in groups
* Custom viewsAdding columns
* Creating search folders
* Follow up flags
* Printing calendars and options
* Using e-mail voting buttons & features
* Deleting auto-complete e-mail addresses
Unit 8 : Microsoft Outlook Advanced
—–
* Creating rules
* Printing attachments
* Organizing contacts with categories
* Managing and tracking client interactions with Outlook activities
* E-mailing contact cards
* Using Tasks (creating, organizing, assigning and tracking)
* Using Journaling
* Setting additional preferences
* Setting calendars and folders
* Sharing permissions
* Planning meetings
* Using and creating Public Folders