Basic Excel

Clear Targets

  • Learn to navigate the Excel interface

  • Learn to access Excel tutorials to continue learning

  • Get ideas for using Excel to work smarter not harder

  • Learn special features of Excel (copying, sorting, SUM, etc.)

Target: Learn the Excel interface

Excel can be found by looking for a green box with an X on it. Searching for Excel can also help locate the program.

The screenshot shows the Home tab selected in orange with the ribbon options visible. Notice that the push pin to the right of the image will allow the ribbon to stay visible. (Pin down the ribbon)

Additional pages can be added to the workbook by clicking the circled + symbol near the bottom of the window.

The view of the workbook can be controlled using the icons highlighted in yellow. Beside the view control is a slider that makes what is visible on the sheet larger or smaller.

Target: Access Excel tutorials to continue and personalize learning

Continue learning about Excel by using the search feature to get a quick answer, or browse by topic to broaden the information accessed.

Target: Get ideas for using Excel to work smarter not harder

Excel Master Document.xlsx




This Excel workbook was created and used by administrators at an elementary school to keep track of school information like teacher schedules, bus routes, etc. Use this template to get ideas to support your school's work.

Target: Learn to use special features of Excel

Resize multiple rows/columns at the same time

This tutorial shows how to create a calendar. It includes changing the page view, sizing multiple rows and columns at the same time, adding pages, and much more, all in under 6 minutes.

Resizing Cells, Dragging items, working in Page Layout.webm

Drag out numbers and other automatically

This tutorial shows how to add lines (borders), drag out numbers (auto-fill), format cells and more.


Add lines, Numbers, Finishing touches to Calendar.webm

Control Printing

Printing in Excel can be unpredictable. This tutorial shows how to only print the desired pages every time.

Printing your page.webm

Create Labels with Mail Merge in Word and Data in Excel

Use Word and Excel to create labels quickly using Mail Merge feature in Word combined with data in Excel.

Excel - Mail Merge.webm