Overview
What you will study
By the end of this Applied MS Excel for Business course offered by City, University of London , 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.
Programme Structure
The program focuses on:
- 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
Key information
Duration
- Part-time
- 2 months
Start dates & application deadlines
- Starting
- Apply before
-
- Starting
- Apply before
-
Language
Delivered
Disciplines
Business Information Systems View 10 other Short Courses in Business Information Systems in United KingdomAcademic requirements
We are not aware of any specific GRE, GMAT or GPA grading score requirements for this programme.
English requirements
We are not aware of any English requirements for this programme.
Other requirements
General requirements
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.
Applicants must have fluent written and spoken English.
Tuition Fee
-
International
520 GBP/fullTuition FeeBased on the tuition of 520 GBP for the full programme during 2 months. -
National
520 GBP/fullTuition FeeBased on the tuition of 520 GBP for the full programme during 2 months.