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 need to organise, and manipulate large volumes of data.
Objectives:
By the end of the course users will be able to manage data lists and create automatic subtotals and grand totals. They will be able to validate data entry, sort & filter data, use conditional formatting to monitor and visualise data, and use table functionality.
Prerequisites:
A thorough grounding in building basic spreadsheet models including inserting & deleting rows & columns, creating simple calculations, and using statistical functions such as Min, Max & Average.
- Structuring Data Lists
- Freezing Worksheet Titles
- Naming a Cell or Cell Range
- Changing & Deleting Names
- Highlight Cells with Formatting Rules
- Formatting Ranges with Top/Bottom Rules
- Data Visualisations
- Creating Custom Formatting Rules
- Rules Manager
- Sorting Data by Single/Multiple Columns
- Filtering List Data
- Defining Custom Filters
- Adding Subtotals
- Grouping & Outlining Data
- What are Tables?
- Converting Ranges into Tables
- Modifying Tables
- Validating Text, Values & Dates
- Creating Input Messages
- Error Alerts
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.
