One Education

Complete Microsoft Office Bundle

One Education
Online

492 
*Orientierungspreis
Originalpreis in GBP:
£ 425

Wichtige informationen

Tipologie Kurs
Niveau Advanced
Methodologie Online
Dauer 12 Months
Beginn nach Wahl
Beratungsservice Ja
Virtueller Unterricht Ja
  • Kurs
  • Advanced
  • Online
  • Dauer:
    12 Months
  • Beginn:
    nach Wahl
  • Beratungsservice
  • Virtueller Unterricht
Beschreibung

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.

Wichtige informationen
Welche Ziele verfolgt der Kurs?

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.

Voraussetzungen: 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.

Einrichtungen (1)
Wo und wann
Beginn Lage
nach Wahl
Online
Beginn nach Wahl
Lage
Online

Was lernen Sie in diesem Kurs?

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

Themenkreis

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