Microsoft Office Mastery

Course details

• Excel 2016
• Getting Started with Microsoft Office Excel 2016
• Navigate the Excel User Interface
• Use Excel Commands
• Create and Save a Basic Workbook
• Enter Cell Data
• Use Excel Help
• Performing Calculations
• Create Worksheet Formulas
• Insert Functions
• Reuse Formulas and Functions
• Modifying a Worksheet
• Insert, Delete, and Adjust Cells, Columns, and Rows
• Search for and Replace Data
• Use Proofing and Research Tools
• Formatting a Worksheet
• Apply Text Formats
• Apply Number Format
• Align Cell Contents
• Apply Styles and Themes
• Apply Basic Conditional Formatting
• Create and Use TemplatesPrinting Workbooks
• Preview and Print a Workbook
• Set Up the Page Layout
• Configure Headers and Footers
• Managing Workbooks
• Manage Worksheets
• Manage Workbook and Worksheet Views
• Manage Workbook Properties
• Word 2016
• Getting Started with Word
• Navigate in Microsoft Word
• Create and Save Word Documents
• Manage Your Workspace
• Edit Documents
• Preview and Print Documents
• Customize the Word Environment
• Formatting Text and Paragraphs
• Apply Character Formatting
• Control Paragraph Layout
• Align Text Using Tabs
• Display Text in Bulleted or Numbered Lists
• Apply Borders and Shading
• Working More Efficiently
• Make Repetitive Edits
• Apply Repetitive Formatting
• Use Styles to Streamline Repetitive Formatting Tasks
• Managing Lists
• Sort a List
• Format a List
• Adding Tables
• Insert a Table
• Modify a Table
• Format a Table
• Convert Text to a Table
• Inserting Graphics Objects
• Insert Symbols and Special Characters
• Add Images to a Document
• Controlling Page Appearance
• Apply a Page Border and Color
• Add Headers and Footers
• Control Page Layout
• Add a Watermark
• Preparing to Publish a Document
• Check Spelling Grammar and Readability
• Use Research Tools
• Check Accessibility
• Save a Document to Other Formats
• Workbooks - Microsoft Word 2016 (Beginner)
• PowerPoint 2016
• PowerPoint Interface
• Navigate the PowerPoint Environment
• View and Navigate a Presentation
• Create and Save a PowerPoint Presentation
• Use PowerPoint Help
• Presentation Basics
• Select a Presentation Type
• Edit Text
• Build a Presentation
• Formatting
• Format Characters
• Format Paragraphs
• Format Text Boxes
• Inserting Options
• Insert Images
• Insert Shapes
• Working with Objects
• Edit Objects
• Format Objects
• Group Objects
• Arrange Objects
• Animate Objects
• Table
• Create a Table
• Insert a Table from Other Microsoft Office Applications
• Charts
• Create a Chart
• Format a Chart
• Insert a Chart from Microsoft Excel
• Review and Presentation
• Review Your Presentation
• Apply Transitions
• Print Your Presentation
• Deliver Your Presentation
• Access 2016
• Introduction to Access
• Orientation to Microsoft Access
• Create a Simple Access Database
• Get Help and Configure Options in Microsoft Access
• Modify Data
• Modify Table Data
• Sort and Filter Records
• Working with Queries
• Create Basic Queries
• Sort and Filter Data in a Query
• Perform Calculations in a Query
• Access Forms
• Create Basic Access Forms
• Work with Data on Access Forms
• Working with Reports
• Create a Report
• Add Controls to a Report
• Enhance the Appearance of a Report
• Prepare a Report for Print
• Organize Report Information
• Format Reports

• Unlimited access to the course for a lifetime.
• Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course.
• Structured lesson planning in line with industry standards.
• Immerse yourself in innovative and captivating course materials and activities.
• Assessments are designed to evaluate advanced cognitive abilities and skill proficiency.
• Flexibility to complete the Microsoft Office Course at your own pace, on your own schedule.
• Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience.