Course Description
Employers expect everyone to have basic Microsoft Office skills and this course will get yours up to scratch. This [course_title] 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.
The course covers all the basics you need to know on the 4 key pieces of software. Covering Word, Outlook, Excel and PowerPoint, you will learn best practices and be able to achieve confidence and job satisfaction with practice. 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 more. 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.
What Will I Learn?
- Confidently use Microsoft Office in the workplace
- Understand the essential skills employers expect in Word, Outlook, Excel and PowerPoint
- Apply best practices to your work
- Achieve confidence and job satisfaction through practice
Requirements
- 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!
Who is the target audience?
- 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
-
Introduction Video00:02:00
-
A Quick Tour of the Interface00:07:00
-
Using Styles00:06:00
-
Spellchecking a Document00:06:00
-
Find & Replace, and the New Navigation Pane00:04:00
-
Adding a List in Word00:08:00
-
Inserting a Table00:05:00
-
Inserting a Chart and a Picture00:05:00
-
Using AutoCorrect, and a Look at Quick Parts00:08:00
-
Saving a Document as a Template00:06:00
-
The Outlook 2010 INterface, and Setting Up Your Account00:05:00
-
Email and Folders in Outlook 201000:06:00
-
Forwarding Emails, and Sending & Receiving Attachments00:06:00
-
The Outlook Calendar00:07:00
-
Adding a Recurring Appointment, and Setting Up a Meeting00:07:00
-
Adding Outlook Contacts00:07:00
-
Outlook Tasks00:07:00
-
Simple Excel Calculations – Subtraction00:03:00
-
Simple Excel Calculations – Multiplying by a Percentage00:03:00
-
Simple Excel Calculations – Subtracting and Multiplying in the Same Formula00:04:00
-
Simple Excel Calculations – The Invoice00:06:00
-
Simple Excel Calculations – Locking Cell References00:07:00
-
Excel Formulas and Functions00:05:00
-
Inserting Functions from the Autosum Button00:05:00
-
Excel Named Ranges00:06:00
-
Outlining in Excel00:06:00
-
Sorting Data in Excel00:05:00
-
Adding Filters in Excel00:06:00
-
Introduction to Excel Tables00:09:00
-
PowerPoint Basics00:07:00
-
Adding a Bullet List and a Table00:05:00
-
Adding a Chart to your Presentation00:03:00
-
Adding a SmartArt Diagram to a Slide00:04:00
-
Adding Images in PowerPoint00:07:00
-
Adding Slide Transitions and Applying a Theme00:05:00
-
Adding Animations00:05:00
-
Putting it All Together00:05:00
Course Reviews
No Reviews found for this course.