Course description
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
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.
Eligibility
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
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...