Microsoft Office Online Course - Word, Excel, PowerPoint, Outlook, Access
Microsoft Office Online Course - Word, Excel, PowerPoint, Outlook, Access
PRIVATE
PRIVATE COURSE OR
1 Year Access 
Advanced
20 Students -
3 days, 6 hours
Introduction
If you are looking forward to learning each and every single details of Microsoft Office, then you are at the right place. Microsoft Office Online Course – Word, Excel, PowerPoint, Outlook, Access is designed for beginners to grasp Microsoft Office and all of its features. This course will teach all the essential functions of Word, Excel, PowerPoint, Outlook and Access.
Course description
Initially, you will learn about the basic features of Microsoft Word such as creating a new document, personalizing the Microsoft Word interface, adding graphics, etc. Besides, you will learn about the techniques of controlling page appearance, proofing and editing a document. Following that, you will learn about the foundations of Microsoft Office Excel that is essential to create and work with an electronic spreadsheet. You will be able to insert and delete text, adjust cells, create columns, rows and much more. Next, Microsoft PowerPoint will help you to learn to navigate the PowerPoint environment, create and save PowerPoint presentation, delivering advanced text editing etc.
Microsoft Outlook will help you to set up and use Outlook on Windows. It will also assist you in creating and sending messages, managing contacts, using the calendar, managing tasks, working with notes and much more.
Overall, this course gives you all information to access Microsoft Office 2016. Register today and get benefit from this course.
Course design
The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.
You are taught through a combination of
- Video lessons
- Online study materials
- Mock exams
- Multiple-choice assessment
How is the course assessed?
To successfully complete the course you must pass an automated, multiple-choice assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion.
Will I receive a certificate of completion?
Upon successful completion, you will qualify for the UK and internationally-recognised certificate and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hardcopy Certificate for £15.
Why study this course
Whether you’re an existing practitioner or aspiring professional, this course will enhance your expertise and boost your CV with key skills and an accredited qualification attesting to your knowledge.
The Microsoft Office Online Course – Word, Excel, PowerPoint, Outlook, Access is open to all, with no formal entry requirements. All you need is a passion for learning, a good understanding of the English language, numeracy and IT, and to be over the age of 16.
Course Curriculum
| Microsoft Word | |||
| Identify the Components of the Word Interface | 00:30:00 | ||
| Create a Word Document | 00:30:00 | ||
| Help | 00:30:00 | ||
| Navigate and Select Text | 00:30:00 | ||
| Modify Text | 00:30:00 | ||
| Find and Replace Text | 00:30:00 | ||
| Apply Character Formatting | 00:30:00 | ||
| Align Text Using Tabs | 00:30:00 | ||
| Display Text as List Items | 00:30:00 | ||
| Control Paragraph Layout | 00:30:00 | ||
| Apply Borders and Shading | 00:30:00 | ||
| Apply Styles | 00:30:00 | ||
| Manage Formatting | 00:30:00 | ||
| Insert a Table | 00:30:00 | ||
| Modify a Table | 00:30:00 | ||
| Format a Table | 00:30:00 | ||
| Convert Text to a Table | 00:30:00 | ||
| Sort a List | 00:30:00 | ||
| Renumber a List | 00:30:00 | ||
| Customize a List | 00:30:00 | ||
| Insert Symbols and Special Characters | 00:30:00 | ||
| Add Images to a Document | 00:30:00 | ||
| Apply a Page Border and Color | 00:30:00 | ||
| Add a Watermark | 00:30:00 | ||
| Add Headers and Footers | 00:30:00 | ||
| Control Page Layout | 00:30:00 | ||
| Check Spelling and Grammar | 00:30:00 | ||
| Other Proofing Tools | 00:30:00 | ||
| Check Accessibility | 00:30:00 | ||
| Customize the Word Interface | 00:30:00 | ||
| Additional Save Options | 00:30:00 | ||
| Manage Additional File Types | 00:30:00 | ||
| Activities – Microsoft Word 2016 for Beginners | 00:00:00 | ||
| Microsoft Excel | |||
| Identify the Elements of the Excel Interface | 00:30:00 | ||
| Activity – Identify the Elements of the Excel Interface | 00:05:00 | ||
| Create a Basic Worksheet | 01:00:00 | ||
| Activity – Create a Basic Worksheet | 00:05:00 | ||
| Use the Help System | 00:15:00 | ||
| Activity – Use the Help System | 00:05:00 | ||
| Create Formulas in a Worksheet | 01:00:00 | ||
| Activity – Create Formulas in a Worksheet | 00:05:00 | ||
| Insert Functions in a Worksheet | 00:30:00 | ||
| Activity – Insert Functions in a Worksheet | 00:05:00 | ||
| Reuse Formulas | 00:30:00 | ||
| Activity – Reuse Formulas | 00:05:00 | ||
| Manipulate Data | 00:30:00 | ||
| Activity – Manipulate Data | 00:05:00 | ||
| Insert, Manipulate, and Delete Cells, Columns, and Rows | 00:30:00 | ||
| Activity – Insert, Manipulate, and Delete Cells, Columns, and Rows | 00:05:00 | ||
| Search For and Replace Data | 00:30:00 | ||
| Activity – Search For and Replace Data | 00:05:00 | ||
| Spell Check a Worksheet | 00:30:00 | ||
| Activity – Spell Check a Worksheet | 00:05:00 | ||
| Modify Fonts | 00:30:00 | ||
| Activity – Modify Fonts | 00:05:00 | ||
| Add Borders and Colors to Cells | 01:00:00 | ||
| Activity – Add Borders and Colors to Cells | 00:05:00 | ||
| Apply Number Formats | 00:30:00 | ||
| Activity – Apply Number Formats | 00:05:00 | ||
| Align Cell Contents | 00:30:00 | ||
| Activity – Align Cell Contents | 00:05:00 | ||
| Apply Cell Styles | 00:30:00 | ||
| Activity – Apply Cell Styles | 00:05:00 | ||
| Define the Basic Page Layout for a Workbook | 01:00:00 | ||
| Activity – Define the Basic Page Layout for a Workbook | 00:05:00 | ||
| Refine the Page Layout and Apply Print Options | 00:30:00 | ||
| Activity – Refine the Page Layout and Apply Print Options | 00:05:00 | ||
| Format Worksheet Tabs | 00:30:00 | ||
| Activity – Format Worksheet Tabs | 00:05:00 | ||
| Manage Worksheets | 00:30:00 | ||
| Activity – Manage Worksheets | 00:05:00 | ||
| Manage the View of Worksheets and Workbooks | 00:30:00 | ||
| Activity – Manage the View of Worksheets and Workbooks | 00:05:00 | ||
| Customize General and Language Options | 00:30:00 | ||
| Activity – Customize General and Language Options | 00:05:00 | ||
| Customize Formula Options | 00:30:00 | ||
| Activity – Customize Formula Options | 00:05:00 | ||
| Customize Proofing and Save Options | 01:00:00 | ||
| Activity – Customize Proofing and Save Options | 00:05:00 | ||
| Customize the Ribbon and Quick Access Toolbar | 00:30:00 | ||
| Activity – Customize the Ribbon and Quick Access Toolbar | 00:05:00 | ||
| Customize the Functionality of Excel by Enabling Add-Ins | 00:30:00 | ||
| Activity – Customize the Functionality of Excel by Enabling Add-Ins | 00:05:00 | ||
| Customize Advanced and Trust Center Options | 00:30:00 | ||
| Activity – Customize Advanced and Trust Center Options | 00:05:00 | ||
| Activities and Exercise Files – Microsoft Excel 2016 for Beginners | 00:00:00 | ||
| Microsoft PowerPoint | |||
| Navigate the PowerPoint Environment | 00:30:00 | ||
| ACTIVITY – NAVIGATING THE POWERPOINT 2016 USER INTERFACE | 00:05:00 | ||
| Create and Save a PowerPoint Presentation | 00:15:00 | ||
| ACTIVITY – CREATING AND SAVING A POWERPOINT PRESENTATION | 00:05:00 | ||
| Use Help | 00:15:00 | ||
| ACTIVITY – USING POWERPOINT HELP | 00:05:00 | ||
| Select a Presentation Type | 00:15:00 | ||
| ACTIVITY – SELECTING A PRESENTATION TYPE | 00:05:00 | ||
| Build a Presentation | 00:15:00 | ||
| ACTIVITY – BUILDING A PRESENTATION | 00:05:00 | ||
| Lay Out a Presentation | 00:15:00 | ||
| ACTIVITY – LAYING OUT A PRESENTATION | 00:05:00 | ||
| Edit Text | 00:15:00 | ||
| ACTIVITY – EDITING TEXT | 00:05:00 | ||
| View and Navigate a Presentation | 00:15:00 | ||
| ACTIVITY – VIEWING A PRESENTATION | 00:05:00 | ||
| Format Characters | 00:15:00 | ||
| ACTIVITY – FORMATTING CHARACTERS | 00:05:00 | ||
| Format Paragraphs | 00:30:00 | ||
| ACTIVITY – FORMATTING PARAGRAPHS | 00:05:00 | ||
| Format Text Boxes | 00:15:00 | ||
| ACTIVITY – FORMATTING TEXT BOXES | 00:05:00 | ||
| Insert Images | 00:30:00 | ||
| ACTIVITY – INSERTING IMAGES | 00:05:00 | ||
| Insert Shapes | 00:15:00 | ||
| ACTIVITY – INSERTING SHAPES | 00:05:00 | ||
| Insert WordArt | 00:15:00 | ||
| ACTIVITY – INSERT WORDART | 00:05:00 | ||
| Edit Objects | 00:30:00 | ||
| ACTIVITY – EDITING OBJECTS | 00:05:00 | ||
| Format Objects | 00:15:00 | ||
| ACTIVITY – FORMATTING OBJECTS | 00:05:00 | ||
| Group Objects | 00:15:00 | ||
| ACTIVITY – GROUPING OBJECTS | 00:05:00 | ||
| Arrange Objects | 00:15:00 | ||
| ACTIVITY – ARRANGING OBJECTS | 00:05:00 | ||
| Animate Objects | 00:15:00 | ||
| ACTIVITY – ANIMATING OBJECTS | 00:05:00 | ||
| Create a Table | 00:15:00 | ||
| ACTIVITY – CREATING A TABLE | 00:05:00 | ||
| Format a Table | 00:15:00 | ||
| ACTIVITY – FORMATTING A TABLE | 00:05:00 | ||
| Insert a Table from Other Microsoft Office Applications | 00:15:00 | ||
| ACTIVITY – INSERTING A TABLE FROM MICROSOFT EXCEL | 00:05:00 | ||
| Create a Chart | 00:15:00 | ||
| ACTIVITY – CREATING A CHART | 00:05:00 | ||
| Format a Chart | 00:15:00 | ||
| ACTIVITY – FORMATTING A CHART | 00:05:00 | ||
| Manipulate a Chart | 00:15:00 | ||
| ACTIVITY – MANIPULATING A CHART | 00:05:00 | ||
| Insert a Chart from Microsoft Excel | 00:15:00 | ||
| ACTIVITY – INSERTING A CHART FROM MICROSOFT EXCEL | 00:05:00 | ||
| Review Your Presentation | 00:30:00 | ||
| ACTIVITY – REVIEWING YOUR PRESENTATION | 00:05:00 | ||
| Apply Transitions | 00:15:00 | ||
| ACTIVITY – APPLYING TRANSITIONS | 00:05:00 | ||
| Print Your Presentation | 00:15:00 | ||
| ACTIVITY – PRINTING YOUR PRESENTATION | 00:05:00 | ||
| Deliver Your Presentation | 01:00:00 | ||
| ACTIVITY – DELIVERING YOUR PRESENTATION | 00:05:00 | ||
| Activities – Microsoft PowerPoint 2016 for Beginners | 00:00:00 | ||
| Microsoft Outlook | |||
| Navigate the Outlook Interface | 00:15:00 | ||
| ACTIVITY – NAVIGATING THE OUTLOOK INTERFACE | 00:05:00 | ||
| Perform Basic E-mail Functions | 00:30:00 | ||
| ACTIVITY – PERFORMING BASIC E-MAIL FUNCTIONS | 00:05:00 | ||
| Use Outlook Help | 00:15:00 | ||
| ACTIVITY – GETTING HELP IN MICROSOFT OUTLOOK 2016 | 00:05:00 | ||
| Create an E-mail Message | 00:15:00 | ||
| ACTIVITY – CREATING AN E-MAIL MESSAGE | 00:05:00 | ||
| Check Spelling and Grammar | 00:15:00 | ||
| ACTIVITY – CHECK SPELLING AND GRAMMAR | 00:05:00 | ||
| Format Message Content | 00:15:00 | ||
| ACTIVITY – FORMAT MESSAGE CONTENT | 00:05:00 | ||
| Attach Files and Items | 00:15:00 | ||
| ACTIVITY – ATTACHING A FILE TO A MESSAGE | 00:05:00 | ||
| Enhance an E-mail Message | 00:30:00 | ||
| ACTIVITY – ENHANCING AN E-MAIL MESSAGE | 00:05:00 | ||
| Manage Automatic Message Content | 00:15:00 | ||
| ACTIVITY – MANAGING AUTOMATIC MESSAGE CONTENT | 00:05:00 | ||
| Customize Reading Options | 00:15:00 | ||
| ACTIVITY – CUSTOMIZING READING OPTIONS | 00:05:00 | ||
| Work with Attachments | 00:15:00 | ||
| ACTIVITY – WORKING WITH ATTACHMENTS | 00:05:00 | ||
| Manage Your Message Responses | 00:15:00 | ||
| ACTIVITY – MANAGING YOUR MESSAGE RESPONSES | 00:05:00 | ||
| Manage Messages Using Tags, Flags, and Other Commands | 00:15:00 | ||
| ACTIVITY – MANAGING MESSAGES USING TAGS, FLAGS AND OTHER COMMANDS | 00:05:00 | ||
| Organize Messages Using Folders | 00:15:00 | ||
| ACTIVITY – ORGANIZING MESSAGES USING FOLDERS | 00:04:00 | ||
| View the Calendar | 00:15:00 | ||
| ACTIVITY – CUSTOMIZING YOUR CALENDAR VIEW | 00:05:00 | ||
| Manage Appointments | 00:15:00 | ||
| ACTIVITY – MANAGING APPOINTMENTS | 00:05:00 | ||
| Manage Meetings | 00:30:00 | ||
| ACTIVITY – CREATING AND MANAGING MEETINGS | 00:05:00 | ||
| Print Your Calendar | 00:15:00 | ||
| ACTIVITY – PRINTING YOUR CALENDAR | 00:05:00 | ||
| Create and Update Contacts | 00:15:00 | ||
| ACTIVITY – CREATING AND UPDATING CONTACTS | 00:05:00 | ||
| View and Organize Contacts | 00:15:00 | ||
| ACTIVITY – VIEW AND ORGANIZE CONTACTS | 00:05:00 | ||
| Create Tasks | 00:15:00 | ||
| ACTIVITY – CREATING TASKS | 00:05:00 | ||
| Manage Tasks | 00:15:00 | ||
| ACTIVITY – MANAGING TASKS | 00:05:00 | ||
| Manage Notes | 00:15:00 | ||
| ACTIVITY – CREATING AND MANAGING NOTES | 00:05:00 | ||
| Customize the Outlook Interface | 00:30:00 | ||
| ACTIVITY – CUSTOMIZING THE OUTLOOK INTERFACE | 00:05:00 | ||
| Create and Manage Quick Steps | 00:15:00 | ||
| ACTIVITY – CREATING AND MANAGING QUICK STEPS | 00:05:00 | ||
| Activities – Microsoft Outlook 2016 for Beginners | 00:00:00 | ||
| Microsoft Access | |||
| Orientation to Microsoft Access | 01:00:00 | ||
| Create a Simple Access Database | 01:00:00 | ||
| Get Help in Microsoft Access | 00:30:00 | ||
| Modify Table Data | 00:30:00 | ||
| Working With Records | 00:15:00 | ||
| Sort and Filter Records | 00:30:00 | ||
| Create Lookups | 01:00:00 | ||
| Join Data from Different Tables in a Query | 01:00:00 | ||
| Sort and Filter Data in a Query | 01:00:00 | ||
| Perform Calculations in a Query | 00:30:00 | ||
| Create Parameter Queries | 00:30:00 | ||
| Create Action Queries | 00:30:00 | ||
| Create Find Duplicate and Find Unmatched Queries | 00:30:00 | ||
| Summarize Data | 00:30:00 | ||
| Create a Report | 01:00:00 | ||
| Add Controls to a Report | 00:30:00 | ||
| Enhance the Appearance of a Report | 00:30:00 | ||
| The Access Options Dialog Box | 01:00:00 | ||
| Create a Table | 01:00:00 | ||
| Modify a Table and Fields | 00:30:00 | ||
| Create Table Relationships | 00:30:00 | ||
| Create Query Joins | 00:30:00 | ||
| Join Tables That Have No Common Fields | 00:30:00 | ||
| Relate Data within a Table | 00:30:00 | ||
| Work with Subdatasheets | 00:30:00 | ||
| Create Subqueries | 00:30:00 | ||
| Data Normalization | 01:00:00 | ||
| Create a Junction Table | 00:30:00 | ||
| Import Data into Access | 00:30:00 | ||
| Export Data to Text File Formats | 00:30:00 | ||
| Export Access Data to Excel | 00:30:00 | ||
| Create a Mail Merge | 00:30:00 | ||
| Organize Report Information | 00:30:00 | ||
| Format Reports | 00:30:00 | ||
| Include Charts in a Report | 00:30:00 | ||
| Add a Calculated Field to a Report | 00:30:00 | ||
| Add a Subreport to an Existing Report | 00:30:00 | ||
| Create a Mailing Label Report | 00:30:00 | ||
| Publish a Report as PDF | 00:30:00 | ||
| Activities – Microsoft Access 2016 for Beginners | 00:00:00 | ||
| Mock Exam | |||
| Final Exam | |||
Related Courses
Intermediate
Intermediate
Intermediate
Important Links
With a team of industry professionals producing and delivering our course content, you can be sure the skills and knowledge you learn are applicable to your career aspirations, whether that’s in management, administration or beyond.
0
0
Your Cart
Your cart is emptyBrowse Courses
Upgrade to get UNLIMITED ACCESS to ALL COURSES for only £49/year
Claim Offer & UpgradeMembership renews after 12 months. You can cancel anytime from your account.
Other Students Also Buy
-
Get Lifetime Access To Your Course£9.99 Add to basket+Add