
A one-day instructor led workshop providing an introduction to the basic skills for working with Excel. By the end of the course delegates will be able to create, modify and print Excel spreadsheets, write simple formulas and build basic charts.
Pre-Requisites
To optimise the training, it would be best if attendees were able to select and open menus and icons and have a working knowledge of a computer keyboard, i.e. Shift, Ctrl, TAB and Home keys on the keyboard
At the end of this course you will be able to:
- Create a basic worksheet
- Perform calculations in an Excel worksheet
- Modify an Excel worksheet
- Format a worksheet
- Create charts
- Print the content of an Excel workbook
Duration – 1 day
Course Content
Getting Started with Excel
- Tour the Excel Screen
- Creating a new Excel workbook
- Entering and editing labels and values
- Selecting cells and data ranges
- Moving and copying data
- Saving and updating a workbook
- Navigate and Select Cells in Worksheets
- Customise the Quick Access Toolbar
Calculations in an Excel Worksheet
- Creating new formulas
- Using SUM function
- Using AVERAGE, MIN, MAX and COUNT
- Using Autofill
- Copying formulas and functions
- Editing formulas and functions
Modifying a Worksheet
- Edit Worksheet Data
- Find and Replace Data
- Using Sorting and Filtering
Modifying a Worksheet Structure
- Formatting text
- Formatting rows and columns
- Formatting numbers
- Inserting rows and columns
- Deleting rows and columns
- Freezing panes
- Splitting the screen
Creating Charts
- Creating a simple chart using Chart Wizard
- Formatting a chart
Printing Excel Workbooks
- Define the Page Layout
- Print a Workbook
Enquiry Request – Get In Touch