This module is designed as refresher training for users of MS Excel focusing on some of the basic methods used in creating and managing spreadsheet files.
Participants should be comfortable carrying out basic computing tasks such as managing files, sending and receiving email and browsing the internet. They will learn the fundamental skills required to produce, edit, and format and print basic spread sheets.
Topic List and Course Structure
Getting Started in MS Excel
- What is a spread sheet application
- Starting MS Excel
The MS Excel Screen
- The Ribbon
- The Formula Bar
- The Status Bar
- Cells and Sheets
- Getting Around
- Selecting Techniques
Working with Data
- Data Types
- Entering and Editing Data
- Moving and Copying Data
- Using AutoFill
Finishing a Workbook
- Saving, printing and closing workbooks
- Starting a Workbook
- Opening, creating and managing workbook files
Creating Simple Formula
- Formula examples
- Editing Formula
- Order of Operations
- Using Basic Functions
- Sum, Average, Min, Max and Count
- Using AutoSum
Number Formats
Target Audience: All members of staff who wish to improve their ability in MS Excel.
Duration: 3 Hours
All courses are bookable on the Upcoming Courses page
3 CPD credits awarded. Please contact staff_l&d@rcsi.ie if you need a certificate of attendance.