Microsoft Excel Beginner's Tutorial

Introduction

• Presenter: Jamie Keed
• Platform: Teachers Tech
• Topic: Beginner's tutorial on Microsoft Excel
• Objectives:
  • Basic layout
  • Terminology
  • Inputting data
  • Formatting data
  • Working with functions and formulas
  • Creating charts
  • Printing
• Additional tips and future videos mentioned.

Getting Started

• Using Microsoft Excel on Windows 10 and Microsoft 2016
• Steps apply to other versions as well.
• Opening Excel:
  • Recent files: Pinned files stay at the top.
  • Templates: Useful for professional-looking workbooks.
  • New blank workbook: Best place to start learning basics.

Basic Terminology

• Tab and Ribbon: Tabs at the top, Ribbon below with grouped features.
• Column and Row: Columns (A, B, C...), Rows (1, 2, 3...)
• Cell and Range:
  • Cell: Intersection of a column and row (e.g., C3)
  • Range: Group of cells (e.g., C4:K17)
• Workbook and Worksheet:
  • Workbook: Entire Excel file
  • Worksheet: Individual tabs/sheets within the workbook
• Navigating:
  • Click to select a cell
  • Tab to move right, Shift+Tab to move left
  • Enter to move down, Shift+Enter to move up

Entering Data

• Example: Top 10 grossing movies
• Titles for columns: Rank, Title, Studio, Worldwide Gross, Domestic, Overseas, Year
• Formulas:
  • Begin with = (e.g., =2*2)
  • Cell references adjust when copied

Formatting Data

• Adjusting View:
  • View > Zoom for better visibility
  • Bottom right corner for quick zoom control
• Text Formatting:
  • Changing font style, size, color
  • Adjust column width
  • Add border styles
• Aligning Text:
  • Merge cells (Merge & Center)
  • Use Styles for quick formatting
• Wrap Text: Enables text to fit within cell dimensions
• Inserting Rows/Columns: Right-click to insert

Creating Formulas

• Basic Formulas:
  • Example: =E3/D3 for percentages
  • Use % button to format as percentage
  • Copy formula by dragging fill handle
• Functions:
  • Autosum: Quickly totals a range
  • Average and other common functions

Using Freeze Panes

• View > Freeze Panes to keep headers visible while scrolling
• Helps in large datasets for better navigation and comparison

Charts and Graphs

• Creating Charts:
  • Insert > Recommended Charts
  • Highlight data and control to select non-contiguous ranges
• Editing Charts:
  • Add titles, adjust styles
  • Use Chart Elements to tweak appearance

Printing and Final Touches

• Print Preview: Ensure correct layout before printing
• Adjustments:
  • Make necessary changes to fit data on page
  • Check for borders and cell visibility

Conclusion

• Importance of learning basic functions to leverage Excel’s full potential
• Future tutorial videos will dive deeper into advanced features

Remember to subscribe and turn on notifications for more tutorials!