Excel – Data Analysis with Power Pivot

1 – 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

2 – 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

3 – Modifying a Worksheet

• Insert, delete, and adjust cells, columns, and rows
• Search for and replace data, and use filter tools for data management
• Use proofing and research tools to ensure accuracy

4 – 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

5 – 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

6 – Managing Workbooks

• Manage multiple sheets and workbooks efficiently
• Update workbook properties to maintain organized files
• Manage workbook and worksheet views for better navigation