This class is for those who have been using Excel on a regular basis and have knowledge of formulas. Topics covered include: advanced formulas and functions (financial, logical, date/time), relative and absolute references, working with multiple worksheets, using 3D formulas and references; working with tables; the total row; sorting; filtering; data validation and subtotaling; and much more.
REQUIREMENTS: Completion of Excel – Level 1 and/or working knowledge of Excel.
Please view the Table of Contents for each course below to help determine your proficiency.
View Table of Contents – Excel Level 1
View Table of Contents – Excel Level 2
View Table of Contents – Excel Level 3
View Table of Contents – Excel Level 4