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 | Data Selection & Range Names Data Selection Techniques Cell & Range Names The Name Box Edit the Cell or Range Name Introduction to Excel Tables Create & Modify Tables Special Functionality of a Table Convert a Table to a Range Dates & Times in Excel The TODAY/NOW Functions The DAY/MONTH/YEAR Functions Sorting Quick Sorts Custom Sorts Sort from Left to Right Sort by Custom Lists Create Custom Lists for Sorting |
| Module 2 | Filtering Types of Filters Clear Filters from The Entire Database Top Ten Filter Filter Months Custom AutoFilters Understand the AND/OR Turn Off the Filter Advanced Filter Duplicate Records Highlight Duplicates with Conditional Formatting Filter Unique Records Only Remove Duplicate Records |
| Module 3 | Relative & Absolute References Change a Formula Reference from Relative to Absolute Use Naming Cells for Absolute References Work with Text Functions The UPPER Function The LOWER Function The PROPER Function Paste Values The CONCAT Function Text to Columns Separating One Column into Multiple Columns The Delimited/Fixed Width Option Create Links Between Different Worksheets Link Cells with Copy & Paste Link Link Different Workbooks Open Linked Workbooks Edit Links Change Source Workbooks Break Links Between Workbooks Hyperlinks Consolidating Worksheets Subtotals Outline a Worksheet Create a Manual Outline Remove an Outline Protect Worksheet Protection Protect Workbooks File Password Protection |
| Module 4 | Excel Options Split/Freeze Panes Data Validation Validate Data Apply Data Validation Invalid Data Remove Data Validation Create Dropdown Lists using Data Validation Transpose a Range from Vertical to Horizontal Move/Copy Sheets Document Worksheets using Comments |
| Module 5 | Create/Modify Charts Chart Types Insert/Remove Gridlines Format Text & Numbers Scale & Customize an Axis Use Advanced Chart Features Dual–Axis Charts Trendlines Chart Templates |