Gain a thorough understanding of intermediate and advanced features in MS Excel 2013. In this module, you will learn to create spreadsheets, charts, graphs, linked forms, and effective reports. This module is especially useful for individual wanting to work in an office environment or in an accounting function where financial reports are needed. The relationship between Excel and Access will be introduced.

Course Length

36 hours

Text Books

  • Microsoft Office Excel 2013 – Intermediate, CCI Learning Solutions, Courseware Developers: Sue Wong, ISBN: 978-1-55332-293-1
  • Courseware Download: http://ccilearning.com

    On CCI Learning Web Page Enter Courseware #: 3241

  • Microsoft Office Excel 2013 – Advanced, CCI Learning Solutions, Courseware Developers: Kenny Lee, ISBN: 978-1-55332-294-8
  • Courseware Download: http://ccilearning.com

    On CCI Learning Web Page Enter Courseware #: 3241

Method of Evaluation

  • Practical Exercises 20%
  • Participation 20%
  • Final Exam 60% (minimum 65%=pass)

Competencies

Knowledge

  • Understanding of all features and functions including Workbooks, Worksheets and Files
  • Understand formulas, how to present data,
  • Understand the value of Excel for presentations and as a problem-solving tool

Skills

  • Able to create and format a spreadsheet
  • Able to create formulas and functions
  • Able to create charts and use Excel to predict trends
  • Able to solve problems
  • Able to analyze and present data
  • Able to work between software applications to present reports
Microsoft Applications