Identify the benefits associated with newer functions and features in Excel
and utilize these newer tools
Create advanced formulas using Excel functions
and utilize formula “best practices”
List various ways you can improve your
efficiency and effectiveness in Excel by utilizing tips and tricks discussed in
this session
Construct PivotTables – including those with user-defined
calculations – and list examples of advantages of PivotTables compared to
formula-based summaries and calculations