HOME
 

Applied MS Excel for Business

City University London
Course summary
10 weeks
490 GBP
English
Part time
Open / Scheduled
Next available date: 29/04/2020 - London
Course Dates
London
29/04/2020   (English)
490 GBP
01/05/2020   (English)
490 GBP
Applied MS Excel for Business

Course description

Applied MS Excel for Business

Assuming a basic knowledge of Microsoft Excel, this hands-on step-by-step spreadsheet course guides you 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.

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 formulas 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 formulas 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.

Suitability - Who should attend?

Prerequisite knowledge

A basic knowledge of MS Excel, such as:

  • Entering and editing data in Excel;
  • Calculating numerical data;
  • Using mathematical formulas;
  • Analysing data using simple statistical functions;
  • Sorting and filtering data.

Training Course Content

  • 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 formulas, 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

Get Inspired! Watch the Video

A short course is an excellent way to gain new expertise, advance skills or simply follow a passion. With courses in business, computing, writing, creative industries, languages and law there is something for everyone. Glimpse inside our short course community: hear from our industry-expert tutors and listen to students as they reflect on their learning experience.

About provider

City University London

City University 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

Contact info

City University London

Northampton Square
EC1V 0HB London

 Show phone number

U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's second annual U.K. L&D Report!

uk-ld-report-2019

Learn more

 
Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

 
Find more courses here