Microsoft Office - Essential Skills

This Essential Skills course is an introductory course for using Office at work, particularly for anyone returning to work

This Microsoft Office Essential skills course is an introductory course for anyone who uses Office in the workplace, but particularly anyone returning to work after a career break or looking for a change of career. Throughout the course we will cover techniques used by everyday people in their jobs and walk you through a step-by-step process for creating these techniques for yourself. I'll even include a few "secrets of the pros"...

Because my goal is to get you up to speed as quickly as possible I'll be covering the four most popular components of Microsoft Office - Word, Outlook, Excel and PowerPoint. 

Within these four programs you will cover 90% of the daily tasks carried out in today's office environment including email and calendars, using formulas and functions, sorting and filtering data, using styles and multi-level lists, setting up a PowerPoint presentation and some of my favourite image editing tricks. By the end of the course you will be an Office all-rounder with enough confidence to sail through an interview or just work smarter.

Since it is by far the most common version in use at the current time I will be using Office 2010 edition.

At the end of my course, students will be able to...

  • Confidently use Microsoft Office in the workplace
  • Understand the essential skills employers expect in Word, Outlook, Excel and PowerPoint
  • Apply best practices to their work
  • Achieve confidence and job satisfaction through practice

Who should take this course? Who should not?

  • You should take this course if you use Microsoft Office at work but have never been trained
  • Take this course if you want to become more confident, achieve progression at work or find a new job
  • Update your skills by taking this course if you are returning to work after a career break
  • This course is not intended as a comprehensive guide to Microsoft Office, it is intended to teach the essential skills employers want
  • It does not cover advanced topics but does cover all you need to get started plus lots of cool shortcuts to make your day fly by

What will students need to know or do before starting this course?

What materials/software do the students need and what actions do they have to perform before the course begins?

  • This Essential Skills course requires no previous knowledge, but assumes that students will have access to a PC and a copy of Office 2010 or later.
  • Most of the principles can also be applied to Office 2007 and to Office 2013, but as the 2010 version is the most commonly used, this is the version I have chosen for the tutorials.
  • When appropriate, the actual files used in the tutorial are provided for practice and I encourage students to download them and follow along. You will learn faster and be more confident when you try it yourself!

Intended Audience: Anyone returning to work after a career break, Anyone looking for a new office job, Anyone looking for promotion at work

Why Microsoft Office Essential Skills?
How to use this course
What will you learn?
Exploring the Word 2010 Interface
Introducing Styles
Spellchecking a document
Find & Replace and the new Navigation pane
Adding a List
Inserting a Table
Inserting a Chart and a Picture
AutoCorrect and Quick Parts
Saving a Document as a Template
What will you learn?
The Outlook 2010 interface and setting up an account
Email and Folders
Forwarding emails and Sending & Receiving Attachments
Calendar
Adding a Recurring Appointment and Setting up a Meeting
Adding Outlook Contacts
Outlook Tasks
What will you learn?
Simple calculations - subtraction
Simple calculations - multiplying by a percentage
Simple calculations - performing a subtraction and a multiplication in the same formula
Simple calculations - the Invoice
Simple calculations - locking cell references
Formulas and Functions
Using functions from the AutoSum button
Named Ranges
Outlining
Sorting data
Adding Filters
Introduction to Tables
What will you learn?
PowerPoint - the Interface and PowerPoint basics
Adding a Bullet List and a Table
Adding a Chart
Adding a SmartArt diagram
Adding Images
Adding Transitions and a Theme
Adding Animations
Putting it all together
Where do we go from here?

What's included

  • 36 Video Lessons
  • 7 Text Lessons

  • Works on all devices
  • Certificate of completion

David Millard

Instructor