Course Code: MTK23
Subject area: Business, Management & HR
Awarding body: City College Plymouth
Qualification: College Certificate
Course type: Short course
Time of Day: Daytime
Duration: One day
When you'll study: Various days, 9.00am - 4.30pm
Are you looking for Microsoft excel training at advanced level? This one day course covers pivot tables for analysis using macros, the ‘what if’ function and how to analyse data as well as setting up a database.
The skills and knowledge acquired in this Excel Advanced workshop are taking you to the next level of Excel use, giving you the opportunity to be able to use and operate the software at a superior level.Topics include:
- pivot tables for analysis
- using macros
- using the ‘What If’ function
- how to analyse data
- setting up a database.
You will require a good working knowledge of Microsoft Excel.
There is no assessment for this course.
On successful completion you may progress to a range of computing courses at the College.
Fees quoted apply to courses starting in the academic year 2017/18 (August 2017 – July 2018). There may be a slight increase in fees for courses starting 2018/19.