Get the most out of Microsoft Office 2010 to improve your organizational abilities and office software skills.
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.
Module 1: Making the switch to Word 2010
Module 2: Whats's New in Word
Module 3: Creating your first Word document
Module 4: Explore Your Document using the Navigation Pane
Module 5: Create visually compelling documents
Module 6: Get control of Page Numbers, Headers, and Footers
Module 7: Create and Customize a Table of Contents
Module 8: Create accessible documents
Module 9: Word 2010 tips and techniques
Module 10: Keyboard Shortcuts
Module 11: Microsoft Office 2010 Security
Module 12: Making the switch to Excel 2010
Module 13: What's new in Excel 2010
Module 14: Basic Tasks in Excel 2010
Module 15: Create your first spreadsheet
Module 16: Create Formulas
Module 17: VLOOKUP - What it is and when to use it
Module 18: Understand Data at a glance with Conditional Formatting
Module 19: Sparklines - Use tiny charts to show data trends
Module 20: Use Excel tables to manage information
Module 21: The IF Function - What it is and how to use it
Module 22: How to create a basic chart in Excel 2010
Module 23: Save time by creating and running macros in Excel 2010
Module 24: Figure out dates by using formulas in Excel 2010
Module 25: Plan payments and savings in Excel 2010
Module 26: Keyboard shortcuts in Excel 2010
Module 27: First Assessment (Word & Excel)
Module 28: Making the switch to PowerPoint 2010
Module 29: What's new in PowerPoint 2010
Module 30: Create your first PowerPoint 2010 presentation
Module 31: Add photos to PowerPoint
Module 32: Insert video into a presentation
Module 33: Broadcast a presentation
Module 34: Charts and SmartArt in PowerPoint
Module 35: Animations and Transitions
Module 36: Keyboard Shortcuts
Module 37: PowerPoint Tips and Techniques
Module 38: Making the Switch to Microsoft Access 2010
Module 39: Design and Create New Tables for a Database
Module 40: Create Relationships and Queries for a New Database
Module 41: Create Forms and Reports for a New Database
Module 42: Build and Publish Web Databases
Module 43: Access 2010 Keyboard Shortcuts
Module 44: Making the Switch to Outlook 2010
Module 45: What's new in Microsoft Outlook 2010
Module 46: Get Familiar with the Outlook Calendar
Module 47: Manage Your Information and Create RSS Web Feeds
Module 48: Organise Messages and Automatic Replies
Module 49: Electronic Business Cards, E-mail Signatures and Instant Search
Module 50: Organise with Templates and Views
Module 51: Second Assessment (PowerPoint, Access and Outlook)
Module 52: Course assessment
