Shaw Academy

Your Future, Your Way!

Course Catalogue

Get 4 Weeks FreeLogin

44,932

Graduates
All Levels
Certified

0%

Most of this week’s places have been filled.

Start your course now to guarantee your place.

learn-icon

Excel Class Overview

  • Data analysis techniques using tools and functions such as slicers and pivot tables
  • How to ensure data integrity by applying structured references, creating input sheets and error checking
  • How to present and format your data using spreadsheets, graphs and charts
  • How to navigate and utilise multiple sheets, workbooks and printing options using keyboard shortcuts
  • Create templates, custom lists, macros and basic VBA techniques

Excel Course Content

module 1

Diploma in Excel

free

+

-

  1. Setting the Stage

    This class sets the stage for the Excel workspace. It covers the basics of how to navigate Excel, starting from opening and closing a workbook. You will get an introduction to Excel skills and keyboard shortcuts, basic formatting and four basic functions. The lesson ends with a practical where you will use all the skills acquired throughout the lesson to do simple data entries and create your first list.

  2. Blank Canvas

    This lesson begins with a blank spreadsheet that you will learn to build on. Continuing on from the basics learned in Lesson 1, you will receive further Excel training in formatting options, and learn how to manage data across more than one worksheet and more than one workbook. You will also venture into the Insert tab and create your first table.

  3. Sheets, Tables, and Things

    This online class focuses on an area in Excel where few dare to venture — the File tab. You will learn a new tool that allows you to efficiently link cells, worksheets and workbooks, plus a new function, SUMIF, is explained to add to your repertoire.

  4. Keep Organised

    This lesson pays special attention to the tools that help keep things organised in Excel. You will explore simple date functions, how to sort, and how to filter data. Absolute and relative referencing are also explained, allowing you to work even more efficiently in Excel.

  5. Code of Conduct

    This Excel crash course focuses on data integrity and how to use outlines to group data, flash fill, remove duplicates, add control checks, spellcheck, and create basic dropdown lists. You will also learn another function, AVERAGE, as well as how to use cell styles and the thesaurus.

  6. Lights, Camera, Action!

    This is a practical training class and covers two of the biggest tools, charts and graphs. These are the stars of Excel which you can use to visually represent your data and add professionalism to any spreadsheet or report.

  7. Getting Into Shape

    In this lesson you will learn how to add a personal touch to presentations by adding shapes or using SmartArt to illustrate information in a particular way. Other useful tools that will be covered include people graphs, slicers, icons and 3D models.

  8. Keep It Clean

    This excel class will focus on how to obtain and use accurate data. You will learn how to use the TRIM and CLEAN functions, and take sorting one step further in order to sort using multiple levels and highlight duplicate records using conditional formatting. This lesson also covers print settings, so you can keep hard copies of your hard work after finalising your data.

  9. Creating Footprints

    The lesson focuses on creating footsteps for someone to follow in as we will be learning all about templates, what templates are available and even how to create your very own template. Added extras covered will be building on conditional formatting and uncovering the options available to us in this useful command. If you are all for saving trees, this lesson will also show you ways to create PDF versions of your workbook.

  10. A Helping Hand

    This lesson focuses on all the support available to Excel users and how to access them within the application. You will learn how to customise the Excel workspace to suit your needs, before bringing together all the basic skills acquired throughout the module into an exciting mini project, where you will create your very own personal monthly budget template that you can begin using straight away.

module 2

Intermediate in Excel

+

