Excel Training - Introduction
Excel training combining practical exercises and tuition to unable the participant to grasp the basics of using Microsoft® Excel. The participant will understand the similarities and differences between Microsoft® Excel and Microsoft® Access and in particular when to use Excel. During the course the participant will develop a spreadsheet to perform monthly financial tracking, will learn how to format the spreadsheet to enhance readability and to produce charts to display information graphically.
Course content:
- An introduction to spreadsheets
- Working with Workbooks, Worksheets and Cells
- Working with Columns and Rows
- Working with Views
- Navigation
- Organising and Arranging data
- Formatting data
- Toolbars
- Customising the workbook
- File management
- Sorting
- Formulas and Functions
- Templates
- Creating charts
Course duration 1 day.
Course Prerequisites. The course assumes the participant will have a basic understanding of personal computers and Microsoft ® Windows. No previous knowledge of spreadsheets or Microsoft ® Excel is required.
