Microsoft Office Training Limited courses

...Variables and Intrinsic Functions Understanding Expressions and Statements Declaring Variables Understanding Data Types Determining the Value of Variables... Learn about: Text Functions, Visual Basic training, Microsoft excel training...

...This course aims to provide delegates with a foundation for Excel knowledge and skills. The introduction course will give you the basics that you... Learn about: MS Excel, Quick Analysis, 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: Text Functions, Calculated columns, Database training...

...to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros... Learn about: MS Excel, Excel Tables, 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: Microsoft Excel, Calculated columns, Text Functions...

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

...SmartArt graphics Add animations and change its effect options Add action buttons to control the flow of the presentation Use various options to customise... Learn about: Print slides, Microsoft Powerpoint, Ms PowerPoint...

...At the end of this course you will be able to: Edit text in a Word document Modify the appearance of text in a Word document Organise data in tables... Learn about: Insert a Table, Proofing Tools, Manage Formatting...

...At the end of this course you will be able to: Customise tables and charts Customise formatting with styles and themes Modify pictures in a document Create... Learn about: Insert a Table, Proofing Tools, Microsoft Word...

...At the end of this course you will be able to: Collaborate on documents Add reference marks and notes Make long documents easier to use Secure a document Work with forms... Learn about: Ms Word, Select Text, Manage Formatting...

...schedule Use different views to analyse the project plan Create, allocate and manage resources in a project plan Finalise a project plan Track progress... Learn about: Automatic Scheduling, Grouping Tasks, Project Plan...

...Print a Custom Report Re-using Project Plan Information Create a Project Plan Template Create a Custom Combination View Make Custom Views Available... Learn about: Grouping Tasks, Microsoft Project, Project Plan...

...table data Entering and editing data Sorting and filtering table records Deleting records Relationships Why use table relationships? Relationship types... Learn about: Database training, Deleting records, Designing Forms...

...Table Properties Advanced Query Design Advanced Naming Conventions Join Tables in Queries Manage Query Joins Use Self-Joins in Queries Summarise Data... Learn about: Database training, Microsoft Access, Import Data...

...At the end of this course you will be able to: Understand the Outlook interface Send and receive email messages Organise email messages Manage their calendar... Learn about: Manage meetings, Email Functions...

...Card Manage Advanced Contacts Options Forward Contacts Export Contacts Managing Activities by Using Tasks and Journal Entries Assign and Manage Tasks Record... Learn about: Email Functions, Manage meetings...

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

...Plan Create an Office Layout Work with Layers Representing External Data in Visio Generate a PivotDiagram (Visio Professional edition only) Create an Organization... Learn about: Visio Interface, Microsoft Visio, Office IT...

...From Examples Grouping and Aggregating data Pivoting and Unpivoting Using filters Modeling the data Introduction to modeling your data How to manage... Learn about: Simple visualizations, Power BI, MS Excel...

...efficiently use Office 365 on a day-to-day basis. The course is designed with real world scenarios in mind. Delegates will learn how to use Outlook Online... Learn about: Ms Office, Microsoft Office, Office IT...