GW_E3_F/502/0168_SS_BASICS_L1

Spreadsheet program that allows you to store, organize, and analyze information. While you may think Spreadshe are  only used by certain people to process complicated data, anyone can learn how to take advantage of the program's powerful features. Whether you're keeping a budget, organizing a training log, or creating an invoice, Spreadsheets makes it easy to work with different types of data.
1 / 18
next
Slide 1: Slide
Computing ICTFurther Education (Key Stage 5)

This lesson contains 18 slides, with interactive quizzes and text slides.

time-iconLesson duration is: 30 min

Items in this lesson

Spreadsheet program that allows you to store, organize, and analyze information. While you may think Spreadshe are  only used by certain people to process complicated data, anyone can learn how to take advantage of the program's powerful features. Whether you're keeping a budget, organizing a training log, or creating an invoice, Spreadsheets makes it easy to work with different types of data.

Slide 1 - Slide

LESSON OUTCOMES
  • Open Excel program
  • Open an Excel Workbook
  • Understand the function of the Ribbon Tabs
  •  Access The backstage View
  •  Create Quick Access Commands 

Slide 2 - Slide

Slide 3 - Slide

Slide 4 - Slide

Slide 5 - Slide

Get Started
The procedures in the next will work for all recent versions of Microsoft Excel, including Excel 2019, Excel 2016, and Office 365. There may be some slight differences, but for the most part these versions are similar. However, if you're using an earlier version, you may 
want to refer to one of our other Excel tutorials instead


Slide 6 - Slide

Home is a Tab on the Ribbon.

A
True
B
False

Slide 7 - Quiz

The Ribbon
  1. Excel uses a tabbed Ribbon system instead of traditional menus. The Ribbon contains multiple tabs, each with several groups of commands. You will use these tabs to perform the most common tasks in Excel.
  2. Each tab will have one or more groups.
  3. Some groups will have an arrow you can click for more options
  4. .Click a tab to see more commands.

Slide 8 - Slide

The Excel Ribbon
Home Tab
In general, the home tab is a tab or button in an application or web page that returns you to the home section. 2. In Microsoft Office, the Home tab is the default tab in Microsoft Word, Microsoft Excel, Microsoft PowerPoint, and other Microsoft Office products.
The Excel Ribbon
The Excel Ribbon Groups Excel Commands into sets of Tabs that enable simple method of acceessing commands
The Page Layout Tab
This tab lets you define the page layout for your file, including the page size, size of the page margins, and the positioning of the systems on each page.
Insert Tab
The Insert tab contains various items that you may want to insert into a document. These items include such things as tables, word art, hyperlinks, symbols, charts, signature line, date & time, shapes, header, footer, text boxes, links, boxes, equations and so on.
The Print Area Tab
This tab lets you define define the Print Area and add headers and footers .
The Data Tab
We use Data tab for the large amount of data.It is useful to import the data by connecting with the server, and we can import data automatically from web, MS Access etc. And sort & filter are very helpful options we have in Excel; it makes easy to read vast data.
The FormulaS Tab
The Formula tab is used to  insert functions, define names, create name ranges, review formulas. In ribbon, Formulas tab has very important and most useful functions to make dynamic reports. Insert Function

Slide 9 - Slide

The Quick Access Toolbar
Located just above the Ribbon, the Quick Access Toolbar lets you access common commands no matter which tab is selected. By default, it includes the Save, Undo, and Repeat commands. You can add other commands depending on your preference.
To add commands to the Quick Access Toolbar:
  1. Click the drop-down arrow to the right of the Quick Access Toolbar.
  2. Select the command you want to add from the drop-down menu. To choose from additional commands, select More Commands.
  3. The command will be added to the Quick Access Toolbar.

Slide 10 - Slide

Worksheet Views
Excel has a variety of viewing options that change how your workbook is displayed. These views can be useful for various tasks, especially if you're planning to print the spreadsheet. To change worksheet views, locate the commands in the bottom-right corner of the Excel window and select Normal view, Page Layout view, or Page Break view.

  1. Normal view is the default view for all worksheets in Excel.
  2. Page Layout view displays how your worksheets will appear when printed. You can also add headers and footers in this view.
  3. Page Break view allows you to change the location of page breaks, which is especially helpful when printing a lot of data from Excel.


Slide 11 - Slide

The Backstage View
  • Backstage view gives you various options for saving, opening a file, printing, and sharing your workbooks.
  • Click the File tab on Click the buttons in the interactive below to learn more about using Backstage view.







  • the Ribbon. Backstage view will appear.
  • Click the buttons in the interactive below to learn more about using Backstage view.

Slide 12 - Slide

What is purpose of the Quick Access Bar
A
Provide Custom Commands
B
Provide Access to backstage
C
Identify The Selected Row
D
Change The Worksheet View

Slide 13 - Quiz

It is possible to create a border on only one side of a cell.

A
True
B
False

Slide 14 - Quiz

What are the horizontal sections of an Excel worksheet
A
Columns
B
Rows
C
Cells
D
Squares

Slide 15 - Quiz

How Do access the Backstage view

Slide 16 - Open question

Challenge
  • Open Excel.
  • Click Blank Workbook to open a new spreadsheet.
  • Using the Customize Quick Access Toolbar, click to add New, Quick Print, and Spelling.
  • In the Tell me bar, type the word Colour. Hover over Fill Colour and choose yellow. This will fill a cell with the colour yellow.
  • Change the worksheet view to the Page Layout option.
  • When you're finished, your screen should look like this:
  • Change the Ribbon Display Options back to Show Tabs and Commands.
  • Use The snipping tool to take a screen shot of the completed workbook

Slide 17 - Slide

Upload the workbook you saved as part of the challenge

Slide 18 - Open question