Professional Training

Applied MS Excel for Business

10 weeks
520 GBP
Next course start
Enquire for more information See details
Course delivery
10 weeks
520 GBP
Next course start
Enquire for more information See details
Course delivery
Leave your details so the provider can get in touch

Course description

Applied MS Excel for Business

Applied MS Excel for Business

Everyone thinks they know how to use Microsoft Excel, but do you really understand its full potential? Develop more than just a basic understanding of this highly useful tool to make your working life easier.

You'll learn how to use the most common and useful tools in the software, rather than carrying out tasks manually. This will save you time and make you more efficient.

This Microsoft Excel evening course covers the functionality of MS Excel that's most requested by employers, including data analysis, allowing you to make the most of this common, but often under-used, software program.

Upcoming start dates

1 start date available

Enquire for more information

  • Classroom
  • London

Suitability - Who should attend?

This course is for anyone who regularly uses Microsoft Excel at work, and who wants to make sure they are using the program correctly and that they have the most commonly required skills for using Excel.


To get the most out of this Excel course you need a basic knowledge of MS Excel, including how to:

  • enter, edit, sort and filter data
  • analyse data using simple statistical functions
  • calculate numerical data
  • use mathematical formulas.

English requirements

Applicants must be proficient in written and spoken English.

Outcome / Qualification etc.

There's no formal assessment on this Microsoft Excel course, but you will receive a certificate of attendance.

When you learn how to use Microsoft Excel correctly, you'll understand how to convert work done manually into Excel spreadsheets, making you more efficient and freeing up time to work on more rewarding tasks. Your new skills will also minimise mistakes in your work.

By the end of this course, you'll be able to:

  • Use the intermediate level and some advanced level features in MS Excel, including the VLOOKUP function, Pivot tables, Goal Seek, Scenario Manager, and simple macros
  • Use the DSUM, DCOUNT and DAVERAGE functions, using multiple extraction criteria to summarise information in a spreadsheet
  • Use complex nested formulas and logical tests in a business context
  • Design tree diagrams to analyse situations where more complex examples of nested formulas and logical tests are required
  • Understand how to use MS Excel's functionality and how to apply this appropriately in common business scenarios.

Training Course Content

The course begins with a review of the basic functionality of MS Excel that you're expected to know already. You'll learn how to build Microsoft Excel spreadsheets correctly, allowing you to take full advantage of its varied tools. By the end of the course, you'll know how to use all the program's fundamental and most commonly required functionality.

Many employers now require prospective employees who will be using MS Excel regularly to take a test in Excel. This course covers the majority of questions that appear in such tests.

You'll learn how to:

  • Write arithmetic formulas, including precedence of operators and the proper use of brackets
  • Create the formula for compound interest (the most important basis of financial mathematics)
  • Use the Goal Seek tool
  • Calculate depreciation using Goal Seek without using the built-in functions
  • Calculate depreciation using the built-in functions in DB and SLN
  • Use the IF function to analyse and interpret input data
  • Use nested IF functions to deal with more complicated problems
  • Fill in an order form with the aid of drop-down lists, automatic price lookup and calculation of discount
  • Use the database functions (DCOUNT, DSUM and DAVERAGE) to produce an automatically updating monthly report
  • Analyse tabular information using Pivot Table Wizard
  • Record and write simple Visual Basic Macro programs, as well as learn suggested uses of simple macros.
  • Use Scenario Manager in a forecasting environment.

Course delivery details

This Microsoft Excel evening short course runs for ten weeks. You can attend the two-hour lessons on weekday evenings.

Get Inspired! Watch the Video

Request info

Contact course provider

Fill out your details to find out more about Applied MS Excel for Business.

  Contact the provider

  Get more information

  Register your interest

Country *

reCAPTCHA logo This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
City, University of London
Northampton Square
EC1V 0HB London

City, University of London

City, University of London is a special place. With skill and dedication, we have been using education, research and enterprise to transform the lives of our students, our community and the world for a hundred years. We are proud of...

Read more and show all courses with this provider