Excel Introduction | 6 Dec 2021

Introduction to Microsoft Excel

This is a 1-day introductory course helping you unlock the maximum potential of this popular data-analysis tool. After completing the course, you will feel empowered with key skills to create and edit worksheets, implement formulas and functions, visualise data in a consumable and professional format, and much more.

If you are not sure , contact us to assist you choosing the relevant level of training and we can work with your live files in order to achieve maximum productivity.


Introduction

  • What is a Spreadsheet
  • Starting Excel
  • Parts of the screen
  • Quitting Excel

Basic Skills

  • Cursor movement
  • Using Go To
  • Highlighting areas of the worksheet
  • Entering data
  • Editing a cell entry
  • Deleting a cell or range of cells
  • Undoing the last command
  • Redoing the last command
  • Drag and drop
  • Filling a range
  • Insert and delete
  • AutoComplete
  • Inserting deleting rows and columns
  • Smart Tags
  • Opening, closing and saving
  • Creating a new file
  • Viewing a list of open files
  • Version compatibility
  • Email a spreadsheet
  • File search

Entering Formulae

  • Entering simple calculations
  • Circular references
  • Using AutoSum
  • Using Paste Function
  • Statistical functions
  • Relative and absolute cell referencing
  • Formula auditing mode
  • Printing cell formulae
  • Using Auto Calculate
  • Error correction
  • Screen tips for function arguments

Formatting

  • Using the formatting ribbon
  • Adjusting column widths and row heights
  • Changing cell alignment
  • Formatting numbers
  • Changing fonts and attributes
  • Borders and patterns
  • Using the shortcut menu
  • Copying styles
  • Cut, copy and paste
  • Copying data into Word

Printing

  • Print preview
  • Changing the page setup
  • Defining the print area
  • Printing
  • Inserting a page break
  • Page break preview

Charts and Drawing

  • Creating a chart
  • Changing the chart type
  • Using the drawing tools

Delivery: Online (live)
Level: Foundation
Course Dates : 6 Dec 2021
Day & Time:
Week Days
Weekend
Daytime
Evening
What is included:
VAT
Breakfast
Lunch
Refreshments
Digital courseware
Digital Recording
Printed courseware
Accommodation
Extra revision sessions
Venue: Virtual Live Meeting
Training Instructor accredited by: Microsoft (MCT)
Style:
Authoritative
Challenging
Inspiring
Methodical
Starts: December 2021
Duration: 1 day or less

Public discussion (0)

You must log in to send a new comment.