Office 2010 Basic & Advanced for Dummies

Description

• Complete beginners who have need help in getting to grips with each of the tools – Word, Excel, Outlook and PowerPoint.
• Business users who need to gain experience in using the advanced features of Office 2010 for greater productivity.
• Intermediate Office users who want to become more proficient with the software but struggle with “traditional” training materials.
• Individuals who want to learn how Office can be used in a home setting.

• Opening and saving documents.
• Understanding how to use the menu ‘Ribbon’.
• Adding, deleting and moving text in documents.
• Basic formatting options; fonts, emphasis, alignment and size.
• Configuring the page setup options and printing.
• Using free templates to arrange your words for any purpose; letters, job applications, posters, greetings cards and more.
• Using the spelling and grammar checking tools.

• Creating sets of individualised letters and envelopes instantly using Mail Merge to populate key details.
• Inserting form fields.
• Using the Styles bar to apply professional formatting.
• Collaboration tools and editing markup.
• Troubleshooting using the Outline View.
• Correctly using headings to create an automatic index or table of contents for a document.
• Protecting documents with password encryption.
• Developing personalised macros to create the ultimate time-saving shortcuts.
• Adding macros to the toolbar.
• Assigning personalised hotkey functions.

• Understanding spreadsheets and workbooks, and what they do.
• Opening and saving workbooks.
• Understanding how to use the menu ‘Ribbon’.
• Adding, deleting and moving information.
• Basic cell options; size, alignment and number format.
• Performing basic calculations.
• Formatting borders, fonts and colours.

• Using the Styles bar to apply professional formatting to cells.
• Hiding unnecessary data, manually or by using Filters.
• Importing and exporting data.
• Building simple formulas to perform calculations.
• Tracing precedent and dependent cells and error-checking.
• Protecting documents with password encryption.
• Creating advanced formulas to manipulate data.
• Constructing database-like reports using Pivot Tables.
• Developing personalised macros for the ultimate time-saving shortcuts.
• Adding macros to the toolbar.
• Assigning personalised hotkey functions.

• Setting up and navigating Outlook, becoming familiar with common features and functions in the process.
• Receiving and composing and sending e-mail.
• Managing your incoming mail, using folders and filters to help automate some common tasks.
• Storing and using contact information in the Outlook address book.
• Creating and managing tasks in the To-Do List
• Setting up reminders and alerts to ensure no appointments or deadlines are missed.
• Creating and editing calendar appointments and events.
• General tips and tricks to help increase efficiency and get more out of using Outlook.

• Navigating the PowerPoint interface and becoming familiar with the location of commonly-used tools.
• Starting a new presentation and creating and adding slides.
• Adding text to a slide to align with the prepared “talk”, applying themes and formatting text boxes to improve the appearance of the presentation.
• Resizing and rearranging content to fit comfortably onto a slide.
• Inserting graphics and creating SmartArt to create visual interest and animating objects and inserting sound and video for added spice.
• Adding transition effects to liven up the move between slides.
• Animating objects and inserting sound and video for added spice.
• Presenting your show effectively – how to talk clearly and convincingly, and using the slidedeck to support your presentation.
• Printing handouts or exporting files to Word for distribution to meeting attendees and to help them remember what was discussed.

• No prior knowledge required – develop an advanced working knowledge of Office 2010 quickly and easily!
• Improve efficiency and productivity using Office 2010 at home or in the office, to create documents, perform mathematical analysis, manage communications and calendars, or to create a compelling presentation.
• Learn the advanced professional skills needed to operate Microsoft Office 2010 with maximum ease and speed.

• Starting, navigating, and exiting Office 2010 applications
• Managing e-mail, contacts, tasks, and calendars with Outlook
• Building and formatting a PowerPoint presentation with graphics, movement, and sound
• Using Word styles and templates to enhance documents and save time
• Tips for printing envelopes and performing a mail merge
• Applying Excel’s tools for sophisticated data analysis
• Tackling common financial chores such as calculating loan payments and interest and much more!