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

Blog File(s):

Excel-Resources.xlsx