Category
ICT
Course Type
Microsoft
Price Per Course
£595 for any two half day courses +VAT
On-Site at Customer Premises, Max 10 Delegates
Duration
Half day
Full/Part Time
Part Time
Provider
Dates and Locations
Contact us for the latest course dates.
Book courseThis course is intended for users who have been working with spreadsheets created by others and now need to be able to build their own spreadsheets and create automated calculations using formulae and functions.
Objectives:
By the end of the course users will be able to create spreadsheets, which include simple calculations, as well as use some of the popular functions, such as Sum, Min, Max, Average and Count. They will also be able to create calculations containing multiple operators with the effective use of brackets and understand the importance of Relative and Absolute cell references when copying formulae.
Prerequisites:
Users must be able to create simple spreadsheets and be able insert and delete columns and rows and apply basic text and number formatting.
- Navigating, Selecting & Entering Data
- Entering Data with AutoFill
- Undo Errors
- Modifying Column Widths & Row Heights
- Introducing the Formula Bar
- Entering Simple Calculations
- Moving & Copying Formulae
- Absolute & Relative Cell Referencing
- Introducing Functions
- Adding Numbers with AutoSum
- Circular References & Errors
- Creating Statistical Functions
- Sum
- Average
- Min
- Max
- Count
- What is an IF Function?
- Creating an IF Function
- Calculating Percentages
Enquire about a course
Fill in your information to apply for this course. The information you provide on this application form may be passed to funding bodies, in line with the Data Protection Act 1998, and may be shared with other training providers and possible employers for the purpose of administration, statistical and research purposes.
