Expand your Microsoft Excel skills by manipulating multiple worksheets and workbooks, and by creating and formatting pivot tables, tables, and charts. Upon successful completion of this course you will be able to create workbooks using intermediate Microsoft Excel tools.
Graduates of this course will be able to apply absolute and relative cell referencing as well as named ranges in formulae. You will be able to create IF statements and PivotTables. Upon successful completion of this course you will be able to perform the LOOKUP function to search and retrieve data from a table, and sort, filter, and use subtotalling. With the skills you gain in this course you will be able to manage multiple workbooks, create charts, use PivotTables, and apply cell referencing to worksheets in Microsoft Excel.
It is recommended that you complete CCTO140, Microsoft Excel Level I, or have equivalent experience with MS Excel before enrolling in this course.