By the end of this course, you will be able to:

• Recognize how to open a spreadsheet and save your work
• Identify where you can access the Ribbon, the Quick Access
• Recognize how to backup and recover your work if you ever lose it
• Explain how to use Fill and Flash Fill
• Define how to Copy, Cut and Paste in Excel
• State how to customize your options and preferences in Excel
• Indicate the use of Toolbar and Mini Toolbar options in Excel
• Identify how to enter text, numbers, names and basic formatting
• Recognize how to format cells properly
• Describe how to move worksheets around and apply spell check

By the end of this course, you will be able to:

• Describe how to use Word on touch-based machines (iPad, tablet etc.)
• Explain how to customize and personalize Word settings for your needs
• Recognize how to use the ribbon, quick access toolbar and mini toolbar
• Describe how to enter words, letters, symbols, dates, tables
• Recall how to use helpful shortcut features like Find and Replace
• Outline how to access different views in Word including Print preview
• Recognize how to check for spelling and grammar and how to use Word's autocorrect feature
• Demonstrate formatting documents by changing fonts, sizes, borders, shading, bullets and paragraphs

By the end of this course, you will be able to:

• Discuss navigating Microsoft Access using the ribbon and toolbar
• Recognize how to customize Access for your specific requirements
• Discuss the use of the desktop or web app versions
• Identify how to create tables and create relationships between those data tables
• Identify how to sort, filter, enter and find data in your databases
• Discuss correctly designing an Access table including using Design View and Field properties
• Recognise how to create, design and edit Forms

By the end of this course, you will be able to:

• Discuss the use of advanced functions and formulas in Excel
• Illustrate a good understanding of financial functions
• Identify how time and dates are stored and calculated
• Discuss how to use statistical functions to perform regression and percentile calculations
• Explain and demonstrate how text functions work
• Discuss detailed knowledge of logical functions
• Recognize how to connect Excel with external data sources

Upon completion of this course you will be able to:

• Describe how to start PowerPoint, open, save protect and edit your presentations
• Explain how to customize PowerPoint settings to your needs
• Recognize how to locate the ribbon, quick access toolbar and status bar in PowerPoint 2013
• Describe how to add and delete slides, adjust sizes and orientation
• Identify how to change your presentation view and define what each view is used primarily for
• Discuss how to add and format text using text boxes and symbols
• Explain how to use master themes, layouts and templates

By the end of this course, you will be able to:

• Recognize how to create a new publication
• Explain how to Insert, rename, move and delete pages
• List the use of rulers, measurements and guidelines
• Identify how to change Publisher options to suit your needs
• State how to Insert, format and work with text boxes
• Describe the process of inserting paragraphs, columns, hyperlinks and more
• Recall how to work with Styles in Publisher
• Discuss the ways of working with images, including Bitmap and Vector
• Indicate how to use all the different digital file types
• Describe how to move, crop, resize and adjust settings on all your images

By the end of this course, you will be able to

• Identify how to navigate Outlook and understand the ribbon, quick access toolbar and contextual menu
• Recognize how to customize Outlook to your needs
• Discuss how to set up an Outlook account
• Identify the process of send and receive emails and calendar appointments
• Recognize how to add contacts to your address book
• Recognize how to add tasks and create notes
• Discuss integrating Outlook with email service providers
• Identify how to add, remove and delete items form folders
• Disucss using auto archive and manual archive

By the end of this course, you will be able to:

• Discuss creating a new SharePoint site
• Recognize how to add contents and Apps to a SharePoint site
• Recognize how to set up users and user permissions on a SharePoint site
• Discuss the integration SharePoint with other MS Office tools
• Recognize how to import data from an Excel workbook
• Identify the process of updating documents including checking them in and out
• Recall how to work with page history and versions

Upon successful completion of this course you will be able to:

• Discuss MS Visio with a solid understanding of it
• Recognize how to set up Visio to suit your needs
• Recognize how to create drawings using templates and stencils
• Identify how to create your own object from scratch
• Identify the process of aligning shapes using Dynamic Grid
• Discuss the utilization of ruler, grids, guides and the drawing tools
• Recognize how to resize, move and connect shapes
• Discuss using Autoconnect, Auto-add and Auto-delete
• Recognize how to work with text, from orientation to proofing
• Discuss how to utilize multi-page drawings, fill, color, themes and the format painter

By the end of this course, you will be able to:

• Navigate with confidence around Microsoft Project 2013
• Customize Project 2013 to your requirements
• Use keyboard shortcuts to speed up your Project capability
• Set up tasks, enter project information and use task basics such as entry bar, timeline and properties
• Use the resource sheet view and resource assignment tool
• Open and save projects in the right way including using Autosave and understand the different file formats
• Create project calendars and schedule work
• Use the different views in MS Project to display what you need

By the end of this course, you will be able to:

• Describe the features of Personal and Community SharePoint sites
• Explain how to use the Global Navigation Bar
• Illustrate the use of Microblogging, following, tasks and newsfeeds
• Describe how Community sites work, how to set them up, moderate and administer them
• Recall how to integrate SharePoint with Outlook and sync up alerts
• Describe the use Project sites within SharePoint

By the end of this course, you will be able to:

• Identify how to Split projects into subprojects
• Discuss using a shared resource pool and access Project files with a shared resource pool
• Recognize how to set priorities between Projects
• Discuss using WBS codes
• Identify how to properly cost and budget a project
• Recognize how to produce the reports you need in MS Project
• Identify how to produce Burndown and Standard cost reports

By the end of this course, you will be able to:

• Discuss the uses and constraints of Indexing in databases
• Recognize how to link to other databases and use the Datasheet view
• Identify how to install SQL Server Express and set up accessing a database
• Discuss the process and purpose of splitting an Access database
• Discuss the basics of Macros, both their uses and how to make them
• Identify how to customize the Quick Access Toolbar
• Discuss creating Macros using VBA code

By the end of this course, you will be able to:

• Discuss about PSE preferences and how to set up PSE 15
• Recognize essential Photoshop keyboard shortcuts
• Identify how to import images into Photoshop Elements from a camera, files and folders and a scanner
• Discuss all about the Organizer including the timeline and catalogues
• Discuss about adding keywords and tags and saving your images in albums
• Identify how to bulk import
• Recognize how to backup Photoshop and restore deleted files
• Discuss the Editor and how to change your preferences
• Discuss editing images including Auto Smart Tone, Effects, Textures and Frames and the Quick Selection Tool
• Identify how to remove red eye
• Recognize how to print properly from Photoshop Elements
• Discuss editing in expert mode including cropping, rotating and flipping and straightening images

In this course you will learn:

• Identify how to create a table, name a table and remove duplicate rows
• Recognize how to insert rows and columns into tables
• Discuss the use of table styles, reference and selection
• Identify the basic principles of a PivotTable
• Recognize how to create a PivotTable
• Recognize how to filter in PivotTables
• Identify how to perform data analysis using a PivotTable
• Discuss how to use the Scenario Manager
• Outline how to use Goal Seek
• Discuss how to use the Solver tool in Excel