Complete Microsoft Office Bundle

One Education
One Education

Course

Online

£ 425 VAT inc.

Description

  • Type

    Course

  • Level

    Advanced

  • Methodology

    Online

  • Duration

    12 Months

  • Start date

    Different dates available

  • Support service

    Yes

  • Virtual classes

    Yes

If you are looking forward to learning each and every single details of Microsoft Office, then you are at the right place. Complete Microsoft Office Bundle 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.
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.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

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.

The Complete Microsoft Office Bundle 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.

Upon successful completion, you will qualify for the UK and internationally-recognised professional qualification and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £19 and Hardcopy Certificate for £34.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2019

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 5 years

Subjects

  • Excel
  • Word
  • Powerpoint
  • Access
  • Presentation
  • Options
  • Office IT
  • Microsoft Excel
  • Layout
  • Grammar
  • Ms Office
  • Microsoft excel training
  • MS Excel
  • Ms PowerPoint
  • Microsoft Access
  • Outlook
  • Proofing
  • Microsoft Office
  • Ms Word

Course programme

COURSE CURRICULUM

Microsoft Word
  • Identify the Components of the Word Interface
  • Create a Word Document
  • Help
  • Navigate and Select Text
  • Modify Text
  • Find and Replace Text
  • Apply Character Formatting
  • Align Text Using Tabs
  • Display Text as List Items
  • Control Paragraph Layout
  • Apply Borders and Shading
  • Apply Styles
  • Manage Formatting
  • Insert a Table
  • Modify a Table
  • Format a Table
  • Convert Text to a Table
  • Sort a List
  • Renumber a List
  • Customize a List
  • Insert Symbols and Special Characters
  • Add Images to a Document
  • Apply a Page Border and Color
  • Add a Watermark
  • Add Headers and Footers
  • Control Page Layout
  • Check Spelling and Grammar
  • Other Proofing Tools
  • Check Accessibility
  • Customize the Word Interface
  • Additional Save Options
  • Manage Additional File Types
  • Activities – Microsoft Word 2016 for Beginners

Microsoft Excel
  • Identify the Elements of the Excel Interface
  • Activity – Identify the Elements of the Excel Interface
  • Create a Basic Worksheet
  • Activity – Create a Basic Worksheet
  • Use the Help System
  • Activity – Use the Help System
  • Create Formulas in a Worksheet
  • Activity – Create Formulas in a Worksheet
  • Insert Functions in a Worksheet
  • Activity – Insert Functions in a Worksheet
  • Reuse Formulas
  • Activity – Reuse Formulas
  • Manipulate Data
  • Activity – Manipulate Data
  • Insert, Manipulate, and Delete Cells, Columns, and Rows
  • Activity – Insert, Manipulate, and Delete Cells, Columns, and Rows
  • Search For and Replace Data
  • Activity – Search For and Replace Data
  • Spell Check a Worksheet
  • Activity – Spell Check a Worksheet
  • Modify Fonts
  • Activity – Modify Fonts
  • Add Borders and Colors to Cells
  • Activity – Add Borders and Colors to Cells
  • Apply Number Formats
  • Activity – Apply Number Formats
  • Align Cell Contents
  • Activity – Align Cell Contents
  • Apply Cell Styles
  • Activity – Apply Cell Styles
  • Define the Basic Page Layout for a Workbook
  • Activity – Define the Basic Page Layout for a Workbook
  • Refine the Page Layout and Apply Print Options
  • Activity – Refine the Page Layout and Apply Print Options
  • Format Worksheet Tabs
  • Activity – Format Worksheet Tabs
  • Manage Worksheets
  • Activity – Manage Worksheets
  • Manage the View of Worksheets and Workbooks
  • Activity – Manage the View of Worksheets and Workbooks
  • Customize General and Language Options
  • Activity – Customize General and Language Options
  • Customize Formula Options
  • Activity – Customize Formula Options
  • Customize Proofing and Save Options
  • Activity – Customize Proofing and Save Options
  • Customize the Ribbon and Quick Access Toolbar
  • Activity – Customize the Ribbon and Quick Access Toolbar
  • Customize the Functionality of Excel by Enabling Add-Ins
  • Activity – Customize the Functionality of Excel by Enabling Add-Ins
  • Customize Advanced and Trust Center Options
  • Activity – Customize Advanced and Trust Center Options
  • Activities and Exercise Files – Microsoft Excel 2016 for Beginners
