Microsoft Excel 2010 - Level 1 ebook

INF1015-E
978-1-925179-85-9
Colour PDF

This course aims to give the new spreadsheet user a thorough grounding in the basics of spreadsheeting and using Microsoft Excel 2010. Particular emphasis is placed on the importance of accuracy, good formula building techniques, and sound formatting and design principles.

At the completion of this course you should be able to:

  • navigate your way around Microsoft Excel 2010
  • create a new workbook
  • open and navigate within workbooks and worksheets
  • understand and work with ranges in a worksheet
  • understand, create and work with formulas and functions used to perform calculations
  • copy and paste data in Excel
  • understand and use formula cell referencing to create more complex formulas
  • use font formatting techniques to greatly enhance the look of a worksheet
  • align the contents of cells in a number of ways
  • format rows and columns in a worksheet
  • understand and use the number formatting features in Excel
  • print your workbook data
  • create effective charts in Microsoft Excel

This course assumes little or no knowledge of spreadsheets or Microsoft Excel 2010. However, it would be beneficial to have a general understanding of personal computers and the Windows operating system environment.

INF1015-E cover image

$24.50

Purchase: Add to Cart

Print edition   |   Manual licence

  View outline

View a detailed outline of the course material. You may need to install Adobe Acrobat Reader to open this file.

View Outline

  Download student files

Download working files to go with this course. Read the installation instructions for opening these files.

Download Files Zip