Microsoft Office 2013 with an Exam

Learn how to use the applications of Microsoft Office 2013 at all levels of proficiency. This course includes comprehensive learning in each element of Microsoft Office: PowerPoint, Word, Excel and Outlook. Microsoft Office is the most commonly used software within business so thorough knowledge of the Office suite and its many powerful applications will add to your professional skill set and boost your career by making you more attractive to potential employers. Gain an in depth understanding of this vital package, improve existing skills and learn brand new ones with this vital course.

Microsoft Office specialisation certification is available for Word, Excel, PowerPoint and Outlook, validating core skills in these applications. Each MOS exam is a stand alone certification.

Comprehensive and convenient

The course is broken down into 12 comprehensive modules covering basic, intermediate and advanced uses of Microsoft Office 2013. You can spend as little or as much time on each module as you feel is necessary – simply log in and out of your course at your convenience. The flexible nature of the course means you can learn at your own pace depending on other commitments. The nature of online learning enables you to study anywhere and at any time.

key learning points

This course has been developed to give you a thorough grounding in Microsoft Office 2013 and its various uses. Focus areas include:

• Excel 2013 basic, advanced and intermediate: Explore the concepts and uses of Excel from basic through to advanced levels. Along the way you will learn to create and format spreadsheets, and collate and analyse data and information. Learn how to produce professional looking charts and tables using the tools and formulas within the Excel.
• Outlook 2013 basic, advanced and intermediate: Learn how to use Microsoft Outlook to send professional-standard emails with the tools and functions provided. Get to grips with using the calendar, task manager, contact manager, note taking function, journal, web browser and other features, and how application of these functions can enable you to work more efficiently.
• PowerPoint 2013 basic, advanced and intermediate: Learn how to make professional looking and dynamic presentations, and how to share information easily using images, video, narration, charts, graphics, tables and more.
• Word 2013 basic, advanced and intermediate: Discover how to create professional-looking documents using a variety of tools and features. Learn how to use Word to create documents such as invoices, letters, posters, certificates, meeting minutes, orders and much more.

advantages of this course

• Comprehensive high quality e-learning content delivered in 12 manageable modules
• Boost your education and job prospects. Develop skills and qualifications to take you to the next step in your career
• Learn at your own pace and fully understand each module before moving on
• Our technical support team will be on hand to offer you advice and guidance via telephone email
• Gain a certificate validating your core skills in these applications

Invest in this course now and boost your job prospects with skills vital for the modern workplace.

• Units of study

Word 2013 Basic

• Introduction
• Create Document
• Opening an Existing Document
• Save the current document
• Navigation and Selection Techniques
• Entering, Amending and Deleting Text
• Formatting Text
• Formatting Paragraphs
• Run a Spell Check and correct any mistakes found
• Use Synonyms and the Thesaurus
• Bullets and Numbered Lists
• Cut, Copy and Paste
• Create and Format Tables
• Page Layout
• Print Preview & Printing a document

Word 2013 Intermediate

• Quick Parts
• Section Breaks
• Insert Headers and Footers
• Styles
• Table of Contents
• Cover Page
• Inserting Images
• SmartArt
• Style Sets and Themes
• Inserting special characters/symbols
• Borders and Shading
• Table Draw and Quick Tables
• Columns

Word 2013 Advanced

• Mail Merge
• Footnotes and Endnotes
• Watermarks
• Tracking changes and comments
• Protecting a Document
• Creating Forms
• Macros
• User Accounts with Word
• Final Topic / Review

Excel 2013 Basic

• Introduction
• Create Workbook
• Opening an Existing Workbook
• Saving a workbook
• Entering and editing data
• Formatting
• Headers & Footers
• Copy, pasting and moving data
• Working with columns and rows
• Using Autofil
• Preview and Printing
• Formula and Functions
• Sorting and Filtering Data

Excel 2013 Intermediate

• Charts and Graphs
• Named Ranges
• Intermediate Formula and Functions
• Formula Auditing
• Outline Groups
• Data Validation
• Sparklines
• Conditional Formatting
• Comments
• Protecting a workbook

Excel 2013 Advanced

• Create Custom Lists
• Forms
• Advanced Formula and Functions
• Using the Watch Window
• Scenarios
• Goal Seek
• Solver
• Pivot Tables
• Macros
• Working with External Data sources

PowerPoint 2013 Basic

• Introduction
• Create a Presentation
• Opening an Existing Presentation
• Saving a Presentation
• Building your presentation
• Formatting Text
• Run a Spell Check and correct any mistakes found
• Cut, Copy and Paste
• Bulleted and numbered Lists
• Understanding PowerPoint Views
• Running your Slide Show
• Creating Slide Notes
• Printing
• Inserting and formatting shapes
• Inserting Pictures

PowerPoint 2013 Intermediate

• Inserting and Formatting Tables
• Inserting and Formatting Charts
• Inserting and using SmartArt
• Image Manipulation
• Applying Themes
• Slide Backgrounds
• Animation
• Slide Show Presentation Options
• Annotating / Referencing slides
• Applying annotations while running a slide show

PowerPoint 2013 Advanced

• Slide Master
• Create templates
• Actions
• Sections
• Advanced Animation
• Inserting video
• Inserting audio
• Collaboration
• Exporting
• Protecting presentations

Outlook 2013 Basic

• Introduction
• Reading Email Messages
• Replying to and forwarding messages
• Creating a New Message
• Spell Checking Messages
• Setting the Importance Level
• Working with Message Attachments
• Working with Message Flags
• Mark a message as read or unread
• Saving a message as a Draft
• Searching for a message
• Deleting Messages
• Creating Folders
• Moving message into folders
• Sorting and Grouping Messages
• Viewing the Outlook Calendar
• Creating an Appointment
• Changing an Appointment
• Creating an All Day Event
• Printing the Calendar
• Working with Tasks
• Working with the To-Do Bar

Outlook 2013 Intermediate

• Email Formats
• Resend a Message
• Recall a Message
• Requesting Delivery and Read Receipts
• Saving Sent Items to another Folder
• Delaying delivery of a message
• Directing Replies
• Using Voting Buttons
• Using Categories for Email
• Using Signatures
• Viewing Messages by Conversation
• Adding to the Favourites Folder list
• Using Quick Steps
• Setting Up Rules
• Mark a Contact as Private
• Using Schedule View
• Mark an Appointment as Private
• Create a Recurring Appointment
• Working with Meetings
• Email a Calendar
• Add a person to the Address Book
• Using Categories with People
• Create a Contact Group
• Categorize Tasks

Outlook 2013 Advanced

• Setting up Multiple Email Accounts
• Controlling Desktop Alerts and other message arrival options
• Managing Junk Email
• RSS Feeds
• View and Change Email views
• Build a New Email View
• Create an Email Message Template
• Use a rule to automatically reply using a template
• Identifying default email options
• Archiving
• Mailbox Cleanup
• Using Search Folders
• Send/Receive Groups
• Download Headers
• Contact Fields
• Advanced Contact Searches
• Connecting the People Pane to social media sites
• Virtual Business Cards in signatures
• Sending an electronic Business Card
• Contact Views
• Mail Merge
• Calendar Groups
• Customising the Weather Bar
• Import/Export
• Final Topic/Review