-

  1. Setting the stage

    This lesson sets the stage being the Excel workspace. It covers the very basics of navigating Excel starting from opening and closing a workbook. You will get an introduction to the keyboard shortcuts, basic formatting and even four basic functions. The lesson ends with a practical where you will use all the skills acquired throughout the lesson to do simple data entries and create your first list.

  2. The blank canvas

    This lesson focuses on our blank canvas upon, which to create spreadsheet masterpieces. It builds on the basics of lesson 1 and introduces even more formatting options. Here you will learn about managing data across more than one worksheet and more than one workbook. You will venture into the Insert tab and create your first table.

  3. Sheets, tables, and things

    This lesson focuses on the area in Excel where few dares to venture, so we go backstage to look at the File tab. This lesson also focuses on a tool for working efficiently in Excel by linking cells, worksheets and workbook and a new function, the handy SUMIF, is unpacked to add to your repertoire of functions.

  4. Keep organised

    This lesson pays special attention to tools to keep organised in Excel. This includes exploring simple date functions, sorting, and filtering data. A key concept is explained, being absolute and relative referencing that will stand you in good stead to be able to work even more efficiently in Excel.

  5. The code of conduct

    This lesson focuses on the integrity of data and the skills acquired to do so comprise using outlines to group data, flash fill, removing duplicates, adding control checks, using spellcheck and creating basic dropdown lists. Added extras will be learning another function, AVERAGE as well using cell styles and the thesaurus.

  6. Lights, camera, action!

    This is a very practical lesson and covers one of the main acts, charts and graphs. These are the stars of the show being the tools you can use to visually represent your data and adds professionalism to any spreadsheet or report. This lesson covers two basic types of graphs, which will be more the sufficient to get you started with presenting meaningful data.

  7. Getting into shape

    This lesson is also very practical and fun where you get to be a bit more creative. You can add your personal touch to presentations by adding in shapes or using SmartArt to illustrate information in a particular way. Other useful tools that will be covered include people graphs, slicers, icons and 3D models.

  8. Keep it clean

    This is an action-packed lesson with a focus on using accurate data. The first step to achieving accurate data is ensuring it is cleaned. To do this you will learn the TRIM and CLEAN functions. You will take sorting one step further to be able to sort using multiple levels and highlight duplicate records using conditional formatting. You will also learn some extra keyboard shortcuts to find data quickly. This lesson also covers print settings, so you can keep hard copies of your hard work after finalising your data.

  9. Creating footprints

    The lesson focuses on creating footsteps for someone to follow in as we will be learning all about templates, what templates are available and even how to create your very own template. Added extras covered will be building on conditional formatting and uncovering the options available to us in this useful command. If you are all for saving trees, this lesson will also show you ways to create PDF versions of your workbook.

  10. A helping hand

    There are many safety nets available in Excel with multiple ways to access the Help function being the key one. This lesson focuses on all the support available to Excel users and how to access them within the application. We will also discuss customising the Excel workspace to make it really feel like home. Being the last lesson for Module 1, this lesson will culminate all the basic skills acquired throughout the module into an exciting mini project, where you will create your very own personal monthly budget template that you can begin using straight-away.

module 3

Advanced in Excel

+

-

  1. More Functions and Formulae

    A more complex look at the variety of available functions and formulae.Topics covered in this module include: - More Functions and Formulae - Naming cells and ranges - Common worksheet errors - Displaying and printing formulae - Using the COUNT function 5 - Using the IF function - Exercise / Solutions - Summary

  2. Automating Your Work with Macros

    In this excel class, learn how to generate and run Macros to make workflow more quickly and smoothly.Topics covered in this module include: - Automating Your Work with Macros - Recording a macro - Replaying a macro - Exercise / Solutions - Summary

  3. Importing Data

    Using Data from a variety of external sources and how to effectively import it into Excel. Topics covered in this module include: - Importing Data - Importing from text files - Importing from Microsoft Access - Exercise / Solutions - Summary

  4. Working with Tables

    How to generate tables and use the versatile range of options to filter and view the data. Topics covered in this module include: - Working with Tables - Sorting a table of records - Filtering a table of records - Subtotalling a table of records - Exercise / Solutions - Summary

  5. Creating and Formatting Data

    Viewing data within a Workbook more efficiently by changing the format and additional formatting options. Topics covered in this module include: - Creating and Formatting Data - Combining cell contents - Using conditional formatting - Creating a custom number format - Creating a custom date format - Creating and applying a style - Exercise / Solutions - Summary

  6. Creating and Formatting Content

    Adding external or internal content to enhance Workbooks. Topics covered in this module include: - Creating and Formatting Content - Inserting clip art - Inserting graphics - Moving graphics - Resizing graphics - Formatting graphics - Creating and modifying diagrams - Moving and resizing diagrams - Formatting diagrams - Annotating a chart - Filling data series with pictures - Changing the chart type - Manipulating pie charts - Selecting and saving a chart template - Exercise / Solutions - Summary

  7. Thesaurus and Research

    Using the Thesaurus and Research options to highlight and correctly collate external sources. Topics covered in this excel course module include: - Using the Research Tool - Using the Thesaurus to find synonyms - Using research services - Exercise / Solutions - Summary

  8. Validating Data

    How to set Validation to ensure that errors are not introduced into a Workbook. Topics covered in this module include: - Validating Data - Using totals as visual checks - Using formulae for automatic checks] - Using the Range Finder - Auditing a worksheet - Using error checking - Watching and evaluating formulae - Exercise / Solutions - Summary

