Microsoft Office 2010 - Revised 2018
Learn how to use Microsoft Office 2010 and improve your organisational ability and computer skills today.
Description
Microsoft Office has five software products that are useful for both students and professionals. This free online course will help you master the functions, capabilities, and uses of Microsoft Word 2010, Microsoft Excel 2010, Microsoft PowerPoint 2010, Microsoft Access 2010, and Microsoft Outlook 2010. The advantages of mastering these Microsoft Office tools are endless, whether you want to ace your schoolwork or improve your career skills.
If you have used an older version of Microsoft Office, particularly 2003 and 2007 version, you will be amazed by the new features of Microsoft Office 2010! For students who have completed our ABC IT introductory computer course, the Microsoft Office 2010 course is the perfect next step for getting your Microsoft Office skills up-to-date.
This Microsoft Office online course is for anyone who wants to improve their office skill, organisational ability, and computer knowledge. Whether you are a student with loads of computer-related work, or a professional who needs staff with MS Office skills, this course is for you. So get started with this free course, and improve your MS Office skills today.
Modules
Module 1: Making the switch to Word 2010
-
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
Module 2: Whats's New in Word
-
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
Module 3: Creating your first Word document
-
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
Module 4: Explore Your Document using the Navigation Pane
-
Learning Outcomes
-
See what your document is made of
-
Locate, add to, and reorganize content
-
Find and replace text and other elements
-
Lesson Summary
Module 5: Create visually compelling documents
-
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
Module 6: Get control of Page Numbers, Headers, and Footers
-
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
Module 7: Create and Customize a Table of Contents
-
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
Module 8: Create accessible documents
-
Learning Outcomes
-
Heading styles
-
Paragraph styles
-
Add alt text to images and tables
-
Structure tables for easy navigation
-
Tips and tricks
-
Lesson Summary
Module 9: Word 2010 tips and techniques
-
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
Module 10: Keyboard Shortcuts
-
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
Module 11: Microsoft Office 2010 Security
Module 12: Making the switch to Excel 2010
-
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
Module 13: What's new in Excel 2010
-
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
Module 14: Basic Tasks in Excel 2010
-
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
Module 15: Create your first spreadsheet
-
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
Module 16: Create Formulas
-
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
Module 17: VLOOKUP - What it is and when to use it
-
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
Module 18: Understand Data at a glance with Conditional Formatting
-
Learning Outcomes
-
Format cells to make data stand out
-
Quick formatting
-
Work with rules
-
Make your own rules
-
Lesson Summary
Module 19: Sparklines - Use tiny charts to show data trends
-
Learning Outcomes
-
Introduction to Sparklines
-
Line sparklines
-
Column sparklines
-
Win, Loss sparklines
-
Lesson Summary
Module 20: Use Excel tables to manage information
-
Learning Outcomes
-
Introduction to tables
-
Sort, filter, and remove duplicates
-
Using formulas in tables
-
More about formulas
-
Lesson Summary
Module 21: The IF Function - What it is and how to use it
-
Learning Outcomes
-
Introduction to the IF function
-
Add or multiply IF results
-
Using more than one IF function
-
Lesson Summary
Module 22: How to create a basic chart in Excel 2010
-
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
Module 23: Save time by creating and running macros in Excel 2010
-
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
Module 24: Figure out dates by using formulas in Excel 2010
-
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
Module 25: Plan payments and savings in Excel 2010
-
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
Module 26: Keyboard shortcuts in Excel 2010
-
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
Module 27: First Assessment (Word & Excel)
Module 28: Making the switch to PowerPoint 2010
-
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
Module 29: What's new in PowerPoint 2010
-
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
Module 30: Create your first PowerPoint 2010 presentation
-
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
Module 31: Add photos to PowerPoint
-
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
Module 32: Insert video into a presentation
-
Learning Outcomes
-
Introduction
-
Embed a video
-
Link to a video
-
Size a video
-
Playback options
-
Insert a video from a website
-
Lesson Summary
Module 33: Broadcast a presentation
-
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
Module 34: Charts and SmartArt in PowerPoint
-
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
Module 35: Animations and Transitions
-
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
Module 36: Keyboard Shortcuts
-
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
Module 37: PowerPoint Tips and Techniques
-
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
Module 38: Making the Switch to Microsoft Access 2010
-
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
Module 39: Design and Create New Tables for a Database
-
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
Module 40: Create Relationships and Queries for a New Database
-
Learning Outcomes
-
Create relationships for a new database
-
Create relationships
-
Set referential integrity
-
Create lookup fields
-
Create queries for a new database
-
Lesson Summary
Module 41: Create Forms and Reports for a New Database
-
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
Module 42: Build and Publish Web Databases
-
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
Module 43: Access 2010 Keyboard Shortcuts
-
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
Module 44: Making the Switch to Outlook 2010
-
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
Module 45: What's new in Microsoft Outlook 2010
-
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
Module 46: Get Familiar with the Outlook Calendar
-
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
Module 47: Manage Your Information and Create RSS Web Feeds
-
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
Module 48: Organise Messages and Automatic Replies
-
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
Module 49: Electronic Business Cards, E-mail Signatures and Instant Search
-
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
Module 50: Organise with Templates and Views
-
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
Module 51: Second Assessment (PowerPoint, Access and Outlook)
Course assessment
Learning Outcomes
Having completed this course you will be able to:
- Explain Microsoft Word 2010 functions capabilities and uses.
- Explain Microsoft Excel 2010 functions capabilities and uses.
- Explain Microsoft PowerPoint 2010 functions capabilities and uses.
- Explain Microsoft Access 2010 functions capabilities and uses.
- Explain Microsoft Outlook 2010 functions capabilities and uses.
Certification
All Alison courses are free to enrol, study and complete. To successfully complete this Certificate course and become an Alison Graduate, you need to achieve 80% or higher in each course assessment. Once you have completed this Certificate course, you have the option to acquire an official Certificate, which is a great way to share your achievement with the world. Your Alison Certificate is:
Ideal for sharing with potential employers - include it in your CV, professional social media profiles and job applications
An indication of your commitment to continuously learn, upskill and achieve high results
An incentive for you to continue empowering yourself through lifelong learning
Alison offers 3 types of Certificates for completed Certificate courses:
Digital Certificate - a downloadable Certificate in PDF format, immediately available to you when you complete your purchase
Certificate - a physical version of your officially branded and security-marked Certificate, posted to you with FREE shipping
Framed Certificate - a physical version of your officially branded and security-marked Certificate in a stylish frame, posted to you with FREE shipping
All Certificates are available to purchase through the Alison Shop. For more information on purchasing Alison Certificates, please visit our FAQs. If you decide not to purchase your Alison Certificate, you can still demonstrate your achievement by sharing your Learner Record or Learner Achievement Verification, both of which are accessible from your Dashboard. For more details on our Certificate pricing, please visit our Pricing Page.