-- Apply Custom Formats and Layouts --

• Apply custom data formats

• Apply advanced conditional formating and filtering

• Apply custom styles and templates

• Prepare workbooks for internationalization

• Use macros

• Outlining

• Custom Views

-- Create advanced formulas --

• Functions

• Apply functions in formulas

• Mathematical functions

• Statistical functions

• Financial functions

• Useful Data functions

• Some other useful functions

• Look up data by using functions

• Apply advanced date and time functions

• Functions for manipulating Text

• Arrays

• Auditing and troubleshooting Formulas

-- Scenarious --

• Create scenarious

-- Create advanced charts --

•  Graphs

• Create advanced chart elements

• Sparkline

-- Pivot table and charts --

• pivotTables

• Create and manage Pivot Charts

-- Manage and Share workbooks --