Microsoft Excel Beginner's Tutorial

Instructor Introduction

• Instructor: Jamie Keyed from Teachers Tech
• Purpose: Beginner's tutorial on Microsoft Excel
• **Goals: **
  • Understanding basic layout and terminology
  • Data input and formatting
  • Working with functions and formulas
  • Creating charts and printing worksheets

Introductory Notes

• Uses Microsoft Windows 10 and Office 2016
• Other versions have similar functionality
• Utilizes a taskbar for quick access to Excel
• Recent files are displayed upon opening Excel
• Pin important files for easy access
• Use templates for efficiently creating professional documents
• Start with a blank workbook to learn the basics

Excel Layout and Terminology

• Tabs: Located at the top, similar across Word, Excel, and PowerPoint
• Ribbon: Below tabs, contains groups of functions
  • Examples: Font group, alignment group
  • Additional options within groups accessed through a small button
• **Columns and Rows: **
  • Columns: Labeled by letters
  • Rows: Numbered
  • Cells: Intersection of a row and column
  • Range: Group of cells
  • Workbook: The entire Excel file
  • Worksheets: Individual sheets within a workbook
    • Rename, add, and rearrange worksheets

Entering and Formatting Data

• Use the Home tab for basic formatting
• Zoom: Adjust via View tab or bottom-right slider
• Example project: Top 10 grossing movies of all time
• Navigating cells: Click, tab, enter, shift+tab, shift+enter keys
• Column and row adjustments: Drag to resize, double-click to auto-size
• Formatting text: Change font, size, color, bold, and add borders
• Styles: Quickly apply predefined formatting
• Entering data: Type directly in a cell or above in the formula bar

Basic Formatting Tips

• Use Wrap Text for long text within a cell
• Insert rows to add titles or additional information
• Merge and Center: Useful for titles spanning multiple columns
• Apply Styles for consistent formatting
• Currency format: Add dollar signs or other currency symbols
• Print Preview: Check layout before printing
  • Adjust column width to fit within page margins

Introduction to Formulas

• Formulas: Equations starting with =
• Example: =2*2 displays 4 but shows formula in the formula bar
• Create formulas using cell references, enabling dynamic updates
• Example project: Calculate percentages
  • Insert columns for Percentage Domestic and Percentage Overseas
  • Create a formula: =Domestic/Worldwide, select %, copy down
• Drag to copy: Extended formulas to adjacent cells automatically adjust*

Introduction to Functions

• Total: Use AutoSum for quick summation
  • Highlight the range to sum
  • Copy or drag to apply formula to other cells
• Average: Find the average of a range
  • Select the range, apply Average function

Additional Tips

• Freeze Panes: Keep headings visible while scrolling
  • Found under the View tab
  • Freeze top row, first column, or selected range
• Use the Tell Me feature in Microsoft products to find commands quickly

Creating Charts

• Highlight Data: Select cells for chart content
• Insert Chart: Recommended charts, customize as needed
• Chart Title: Add and format chart titles and axis labels
• Chart Adjustments: Resize, move, and style chart
• Print Preview of Charts: Ensure chart fits within printable area

Conclusion

• Overview of Excel basics covered
• Mention of future videos for advanced Excel features
• Encouragement to practice and apply learned skills
• Invitation to subscribe and provide feedback in comments