Microsoft Excel Beginner's Tutorial

Introduction

• Speaker: Jamie from Teachers Tech
• Focus: Beginner's guide to Microsoft Excel
• Key Topics: Layout, terminology, data input, formatting, functions, formulas, charts, and printing.

Getting Started with Excel

• Versions Used: Windows 10, Microsoft 2016 (applicable to other versions)
• Home Screen: Recent files, templates, pinned items
• Templates can save time and create professional workbooks.
• Best to start with a blank workbook to learn basics.

Excel Basics

• Tabs and Ribbon: Located at the top, similar to other Microsoft Office products.
• Groups: Sections within the ribbon. Each tab has its groups (e.g., Font, Alignment).
• Columns and Rows: Columns (letters), Rows (numbers), cells are where they intersect.
• Cell Reference: When you click a cell, its reference appears in the top left corner.
• Range: Group of selected cells (e.g., C4 to K17).

Navigating and Formatting Data

• Entering Data: Tab to move right, Shift + Tab to move left, Enter to move down, Shift + Enter to move up.
• Adjust Width/Height: Drag column/row edges, double-click to auto-fit.
• Workbook Structure: Workbook contains multiple worksheets (tabs at the bottom).
• Renaming/Adding Sheets: Double click to rename, use the + icon to add sheets.
• Basic Text Formatting: Change font, size, color, bold, borders.
• Zooming: View tab for zoom options, bottom-right slider.

Data Input Example: Top 10 Grossing Movies

• Enter Data: Rank, Title, Studio, Worldwide Gross, Domestic, Overseas, Year.
• Alignment and Wrapping: Center text, wrap text for better visibility.
• Formatting Sections: Use borders, styles for headings, and cell merging for titles.
• Currency Format: Use the $ icon for currency formatting.

Print Layout

• Print Preview: Dotted lines indicate page breaks.
• Adjusting for Print: Make necessary column/row adjustments.
• Borders and Styles: Ensure visibility when printing.

Introduction to Formulas

• Basics: Start with an equal sign (=) to create formulas.
• Cell References: Use cell references so calculations update automatically.
• Example: Calculating percentage of domestic vs. worldwide gross.
• Copying Formulas: Use the fill handle (bottom-right corner) to drag and fill.

Functions and Automation

• AutoSum: Quick way to sum a range of cells.
• Average Function: Calculate the average of a range.
• Other Functions: Explore the variety of built-in functions under the Formulas tab.
• Freeze Panes: Keep specific rows/columns visible while scrolling.

Creating Charts

• Insert Charts: Use the Insert tab to add charts to represent data visually.
• Selecting Data: Highlight relevant data, use Ctrl for non-contiguous selections.
• Chart Types: Recommended charts or choose from various types (e.g., bar, pie).
• Formatting Charts: Add titles, axis labels, and customize layout and colors.

Conclusion

• Review and Practice: Experiment with basic formulas, functions, and charts.
• Advanced Topics: Future videos will cover more advanced features.
• Engagement: Like, comment, and subscribe for more tutorials.