Category: PA & Secretary Courses

Name: Excel Intermediate
Start: 2019-8-21T09-09-15-00
End: 2019-8-21T16-16-30-00
Location: Slough

Secretaries PA’s How to Improve your Productivity

5 WAYS BY WHICH SECRETARIES CAN INCREASE THEIR PRODUCTIVITY In the running of an organization, a secretary is an essential part of the workforce. The role a secretary plays is vital to the success of any organization; small, medium or large organization. A secretary is an exciting career path with lots of opportunities. You would […]

28th February 2019 | By Taylor Mason More

Skills of a Secretary PA

Skills of a Secretary If you’re looking for wоrk as a personal assistant, certain skills will serve you wеll. Thе good news is that many can be learned and perfected. Read on for the key skills уоu’ll need to be a great personal assistant. Organisation Make sure your bоѕѕ hаѕ аll his/her papers, […]

4th July 2017 | By Taylor Mason | Reply More

Benefits of Taking Executive PA Training Courses

Benefits of Taking Executive PA Training Courses In most professions, it often becomes necessary to advance your professional skills in order to stay relevant in your industry. Taking executive PA training courses may help a personal assistant advance in their career by giving them several options to choose from in terms of industries and companies. […]

27th May 2016 | By Taylor Mason | Reply More

Executive PA Training Course

Executive PA Training Course An executive personal assistant is the right hand of the CEO. Assistants have been credited to contributing at least 40% of their boss’ success due to proper management and communication skills. It is necessary for personal assistants in the industry to take up Executive PA training courses at Taylor Mason Training […]

24th May 2016 | By Taylor Mason | Reply More

Upcoming Public Training Courses

Course Type

Course Type & location

Course Location

august

wed21aug9:15 am4:30 pmExcel IntermediateLearn more about Microsoft Excel9:15 am - 4:30 pm Slough, 268 Bath Road Slough Berkshire SL1 4DX Training Course Price : £295

To book your course simply click add to cart & checkout

Excel Intermediate London

Book Online Now!

Price £295.00

Inquire before you Buy

Training Course Price

£295

Training Course Detials

CPD CERTIFIED COURSE

Note: this Excel Intermediate course is CPD certified.
This means that not only has it been rigorously assessed in terms of content and quality, but it comes with a FREE CPD Certification certificate.

COURSE OUTLINE

Full details of modules and topics covered in this one-day course

VERSIONS COVERED

This course covers 2007, 2010, 2013 and 2016 versions

DURATION

This is a one-day training course structured into 6 modules

COURSE AIMS

This hands-on one-day training course has been designed to give delegates a solid understanding of more advanced tools and concepts used in Excel 2007, 2010, 2013 or 2016, in order to increase their knowledge and productivity.

TARGET AUDIENCE

Users with a basic understanding of Microsoft Excel 2007, 2010, 2013 or 2016 who want to take their knowledge of the basic features further in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction course.

MODULE 1: Advanced File Tasks

Learning outcomes:

A look at some important administrative features which are useful for managing and controlling Excel files.

Topics covered:

Saving and File Management
Converting and Encrypting Files
File Properties and Digital Signatures
File Accessibility and Compatibility

MODULE 2: Working with Functions and Formulas

Learning outcomes:

Some key formulas and functions essential to Excel users along with features to help manage formulas, functions and ranges.

Topics covered:

Autosum Functions (SUM & AVERAGE)
IF and Nested Functions
Working with Named Ranges
Array Functions (SUMIF & AVERAGEIF)
Formula Auditing
Formulas with Absolute References
Text Functions

MODULE 3: Managing Tables in Microsoft Excel

Learning outcomes:

Managing spreadsheet data in table format, an excellent feature to administrate large sets of data.

Topics covered:

Creating Excel Tables
Working with Records and Filters
Advanced Filters

MODULE 4: Data Tools in Excel

Learning outcomes:

Features to help with managing spreadsheet data making it a less daunting and repetitive task to manage the data.

Topics covered:

Text to Columns
Flash Fill
Remove Duplicates
Data Validation
Consolidate

MODULE 5: Doing More with Charts in Excel

Learning outcomes:

Developing your ability to effectively create charts and format them specific to the reader

Topics covered:

Trendlines
Error Bars
Working with Axis Options
Advanced Chart Formatting

MODULE 6: Sparklines

Learning outcomes:

Use Sparklines to help analyse data by creating small customisable charts within cells. Edit and format the Sparklines and data points to help your data stand out

Topics covered:

Creating Sparklines
Editing Sparklines

Time

(Wednesday) 9:15 am - 4:30 pm

Location

Slough

