This one-day course is designed to help a delegate to develop intermediate skills in using Microsoft Excel as a spreadsheet tool.
English
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.
Any delegate wanting to develop their skills in using Microsoft Excel to design spreadsheets to solve accounting and data analysis tasks.
1 Day
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 |