Introduction to Excel

Learn the basics of Excel with this innovative resource. The hands-on workbooks provide instruction and activities about the fundamentals of formatting cells, calculating and creating charts as introductory activities to the world of Excel.

Complete lessons with solutions are provided – no teacher prep needed. It is great for beginners or revision at the beginning of a course.

The learner initially works in 4 editable Excel workbooks that teach and provide appropriate activities at the same time - an efficient way to learn. This is followed by a student activity booklet where the students create their own spreadsheets from scratch. There is an Excel Icons puzzle and an Excel Basics Google quiz to consolidate learning. This resource provides lessons for both classroom teachers or self-learners. All of these resources can be digital for a paper free classroom. The Excel workbooks are editable by the teacher if needed.

Prerequisites: Good reading skills, previous experience with Microsoft Office products and ribbons would be desirable, ability to follow instructions, access to Microsoft Excel, Microsoft PowerPoint for the Puzzle and the internet for the Google Quiz or Puzzle.

A PDF slideshow – made with PowerPoint - a reference

that explains

• The Excel screen and ribbons
• What a workbook and worksheets are
• The Excel screen layout
• Cells in a worksheet
• Status bar and views
• Backstage view

Workbook 1 - Formatting 1: Teaches and provides relevant learner activities (editable Excel document)

• About Excel, ribbons and saving
• Mouse pointer, formatting text, views
• Cell references, selecting and moving around in cells
• Adjusting and merging cells
• Adding borders and cell styles

Workbook 2 - Formatting 2: Teaches and provides relevant learner activities (editable Excel document)

• Text wrapping and formatting cells
• Copy, pasting, moving and formatting cells
• Inserting and deleting columns
• Autofill and flash fill
• Number formatting
• Sorting data
• Adding pictures
• Tables
• Entering data

Workbook 3 - Calculating: Teaches and provides relevant learner activities (editable Excel document)

• Formula bar
• View and create formulas
• Arithmetic calculations, autosum, averages, percentages
• Autofill, using formulas
• Completing calculations for multiple spreadsheet tables

Workbook 4 - Charts: Teaches and provides relevant learner activities (editable Excel document)

• Types of charts
• Parts of a chart
• Resizing, moving, properties, copying, live update
• Creating column, bar, line, area and pie charts
• Shape effects, create sparklines and revision

Solutions for all Workbook activities

Excel Basic Reference Sheets

Pages of quick reference for all the main need to know actions for Excel – a great help and invaluable reference for learners.

Excel Basics Student Activity Booklet: PDF can be used digitally or printed

Spreadsheet activities for the learner to create from scratch

Includes extension activities

Excel Basics Student Activity Booklet Solution: provided in Excel file

Excel Icons Puzzle: Digital versions in PowerPoint or Google Slides

Excel basics Google Quiz: self-correcting and teacher editable

Please FOLLOW ME for product updates

Tech 4 All's higher-level Excel unit is EXCEL ESSENTIALS which meets MOS certification standards.

Copyright Tech 4 All®. All rights reserved by author. This product is to be used by the original downloader only. Copying for more than one teacher, classroom, department, school, or educational provider is prohibited. It may not be edited, sold or distributed as paper or digital format. In digital format it may only be available for your classroom – do not post digital files where there is public access. It is for use for one teacher for one class only. If you wish to use it again you must buy it again or purchase multiple copies. If your colleagues would like to use this resource please ask them to download their own copy. Tech 4 All® is an independent publisher and is neither affiliated with, nor authorized, sponsored, or approved by, Microsoft Corporation.