268 Bath Road Slough Berkshire SL1 4DX

Other course dates at this location

18th september 2019 9:15 am

Organiser

Taylor MasonTraining for the Workplace & Individuals0843 289 1713 PO Box 3125 450 Brook Drive Reading RG1 9RX

Calendar GoogleCal

thu22aug9:15 am4:30 pmExcel Advanced TrainingLearn advanced Excel tools and concepts9:15 am - 4:30 pm Slough, 268 Bath Road Slough Berkshire SL1 4DX Training Course Price : £295

To book your course simply click add to cart & checkout

Book Online Now!

Book On Line Now!

Price £295.00

Training Course Price

£295

Training Course Detials

DURATION

This is a one-day training course structured into 7 modules

COURSE AIMS

This intensive hands-on one-day training course has been designed to provide delegates with a solid understanding of advanced Excel 2007, 2010, 2013 or 2016 tools and concepts in order to increase their knowledge and productivity.

TARGET AUDIENCE

Users with a good understanding of Microsoft Excel 2007, 2010, 2013 or 2016 who want to expand on their capabilities in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction and Intermediate courses.

MODULE 1: Grouping & Outlining and Subtotals

Learning outcomes:

Useful Excel functions to summarise a spreadsheet making the data easier to identify and explain.

Topics covered:

Outlining and Grouping Data
Using the Subtotals Tool

MODULE 2: What-If Analysis

Learning outcomes:

Tools designed to help with forecasting and finding solutions to complicated problems involving your spreadsheet’s data and formulas.

Topics covered:

Exploring Scenarios
Goal Seek and Data Tables
Using Solver

MODULE 3: PivotTables

Learning outcomes:

Creating Pivot Tables in order to display and summarise large quantities of data effectively.

Topics covered:

Getting Started with PivotTables
Displaying Data in a PivotTable
Formatting a PivotTable
Using the Classic PivotTable Layout
Slicers

MODULE 4: Charting Pivoted Data

Learning outcomes:

Introducing Pivot Charts, adding specialist pivot charts to the already excellent Pivot Table feature.

Topics covered:

Getting Started with PivotCharts
Using the PivotChart Tools Tabs
Formatting a PivotChart

MODULE 5: Advanced Excel Tasks

Learning outcomes:

Here we will look at sharing Excel files along with adding hyperlinks and Custom AutoFill Lists.

Topics covered:

Excel and Hyperlinks
Using Custom AutoFill Lists
Sharing Workbooks

MODULE 6: Creating HLOOKUP and VLOOKUP Functions

Learning outcomes:

Exploring the different Lookup functions, ideal add further functionality to a spreadsheet to reference particular data quickly and effectively.

Topics covered:

Using the VLOOKUP Function
Using the LOOKUP Function

MODULE 7: Introduction to Macros in Excel

Learning outcomes:

Explore how to create your own Macros and introducing Visual Basic for Applications, the application Macros are created in.

Topics covered:

Recording and Playing Macros
Copying and Deleting Macros
Visual Basic and Macros

Want to see other Excel course at other locations?

Time

(Thursday) 9:15 am - 4:30 pm

Location

Slough

268 Bath Road Slough Berkshire SL1 4DX

Calendar GoogleCal

thu22aug9:30 am4:30 pmExcel IntermediateLearn more about Microsoft Excel9:30 am - 4:30 pm London Victoria, 83 Victoria Street London SW1H 0HW Training Course Price : £295

To book your course simply click add to cart & checkout

Excel Intermediate London

Book Online Now!

Price £295.00

Inquire before you Buy

Training Course Price

£295

Training Course Detials

CPD CERTIFIED COURSE

COURSE OUTLINE

Full details of modules and topics covered in this one-day course

VERSIONS COVERED

This course covers 2007, 2010, 2013 and 2016 versions

DURATION

This is a one-day training course structured into 6 modules

COURSE AIMS

TARGET AUDIENCE

MODULE 1: Advanced File Tasks

Learning outcomes:

A look at some important administrative features which are useful for managing and controlling Excel files.

Topics covered:

Saving and File Management
Converting and Encrypting Files
File Properties and Digital Signatures
File Accessibility and Compatibility

MODULE 2: Working with Functions and Formulas

Learning outcomes:

Some key formulas and functions essential to Excel users along with features to help manage formulas, functions and ranges.

Topics covered:

Autosum Functions (SUM & AVERAGE)
IF and Nested Functions
Working with Named Ranges
Array Functions (SUMIF & AVERAGEIF)
Formula Auditing
Formulas with Absolute References
Text Functions

MODULE 3: Managing Tables in Microsoft Excel

Learning outcomes:

