fbpx

Beginner Excel*

8.png

Description

The aim of this course is to give you an introduction to Excel and enable you to get familiar with formulas, basic functions, data entry, and how to navigate around the programme.

Duration

1 day

Content

  • Identify the Excel icon and access the programme
  • Get familiar with the Ribbon
  • Enter dates/numbers/text and understand the difference between them
  • Create simple formulas: add, subtract, divide, multiply
  • Understand rows, columns, cell, and range
  • Know how to enter formulas and text, and how to copy formulas
  • Learn the Sum, Max, Min, Average, Count, CountA functions
  • Know how to insert rows and columns
  • Printing: using scaling and print titles
  • Create a simple chart from recommended chart options
  • Absolute and relative formulas (fixing cells)
  • Using a list in Excel – sorting and filtering
  • Worksheets: renaming, moving, copying, changing tab colour
  • (If time allows) Simple If Statements and/or Conditional Formatting