Mouse Training London Ltd: Training Courses Excel 0218

For Further Course Details Visit Our Homepage

Microsoft Accredited IT Training Provider

Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators

Microsoft MOS Test Centre London

Courses Microsoft Excel VBA Introduction 2 - Day Training Course

Audience: This course is aimed at experienced Excel users who want to automate repetitive tasks or simplify more complex tasks using VBA macros to save huge amounts of time every day. You can learn the elements of the Excel object model and control their automation using simple VBA control structures.

Course Duration: 2 day

All Vouchers now include a Retake Voucher

Option 1 - Voucher & Retake

Option 2 - Voucher, Retake and Gmetrix ( Test Prep )

Option 3 - Exam Pack includes - Voucher, Retake, Gmetrix and Exam study manual

Discount 4 for 3 on MOS Exam Packs

Mouse Training Course Index

Tailored course content can be customised to meet your specific requirements, with scheduled dates to suit you.

Course Location: This Microsoft Excel VBA Introduction Training Course is delivered at our training centres in London Venues; training can also be delivered at your offices.

At Course Completion:

After completing this course, students will be able to:

Use the macro recorder
Understand the Visual Basic Editor
Develop Procedures
Manage the Flow of Control using control structures
Debug procedures
Understand the Excel Object Model
Declare and set the data type of variables
Create User Defined Functions
Write Error Handling routines
Use Message Boxes and Input Boxes

Microsoft Excel VBA Introduction 2 - Day

For Further Course Details Visit Our Homepage

Microsoft Accredited IT Training Provider

Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators

Microsoft MOS Test Centre London

Saturday, 8 July 2017

Courses Microsoft Financial Modelling Course

Audience: This Financial Modelling course is designed for those looking to develop the Excel skills required to be able to create robust and professional financial models. A forecast and integrated set of financial statements are created from first principles based on published historic data.

Course Duration: 1 day

All Vouchers now include a Retake Voucher

Option 1 - Voucher & Retake

Option 2 - Voucher, Retake and Gmetrix ( Test Prep )

Option 3 - Exam Pack includes - Voucher, Retake, Gmetrix and Exam study manual

Discount 4 for 3 on MOS Exam Packs

Tailored course content can be customised to meet your specific requirements, with scheduled dates to suit you.

Course Location: This Microsoft Excel Financial Modelling Course is delivered at our training centres in London Venues; training can also be delivered at your offices.

At Course Completion:

After completing this course, students will be able to

Understand essential financial mathematics
Use essential Excel Functions
Store key constants and references in Names
Produce consistent formatting using Styles
Use Conditional Formatting
Audit worksheet formulas
Include Data Validation for data entry
Protect the model
Plan the model
Create basic Financial Statements
Set up a financial model

Detailed Outline

Microsoft Excel Financial Modelling

For Further Course Details Visit Our Homepage

Microsoft Accredited IT Training Provider

Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators

Microsoft MOS Test Centre London

Tuesday, 23 May 2017

Courses - Microsoft Excel 2016 Power Pivot and Power View Training Course

Audience: This Microsoft Excel 2016 Power Pivot and Power View Training Course is designed for those looking to use the key functionality of applications from the Microsoft Windows and Microsoft Office Suite. No prior knowledge is required.

Course Duration: 1-Day

Course Types: Group Bookings, Public Scheduled Courses, 1-2-1 Sessions, Bespoke Tailored Courses and Saturday Club.

Course Location: Microsoft Excel 2016 Power Pivot and Power View Training Course is delivered at our training centres our London Venues; training can also be delivered at your offices.

Tailored course content can be customised to meet your specific requirements, with scheduled dates to suit you.

Course Duration: 1-Day

Group Rate: £ 695 + VAT

1-2-1 Rate £ 450 + VAT

Saver Discount 3 for 2 on all public courses.

MOS Excel Specialist / Expert Exam Costs ( optional )

New Prices from 19th February 2018

All Vouchers now include a Retake Voucher

Option 1 - Voucher & Retake

Option 2 - Voucher, Retake and Gmetrix ( Test Prep )

Option 3 - Exam Pack includes - Voucher, Retake, Gmetrix and Exam study manual

Discount 4 for 3 on MOS Exam Packs

At Course Completion

After completing this course, students will be able to:

