Microsoft Office Training Limited courses

...Browser Using the With Statement Working with Properties Working with Methods Creating an Event Procedure Reserved Macro Names Using Expressions... Learn about: Visual Basic training, Microsoft Excel, Calculated columns...

...Relative and Mixed references Using Excel functions; Sum, Average, Max and Min Cell Formatting Font Format options Number Format options Change the... Learn about: Excel Tables, Excel Formulas, Date Functions...

...the workbook Advanced Formulas Simple IF examples Using IF to check if a cell is blank Nested IFs VLOOKUP HLOOKUP PMT financial Function Database Functions... Learn about: Calculated columns, Database training, Excel Formulas...

...position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline... Learn about: MS Excel, Converting Tables, Text Functions...

...Working with worksheets Worksheet navigation Select one or multiple Worksheets Insert, Move, Copy or Delete a Worksheet Working with Cells, Rows & Columns... Learn about: Quick Analysis, MS Excel, Excel Tables...

...Rows and Columns Delete a table Graphics Working with Clipart, and Shapes Selecting objects, shapes, pictures or text boxes Arrange a picture... Learn about: Ms PowerPoint, Print slides, Microsoft Powerpoint...

...At the end of this course you will be able to: Modify the PowerPoint environment Using Master View in order to customise a design template Add and customize... Learn about: Slide Design, Print slides, Text and Objects...

...of the Word Interface Create a Word Document Help Editing a Document Navigate and Select Text Modify Text Find and Replace Text Formatting Text and Paragraphs... Learn about: Word Interface, Proofing Tools, Insert a Table...

...Integrate Pictures and Text Insert and Format Screenshots Use the Snipping tool Creating Custom Graphic Elements Create Text Boxes and Pull Quotes... Learn about: Proofing Tools, Microsoft Word, Insert a Table...

...Restrictions Add a Digital Signature to a Document Restrict Document Access Forms Create Forms Manipulate Forms... Learn about: Paragraph Layout, Manage Formatting, Word Interface...

...Constraints and Deadlines to Tasks Create Recurring Activities Adding Notes and links to Tasks Managing Resources Exploring the Entry Table and its fields... Learn about: Project Plan, Microsoft Project, Automatic Scheduling...

...Export Project Plan Cost Data into Excel Save Project Plan Information as a Web Page Updating a Project Plan Enter Task Progress Information View... Learn about: Automatic Scheduling, Project Baseline, Grouping Tasks...

...Relationship types Referential Integrity Working with table subdatasheets Querying a database Creating simple Select Queries Specifying query criteria... Learn about: Microsoft Access, Designing Forms, Deleting records...

...Assign Macros to Events Extending Data Reach Import Data Export Data Work with Linked Tables Managing Databases Object Dependencies Database Documenter... Learn about: Database training, Microsoft Access, Regular Management...

...Manage Appointments Manage Meetings Print Your Calendar Managing Your Contacts Create and Update Contacts View and Organise Contacts Working With Tasks... Learn about: Manage meetings, Email Functions...

...Calendar Management Manage Advanced Calendar Options Create Calendar Groups Manage Meeting Responses Advanced Contact Management Edit an Electronic Business... Learn about: Manage meetings, Email Functions...

...We are a training company with more than 20 years experience of delivering a variety of courses that cover all the apps of the Microsoft Office software... Learn about: Visio Interface, Basic Diagram, Microsoft Visio...

...a Visio Drawing to Other Applications Convert a Visio Drawing to a Web Page Print a Visio Drawing... Learn about: Manipulate Shapes, Microsoft Visio, Visio Interface...

...between those different datasets, Query the data using Shaping and data Modelling, and to create Visualizations, and publish Reports to different platforms... Learn about: Excel data, Transformation Tools, MS Excel...

...Using the Calendar Shared Calendars Outlook Tasks in the Web App Setting Outlook Options, Signatures, Automatic Replies and Rules Using Skype for Business... Learn about: Ms Office, Content Sharing, Microsoft Office...