Excel is known as an application for crunching the numbers and data analysis. However another very important aspect is that of presenting the data in an accessible way, that you have analysed. Consequently, we will look at formatting the data as well as using formulas to analyse the data.
This course is for people who already use Excel for data analysis but who wish to take their skills a bit further and gain a Microsoft certification in the application. There will be a certain amount of work to do outside of the course in preparation for the exam, including using the official Microsoft practice tests as provided by GMetrix (note: the tests are provided in Windows format only).
Where can I study?
What will I learn?
Understanding the Ribbon Layout specific to Excel
Entering and moving data in a Worksheet
Formatting Cells and cell ranges, Borders and Margins.
Creating Basic formulas and functions (SUM, COUNT, COUNTA, AVERAGE)
Sorting and filtering data lists
Using advanced formulas (SUMIF, COUNTIF, AVERAGEIF)
Using Lookup functions (VLOOKUP and HLOOKUP)
Working with data and macros
Creating and formatting Charts (including creating basic pivot tables and pivot charts)
Using images and graphics in Excel (SmartArt)
|Entering and moving data|
|Creating and formatting charts|
How will I be assessed?
You will be working at a fairly brisk pace throughout 5 of the 6 weeks covering all of the content and reviewing tasks that you will have completed outside of college. You will also be given access to Microsoft’s official practice test site (run by GMetrix) so that you can work through practice tests (again outside of college) in preparation for taking the Microsoft exam in Excel in the 6th week.
You need to have a good familiarity with Excel including being able to navigate around a worksheet, understanding the difference between absolute and relative cell references, creating and formatting charts and be familiar with using basic formulas and functions and the syntax that they use.
How do I register for the course / make payment for the course? Please complete the online registration form. To pay, click on ‘apply’ to go to the online store.
This is a classroom based course. You may want to bring a pen and notepad but you will also be provided with a course booklet which you can annotate, should you so wish.
This course will next be running from 09th Jan 2019 and 12th June 2019
Many office-based employment roles require Excel skills.
Costs & funding
Cost of course = £145.00 (including the cost of the exam)
|Qualification type:||Entry Level|
|Mode of study:||Classroom Based|
|Start date:||Multiple Start Dates|
Help with fees may be available depending on your personal circumstances. More information
Fees for 2018/19 are yet to be confirmed. Please contact Admissions for further information
01296 588 595