Practical Beginner Excel 365

The only course you need to get started and feel comfortable working with Excel
Rating: 4.5 out of 5 (93 ratings)
4,793 students
English [Auto]

Learn common terms used in Excel and spreadsheets
Learn how to work with cells, columns and rows
Understand Autofill and Flash Fill options and how to use them
Learn how to cut, copy and paste
Learn how to format data
Learn how to set print options
Learn how to change views
Learn how and when to insert tables
Learn how to insert charts
Learn how to change chart elements


  • You must have a version of Excel to work with
  • No prior knowledge of Excel is required


Excel is the spreadsheet tool of choice for over 750 million people. Originally designed around the red books used by accountants with columns and rows, it was used to store information and carry out basic calculations. Now Excel is used for way more than that. Not only is it a powerful calculation tool and record keeper but it is also a tool for reporting and analysing.

With so many features and functions available getting started with Excel can be daunting to many. However, it doesn’t have to be difficult to learn Excel and this course is designed to take you step by step through the Basics of Excel.

By the end of this course, you will be comfortable navigating an Excel workbook, entering and formatting data, setting print options, inserting objects to a worksheet and much more.

This course is made up of 4 modules

Module 1 – Your First Look at Excel

Getting started with Excel can be daunting for many. There is so much to learn and knowing where to start can be difficult. What is a cell? What is the formula bar? Don’t you use ribbons for your hair? If all this jargon is foreign to you, don’t feel alone. We are here to help. This module is aimed at those looking at Excel for the first time.

By the end of this module you will be able to

· Open and Save Workbooks

· Navigate the Ribbons to find commands you need

· Enter Data and formulas

· Navigate a workbook and select data

· Edit the quick access toolbar

Excel is equipped with many tools to help you work with data. Basic tools, such as autofill can reduce the time you spend entering data, Sort and filter will allows you quickly find and work with contents of a worksheet with ease and formatting will allow you present your report in an easy to understand way. Learning to modify your data with these basic tools

By the end of this module you will be

· Comfortable using Autofill

· Know how to cut, copy and paste

· Have the ability to sort and filter data

· Able to present your data in a formatted Style

Module 3 – Print and View Options

There is nothing worse than receiving a workbook prepared by someone else only to print it and find the print options have not been adjusted. Before you print a workbook or worksheet or before you share the workbook with someone else that may print it, you should always check to ensure print options are set correctly. By the end of this module you will be able to

· Preview and print

· Adjust page, margin and sheet options for printing

· Insert Headers and Footers

· Freeze panes

· Switch between different views available in Excel

Module 4 - Insert Options

Excel gives you the ability to insert picture, shapes, tables, charts, slicers and many other features that enhance the view and user functions of your workbooks and worksheets. Tables are often used to quickly summarize data along with charts, slicers and sparklines. By the end of this module you will be comfortable

· Inserting and format pictures and shapes

· Inserting tables

· Inserting and formatting charts

· Using slicers, timelines and sparklines

Who this course is for:

  • This course is NOT suited for experienced Excel users
  • This course is aimed at those new to Excel or those that really need a basic refresher Excel course

Course content

4 sections51 lectures2h 0m total length
  • Introduction
  • Module 1 Introduction
  • Before you forget
  • Excels Help features
  • How do I open and save an Excel Workbook?
  • Opening and Saving Workbooks
  • What are the Ribbons
  • Excel Orientation
  • How do I enter data to excel
  • How do I add a formula?
  • Entering data and formuals to Excel
  • How do I navigate a workbook and select data?
  • How do I use and edit the quick access tool bar?
  • The quick access toolbar
  • Learn and Earn Activities
  • Module 1 basic excel quiz
    5 questions
  • Module 1 practice
    1 question
  • Module 1 Conclusion


Microsoft MVP, CPA Accountant, & Life Long Learner
Paula Guilfoyle CPA & MVP
  • 4.3 Instructor Rating
  • 10,336 Reviews
  • 116,620 Students
  • 25 Courses

Paula is a qualified CPA with over 15 years' experience in the fields of Accountancy, Business Management, Process improvement, Internal Audit, Group accountant, Operations Management and Training. All across a broad range of industries and sectors.  Paula has been Key Speaker at many Accounting Events where her talks on Excel are received very positively. Taken from her experiences in Accounting and business fields, Paula also has Udemy courses for those wishing to upskill, especially in the area of Spreadsheets, Bookkeeping and Accounting.

In 2020 Paula was awarded with a Microsoft MVP award for her dedication to Excel and the Excel community.