Advanced MS Excel 2: Taking Formulas Further

Class ID: 

Advanced Microsoft Excel II: Use range names and 3-D references in formulas; learn to use financial, logical and date functions; troubleshoot formulas and functions with auditing tools, use Goal Seek and Scenarios.

Students should have taken all previous Excel classes or be familiar with the skills covered.

Download handouts and practice problem files below. If files fail to download properly, try a different browser (Internet Explorer, Firefox).

Advanced Excel 2010 2 - Formulas.pdf533.72 KB
Advanced Excel Practice - Formulas.xlsx16 KB
Advanced Excel Practice - Formulas 97-2003.xls30.5 KB
Advanced Excel Formulas Homework Answers.xlsx18.17 KB
Class Practice Files.xlsx75.14 KB
Class Practice Files 97-2003.xls147 KB