4.5 Read 8 reviews
Overview
What you will study
By the end of this Applied MS Excel for Business course offered by City St George's, 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
- Full-time
- 2 days
- Part-time
- 2 months
Start dates & application deadlines
- Starting
- Apply before
-
- Starting
- Apply before
-
- Starting
- Apply before
-
Language
English
OTE 140
Delivered
On Campus, Online
Campus Location
- London, United Kingdom
Disciplines
Business Information Systems View 6 other Short Courses in Business Information Systems in United KingdomWhat students do after studying
Join for free or log in to access our complete career info list.
Academic requirements
We are not aware of any specific GRE, GMAT or GPA grading score requirements for this programme.
English requirements
OTE 140
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 Fees
Tuition fees are shown in and the most likely applicable fee is shown based on your nationality.
-
International Applies to you
Applies to youNon-residents520 GBP / full≈ 520 GBP / full -
Domestic Applies to you
Applies to youCitizens or residents520 GBP / full≈ 520 GBP / full
Living costs
London
United Kingdom
1137 - 2157 GBP / month
The living costs include the total expenses per month, covering accommodation, public transportation, utilities (electricity, internet), books and groceries.
Funding
Improve page content