Excel Skills to Make an Impression
- Level(s) of Study: Short course; Professional
- Course Fee:
Available at no cost to eligible individuals (see criteria below).
- Start Date(s): Self-paced online learning
- Duration: 8 hours (recommended 4 weeks, 2 hours per week)
- Study Mode(s): Part-time
- Entry Requirements: More information
Introduction:
Please note: This course is delivered through the Enterprising Ashfield project, which is funded by the Government's Towns Fund. Å·ÃÀ¾ÞÈé (NTU) is pleased to offer free (fully funded) places on this course to support individuals and employees of businesses that are based in the towns of Kirkby-in-Ashfield and Sutton-in-Ashfield.
This course was developed by The Excel Club and is delivered on as an online self-paced course.
Discover Microsoft Excel skills to take your career to the next level
Microsoft Excel is a mainstay of professional roles around the world. From administration, to finance, to data analysis, and beyond, wherever there are numbers, you are likely to find Excel.
This course from The Excel Club is designed to help you take your Excel skills to the next level. Many users never get beyond the program’s most basic functionality, often feeling intimidated.
The course is designed to provide a gentle introduction to intermediate and advanced Excel skills. You will go from creating simple lists to carrying out complex Excel data analysis in no time.
The Excel skills you learn are sure to get you noticed, by both your current and prospective future employers.
Learn how to use Excel pivot tables, IF statements, and more
On this course, you will begin to explore some intermediate and advanced Excel functionality.
Some of the Excel skills covered include using Excel IF statements and comparative operators, simple and complex lookups, pivot tables for data analysis and exploration, calculations using Excel’s new dynamic arrays, and more.
With these advanced Excel skills, you will be able to approach complex tasks with confidence. You will be empowered to advance your career, either in your current role or in a new one.
This course is delivered by , a digital education platform that offers online courses and degrees from top universities and organisations around the world. They offer a variety of courses across many subjects, designed and taught by academic and industry experts.
What you’ll study
By the end of this course, you'll be able to...
- Solve logical problems using comparative operators and IF statement
- Demonstrate the use of simple to complex Lookups
- Calculate aggregations with conditions attached using SUMIF, SUMIFS and other IFS functions
- Explore and analyze data using Pivot tables
- Discuss and apply how Excel table features can make you more efficient
- Perform calculations using Excel's new Dynamic Arrays
Certificate of attendance and digital badge
Upon successful completion of the course, you will receive a digital certificate of attendance and a digital badge powered by .
Your is more than just a certificate – it’s secure, verifiable, and protected against fraud through encryption and blockchain technology.
They also come with detailed metadata, including an overview of the skills you have achieved on the course, evidence of completion, and assessment criteria if appropriate.
Share your achievements seamlessly with friends, customers, and potential employers online, and proudly add your badge or certificate to social media platforms such as LinkedIn, so all the right people can see it.
How you’re taught
The course is delivered 100% online and is self-paced . You can start straight away and join a global classroom of learners.
Contact hours
It is recommended that you complete the course over a 4 week period, spending 2 hours per week to fit around your schedule.
Entry requirements
This course would be suitable for anyone seeking to advance their career by learning more advanced Excel skills.
This includes those working or seeking to work in data analysis, advanced administration, or finance roles, among others.
In this course we use Excel 365. You can .
You must be over the age of 18 in order to attend this course.
Fees and funding
This course is available at no cost to eligible participants.
If you live or work outside the eligible postcode area, you can join our fee-paying short courses delivered on the City Campus.
How to apply
If you have any questions about this course, you can email EnterprisingAshfield@ntu.ac.uk or call us at +44 (0)115 848 2813.
