Excel Boost for Beginners

New to Excel, or just feeling like there are fundamental gaps which leave you unsure about creating or modifying spreadsheets or working with calculations? Then Excel Boost is the tonic you need. In this action-packed course, we will cover all the essential skills to get you creating professional automated spreadsheet solutions with speed and confidence.

Public Sector Network · 1 March 2022

INTRODUCTION

The course consists of 5 modules, each module has 5-6 practical videos of around 6 minutes each, where you’ll learn best practise and get to apply the skills in a worked activity. After each video there’s a quick  skill check and at the end of each module you get another optional practise exercise, a cheat-sheet summarising key elements for that module and another quiz.



LEARNING OBJECTIVES

Module 1 – Creating a Spreadsheet   

  • Getting Oriented
  • Enter and Edit Data
  • Using the Fill Handle
  • Cut, Copy and Paste
  • Work with Columns and Rows

Module 2 – Formatting a Spreadsheet

  • Formatting Tools
  • Alignment Options
  • Number Formats
  • Cell Styles and the Format Painter
  • Conditional Formatting

Module 3 – Performing Calculations

  • Simple Calculations Intro
  • Calculations that Multiply and Divide
  • Sum Function
  • Average, Max and Min
  • Order of Operations
  • Absolute Cell References

Module 4 – Managing Large Spreadsheets

  • Managing Multiple Sheets
  • Sorting and Filtering Data
  • Freeze Panes and Split Screen
  • Page Layout and Printing
  • Calculations across sheets

Module 5 – Working with Charts

  • Creating Charts
  • Modifying Charts
  • Line and Area Charts
  • Pie & Doughnut Charts
  • Creating a Simple Dashboard     

ABOUT TRAINER

Experienced and dynamic information technology trainer with 15 years commercial experience in the IT industry. I deliver and design training programs to help people use technology confidently and effectively in their workplace.


GETTING THE MOST OUT OF THIS COURSE


FIRST LESSON FREE FOR LIMITED TIME!

To celebrate the launch of the Academy we are offering free access to the first lesson of this training material.

You can view the first lesson of Excel Boost for Beginners below.


Course Content

Expand All

About Instructor

+14 enrolled

You will need to be a Public Sector Network member to access this course.

If you already have a community member account, please login by clicking the login button below.

If you are not yet a member you can sign up for free here: Signup

Login to access this course

Course Includes

  • 11 Lessons
  • 26 Topics
  • 27 Quizzes
  • Course Certificate