Applied MS Excel for Business

City University London

Short course

In Islington

Price on request

The best Other Accounting courses

See all

See all

Description

  • Type

    Short course

  • Location

    Islington

Assuming a basic knowledge of Microsoft Excel, this hands-on step-by-step spreadsheet course guides participants through commonly used business applications such as forecasting techniques, advanced database functions, logical tests, Pivot tables and what-if analysis. In the final week we look at the recording, running and basic editing of VBA macros. Course Information Start DateStart TimeDurationCostCourse CodeApply Wednesday 5 October 2016 18:30 - 20:30 10 weekly classes £480.00 CS1596 Apply Now Thursday 6 October 2016 18:30 - 20:30 10 weekly classes £480.00 CS1596 Apply Now Friday 7 October 2016 18:30 - 20:30 10 weekly classes £480.00 CS1596 Apply Now Monday 16 January 2017 18:30 - 20:30 10 weekly classes £480.00 CS1596 Apply Now Wednesday 18 January 2017 18:30 - 20:30 10 weekly classes £480.00 CS1596 Apply Now Friday 20 January 2017 18:30 - 20:30 10 weekly classes £480.00 CS1596 Apply Now Wednesday 3 May 2017 18:30 - 20:30 10 weekly classes £480.00 CS1596 Apply Now Friday 5 May 2017 18:30 - 20:30 10 weekly classes £480.00 CS1596 Apply Now Tutor Info Robert Stephenson is a visiting lecturer at London Metropolitan University. He has a Mathematics and Computing BSc (UNL) and Data Communications,...

Facilities

Location

Start date

Islington (London)
See map
Northampton Square, EC1V 0HB

Start date

On request

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

Subjects

  • Excel
  • Forecasting
  • Basic
  • IT
  • Basic IT training
  • Microsoft Excel
  • Spreadsheet
  • Database
  • Database training
  • Basic IT
  • Mathematics
  • Microsoft excel training
  • MS Excel
  • GCSE Mathematics

Course programme

What will I learn?
  • Review of writing arithmetic formulas - precedence of operators and the proper use of brackets
  • The formula for compound interest (the most important basis of financial mathematics)
  • Goal Seek - this tool has many and varied uses when working with mathematical formulae, often making it much easier to get answers to difficult questions.
  • Calculating depreciation using Goal Seek and without using the built in functions
  • Calculating depreciation using the built in functions DB and SLN
  • The use of the IF function in Excel to analyse and interpret input data - e.g. grading student marks, calculating discounts, and wage bonus calculation.
  • The use of nested IF functions is covered extensively to deal with more complicated problems.
  • Filling in an order form with the aid of drop-down lists, automatic price lookup and calculation of discount
  • The use of the database functions (DCOUNT, DSUM and DAVERAGE) to produce an automatically updating monthly report
  • Analyse tabular information using Pivot Table Wizard (for example data gathered about voting patterns in an election)
  • An introduction to recording and writing simple Visual Basic Macro programs and suggested uses of simple macros
  • The use of Scenario Manager in a forecasting environment

By the end of the course, you will be able to:

  • use Intermediate level and some Advanced level facilities of the Microsoft Excel spreadsheet package such as Goal Seek, Scenario Manager, the VLOOKUP function, Pivot Tables and simple Macros
  • use DSUM, DAVERAGE,DCOUNT functions, using multiple extraction criteria to summarise information in a database table
  • use complex nested formulae and logical tests in a business context (e.g. working out bonus payments linked to performance)
  • design tree diagrams to analyse situations where more complex examples of nested formulae and logical tests are required
  • demonstrate an understanding of the variety of solutions that exist within Excel to common business scenarios; be capable of selecting an appropriate one.

See related categories

Applied MS Excel for Business

Price on request

The best Other Accounting courses

See all

See all