Excel and Outlook Self-Development Resources
A document for self improvement at all levels in both Excel and Outlook. Topics included are listed below
EXCEL
- Getting Started
- Cell Basics
- Modifying
- Formatting
- Saving
- Simple formulas
- Worksheet basics
- Printing
- CTRL Key shortcuts
- Basic Charts
- Protecting Files
- Complex Formulas
- Basic Functions
- Sorting
- Outlining
- Filtering
- Formatting
- ALT Key Shortcuts
- Plan Payments & Savings
- IF Function
- Using Tables
- VLOOKUP
- Reviewing & Sharing Workbooks
- Templates
- Charts
- Sparklines
- Conditional Formatting
- PivotTables
- What-If Analysis
- Drop Down Lists
- Practice workbooks
- Quizzes
OUTLOOK
- Getting to know Outlook
- Sending & Receiving mail
- Organising & Managing mail
- Managing contacts
- Managing calendars
- Collaborating with Calendars
- Using views to stay organised
- Instant search & Search Folders
- Filing stuff in folders
- Email signatures
- Automatic replies
- Outlook and RSS: The internet in your mailbox
- Keyboard shortcuts: Email
- Keyboard shortcuts: Calendar, contacts, tasks
- Keyboard shortcuts: Alt Key shortcuts
- Outlook Best Practices – Get Organised
- Saving time with templates
- Task basics