course-premium

Level 4: Microsoft Excel

3.8
2 reviews
  • Heather's way to deal with educating was ideal for my style of learning. Without saying I was uncertain, Heather could perceive this without talking with me. I learnt an extraordinary arrangement from this course and would prescribe to all. Heather was an extraordinary teacher.
    |
  • At the end of the day, Heather's energy shone through. She generally has the response to any inquiries straight away. Learnt some extremely helpful tips and in addition an exceptionally welcome recap of the Introduction course. I feel a great deal more certain about applying calculations/formulae/functions to a spreadsheet.
    |

Course

In Royal Leamington Spa

Price on request

Expand your knowledge in Microsoft Excel!

  • Type

    Course

  • Location

    Royal leamington spa

  • Duration

    2 Days

  • Start date

    Different dates available

The course will provide the delegates with the opportunity to explore the more specialised and advanced features and facilities of Excel.
It will show how repetitive tasks can be automated and, using pivot tables, show how data can be further summarised and analysed.

Facilities

Location

Start date

Royal Leamington Spa (Warwickshire)
See map
Althorpe Enterprise Hub, Althorpe Street, , CV31 2GB

Start date

Different dates availableEnrolment now open

About this course

Everyday users with an extremely good working knowledge of Excel who want to develop their knowledge further. Should be competent
at creating formulae and functions covered in the previous levels of training.

Attended the Level 3 Excel course or been using Excel for a long period of time.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

3.8
  • Heather's way to deal with educating was ideal for my style of learning. Without saying I was uncertain, Heather could perceive this without talking with me. I learnt an extraordinary arrangement from this course and would prescribe to all. Heather was an extraordinary teacher.
    |
  • At the end of the day, Heather's energy shone through. She generally has the response to any inquiries straight away. Learnt some extremely helpful tips and in addition an exceptionally welcome recap of the Introduction course. I feel a great deal more certain about applying calculations/formulae/functions to a spreadsheet.
    |
100%
4.4
fantastic

Course rating

Recommended

Centre rating

N.

4.0
10/05/2016
What I would highlight: Heather's way to deal with educating was ideal for my style of learning. Without saying I was uncertain, Heather could perceive this without talking with me. I learnt an extraordinary arrangement from this course and would prescribe to all. Heather was an extraordinary teacher.
What could be improved: No negative aspects.
Would you recommend this course?: Yes

Brize Norton

3.5
10/03/2016
What I would highlight: At the end of the day, Heather's energy shone through. She generally has the response to any inquiries straight away. Learnt some extremely helpful tips and in addition an exceptionally welcome recap of the Introduction course. I feel a great deal more certain about applying calculations/formulae/functions to a spreadsheet.
What could be improved: Everything OK.
Would you recommend this course?: Yes
*All reviews collected by Emagister & iAgora have been verified

Subjects

  • Microsoft Project
  • Excel
  • Word
  • Powerpoint
  • Microsoft Excel
  • Spreadsheet
  • Microsoft Word
  • Microsoft Powerpoint
  • Computer Engineering
  • IT Security
  • Microsoft excel training
  • MS Excel
  • IT Systems
  • Computer Science
  • Office systems
  • IT
  • Computering
  • Microsoft
  • Mirosoft Access

Course programme

Customising the Ribbon

• Creating new custom tabs and groups

• Renaming a tab, group or command button

• Adding a command button to a custom group

• Changing the symbol for a command button

• Removing a tab, group or command button


Formulae and Functions

• Text functions

• Date and time functions


Auditing Tools

• Displaying more than one formula at the same time

• Identifying the structure of calculations

• Tracing precedents and dependents

• Removing tracing arrows


Data Management

• Advanced filtering and filtering using slicers

• Performing database statistical functions

• SUMIF and COUNTIF functions

• COUNT and COUNTA functions

Analysing and consolidating information

• Using the data consolidation feature

• Consolidating data by position

• Consolidating data by category


Subtotalling Data

• Setting up outlines for rows and columns

• Creating subtotals

• Subtotal outlines

• Displaying or hiding outline symbols

• Creating nested subtotals

• Creating multiple summary functions

• SUBTOTAL function


Working with Data

• Pick from list

• Data Validation

Conditional Formatting

• Setting up simple conditional formatting

• Using predefined conditional formatting

• Conditional formatting based on the cell content

• Conditional formatting using a calculation

• Deleting conditional formatting


Charting Worksheet Data

• Revising creating, formatting and modifying charts

• Adding additional data to a chart

• Creating combination charts

• Incorporating a secondary axis

• Adding trendlines to a chart

• Marking high and low points on a chart

• Creating sparklines


Analysing and Consolidating Data using Pivot Tables

• Creating and working with pivot tables

• Naming a pivot table database

• Adding, moving and deleting fields

• Refreshing a pivot table

• Displaying sub and grand totals

• Showing pivot tables in compact, outline or tabular format

• Grouping date fields to show other time intervals

• Changing number formats

• Using functions in a pivot table

• Showing data as a percentage of other data

• Filtering data with a slicer

• Pivot table options

• GETPIVOTDATA function


Macros

• Macro security

• Enabling macros

• Using macros to automate repetitive tasks

• Recording and running a macro

• Assigning a macro to the toolbar, menu or keyboard

• Deleting macros

Level 4: Microsoft Excel

Price on request