|
Introduction
• Refresher on basic formulas and functions
• Preventing rounding errors
• Building in checks and proofs
• Conditional formulas
• Linking worksheets / workbooks
Further functions
• Logical functions; IF, AND, OR
• Conditional statistical functions
• Date and time functions
Creating business diagrams
• Creating Venn diagrams
• Editing diagrams
• Exporting diagrams
Databases
• Creating a database
• Sorting and filtering
• Sub-totalling
• Consolidations
• Enhanced list functionality |
Formatting numbers
• Creating custom number formats
• Conditional formatting
• Controlling date formats
Creating charts
• The different types of charts
• Chart formatting features
• Using Trends
• Combining charts
• Linking Excel and Word
Security
• Worksheet protection
• Workbook protection
Questions and answers |
Courses provided by partners Media Training.
