Microsoft Office 2010 - Revised 2018

Modules

• Learning Outcomes

• What's new with keyboard shortcuts

• Reacquaint yourself with everyday tasks

• Acquaint yourself with the ribbon

• Some tools appear on demand

• Behind the scenes: File tab and Backstage view

• Work between new and earlier versions of Word

• Lesson Summary

• Learning Outcomes

• Work in Word anywhere

• Bring your best ideas to life

• Document Navigation Pane

• Work more easily

• Customize the Ribbon

• Work better together

• Coauthoring

• Lesson Summary

• Learning Outcomes

• Create and save a new document

• Fix spelling and grammar as you type

• Add formatting to your text

• Change page margins

• Save, print and close a new document

• Moving around in a document

• Use formatting marks

• Move text around in the document

• Change line spacing and alignment

• Lesson Summary

• Learning Outcomes

• See what your document is made of

• Locate, add to, and reorganize content

• Find and replace text and other elements

• Lesson Summary

• Learning Outcomes

• Make your text stand out with special effects

• Polish your pictures like a pro

• Add a screenshot without using another program

• SmartArt graphics: Turn ideas into illustrations

• Lesson Summary

• Learning Outcomes

• Open the header and footer space; find tools

• Get more help from Word with style galleries

• Get less help from Word by using Quick Parts

• Insert page numbers; use "Page X of Y" format

• Add the current date and time

• Add the document filename and path

• Insert an art logo into a header

• Adjust header and footer position on the page

• Use varying headers and footers

• Remove page numbers, headers, and footers

• Lesson Summary

• Learning Outcomes

• Generate and update a TOC

• Create and customize a table of contents

• Mark other styles for use in a TOC

• Use outline levels to mark text for a TOC

• Control TOC content and formatting

• Customize a TOC by changing styles

• Remove a TOC

• Lesson Summary

• Learning Outcomes

• Heading styles

• Paragraph styles

• Add alt text to images and tables

• Structure tables for easy navigation

• Tips and tricks

• Lesson Summary

• Learning Outcomes

• Open Word quickly

• Use a template from Office.com

• Convert a list into a table

• Make a bulleted list more interesting

• Crop a picture to shape

• Zoom with your mouse

• Put documents on SkyDrive

• Find and replace text

• Techniques for selecting things

• Show or hide the Ribbon

• Use the Quick Access Toolbar

• Add a list with checkboxes

• Lesson Summary

• Learning Outcomes

• Introduction

• How to use access keys

• Access keys in dialog boxes

• F6: Another kind of access key

• How to use key combinations

• Key combos for working with files

• Moving around a document

• Key combos for working with text

• Other handy shortcuts

• Lesson Summary

• Learning Outcomes

• Active content

• Enable content

• Trusted documents

• Protected view

• Lesson Summary

• Learning Outcomes

• Making the switch to Excel 2010

• Work with files in the Backstage view

• Do the basics on the home tab

• Math, Anywhere

• Commands when you need them

• Keyboard shortcuts

• Keep your favorite buttons visible

• Work between new and old Excel versions

• Lesson Summary

• Learning Outcomes

• Access the right tools, at the right time

• Backstage view in Excel 2010

• Access workbooks in new ways

• Make fast, effective comparisons from lists of data

• Introduction to Sparklines

• Obtain powerful analysis from your desktop

• Changes made to functions

• Create an Excel table

• Create workbooks with more visual impact

• Paste with live preview

• Collaborate on workbooks in new ways

• Collaborate on a worksheet in the browser

• Find and fix accessibility issues

• Extend workbooks in new ways

• Lesson Summary

• Learning Outcomes

• What is Excel?

• Ceate, save, print, and apply templates to a workbook

• Format numbers in a worksheet

• Create an Excel table, formula and chart your data

• Filter and sort your data

• Lesson Summary

• Learning Outcomes

• Meet the Excel spreadsheet

• Do basic math in Excel

• Create column titles

• Let Excel type for you

• Get more(or less) columns, rows, spreadsheets

