Beginners Excel

75.00

To give the novice Excel user an introduction to Excel and enable him/her get familiar with formulas/basic functions/data entry and how to navigate around the programme.

SKU: G1070519 Category: Tags: , ,

Description

To give the novice Excel user an introduction to Excel and enable him/her get familiar with formulas/basic functions/data entry and how to navigate around the programme.

  • Identify the Excel icon and access the programme.
  • Customise the Quick Access Toolbar
  • Get familiar with the Ribbon – locate previous commands (if upgrading from Excel 2003)
  • Understand rows, columns, cell and range
  • Know how to save files in the different formats and how to “pin” a frequently used file
  • Sum, Max, Min, Average, Count, CountA functions
  • Know how to enter formulas, and text and how to copy formulas.
  • Format numbers and text
  • Create simple formulas : add, subtract, divide, multiply
  • Know how to insert rows and columns.
  • Printing: Use scaling, headers and footers Create a simple chart
  • Absolute and relative formulas (fixing cells)
  • Using a list in Excel – sorting and filtering
  • Create simple formulas
  • Worksheets : renaming, moving, copying, changing tab colour
  • (If time allows) Simple If statements and/or Conditional formatting being a source of tension and a reduction in overall team performance.

Trainer Website:

The Excel Expert

The Excel Lady

Event Details

Day 1: May 28, 2019

Start time: 09:30 a.m.

End time: 16:30 p.m.

Venue: TBC