20% of this week’s places have been filled.

Start your course now to guarantee your place.

Course Content

free

Diploma in Excel

  • Setting the Stage

    This lesson 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 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.

  • 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 be introduced to further 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.

  • Sheets, Tables, and Things

    This lesson 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.

  • 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.

  • Code of Conduct

    This lesson 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.

  • Lights, Camera, Action!

    This is a practical lesson and covers one of the main acts, 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.

  • 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.

  • Keep It Clean

    This lesson 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.

  • Creating Footprints

    The lesson focuses on creating footsteps for someone to follow in as you learn all about templates, what templates are available, and how to create your own template. You will also learn how to build on conditional formatting and uncover the options available to you. If you are all for saving trees, this lesson will also show you ways to create PDF versions of your workbook.

  • 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.

Hide Lesson List

Intermediate in Excel

View Lesson List

Advanced in Excel

View Lesson List

Proficient in Excel

View Lesson List

44,932

Graduates
All Levels
Certified
4
Modules
16
Weeks
32
Videos
Start your free course

Globally Recognised

Cancel Anytime

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!

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.

The more you learn, the less you pay!

Just

28 Days free trial

Access to ALL our courses

Cancel Anytime

Start your free course

Your future, your way.