Excel 365 Beginners Half Day

Introduction to Excel 365 and File Management (1 Hour)

• Welcome and Overview of Excel 365 (15 min)
  • Introduction to Excel 365 Features
  • Navigating the Excel Workbook
  • Differences between online and Desktop (Client) Versions
• Creating, Saving, and Managing Files in Excel and SharePoint (15 min)
  • Starting a New Workbook
  • Saving and Organising Files Locally and on SharePoint
  • Overview of SharePoint for Excel File Management
• Basic Data Entry and Formatting (15 min)
  • Data Entry Techniques
  • Basic Cell Formatting (Fonts, Colours, Sizes)
  • Introduction to Absolute and Relative Cell References
• Understanding Absolute vs Relative References (15 min)
  • Concept and Importance
  • Practical Examples and Exercises

Coffee Break (15 min)

Excel Functions, Data Management, and Collaboration (1 Hour 45 min)

• Basic Formulas and Operator Preference (30 min)
  • Writing Formulas with Emphasis on Reference Types
  • Order of Operations in Excel Formulas
• Essential Functions and Their Use (30 min)
  • Using Functions: SUM, AVERAGE, MAX, MIN
  • Contextual Use of Absolute and Relative References in Functions
• Data Organisation: Sorting, Filtering, and Sharing (30 min)
  • Applying Basic Sorting and Filtering Techniques
  • Sharing Excel Files via Email, SharePoint
  • Collaboration Features in Excel 365 (Online vs Desktop)
• Q & A, Practice, and Wrap-Up (15 min)
  • Addressing Participant Queries
  • Hands-on Practice
  • Summary of Key Learnings and Further Resources