Excel — Spring 22

Lesson 1 — The Basics

By


Learning Objectives

  • Be familiar with the terms in Excel
  • Know how to enter data into a spreadsheet

 

Instructions

1. In this lesson, you will watch a video demonstrating the basic techniques in Excel. Before watching, notice the following:

— The version in the video is Excel 2016 on a PC. If you are other recent versions of Excel such as 2019 or 2020, your screen layout should still be very similar to that in the video. Scroll down the page for details.

— The Excel layout on a Mac is very similar to that of a PC.

— The video also talks about tricks and shortcuts but don’t worry if you don’t get them. The most important thing is to be able to enter data and do simple formatting at this stage.

 

—Here is the video:

Beginner’s Guide to Microsoft Excel

(Since I don’t have a PC, I am using the above video so that PC users can see the layout on their screen. From next lesson onward, I will use my Mac for demonstration. Regardless, the Excel on PC and Mac are very similar since we are using the very basic features only.)

 

2. For Mac users:

The PDF below shows:

—where to find the Excel templates
— where to find the Merge & Center option
— where to find the Save As option

Excel_basics_Mac.pdf

-END-



Content is copyright the author. Layout is copyright Mark Ciotola. See Corsbook.com for further notices.