Introduction to Microsoft Excel

• Excel is a tool for analyzing and gaining insights from data.
• Two ways to access Excel:
  • Web: Navigate to Excel.new for free access, with most desktop functionalities.
  • Desktop: Purchase Microsoft 365 for the desktop version.

Getting Started with Excel

• Start Page:

  • Options to start a new blank workbook or choose from templates.
  • Access recent workbooks and a search feature.

• Workbook Structure:

  • Cells are rectangles on the grid.
  • Columns are labeled by letters and rows by numbers.
  • Cell reference example: E7 (Column E, Row 7).
  • Zoom in/out using bottom right corner or CTRL + mouse wheel.

Entering and Formatting Data

• Typing data into cells:

  • Headers: Start with typing in headers like "Sales," "Date."
  • Use Tab or arrow keys to navigate between cells.

• Filling Patterns:

  • Excel detects patterns and can auto-fill sequences (e.g., months).

• Formatting Numbers:

  • Use a thousand separator and remove decimals if unnecessary.
  • Shortcut: CTRL + 1 for format cells dialog.

• Column and Row Adjustments:

  • Auto-fit column width to contents by double-clicking column line.
  • Hide or delete columns and rows via right-click options.

Data Organization and Analysis

• Reordering Columns:

  • Drag columns to new positions using shift key.

• Table Formatting:

  • Convert data into a table for better readability with banded rows.
  • Use table styles to customize appearance.

• Totals and Sums:

  • Add total rows in tables to sum data.

Using Functions and Formulas

• Basic Calculations:

  • Use “=“ for formulas, e.g., =B2 + B3 + B4.

• Functions:

  • SUM is a common function, e.g., =SUM(B2:B4).
  • Explore other functions under the formulas tab.

Data Sorting and Filtering

• Sorting:

  • Sort columns by largest to smallest or oldest to newest.

• Filtering:

  • Filter data to view specific ranges such as quarters.

Visual Representation

• Charts:
  • Use the insert tab to add charts, such as line charts, for visual data representation.

Advanced Analysis with Pivot Tables

• Creating Pivot Tables:
  • Insert a pivot table from the insert tab.
  • Drag and drop fields to values, rows, and columns for analysis.
  • Options to summarize data differently, e.g., average or sum.

Sharing Your Workbook

• Sharing:
  • Ensure workbook is saved in OneDrive to share with others.
  • Use the share button to send to team members.

Conclusion

• Excel provides tools for basic to advanced data analysis.
• Additional resources:
  • Free YouTube playlist for learning Excel.
  • A structured Excel course for fundamentals.
  • Consider subscribing for more instructional videos.