MS Office is the most widely used tool for documenting and organizing information, delivering presentations, as well as processing data in offices environments across the globe. It has been designed to be user friendly, interactive and powerful, which drastically helps increase users’ productivity within the office environment. From opening a job posting for any industry, Microsoft Office efficiency is listed under required skills and qualifications for all positions. In fact, MS Office proficiency is one of the top 3 skills desired by employers. Whether you are looking for a job in Business Accounting, Office Administration, Project Administration, Sales, or Insurance Advisory, in current job market, knowledge of Microsoft Office tools is very essential.
Communication: You can communicate and collaborate more effectively with the Microsoft tools. Whether you’re using Outlook for email, or taking advantage of the co-authoring features in Word and PowerPoint, you’re literally on the same page as your co-workers. That ease of communication helps cut down on errors and improve the quality of service you provide to your customers.
Productivity: Microsoft helps you operate more efficiently so you can be more productive. For example, Excel doesn’t just allow you to quickly enter and compute data; it also has advanced analytical tools so you can discover patterns and make sound financial decisions. Laborious tasks once performed only by accounting professionals can now be completed quickly by assistants with the right training.
Simplicity: Each of the MS Office components is user-friendly and includes easy-to-access help files built right in. If you get stuck at any time, just go to the help tab and type your question. You can even access online support for tutorials on how to troubleshoot whatever issues arise.
This special designed course teach you the basic skills you will need to a level demanded by most employers, including computer keyboard skills, Microsoft Office and book-keeping. What’s more, to ensure you understand how a business works and how to communicate effectively with other employees by using Microsoft office tools.
Gain an understanding of the advanced concepts of document production using Microsoft Word 2016. By the end of the module you will be able to create, edit, format, save and print a wide range of well-presented documents.
Gain advanced knowledge and skills to be able to use Excel or any other spreadsheet application.
Learn the essentials of creating a presentation using presentation tools, specifically Microsoft PowerPoint.
Learn the essentials of working with e-mail as well as using an electronic calendar.
There are no prerequisites to take this course.
PC: Windows XP or later.
Mac: OS X Snow Leopard 10.6 or later.
Browser: The latest version of Internet Explorer, Firefox, Chrome, or Safari (We recommend Firefox or Chrome).
Any edition of Microsoft Office Pro.
This course was developed based upon Windows 10 and Microsoft Office 2016. Many participants may have earlier versions of Windows or Office and that is fine. Simply ask the instructor for clarification on how to accomplish any tasks when necessary.
Adobe Flash Player.
Adobe Acrobat Reader.
Email capabilities and access to a personal email account.
Software must be installed and fully operational before the course begins.
Who Should Attend?
This course is suited for beginners and intermediate users of Microsoft Office which include:
Secretary / Personal Assistant
Administration and General Office Staff
Front Line Staff
Day 1 – Microsoft Office
Module 1: Microsoft Word: Starting Out
Meeting Microsoft Office Word 2010
Creating a Document
Navigating in Your Document
Module 2: Working with Documents
Creating a New Document
Applying Advanced Text Effects
Module 3: Playing Around with Documents
Working with Your Document
Getting Help in Word
Module 4: Doing More with Text
Fonts on the Home Tab
The Font Dialog
Day 2 – Microsoft Excel
Module 1: Starting Out Excel
Exploring your Workbook
Getting Help with Excel
Module 2: Basics and Formatting
Working with Excel
Basic Excel Features
Moving your Data
Modifying Cells and Data
Enhancing a Worksheet’s Appearance
Module 3: Printing and Viewing Your Workbook
Using the View Tab
Managing Multiple Windows
Printing your Workbook
Day 3: Microsoft Excel Advanced
Multiple workbooks and worksheets
IF, VLOOKUP, and Power Functions, Security & Sharing
Data Management, Data Analysis Tools
PivotTables & Macros
Adjust Cell and Tools
Set up Data for Outlines & Picture Formatting Styles
Advanced Formulas and Functions
IF, AND, OR and NOT Functions
VLOOKUP and HLOOKUP
Tabulating Data and Multiple Criteria
Different TEXT & Information Functions
Day 4: Microsoft PowerPoint
Module 1: Starting out PowerPoint
About Microsoft Office PowerPoint
Creating a Presentation
Working with Your Presentation
Module 2: Creating Presentations
Working with Text Boxes
Basic Editing Tools
Advanced Text Tools
The Design Tab
The Transitions Tab
Module 3: Printing and Viewing your Presentation
Using Layouts and Views
Viewing a Slide Show
Preparing Your Presentation
Printing Your Presentation
Day 5: Microsoft Outlook
Module 1: Starting Out
Interacting with Outlook
Working with The Outlook Interface
Module 2: Sending and Receiving Emails
Working with E-Mail Messages
Problem Solving – Discussion
NOT INTERESTED IN THIS COURSE?
We always want to improve the quality of our courses. Please select any reasons why you feel this course is inadequate (check all that apply).