Managing spreadsheet data in table format, an excellent feature to administrate large sets of data.

Topics covered:

Creating Excel Tables
Working with Records and Filters
Advanced Filters

MODULE 4: Data Tools in Excel

Learning outcomes:

Features to help with managing spreadsheet data making it a less daunting and repetitive task to manage the data.

Topics covered:

Text to Columns
Flash Fill
Remove Duplicates
Data Validation
Consolidate

MODULE 5: Doing More with Charts in Excel

Learning outcomes:

Developing your ability to effectively create charts and format them specific to the reader

Topics covered:

Trendlines
Error Bars
Working with Axis Options
Advanced Chart Formatting

MODULE 6: Sparklines

Learning outcomes:

Use Sparklines to help analyse data by creating small customisable charts within cells. Edit and format the Sparklines and data points to help your data stand out

Topics covered:

Creating Sparklines
Editing Sparklines

Time

(Thursday) 9:30 am - 4:30 pm

Location

London Victoria

83 Victoria Street London SW1H 0HW

Organiser

Taylor MasonTraining for the Workplace & Individuals0843 289 1713 PO Box 3125 450 Brook Drive Reading RG1 9RX

Calendar GoogleCal

thu22aug9:30 pm4:30 pmRecruitment Interviewing Training CoursesThe best solution for Interview Training. 9:30 pm - 4:30 pm Manchester - Princess Street, Citibase Business Centre 40 Princess St Manchester M1 6DE Training Course Price : £350

To book your course simply click add to cart & checkout

Recruitment Interviewing Training Course

1-day Training Course

Price £350.00

Training Course Price

£350

Training Course Detials

Recruitment Interviewing

The best solution for Interview Training Courses

A hands-on one-day course with free pre-course online skills testing

COURSE OUTLINE

Full details of modules and topics covered in this one-day course

DURATION

This is a one-day training course structured into 13 modules

COURSE AIMS

This one-day workshop concentrates on defining the required skill sets, finding candidates, pre-interview preparation, developing questions and their value, and interview techniques that get specific, behaviour-based examples of past performance.

TARGET AUDIENCE

Managers and supervisors, present and aspiring, who want to become more effective in preparing, conducting and evaluating interviews.

MODULE 1: Introduction and Course Overview

Topics covered:

Learning Objectives

MODULE 2: Determining the Skills You Need

Topics covered:

Technical Skills

MODULE 3: Finding Candidates

Topics covered:

Types of Candidate Search
Alternative Methods

MODULE 4: Advertising Guidelines

Topics covered:

Five Key Points
Other Tips
Ten Tests for Advertising

MODULE 5: Screening CVs

Topics covered:

The Screening Process
Using the Screening Guide
Developing a Guide

MODULE 6: Interviewing Barriers

Topics covered:

Leniency or Stringency
Halo/Horn Effect
Error of Central Tendency
Stereotyping

MODULE 7: Non Verbal Communication

Topics covered:

Interpretation of Gestures
The Best Vacation

MODULE 8: Types of Questions

Topics covered:

Open Questions vs. Closed Questions
Probing

MODULE 9: Traditional vs Behavioural Interviews

Topics covered:

Traditional Interviews
Purpose of Behavioural Interviewing

MODULE 10: Listening for Answers

Topics covered:

Listening Problems
Active Listening

MODULE 11: Difficult Applicants

Topics covered:

Sample BDI Questions
Difficult Applicants

MODULE 12: Interview Preparation and Format

Topics covered:

Interview Preparation
The Interview Format
Before the Interview
During the Interview
Closing the Interview

MODULE 13: Your Personal Action Plan

Time

(Thursday) 9:30 pm - 4:30 pm

Location

Manchester - Princess Street

Citibase Business Centre 40 Princess St Manchester M1 6DE

Organiser

Taylor MasonTraining for the Workplace & Individuals0843 289 1713 PO Box 3125 450 Brook Drive Reading RG1 9RX

Calendar GoogleCal

Send this to a friend

Your emailRecipient email

Category: PA & Secretary Courses

Upcoming Public Training Courses

To book your course simply click add to cart & checkout

Training Course Price

Training Course Detials

Training Course Detials

Time

Location

Other course dates at this location

Organiser

To book your course simply click add to cart & checkout

Training Course Price

Training Course Detials

Training Course Detials

Time

Location

To book your course simply click add to cart & checkout

Training Course Price

Training Course Detials

Training Course Detials

Time

Organiser

To book your course simply click add to cart & checkout

Training Course Price

Training Course Detials

Training Course Detials

Recruitment Interviewing

The best solution for Interview Training Courses

Time

Organiser

Subscribe