• Keep column titles in sight as you scroll

• Prepare to print

• Lesson Summary

• Learning Outcomes

• Formulas in Excel

• Cell references in formulas

• The SUM and AVERAGE functions

• More about cell references and formulas

• More about functions

• Lesson Summary

• Learning Outcomes

• What is VLOOKUP

• How, and when to use VLOOKUP

• Using more than one spreadsheet with VLOOKUP

• Using absolute cell references with VLOOKUP

• Avoiding VLOOKUP errors

• Lesson Summary

• Learning Outcomes

• Format cells to make data stand out

• Quick formatting

• Work with rules

• Make your own rules

• Lesson Summary

• Learning Outcomes

• Introduction to Sparklines

• Line sparklines

• Column sparklines

• Win, Loss sparklines

• Lesson Summary

• Learning Outcomes

• Introduction to tables

• Sort, filter, and remove duplicates

• Using formulas in tables

• More about formulas

• Lesson Summary

• Learning Outcomes

• Introduction to the IF function

• Add or multiply IF results

• Using more than one IF function

• Lesson Summary

• Learning Outcomes

• Introduction to charts

• How spreadsheet data appears in a chart

• Change the chart view

• Add chart titles

• Change the look of your chart

• Make a pie chart

• More chart types

• Lesson Summary

• Learning Outcomes

• Create and run macros

• Edit an existing macro to change what it does

• Save my macro in the Personal Workbook

• Assign a button to my macro

• Lesson Summary

• Learning Outcomes

• Dates and formulas

• Find the number of days between two dates

• Find the number of workdays between two dates

• Find the date that falls after a number of workdays

• Find the date that falls after a number of months

• Find the date that falls after a year, months, and days

• Lesson Summary

• Learning Outcomes

• Calculate credit cart debt

• Figure out mortgage payments

• Calculate vacation savings

• How a first deposit affects savings

• Figure out a down payment

• Paying off a personal loan

• How much your saving add up to over time

• Lesson Summary

• Learning Outcomes

• Introduction to keyboard shortcuts

• Basic keyboard shortcuts

• Keyboard shortcuts for formulas

• Keyboard shortcuts for moving around workbooks

• Keyboard shortcuts for selecting

• Keyboard shortcuts for adding and inserting

• Keyboard shortcuts for formatting

• Introduction to access keys

• Access keys from previous versions

• Access keys in dialog boxes

• Other kinds of access key

• Lesson Summary

• First Assessment (Word & Excel)

• Making the switch to PowerPoint 2010 Learning Outcomes

• Get acquainted with the ribbon

• Create slides and format text

• Insert slide elements

• Design, animate, review

• Backstage view

• Save or undo with the Quick Access Toolbar

• Keyboard Shortcuts

• Switch between new and old versions

• Lesson Summary

• Learning Outcomes

• Create, manage, and collaborate with other people

• Separate PowerPoint presentation files in different windows

• Enrich your presentations with video, picture, and animations

• Embed, edit, and play a video in your presentation

• Trim an audio or video clip

• Use bookmarks in your audio and video clips

• Use transitions with 3-D motion graphic effects

• Copy and paste animated effects from one object to another

• Deliver and share your presentations more effectively

• Broadcast your slide show

• Identify and resolve accessibility issues

• Lesson Summary

• Learning Outcomes

• Create slides and add text

• Choose a layout, insert a picture, apply a theme

• Change the size and position of slide elements

• Add more slide content and use formatting

• Create speaker notes to use when you present

• Finalize your slides and notes

• Save, share and print

• Lesson Summary

• Learning Outcomes

• Insert a single photo

• Use the Clip Art task pane

• Create a photo album

• Crop a photo

• Position photos

• Styles and effects

• File sizes

• Lesson Summary

• Learning Outcomes

• Introduction

• Embed a video

• Link to a video

• Size a video

• Playback options

• Insert a video from a website

• Lesson Summary

• Learning Outcomes

• Introduction

• Before you broadcast publicly

• Start a public broadcast

