Microsoft Excel 2024

Course Title: Microsoft Excel 2024

• AI Integration (Copilot): Microsoft’s AI assistant, Copilot, is a major focus, helping users to generate formulas, create complex formula columns across multiple tables, create custom charts and PivotTables, and summarize textual data through both text prompts and verbal commands.
• New Functions: The latest versions introduce new functions to streamline data manipulation:
  • IMAGE Function: Embed pictures into cells from a web source and move/resize them within tables.
  • LAMBDA Function: Create and name custom, reusable functions using Excel’s formula language.
  • GROUPBY and PIVOTBY: Create summary reports with a single formula, a powerful alternative to traditional PivotTables.
  • Text and Array Functions: 14 new functions designed to easily extract, split, combine, reshape, and resize arrays and text strings.
  • REGEX Modes for XLOOKUP and XMATCH: Utilize regular expressions for more advanced search mechanisms.
• Dynamic Arrays and Charts: Charts can now reference dynamic arrays, automatically updating to include all data when the array recalculates.
• User Interface & Experience:
  • Accessibility Ribbon: A centralized location for all tools needed to create an accessible workbook.
  • Focus Cell: A feature that highlights the active cell for easier navigation.
  • Checkboxes: Generally available for use in simple checklists and more complex solutions.
  • Ink to Text Pen: For Windows Insider users, a feature that converts handwriting into text using a digital pen. 

Target Audience:
This course is ideal for corporate professionals at all skill levels, including administrative assistants, project managers, HR, and marketing specialists who need to produce high-quality documents efficiently.