Excel Skills Level 2

Build Confidence with More Advanced Excel Tools

Do you already know the basics of Microsoft Excel and want to take your skills further? This course is designed for learners who are ready to move beyond simple spreadsheets and start using Excel more confidently for work, study, business or everyday tasks.

Excel Skills Level 2 is a great next step for people who have completed our Introduction to Microsoft Word and Excel course, as well as anyone who already has basic Excel knowledge and wants to improve their spreadsheet skills.

Over 6 weeks, you will learn practical Excel tools that can help you organise information, work with formulas, analyse data, reduce errors and save time. The course is delivered in a supportive classroom environment, with step-by-step guidance so you can practise as you learn.

What You Will Learn

This course will help you develop a stronger understanding of Excel and how it can be used more effectively. You will explore useful functions, formatting techniques and data tools that are commonly used in workplaces, small businesses and administration roles.

Course topics include:

1. Formulas and Special Functions: Explore the power of Excel formulas, including SUM, COUNT, AVERAGE, and IF statements, to streamline your data analysis processes.
2. Texts and Numbers in Excel: Learn effective techniques for manipulating and managing text and numerical data within Excel.
3. Relative & Absolute References: Master the art of using relative and absolute references to efficiently navigate and manipulate data across Excel spreadsheets.
4. Macros: Automate repetitive tasks and boost your productivity by creating and deploying macros in Excel.
5. VLookup vs. SumIf: Understand the differences between VLOOKUP and SUMIF functions and learn when to use each to extract valuable insights from your data.
6. Pivot Tables: Unlock the full potential of Excel’s pivot tables to analyze, summarize, and visualize complex datasets with ease.
7. Data Validation: Ensure data accuracy and integrity by implementing robust data validation techniques in Excel.
8. Protect Sheet/Workbook: Safeguard your sensitive data and prevent unauthorized access by implementing sheet and workbook protection measures.
9. Fixing Errors: Acquire troubleshooting skills to identify and rectify common errors encountered in Excel spreadsheets.

Who Is This Course For?

This course is suitable for:

• People who have completed DVLC’s Introduction to Microsoft Word and Excel course
• Learners who already understand basic Excel and want to advance their skills
• Job seekers wanting to improve their computer and administration skills
• Employees who use spreadsheets at work and want to become more confident
• Small business owners who manage lists, budgets, records or reports
• Volunteers or community workers who use Excel for organising information

You do not need to be an expert in Excel to join this course. However, basic experience using Excel is recommended, including opening a spreadsheet, entering data, using simple formatting and saving files.

Why Learn Advanced Excel Skills?

Excel is used in many workplaces for administration, finance, reporting, rostering, budgeting, stock control, data entry and planning. Building stronger Excel skills can help you work more efficiently, reduce mistakes and feel more confident when handling information.

Whether you are returning to study, looking for work, supporting a small business or wanting to improve your digital skills, this course can help you take the next step.

Course Outcome

By the end of this course, you will have practised a range of Excel tools and functions that can help you create more useful, accurate and organised spreadsheets. You will also gain confidence using formulas, pivot tables, data validation and other features that are commonly used in workplace settings.

Take the Next Step with Excel

If you are ready to move beyond the basics and build practical spreadsheet skills, Excel Skills Level 2 is a supportive and useful next step.

Enrol today and continue building your confidence with Microsoft Excel.