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