Tag: minute taking courses

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

How to Write Meeting Minutes?

How to write meeting minutes? Everyone, who was at the business meeting, tried to take notes with ideas and thoughts. It is called the meeting minutes. Nine times out of ten these notes were illegible, important information was lost and we do not referred to these notes anymore. However, we still cannot underestimate the value […]

14th March 2019 | By Taylor Mason | Reply More

How To Take Minutes of a Meeting

How To Take Minutes Of A Meeting Meetings are one of the unavoidable processes of any event such as business, academic gathering etc. We’ve all arranged them, held them, attended them, and no doubt sometimes wished they didn’t exist. Without minutes being taken, they would be one of the least productive processes. At any given […]

18th June 2018 | By Taylor Mason | Reply More

Upcoming Public Training Courses

Course Type

Course Type & location

Course Location

august

tue20aug9:15 am4:30 pmEvent OverExcel IntroductionGet to grips with the main features of Microsoft Office Excel9:15 am - 4:30 pm GMT Slough, 268 Bath Road Slough Berkshire SL1 4DX Training Course Price : £295

To book your course simply click add to cart & checkout

Excel Introduction

Book Online Now!

Tickets are not available for sale any more for this course!

Training Course Price

£295

Training Course Detials

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 intensive one-day training course is designed to let users get to grips with the main features of Microsoft Office Excel 2007, 2010, 2013 or 2016, including a thorough treatment of the new ‘Ribbon’ interface, originally introduced with Excel 2007. It is entirely ‘hands on’, so those attending will get practice in creating and modifying actual spreadsheets.

TARGET AUDIENCE

The course is intended for new users of Microsoft Excel 2007, 2010, 2013 or 2016 who want to become productive in the shortest possible time. Delegates should be proficient in using a PC with the Microsoft Windows operating system, but no prior experience with Excel is required.

MODULE 1: Getting Started with Microsoft Excel

Learning outcomes:

Starting Excel and some of its basic navigation and help controls.

Topics covered:

Starting Out
About Workbooks
Exploring your Workbook
Getting Help with Excel

MODULE 2: The Excel Interface

Learning outcomes:

A look at the Ribbon interface and the different tabs and options the Ribbon offers.

Topics covered:

The Quick Access Toolbar and File Menu
The Home Tab
The Insert Tab
The Page Layout Tab
The Formulas Tab
The Data Tab
The Review Tab

MODULE 3: Microsoft Excel Basics

Learning outcomes:

Identify and Use Cells, Columns, Rows, Workbooks to enter and manage data.

Topics covered:

Working with Excel
Basic Excel Features
Moving your Data
Smart Tags and Options Buttons
Editing Tools

MODULE 4: Editing your Workbook

Learning outcomes:

Understanding formatting features and enhancing a workbook’s overall appearance and using Conditional Formatting.

Topics covered:

Cell Formatting
Conditional Formatting
Enhancing a Worksheet’s Appearance

MODULE 5: Printing and Viewing your Workbook

Learning outcomes:

Exploring Excel’s printing and viewing options enhancing your ability to print and work with your data effectively.

Topics covered:

Using the View Tab
Managing a Single Window
Managing Multiple Windows
Printing your Workbook
Print Page Layout options

MODULE 6: Working with Charts in Excel

Learning outcomes:

Introducing charts within Excel and explain how to create basic charts to help convey your data with.

Topics covered:

Using Recommended and Standard Charts
Chart Elements
Chart Tools – Design & Format

Time

(Tuesday) 9:15 am - 4:30 pm GMT

Location

Slough

268 Bath Road Slough Berkshire SL1 4DX

Other course dates at this location

17th 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

tue20aug9:15 am4:30 pmEvent OverPowerPoint Training-AdvancedAdvanced PowerPoint tools and concepts!9:15 am - 4:30 pm Reading Greyfriars, 9 Greyfriars Road Reading Berkshire RG1 1NU Training Course Price : £295

To book your course simply click add to cart & checkout

Advanced PowerPoint Training

Book Online Now!

Tickets are not available for sale any more for this course!

Training Course Price

£295

Training Course Detials

COURSE OUTLINE – Advanced PowerPoint Training

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

COURSE AIMS

This intensive hands-on one-day training course has been designed to provide delegates with a solid understanding of advanced PowerPoint tools and concepts in order to bring their ability to create powerful presentations at an expert level.

TARGET AUDIENCE

Users with a good understanding of Microsoft PowerPoint 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 course.

MODULE 1: Managing PowerPoint Files

Learning outcomes:

Organise and manage files within windows and use various file management tools to optimise your presentation.

Topics covered:

Using Windows Explorer within PowerPoint
File Management Tools
Using Presentation Tools: Optimisation and Compression
Using Presentation Tools: Inspection and Checking

MODULE 2: Working with Pictures

Learning outcomes:

Incorporate images into your PowerPoint file and learn a variety of picture editing tools to enhance your presentation.

Topics covered:

Inserting Pictures
Editing Pictures
Manipulating Pictures
Formatting Pictures
Managing Pictures

MODULE 3: Adding Multimedia to a Presentation

Learning outcomes:

Import video and sound media into a presentation and customise and edit these elements.

Topics covered:

Inserting Video Files
Editing Video Files
Inserting Audio Files
Editing Audio Files

MODULE 4: Adding Tables Charts and Diagrams

Learning outcomes:

Effectively use a variety of chart and diagram tools in order to display visually impressive stats and figures.

Topics covered:

Inserting Tables
Editing Tables
Formatting Tables
Inserting Charts
Inserting SmartArt
Formatting SmartArt

MODULE 5: Setting up Slide Masters

Learning outcomes:

Customise and set up consistent and corporate templates by designing a set of slide masters.

Topics covered:

Creating a Slide Master
Using Placeholders
Using Slide Masters
Using Hand-out Masters
Using Notes Masters

MODULE 6: Reviewing Presentations

Learning outcomes:

Learn collaboration and reviewing tools to help share and review your presentation with colleagues.

Topics covered:

Using Comments
Reviewing a Presentation

MODULE 7: Creating Advanced Types of Shows

Learning outcomes:

Make the final tweaks and customisations to your presentation by working with options and presentation tools.

Topics covered:

Setting up Your Show
Presenting Your Show
Creating a Custom Show
Advanced Presentation Techniques

Time

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

Location

Reading Greyfriars

9 Greyfriars Road Reading Berkshire RG1 1NU

Organiser

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

Calendar GoogleCal

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

Send this to a friend

Your emailRecipient email

Tag: minute taking courses

How to Write Meeting Minutes?

How To Take Minutes of a Meeting

About Us

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

Organiser

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

About Us

Subscribe

Management Courses

Health and Safety Courses

Equality Impact Assessment