Create and navigate spreadsheets in Microsoft Excel. Learn how to work with spreadsheets, create and use formulas and functions, understand font and cell formatting, use fill operations, work with headers and footers, and create effective charts. Work with a range of formula techniques, understand conditional formatting and gain all the skills you need to create useful spreadsheets.
Topics include working with workbooks, selecting ranges, copying data, filling data, formulas and functions, formula referencing, font formatting, number formatting, printing, creating charts, formula techniques, conditional formatting, working with a worksheet, charting techniques and chart text formatting.
You need basic computing knowledge.
This course is part of the Business Information Technology Program.