module 4

Proficient in Excel

+

-

  1. Importing Data into Excel

    How to import data from external sources, Databases, Websites as well as other Workbooks into Excel.Topics covered in this module include: - Importing Data into Excel - Importing from an external data source - Using a database query -Importing data from a Web page - Exercise / Solutions - Summary

  2. Advanced Tables

    This online class takes a more complex look at data management by using Tables in Excel. Topics covered in this module include: - Advanced Working with Tables - Creating an modifying a table - Using data forms to manage tables - Using advanced filters - Using subtotals - Grouping and outlining data - Using data validation - Circling invalid data - Exercise / Solutions - Summary

  3. Analysing Data with Automated Tools

    Using automated tools for data and validation. Topics covered in this excel course module include: - Analysing Data with Automated Tools - Using the Analysis ToolPak - Using Goal Seek - Using a data table - Using the Solver - Exercise / Solutions - Summary

  4. Analysing Data with Scenarios

    Setting Scenarios to ascertain a variety of 'What if?' results. Topics covered in this module include: - Analysing Data with Scenarios - Creating and showing scenarios - Merging scenarios - Creating a scenario report - Exercise / Solutions - Summary

  5. Using Pivot Tables and Pivot Charts

    How to use Pivot Tables and generating Pivot Charts. Topics covered in this online excel class include: - Using PivotTables and PivotCharts - Creating a PivotTable report - Specifying the data to analyse - Modifying a PivotTable report - Updating a PivotTable - Grouping dates in a PivotTable - Using the Report Filter area - Drilling down to the detail - Changing the type of calculation - Filtering in a PivotTable - Grouping data in a PivotTable - Sorting PivotTables - Formatting a PivotTable - Charting a PivotTable - Exercise / Solutions - Summary

  6. Analysing Data with Functions

    Using the wide range of Excel functions to analyse data. Topics covered in this module include: - Analysing Data with Functions - Using the Lookup functions - Using the Conditional Sum Wizard - Using Database functions - Exercise / Solutions - Summary

  7. Protecting Cells, Sheets, and Workbooks

    Setting security and passwords to protect data stored on Worksheets as well as hiding functions and files. Topics covered in this module include: - Protecting Cells, Sheets, and Books - Protecting cells - Protecting worksheets - Protecting workbooks - Attaching and viewing digital signatures - Adjusting macro settings - Exercise / Solutions - Summary

  8. Collaborating with Others

    How to share data and Excel Workbooks with others in a workgroup as well as other collaborators online.Topics covered in this module include: - Collaborating with Others - Creating a shared workbook - Viewing and removing users - Resolving conflicting changes - Viewing the change history - Comparing and merging workbooks - Tracking changes to a workbook - Accepting and rejecting changes - Removing workbook sharing - Exercise / Solutions - Summary

  9. Managing Data and Workbooks

    Correctly managing Data and Workbooks for effective and efficient Saving and Storage. Topics covered in this module include: - Managing Data and Workbooks - Publishing workbooks as Web pages - Creating a workbook template - Editing a workbook template - Consolidating worksheets - Hiding columns, rows, sheets, and books - Saving a custom view - Viewing and changing workbook properties - Exercise / Solutions - Summary

Certified by
Globally recognised by
  • Weeks
    19 Weeks

    Duration

  • lessons
    37 Lessons

    Plus assessments

  • modules
    4 Modules

    Online

  • course
    Globally Recognised

    Certification

Avg. Rating

4.6/5

4.5

Plenty of good and practical information! I know I'm gonna return to Shaw Academy for other courses.

4.8

The teachers at Shaw Academy are absolutely amazing, thank you so much for everything you have helped me with so far!

You might also like

Course Benefits

Flexible online classes
You pick the schedule.
Pause course
Take a break any time.
Educator support
Always get your answers.
Offline mode
Download class recordings.
Globally Recognised Courses
International focus to curriculum.
UNLIMITED Courses
One plan - All content.

Start building your future, your way.

Access to all 100+ courses including:
  • Live educator chat support
  • 20+ hours of learning per course
  • Exams & continuous assessments
  • Unique lessons curated by in-house experts
  • Lifetime access to all lessons
  • Globally accredited certifications

$49.99 / month

FREE for 4 weeks

Start your free course

No commitment

FREE for 4 weeks

No Commitment