Plan a date with this online course to upskill.

We're offering you a data analysis in excel online course for just £9 saving you 64% off Janets Quality Education For All's price of £25.

Master Excel data skills for better analysis

Get to grips with the fundamentals of data analysis using Excel in this accessible and engaging online course. Whether you're switching careers or aiming to boost your current role, this course builds your confidence in working with data through hands-on training in Excel tools. Learn how to analyse, format, and present data efficiently across multiple worksheets and workbooks, and unlock the full potential of Excel's features to streamline your workflow.

Learning outcomes

• Understand how to use PivotTables and PivotCharts to transform raw data into actionable insights.
• Discover advanced charting tools and conditional formatting to visualise and highlight trends.
• Get confident using lookup functions, macros, and formula auditing to automate repetitive tasks.
• Learn to sort, filter, and query data to simplify analysis in complex datasets.
• Master forecasting techniques like Goal Seek and Scenarios to predict future outcomes.
• Explore multi-sheet data consolidation, 3-D referencing, and linking external workbooks.

Why choose this Excel course?

Study whenever and wherever it suits you, with device-friendly materials designed for flexible learning. With access to 24/7 live chat and email support, you’re never left in the dark. You'll receive mock exams and multiple-choice assessments to track your progress, and upon completion, a QLS-endorsed certificate to showcase your achievement. This course offers a smart stepping stone to advance your career or pivot into data-focused roles.

Course modules

• Module 1: Modifying a Worksheet - Modify worksheets by inserting, deleting, and adjusting cells, rows, and columns.
• Module 2: Working with Lists - Master sorting, filtering, and querying to manage and analyse lists efficiently.
• Module 3: Analysing Data - Apply conditional formatting techniques to highlight key data patterns and trends.
• Module 4: Visualising Data with Charts - Create, modify, and format charts to visualise data with clarity and impact.
• Module 5: Using PivotTables and PivotCharts - Build PivotTables and PivotCharts to summarise and present data dynamically.
• Module 6: Working with Multiple Worksheets and Workbooks - Work confidently across multiple worksheets and workbooks with links and references.
• Module 7: Using Lookup Functions and Formula Auditing - Use lookup functions and formula auditing tools to ensure data accuracy and logic.
• Module 8: Automating Workbook Functionality - Automate workbook tasks using data validation, error checking, and macros.
• Module 9: Creating Sparklines and Mapping Data - Create Sparklines and map data to present compact visual summaries.
• Module 10: Forecasting Data - Forecast future trends using data tables, scenarios, and Goal Seek tools.

Check out other related deals:

Technical Learning

Online Business Courses

Centre of E-Learning

Online Courses and Home Learning

Online Language Courses