Microsoft PowerPoint
  • Navigate the PowerPoint Environment
  • ACTIVITY – NAVIGATING THE POWERPOINT 2016 USER INTERFACE
  • Create and Save a PowerPoint Presentation
  • ACTIVITY – CREATING AND SAVING A POWERPOINT PRESENTATION
  • Use Help
  • ACTIVITY – USING POWERPOINT HELP
  • Select a Presentation Type
  • ACTIVITY – SELECTING A PRESENTATION TYPE
  • Build a Presentation
  • ACTIVITY – BUILDING A PRESENTATION
  • Lay Out a Presentation
  • ACTIVITY – LAYING OUT A PRESENTATION
  • Edit Text
  • ACTIVITY – EDITING TEXT
  • View and Navigate a Presentation
  • ACTIVITY – VIEWING A PRESENTATION
  • Format Characters
  • ACTIVITY – FORMATTING CHARACTERS
  • Format Paragraphs
  • ACTIVITY – FORMATTING PARAGRAPHS
  • Format Text Boxes
  • ACTIVITY – FORMATTING TEXT BOXES
  • Insert Images
  • ACTIVITY – INSERTING IMAGES
  • Insert Shapes
  • ACTIVITY – INSERTING SHAPES
  • Insert WordArt
  • ACTIVITY – INSERT WORDART
  • Edit Objects
  • ACTIVITY – EDITING OBJECTS
  • Format Objects
  • ACTIVITY – FORMATTING OBJECTS
  • Group Objects
  • ACTIVITY – GROUPING OBJECTS
  • Arrange Objects
  • ACTIVITY – ARRANGING OBJECTS
  • Animate Objects
  • ACTIVITY – ANIMATING OBJECTS
  • Create a Table
  • ACTIVITY – CREATING A TABLE
  • Format a Table
  • ACTIVITY – FORMATTING A TABLE
  • Insert a Table from Other Microsoft Office Applications
  • ACTIVITY – INSERTING A TABLE FROM MICROSOFT EXCEL
  • Create a Chart
  • ACTIVITY – CREATING A CHART
  • Format a Chart
  • ACTIVITY – FORMATTING A CHART
  • Manipulate a Chart
  • ACTIVITY – MANIPULATING A CHART
  • Insert a Chart from Microsoft Excel
  • ACTIVITY – INSERTING A CHART FROM MICROSOFT EXCEL
  • Review Your Presentation
  • ACTIVITY – REVIEWING YOUR PRESENTATION
  • Apply Transitions
  • ACTIVITY – APPLYING TRANSITIONS
  • Print Your Presentation
  • ACTIVITY – PRINTING YOUR PRESENTATION
  • Deliver Your Presentation
  • ACTIVITY – DELIVERING YOUR PRESENTATION
  • Activities – Microsoft PowerPoint 2016 for Beginners

Microsoft Outlook
  • Navigate the Outlook Interface
  • ACTIVITY – NAVIGATING THE OUTLOOK INTERFACE
  • Perform Basic E-mail Functions
  • ACTIVITY – PERFORMING BASIC E-MAIL FUNCTIONS
  • Use Outlook Help
  • ACTIVITY – GETTING HELP IN MICROSOFT OUTLOOK 2016
  • Create an E-mail Message
  • ACTIVITY – CREATING AN E-MAIL MESSAGE
  • Check Spelling and Grammar
  • ACTIVITY – CHECK SPELLING AND GRAMMAR
  • Format Message Content
  • ACTIVITY – FORMAT MESSAGE CONTENT
  • Attach Files and Items
  • ACTIVITY – ATTACHING A FILE TO A MESSAGE
  • Enhance an E-mail Message
  • ACTIVITY – ENHANCING AN E-MAIL MESSAGE
  • Manage Automatic Message Content
  • ACTIVITY – MANAGING AUTOMATIC MESSAGE CONTENT
  • Customize Reading Options
  • ACTIVITY – CUSTOMIZING READING OPTIONS
  • Work with Attachments
  • ACTIVITY – WORKING WITH ATTACHMENTS
  • Manage Your Message Responses
  • ACTIVITY – MANAGING YOUR MESSAGE RESPONSES
  • Manage Messages Using Tags, Flags, and Other Commands
  • ACTIVITY – MANAGING MESSAGES USING TAGS, FLAGS AND OTHER COMMANDS
  • Organize Messages Using Folders
  • ACTIVITY – ORGANIZING MESSAGES USING FOLDERS
  • View the Calendar
  • ACTIVITY – CUSTOMIZING YOUR CALENDAR VIEW
  • Manage Appointments
  • ACTIVITY – MANAGING APPOINTMENTS
  • Manage Meetings
  • ACTIVITY – CREATING AND MANAGING MEETINGS
  • Print Your Calendar
  • ACTIVITY – PRINTING YOUR CALENDAR
  • Create and Update Contacts
  • ACTIVITY – CREATING AND UPDATING CONTACTS
  • View and Organize Contacts
  • ACTIVITY – VIEW AND ORGANIZE CONTACTS
  • Create Tasks
  • ACTIVITY – CREATING TASKS
  • Manage Tasks
  • ACTIVITY – MANAGING TASKS
  • Manage Notes
  • ACTIVITY – CREATING AND MANAGING NOTES
  • Customize the Outlook Interface
  • ACTIVITY – CUSTOMIZING THE OUTLOOK INTERFACE
  • Create and Manage Quick Steps
  • ACTIVITY – CREATING AND MANAGING QUICK STEPS
  • Activities – Microsoft Outlook 2016 for Beginners

Microsoft Access
  • Orientation to Microsoft Access
  • Create a Simple Access Database
  • Get Help in Microsoft Access
  • Modify Table Data
  • Working With Records
  • Sort and Filter Records
  • Create Lookups
  • Join Data from Different Tables in a Query
  • Sort and Filter Data in a Query
  • Perform Calculations in a Query
  • Create Parameter Queries
  • Create Action Queries
  • Create Find Duplicate and Find Unmatched Queries
  • Summarize Data
  • Create a Report
  • Add Controls to a Report
  • Enhance the Appearance of a Report
  • The Access Options Dialog Box
  • Create a Table
  • Modify a Table and Fields
  • Create Table Relationships
  • Create Query Joins
  • Join Tables That Have No Common Fields
  • Relate Data within a Table
  • Work with Subdatasheets
  • Create Subqueries
  • Data Normalization
  • Create a Junction Table
  • Import Data into Access
  • Export Data to Text File Formats
  • Export Access Data to Excel
  • Create a Mail Merge
  • Organize Report Information
  • Format Reports
  • Include Charts in a Report
  • Add a Calculated Field to a Report
  • Add a Subreport to an Existing Report
  • Create a Mailing Label Report
  • Publish a Report as PDF
  • Activities – Microsoft Access 2016 for Beginners

Word Templates
  • Word Templates

Excel Templates
  • Excel Templates

PowerPoint Templates
  • PowerPoint Templates

Mock Exam
Final Exam

See related categories

Complete Microsoft Office Bundle

£ 425 VAT inc.