Micorosoft Office: Excel Essentials

Introduction

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?

Microsoft Excel:
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)

Example modules
Entering and moving data
Data Lists
Formulas
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.

Entry requirements

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.

Additional information

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

Career opportunities

Many office-based employment roles require Excel skills.

Costs & funding

Cost of course = £145.00 (including the cost of the exam)

Course Specification

Qualification type: Entry Level
Mode of study: Classroom Based
Start date: Multiple Start Dates
Course code: PXXXXMSES
Duration (weeks): 6

Fees calculator

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

Start your future with the Buckinghamshire College Group

Apply Now

Top
×