Navigate the Power Pivot window
Specify source data for Power Pivot
Preparing data for analysis
Format data
Create Power Pivot Relationships
Enter Power Pivot Calculations using DAX
Create Key Performance Indicators (KPI's)
Visualise data using Power View
Create Power View Charts and Maps

Detailed Course Outline

Microsoft Excel 2013 Power Pivot and Power View

Microsoft Excel 2016 Power Pivot and Power View

Charis Alexandra Training Course Index

Contact Email

For Further Course Details Visit Our Homepage

Microsoft Accredited IT Training Provider

Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators

Microsoft MOS Test Centre London

Tuesday, 28 March 2017

Courses Microsoft Excel Functions Course in London

Audience: Excel Functions are the backbone of most Excel worksheets but with nearly 500 worksheet functions in Excel how can you possibly learn them all? The answer is to learn the important ones. The Excel functions course is devised to give you a broad skill set covering the primary categories of Excel functions

Course Duration: 1 day

Course Types: Group Bookings, Public Scheduled Courses, 1-2-1 Sessions, Bespoke Tailored Courses and Saturday Club.

Course Costs:

Public Courses : £125 +VAT Next Scheduled Course Please call for details
Group Rate: £ 695 + VAT
1-2-1 Rate £ 450 + VAT
Saver Discount 3 for 2 on all public courses.

MOS Excel Specialist / Expert Exam Costs ( optional )

New Prices from 19th February 2018

All Vouchers now include a Retake Voucher

Option 1 - Voucher & Retake

Option 2 - Voucher, Retake and Gmetrix ( Test Prep )

Option 3 - Exam Pack includes - Voucher, Retake, Gmetrix and Exam study manual

Discount 4 for 3 on MOS Exam Packs

Course Location: This Microsoft Excel Functions Course is delivered at our training centres our London Venues; training can also be delivered at your offices.

Tailored course content can be customised to meet your specific requirements, with scheduled dates to suit you.

At Course Completion

After completing this course, students will be able to use:

Text formulas and functions such as TRIM
Aggregation functions such as SUMIFS
Decision making functions such as IF and IFERROR
Date and Time such as TODAY and NETWORKDAYS
Lookup and Reference functions such as VLOOKUP
Magnitude functions such as MAX, LARGE and RANK
Information functions such as CELL and ISNA

Detailed Course Outline

Microsoft Excel Functions

For Further Course Details Visit Our Homepage

Microsoft Accredited IT Training Provider

Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators

Microsoft MOS Test Centre London

Courses Microsoft Excel 2016 DAX Formulas for Power Pivot

Audience: This course is designed for those who need to create formulas using the Data Analysis Expressions language (DAX) to analyse Power Pivot data. Many of the functions are similar to Excel’s but it is vital that you understand the evaluation context.

Course Duration: Half day module to be combined with any other half day module in the Microsoft Office Suite.

All Vouchers now include a Retake Voucher

Option 1 - Voucher & Retake

Option 2 - Voucher, Retake and Gmetrix ( Test Prep )

Option 3 - Exam Pack includes - Voucher, Retake, Gmetrix and Exam study manual

Discount 4 for 3 on MOS Exam Packs

Course Location: This Microsoft Excel 2016 Microsoft Excel DAX Formulas for Power Pivot Course is delivered at our training centres our London Venues; training can also be delivered at your offices.

Tailored course content can be customised to meet your specific requirements, with scheduled dates to suit you.

At Course Completion

After completing this course, students will be able to:

Write and understand DAX formulas
Use DAX Aggregate functions
Understand the DAX evaluation context
Use DAX Date and Time functions
Use DAX Text functions
Use DAX Mathematical functions
Use DAX Time Intelligence functions

Detailed Course Outlines

Excel 2010 DAX Formulas for Power Pivot

Excel 2013 DAX Formulas for Power Pivot

Excel2016 DAX Formulas for Power Pivot

Charis Alexandra Training Course Index

Contact Email

For Further Course Details Visit Our Homepage

Microsoft Accredited IT Training Provider

Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators

Microsoft MOS Test Centre London

Courses Microsoft Pivot Table Course in London

Microsoft Excel Pivot Table

Audience: For Excel users who need an overview of the power of Pivot Tables. Excel Pivot Tables give you the power to analyse raw data stored in worksheets with ease. If you only know how to do aggregate calculations with functions like SUMIF then you are missing out on a major element of Excel

Course Duration: Half day module to be combined with any other half day module in the Microsoft Office Suite.

All Vouchers now include a Retake Voucher

Option 1 - Voucher & Retake

Option 2 - Voucher, Retake and Gmetrix ( Test Prep )

Option 3 - Exam Pack includes - Voucher, Retake, Gmetrix and Exam study manual

Discount 4 for 3 on MOS Exam Packs

Course Location: This Microsoft Excel Pivot Tables Course is delivered at our training centres our London Venues; training can also be delivered at your offices.

Tailored course content can be customised to meet your specific requirements, with scheduled dates to suit you.

At Course Completion

After completing this course, students will be able to:

Create Pivot Tables
Perform Pivot Table calculations
Present Pivot Table Data
Deal with Pivot Table Source data

Detailed Course outline

Microsoft Excel Pivot Tables

Charis Alexandra Training Course Index

For Further Course Details Visit Our Homepage

Microsoft Accredited IT Training Provider

Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators

Microsoft MOS Test Centre London

Courses Microsoft Financial Modelling Course in London

Audience: Those needing the fundamental Excel skills required to create robust and professional financial models. A forecast integrated set of financial statements is created from first principles based on published historic data.

Course Duration: 1 day

All Vouchers now include a Retake Voucher

Option 1 - Voucher & Retake

Option 2 - Voucher, Retake and Gmetrix ( Test Prep )

Option 3 - Exam Pack includes - Voucher, Retake, Gmetrix and Exam study manual

Discount 4 for 3 on MOS Exam Packs