Excel Training
Brief Description
This one-day training course aims to give basic users of Excel knowledge of commands and functions which will make them more proficient in spreadsheet design and development. How to apply these tools to solving their own business problems and good spreadsheet practice will also be covered.
Accreditation: Certificate of attendance
Course Duration: 1 Day
Maximum number participants: 6
Prerequisites: None
Price: £120+VAT
What Will be covered?
Functions
- Date function
- Time function
- Round function
- IF function
- Integer function
Cell Addressing
- Absolute cell addresses
- Relative cell addresses
Conditional Formatting
- Applying conditional formats to text
- Applying conditional formats to numerical values
- Clearing rules
Database Features
- Using a spreadsheet as a database
- Sorting data
- Basic subtotals
- Filtering data with Filter
- Custom Filter
- Define a range as a table
- Find Feature
Working with Multiple Sheets
- Selecting sheets
- Inserting & deleting sheets
- Copying sheets
- Copy and paste between sheets
- Naming sheets
- 3D calculations
- Group edit facility
- Using Hyperlinks to link worksheets
Working with Multiple Workbooks
- Opening multiple workbooks
- Arranging windows
- Linking workbooks
- Hyperlinks to worksheets and workbooks
Additional Features
- Inserting comments
- Charting
- Revision of basic charts
- Chart types
- Sizing and moving a chart
- Editing a chart
- Changing chart data
- Formatting chart elements
- Drawing features
- Printing a chart
Cancellation Policy
The full cost of the course is to be paid before the start of the course.
If you cancel your place you will be liable for 100% of the cost. Unless a cancellation is received in writing 14 days prior to the commencement
