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

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

  • Progression & Career Opportunities

    Many office-based employment roles require Excel skills.

  • 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

Course Image

Course Details

Qualification Level Entry Level
Study Mode Online Course
Start Date Multiple Start Dates
Duration 6 Weeks
Course Code PXXXXMSES
Runs at

Aylesbury

Apply Now Enquire

Can we email you about course availability and open days you may be interested in?

Please enter your email address
Invalid Input

You are enquiring for...

    Please select a title
    Please tell us your first name
    Please tell us your surname
    Please tell us your date of birth
    Please tell us your email address
    Invalid Input
    Please tell us your postcode
    Please select your highest obtained qualification
    Please tell us how you heard about Bucks College Group
    Please tell us how you heard about Bucks College Group
    Invalid Input