Excel spreadsheets - advanced

Level
Total time

Excel spreadsheets - advanced

Kingston Adult Education
Logo Kingston Adult Education

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.

Description

This course will develop your intermediate Excel skills so that you can handle, organise and interpret data at an advanced level.  You will build on your formulae and function skills and learn how to display data using pivot tables and data tables.  Advanced features of graphs will also be covered together with creating macros.

Student & Entry Requirements:

Learners should be familiar with Excel at Intermediate level.

Learners should be familiar with Microsoft Operating Systems

General & First Session:

Please bring file, paper, pen.

Course Aim & Objective:

To develop advanced excel skills and to use excel to format, handle and organise data and predefined data.  The course will develo…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

This course will develop your intermediate Excel skills so that you can handle, organise and interpret data at an advanced level.  You will build on your formulae and function skills and learn how to display data using pivot tables and data tables.  Advanced features of graphs will also be covered together with creating macros.

Student & Entry Requirements:

Learners should be familiar with Excel at Intermediate level.

Learners should be familiar with Microsoft Operating Systems

General & First Session:

Please bring file, paper, pen.

Course Aim & Objective:

To develop advanced excel skills and to use excel to format, handle and organise data and predefined data.  The course will develop learner's functions and formulae knowledge.  Learners will use a variety of methods to display data and set up macros.

By the end of the course  each learner will be able to:

  • Use conditional formatting
  • Auto formats
  • Paste Special
  • Linking
  • Protection
  • Sorting and Lists
  • Templates
  • Scenarios
  • Functions
  • Formulas
  • Pivot Tables
  • Data tables
  • Advanced features of graphs
  • Macros

Assessment:

  • Observation
  • Practical exercises
  • Evaluation
  • Q & A

Progression:

Another Microsoft application course.

Course Syllabus:

  • Formatting and Data Handling
  • Conditional formatting
  • Auto formats
  • Paste special
  • Linking
  • Protection
  • Organising Data and Predefined Data
  • Sorting & Lists
  • Templates
  • Scenarios
  • Functions and Formulae
  • Functions
  • Formulae
  • Displaying Data and Macros
  • Pivot Tables
  • Data Tables
  • Advanced Features of Graphs
  • Macros
There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.