• Start an internal broadcast

• Four thing to keep in mind

• Features that change during a broadcast

• Lesson Summary

• Learning Outcomes

• Visualize text with SmartArt

• Insert new SmartArt

• Add text and shapes to SmartArt

• SmartArt examples

• Visualize data

• Insert a column chart

• Other chart examples

• Customize a chart

• Lesson Summary

• Learning Outcomes

• Getting started with animations

• Animate text, charts and shapes

• Apply an animation to all slides

• Add transitions

• Animation timing

• Change order and effects

• Animations with motion paths

• Lesson Summary

• Learning Outcomes

• Use access keys

• Use access keys in dialog boxes

• Other kinds of access keys

• Use key combinations

• Keys for creating new files and slides

• Keys for working with text

• Keys for shapes and objects

• Keys that start and stop a presentation

• Lesson Summary

• Learning Outcomes

• Make a slide from a bullet

• Crop, zoom and reuse

• Sorter View, screenshot and clipping

• Show or hide the Ribbon and Quick Access bar

• Lesson Summary

• Learning Outcomes

• Get started with Access 2010

• Start something with the navigation pane

• Get to know the ribbon

• Use files from previous versions

• Get started fast with templates and web databases

• Design on the fly with layout view

• Lesson Summary

• Learning Outcomes

• Plan for good design

• Planning a new database

• Keys and data types

• Create tables for a new database

• Saving, adding and navigating your data

• Lesson Summary

• Learning Outcomes

• Create relationships for a new database

• Create relationships

• Set referential integrity

• Create lookup fields

• Create queries for a new database

• Lesson Summary

• Learning Outcomes

• Create forms for a new database

• Types of forms

• Ways to create forms

• Change forms in layout view

• Create reports for a new database

• Lesson Summary

• Learning Outcomes

• Create and publish a web database

• Save a changed database to the web

• Create a web database from scratch

• Add the web to your database

• Lesson Summary

• Learning Outcomes

• Introduction to keyboard shortcuts

• Basic keyboard shortcuts

• Moving around in Access

• keyboard shortcuts for selecting

• Keyboard shortcuts for editing

• Introduction to access keys

• Basic access keys

• Getting around dialog boxes

• The property sheet and field list

• Other kinds of access keys

• Lesson Summary

• Learning Outcomes

• Find everyday commands in Outlook 2010

• Create and send messages

• Read and respond to messages

• Print and set Outlook options

• Get around in your calendar

• Search and find in Outlook 2010

• Lesson Summary

• Learning Outcomes

• The ribbon, file tab, conversation view, and start topic

• Messages and meetings features

• Instant search improvements

• Organizing your inbox conversations

• Calendar improvements

• E-mail attachment features

• Improved features

• Lesson Summary

• Learning Outcomes

• Calendar basics

• Create meetings

• Create recurring meeetings

• Use colour categories and follow-up flags

• Set tasks and reminders

• Set all-day events and free/busy data

• Lesson Summary

• Learning Outcomes

• Stay organized with conditional formatting

• Conditional formats with calendars and tasks

• Use your RSS feeds in Outlook

• Change settings for your RSS feeds

• Manage your RSS feeds with search folders

• Unsubscribe from an RSS feed

• Lesson Summary

• Learning Outcomes

• Better than just date arrangement

• Introducing date (conversations)

• Reading the conversation map

• Acting conversationally

• Switching views and using search

• Use automatic replies

• Send replies without Exchange

• Rules to manage mails by

• Lesson Summary

• Learning Outcomes

• Create electronic business cards

• Change the look and feels of a business card

• Create e-mail signatures

• Jazz up your signature

• Find it with instant search

• Pile and file with search folders

• Lesson Summary

• Learning Outcomes

• Create and use templates

• Use templates with calendars, tasks, and contacts

• Organise your mailbox with views

• See just what you need with custom views

• Reduce clutter with conversations view

• Lesson Summary

• Second Assessment (PowerPoint, Access and Outlook)

• Micosoft Office 2010 Final Assessment