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. Cost: EUR 95
Description
Please Note:
Our training programmes are designed to support individuals who are currently employed and participating through their organisations. For this reason, places on our courses are available to employees who are nominated by their companies.
Unfortunately, we are not able to offer places on these programmes to individuals who are not currently in employment.
If you are currently unemployed and interested in developing your skills, we encourage you to explore our Skills Connect programme, which is specifically designed to support people who are seeking employment.
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
