Microsoft Office Essential Skills

Course details

Over 40 lectures and hours of video content, plus lots of downloadable materials

• Learn to use Office confidently in the workplace
• Covers things like spellchecking, email folders, Excel calculations, diagrams and images for your presentations
• Practical learning alongside the tutorials
• Quiz assessment to consolidate your learnings through the course
• Expert tuition and support throughout

In this course on Microsoft Office skills you will learn from a Microsoft Certified Trainer how to use the core Office programmes in the workplace and at home. These real life and practical will enable you to get Office working for you!
Employers expect everyone to have basic Microsoft Office skills and this course will get yours up to scratch. Covering Word, Outlook, Excel and Powerpoint, you will learn best practices and be able to achieve confidence and job satisfaction with practice.
Where appropriate the actual files used in the course are provided for practice, and you are encouraged to download them and work alongside the video tutorials.
This course is based in Microsoft Office 2010, but the introductory nature means that the principles can be applied across Microsoft Office 2007 to 2013 and beyond.
Get your skills up to scratch today!

Introduction
Welcome
Microsoft Office Word Essential Skills
Downloadable Materials for Microsoft Office Word Essential Skills
A Quick Tour of the Interface
Using Styles
Spellchecking a document
Find and replace
Adding a list in Word
Inserting a table
Inserting a chart or picture
Using Autocorrect and Quick Parts
Saving a Document as a Template
Microsoft Office Outlook Essential Skills
Interface and setting up your account
Email and folders
Forwarding emails and using attachments
Outlook calendar
Recurring appointments and meetings
Outlook contacts
Outlook Tasks
Social Media Proposal
Microsoft Office Excel Essential Skills
Downloadable Materials for Microsoft Office Excel Essential Skills
Simple Excel Calculations - Subtraction
Simple Excel Calculations – Multiplying by a Percentage
Simple Excel Calculations – Subtracting and multiplying in the same formula
Simple Excel Calculations – The Invoice
Simple Excel Calculations – Locking cell references
Excel formulas and functions
Inserting functions from Autosum button
Excel named ranges
Outlining in Excel
Sorting data
Adding filters
Intro to Excel Tables
Microsoft Office PowerPoint Essential Skills
Downloadable Materials for Microsoft Office PowerPoint Essential Skills
PowerPoint Basics
Adding a bullet list and table
Adding a chart
Adding a SmartArt Diagram to a slide
Adding Images
Adding slide transitions and applying a theme
Adding animations
Putting it all together
Next Steps
Where do we go from here?
Quiz
Part 1
Part 2
Part 3
Part 4 Updated on 10 January, 2018