This course gives the new spreadsheet user a thorough grounding in the essentials of creating and working with spreadsheets using Microsoft Excel. Particular emphasis is placed on developing accurate and well-designed spreadsheets employing sound design and calculation principles.
You will create, navigate and edit spreadsheet data and learn how to format it in a number of ways. You’ll also sort and filter lists of data, create charts, manage rows and columns, headers and footers as well as printing.
Importantly, this course teaches you how to understand and build formulas for automated calculation, including essential functions and the correct cell referencing required to create useful spreadsheets.
No prior knowledge of Excel is required, but participants do need to know how to use a Windows computer.
This course is part of the Business Information Technology Program.