This session is designed
for individuals wanting to develop their skills in using Microsoft Excel to
design spreadsheets to solve basic accounting and data analysis tasks. We will cover the following topics:
Data Lists Create a data list • Use a form to
view, sort, and enter records • Perform single and multi-level sorts • Filter a
list using AutoFilter
Borders and Shading Apply cell borders and shading •
Apply AutoFormat
Viewing a Large
Worksheet Go
To a specific cell or named range • Split a worksheet into different viewing
panes • Freeze and unfreeze panes as worksheet titles • View a workbook in
multiple windows • Hide and unhide rows and columns • Hide and unhide
worksheets and workbooks
Managing Worksheets Switch between worksheets • Enter
and edit data on multiple worksheets • Copy data between worksheets and
workbooks • Insert and delete worksheets • Move and copy a worksheet • Rename a
worksheet • Change the colour of a worksheet tab
String, Date, and
Time Functions
Join strings (CONCATENATE, &) • Extract text from a string (LEFT, RIGHT,
MID) • Change case (UPPER, LOWER, PROPER) • Find and replace text within a
string (FIND, REPLACE, SUBSTITUTE, TRIM, CLEAN, LEN) • Convert between text and
number values (TEXT, VALUE, FIXED, DOLLAR) • Insert specific characters from
the Windows character set (CHAR, CODE) • Enter the date and time using
functions (TODAY, NOW, DATE, TIME) • Return selected parts of a date or time
value (YEAR, MONTH, DAY, HOUR, MINUTE, SECOND) • Perform calculations using
date/time values • Use other date functions (NETWORKDAYS, WEEKDAYS, WEEKNUM)
Statistical
Functions Use
counting functions • Use averaging functions • Use other statistical functions
(MIN, MAX, MEDIAN, MODE, STDEV)
Proofing Tools Use AutoCorrect • Use Find and
Replace • Check spelling across the worksheet
Adding Comments Add a comment • Review, edit, and
delete comments • Print comments
Distributing a
Workbook Save
a workbook as a plain text file • Save a workbook for a different application •
Save a workbook as a template