Unit1: Databases
Apply data filters (AutoFilter)
Perform single and multi-level sorts
Extract data (Advanced Filter)
Use data validation
Use subtotalling
Use grouping and outlines
Unit2: Naming Ranges
Creating a named range
Changing a named range
Selecting fields by using names
Using names in Functions
Unit3: Using Functions And Nested Functions
Using IF (& nested IF)
Using VLOOKUP
Using AND, OR Functions
Using Financial Functions
Using Text Functions
Unit 4: Collaborating
Creating a comment
Changing workbook Properties
Protecting and Unprotect workbooks and spreadsheets
Protecting and Unprotect workbooks and spreadsheets
Protecting a file using passwords
Unit 5: Templates
Creating new Templates
Using the existing Templates
Unit6: Advanced Number Formatting
Apply number formats (accounting, currency, number)
Create custom number formats
Using conditional formatting
Unit7: Analysis Tools
Creating and Using PivotTables
Using Goal Seek
Working with Scenarios
Using Solver (Goal Seek)
Unit8: Use data analysis and PivotTables
Creating PivotTables
Summarizing data using various functions
Working with Pivot Tables
Creating PivotCharts
Unit9: Auditing
Using the Auditing tools
Finding and correcting Formulae errors
Unit10: Printing
Preparing Sheets for Printing
Previewing and Printing Multiple workbooks