Microsoft Office 2010
Course Description
The Microsoft Office 2010 suite contains five software products that help students and professionals to smoothly get tasks done. This training course teaches how to use the advanced functions and capabilities of Microsoft Word 2010 and its Excel, PowerPoint, Access and Outlook peers. The advantages of mastering these tools are endless and can quickly boost your career prospects.
If you have used an older version of the suite, particularly the 2003 and 2007 versions, you will appreciate the new features of Microsoft Office 2010. Anyone who has completed our ‘ABC IT’ introductory computer course will find this the perfect next step in updating their software skills.
This course suits anyone who wants to improve their office skills, organizational abilities and computer proficiency. Many people casually put ‘MS Office’ on their résumés without knowing how to make full use of the software’s powerful capabilities but this course can set you apart from them as it quickly hones your administrative skills and makes you more employable.
What you'll learn in this course?
-
Microsoft Word
-
Microsoft
-
Excel
-
Microsoft Office
Course Curriculum
- 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
- 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
- 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
- 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
- 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
- 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
- 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
Microsoft
Redmond, Washington State, USA
By