MICROSOFT EXCEL: THE BASICS
with David Cox, ICT Consultant.
An introductory level course covering a wide range of procedures, using practical exercises. Learn how to build worksheets and databases, create charts and use time-saving techniques and tools. Relevant to both PC and Macintosh.
RECOMMENDED FOR
Anyone who has a need to use a spreadsheet for financial analysis and other numerical analysis, or using a spreadsheet for managing lists.
REQUIREMENTS
Basic mouse/keyboard skills required.
Course enquiries: Christy Dangerfield- cdangerfield@ccgs.wa.edu.au
Tuesday 6 - 8pm September 2, 9, 16 & 23 $285.00. Limit: 13
BOOK THIS COURSE ONLINE
NOW!
Type in the unit code or course title to locate the enrolment page.
DOWNLOAD THE ENROLMENT FORM (PDF)
|
What is covered in this course
- Entering/Deleting Text and Numbers
- Entering and Modifying Formulas
- Repeating Calculations
- Relative and Absolute Referencing
- Common Functions (eg, sum, average, count)
- Naming Cells
- Creating a Series of Numbers
- Formatting the Spreadsheet
- Modifying Rows or Columns
- Reviewing Formulas
- Comments
- The Chart Wizard
- Embedded Charts
- Editing and Formatting/Deleting Charts
- Drawing Tools
- Sorting Data
- Searching for Data
- A glance at more advanced topics (Amount and detail depends on time available)
Examples
can be saved to CD at the
end of the session, so please bring a
blank CD.
|
 |