Excel Spreadsheets Training - Intermediate to Advanced - Full Lesson
Resource bundle include PowerPoint Presentation, lesson plan and Task Booklet (10 tasks, 15 pp)
Importing delimited data
Advanced sorting of lists
Advanced filtering of lists
Pivot tables
Formulae and functions: IF and VLOOKUP
The PowerPoint presentation will serve as a visual aid during the training, explaining concepts and demonstrating examples. The lesson plan will provide a detailed outline for the trainer, including suggested timings and activities. The task booklet will contain a series of 10 practical tasks with step-by-step instructions and sample data for participants to practice and apply the learned skills.
Examples of scenarios covered:
Importing records of employees saved as delimited text and sort this list in hierarchical order (Director, Manager, Supervisor…)
Using advanced filtering to find invoices; invoice numbers less than 170 and amounts of more than £1,000 excluding
Creating and updating a pivot table for a list of people surveyed so that the data items in the pivot table are a count of the people surveyed, organised by town and subdivided into gender
Using a Lookup function to search a product code in a table of products and return the description of the product or its unit price, without copying and pasting it.
Using the IF function to calculate travel expenses refunds when mileage is differentiated into two different tiers. e.g. Each employee is reimbursed £0.35 per mile for the first 500 miles travelled (Tier 1) and £0.25 thereafter (Tier 2).