Excel – Data Analysis with Power Pivot

Getting Started with Excel

• Navigate the Excel user interface and organize your workspace efficiently
• Use Excel commands and features, and locate tools with shortcut keys
• Create and save a basic workbook
• Access and use Excel Online for cloud-based collaboration
• Enter and edit data entry efficiently in worksheets
• Find help and support through built-in tools and Microsoft Support resources

Performing Calculations

• Build Excel formulas to perform calculations quickly
• Insert and manage Excel functions like SUM, AVERAGE, and logical operators
• Reuse and copy formulas and functions using step-by-step techniques

Modifying a Worksheet

• Insert, delete, and adjust cells, columns, and rows
• Search for and replace data, and use filter tools for data management

Formatting a Worksheet

• Apply text and number formatting, including borders and shading for visual emphasis
• Align, arrange, and organize worksheet content
• Apply colors, borders, and predefined styles for professional spreadsheets
• Apply basic conditional formatting to highlight trends
• Create and use templates to streamline repetitive tasks

Printing Workbooks

• Preview and print worksheets with correct page layout settings
• Configure headers and footers to provide context in printed sheets
• Customize your sheet layout for clean presentation

Managing Workbooks

• Manage multiple sheets and workbooks efficiently
• Update workbook properties to maintain organized files

Microsoft Copilot Chat in Action

• What Is Microsoft Copilot Chat?
• The Magic Prompt Formula
• Work Smarter with AI