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)
- Entering and moving data
- Data Lists
- 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.
Progression & Career Opportunities
Many office-based employment roles require Excel skills.
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