Warning: Undefined global variable $wpseo_og in /home/digitaldepotco/wmc/wp-content/themes/C4/functions.php on line 422 Microsoft Excel for improvers: build confidence with fo
This course is for those who have completed the Microsoft Excel - Beginners, or have experience of using spreadsheets and want to further develop their skills. You should be comfortable with basic Excel functions, formula creation, formatting, and simple data management before joining this course. You will extend your knowledge of spreadsheets, work on more complex tasks with the help of your tutor. Please note you will be withdrawn from the register if you enrol on more than 2 of any of the AI or Excel courses and may be charged a fee for any over this limit.
Location: Crowndale Road, Camden
Who is this course for and what will I learn?
You should have completed the Microsoft Excel - Beginners course or you have experience of using spreadsheets at level 1 including: creating basic formulas, using common functions(SUM, AVERAGE, COUNT), formatting cells and worksheets, creating simple charts, and managing worksheets. You should be familiar with using a computer, knowing how to save and print documents. You should be familiar with using the Internet and email.
At improvers level, you will be looking at more advanced functions, such as IF functions, Lookup functions as well as absolute/relative/mixed cell references, Sorting, Filtering, Freezing Row/Column, PivotTables and PivotCharts, and Printing options in order to further manipulate your spreadsheets.
How will I learn?
This improvers course builds on your existing Excel knowledge through challenging, real-world projects that mirror actual workplace scenarios. You will work with realistic datasets and solve complex business problems using advanced Excel techniques. You will have live tutor demonstrations and you will follow set exercises as practice to develop your skills in manipulating data and explore the features that Excel has to offer.
There is flexibility of learning to accommodate different professional backgrounds and learning goals. Additional exercises are available for those wanting extra practice and individual support for those who need more guidance. You will be expected to complete work at home in addition to work done in class.
Warning: Undefined array key "isSummerSchool" in /home/digitaldepotco/wmc/wp-content/themes/C4/template-course-detail.php on line 991
Assessment and next steps
There is no exam or formal assessment for this course. However, you will complete an Individual Learning Plan (ILP) which will outline the learning objectives for the course. Your progress will be tracked against specific learning outcomes based on the course content and portfolio of work completed. This includes: creating IF statements, using VLOOKUP to retrieve data from large tables, creating PivotTables and PivotCharts, and implementing data validation.
There is no formal qualification, but you can recieve a Certification of Completion from the college on request.
Once you have completed the course you may choose to enrol on other courses related to Excel such as the AAT Bookkeeping and Accounting courses. Advice and Guidance for all further study is available from the Curriculum Manager by request.
What additional support can I get?
You may be eligible for fee reductions or one of our bursaries, please check the Information and Advice section of our website to find out more.
Additional Learning Support (ALS) is available for this course, subject to an interview with a member of our support staff. ALS may include one or more of the following: support in classes, out of class in small groups, workshops or 1:1 with a specialist tutor. Reasonable adjustments including assistive equipment and access support can be made available through our Disability Officer. Please let us know as soon as possible about your learning needs and/or disabilities so we can arrange support at the earliest opportunity.
Teachers are supported to ensure their materials are inclusive to meet learners’ needs. Digital Learning support is available in the Learning Centre.
We offer free support with finding a job, including 1-1 support with job applications, creating a CV or improving your interview skills, as well as advice about progression opportunities. Visit the website for more information or to book an appointment with our Employability Coach.
There are regular cross-college events, external speaker visits, exhibitions, and opportunities for you to get involved in college life. Look out for adverts around the college, iLearn or sign up to Our Newsletter via the website.