Excel your skills on the way to professional success!

We're offering you a CPD certified Microsoft Excel 2021 course for just £9 saving you 64% off Janets Quality Education For All's price of £25.

Present your data in a structured and clear format

Unlock the full potential of Excel with this Microsoft Excel 2021 course designed for everyone!. Whether you’re new to spreadsheets or want to sharpen your existing skills, this online course helps you build the confidence and expertise to elevate your career.

Course modules

• Getting Started: Get familiar with the course setup, learn how to access it on any device, and start Excel with ease. Learn how to ask better questions and understand the Excel interface
• Excel Basics: Learn worksheet essentials, how to enter data and formulas, format values, and manage your workbook with copy, paste, save, print, and ranges
• Excel Essential Functions: Master key functions (math, text, logical, date-time) and learn lookup formulas like VLOOKUP, HLOOKUP, MATCH + INDEX for smarter data use.
• XLOOKUP (Excel 2021/Office 365): Learn to use XLOOKUP for accurate searches, error handling, and filtering with wildcards and approximates.
• Data Tools & Import: Split text, use Flash Fill, remove duplicates, validate entries, and import data from text or CSV files with ease.
• Formatting Data and Tables: Improve your spreadsheet’s look by formatting fonts, numbers, dates, and creating clean, structured tables.
• Pivot Tables: Create and format pivot tables to summarise and group data. Practice with hands-on exercises and solutions.
• Excel Charts: Visualise your data with charts like bar, line, and pie. Customise chart elements for clear and engaging visuals.
• Advanced Excel Charts: Explore advanced visuals like histograms, combo charts, and sparklines to make trends stand out.
• Pivot Charts: Turn pivot tables into interactive charts that update with your data.
• Map Charts (Excel 2019+): Use Excel's map and 3D map features to visualise data geographically.
• Business & Geo Charts: Create stock, radar, surface, and heat maps to showcase complex business data.
• Named Ranges: Use named ranges and INDIRECT formulas to build dynamic, flexible sheets.
• Importing Data into Excel: Import data from websites and PDFs to expand your Excel toolkit.
• Advanced Excel Projects: Put skills to work with projects like tax invoices and sales forecasts that reinforce your learning.

About Janets

Janets is committed to making high-quality education accessible and affordable for learners everywhere. With a strong focus on professional development and practical knowledge, Janets provides industry-recognised qualifications that help individuals grow personally and professionally. Whether you’re reskilling, upskilling, or exploring a new path, Janets ensures every learner receives the support, flexibility, and certification they need to thrive.

Check out our other related deals: