CalendarIntroduction to Excel Spreadsheets Course ( 3 Courses ) See Dates/Register
-
Introduction to Spreadsheets (Microsoft Excel)
This course is designed for new users of Spreadsheets / Excel and those who have been Self Taught. We cover all areas of creating a spreadsheet including entering Excel formulas. Can be used in preparation for MOS Excel Core Exam or ECDL Excel Test. -
Excel Basics
- Introducing the Ribbons
- Workbooks, Worksheets, Rows, Columns, Cells
- Selection Techniques & Mouse Shapes
- Saving, File Types, Compatability
- The File Tab
- Page Layout View
- Getting Help
- Inserting Files
Entering, Selecting & Editing Data
- Entering, Editing, Deleting Data in Cells
- Using the Fill Handle
- Inserting/Deleting Rows, Columns & Cells
- Insert/Deleting/Moving/ Renaming/Copying Sheets
- Creating Custom Lists
Creating Formulas and Functions
- Creating/Editing/Copying Formulas
- Using AutoSum
- Common Basic Functions
- Using the Formula Tab
- Relative and Absolute Cell References
Formatting Cells, Rows, Columns & Sheets
- Formatting Cells Options
- Applying Borders and Shading
- Changing Column Widths
- Changing Row Heights
- Clearing Formats
- Using Format Painter
Charts, Graphs and Data Sort
- Create Simple Charts
- Editing Charts
- Formatting Charts
- Sorting Data
- Auto Filter
Printing
- Print Preview & Page Orientation
- Adding Headers and Footers
- Printing a Selection & Setting a Print Area
- Adjusting Page Breaks using Page Break Preview
- Changing Margins
- Centre on Page
-
For those who need excel skills for their work or want to have an edge over others. Learn about creating & editing spreadsheets entering data for records. Useful for jobs in Human Resources, Accounting, Finance or Research and Development.
-
You must have good basic knowledge of a computer and good working Knowledge of Word Processing.
Introduction to Excel 1 Day Nov
Introduction to Excel Spreadsheets 1 Day Course
Times: 10am to 5pm
Thursday 28th November 2019
Small group size & limited places
Times: 10am to 5pm
Thursday 28th November 2019
Small group size & limited places
| Course Date | 28-11-2019 10:00 am |
| Individual Price | €150.00 |
Introduction to Excel 1 Day Dec
Introduction to Excel Spreadsheets 1 Day Course
Times: 10am to 5pm
Tuesday 17th December 2019
Small group size & limited places
Times: 10am to 5pm
Tuesday 17th December 2019
Small group size & limited places
| Course Date | 17-12-2019 10:00 am |
| Individual Price | €150.00 |
Introduction to Excel 1 Day Jan 2020
Introduction to Excel Spreadsheets 1 Day Course
Times: 10am to 5pm
Tuesday 14th January 2020
Small group size & limited places
Times: 10am to 5pm
Tuesday 14th January 2020
Small group size & limited places
| Course Date | 14-01-2020 10:00 am |
| Individual Price | €150.00 |
