Course Description
Employers expect everyone to have basic Microsoft Office skills and this course will get yours up to scratch. This Microsoft Office Essential Training 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 Video 00:02:00
-
A Quick Tour of the Interface 00:07:00
-
Using Styles 00:06:00
-
Spellchecking a Document 00:06:00
-
Find & Replace, and the New Navigation Pane 00:04:00
-
Adding a List in Word 00:08:00
-
Inserting a Table 00:05:00
-
Inserting a Chart and a Picture 00:05:00
-
Using AutoCorrect, and a Look at Quick Parts 00:08:00
-
Saving a Document as a Template 00:06:00
-
The Outlook 2010 INterface, and Setting Up Your Account 00:05:00
-
Email and Folders in Outlook 2010 00:06:00
-
Forwarding Emails, and Sending & Receiving Attachments 00:06:00
-
The Outlook Calendar 00:07:00
-
Adding a Recurring Appointment, and Setting Up a Meeting 00:07:00
-
Adding Outlook Contacts 00:07:00
-
Outlook Tasks 00:07:00
-
Simple Excel Calculations – Subtraction 00:03:00
-
Simple Excel Calculations – Multiplying by a Percentage 00:03:00
-
Simple Excel Calculations – Subtracting and Multiplying in the Same Formula 00:04:00
-
Simple Excel Calculations – The Invoice 00:06:00
-
Simple Excel Calculations – Locking Cell References 00:07:00
-
Excel Formulas and Functions 00:05:00
-
Inserting Functions from the Autosum Button 00:05:00
-
Excel Named Ranges 00:06:00
-
Outlining in Excel 00:06:00
-
Sorting Data in Excel 00:05:00
-
Adding Filters in Excel 00:06:00
-
Introduction to Excel Tables 00:09:00
-
PowerPoint Basics 00:07:00
-
Adding a Bullet List and a Table 00:05:00
-
Adding a Chart to your Presentation 00:03:00
-
Adding a SmartArt Diagram to a Slide 00:04:00
-
Adding Images in PowerPoint 00:07:00
-
Adding Slide Transitions and Applying a Theme 00:05:00
-
Adding Animations 00:05:00
-
Putting it All Together 00:05:00
Course Reviews
No Reviews found for this course.
or
Get all courses for only £492000+ Globally Recognised Premium Courses
This course includes:
