Microsoft Excel Intermediate
COMPUTER SKILLS
Computer skills are a valuable addition to any employee’s personal portfolio and can greatly increase your desirability to employers.
Overview
This one-day course is designed to help a delegate to develop intermediate skills in using Microsoft Excel as a spreadsheet tool.
Objectives
- Data selection techniques
- Using Tables
- Sorting and Filtering data
- Working with Text functions
- Creating Links between different worksheets and workbooks
- Subtotals and Outlining a worksheet
- Worksheet and workbook Protection
- Creating Charts
Course Prerequisite
Language of Delivery
English
Delivery Methods
Course is facilitated by a competent & experienced subject matter trainer, who utilises the following techniques to ensure that the session is practical and experiential:Â Questions; Discussion; Exercises & Assessments.
Who should attend?
Any delegate wanting to develop their skills in using Microsoft Excel to design spreadsheets to solve accounting and data analysis tasks.
Duration
1 Day
Includes:
- Comprehensive Manual
- Lunch & Refreshments (not applicable to on-site training)
- Electronic Certificate (on successful completion of the course)
- Electronic Trainer Feedback Report
- Electronic Delegate Feedback Questionnaire
Course outline
| Module 1 | Creating a Database Naming a List or Database Range Data Selection Techniques Creating Excel Tables The Table Tools Design Tab Adding Totals to a Table Converting Tables to a normal Excel Range Understanding Dates The Month Function The Year Function Sorting – Quick Sorts, Custom Sorts Sorting in a Special Order |
| Module 2 | Filtering Data Using the AutoFilter Types of AutoFilters Top Ten Filter Filtering Months Custom AutoFilters Turn the Filter Off Using the Advanced Filter Dealing with Duplicate Records |
| Module 3 | Relative and Absolute References Concatenate Function Copy and Paste Link Create Links in the same Workbook Create links across different Workbooks Edit External Links Change Linked Source Workbooks Breaking Links between Workbooks Arrange Open Workbooks Hyperlinks Link between Excel and Word Consolidate Worksheets Subtotals Nested Subtotals Outline a Spreadsheet Manually |
| Module 4 | Control Worksheet Display Splitting of Panes Freeze Panes Validate Data Create Dropdown Lists Text to Columns Transpose Add, Edit and Delete Comments Protect Worksheets Protect Workbooks Workbook Password Protection |
| Module 5 | Charts Chart Types Add and Remove Chart Elements Format Text and Numbers Format a Data Series Scaling and Customising a Value Axis Combo Charts Dual Axis Charts Trendlines Chart Templates |
| Module 6 | Graphics Manage Drawings Group and Ungroup Shapes Insert WordArt Insert SmartArt Graphics |