Tour Excel - activity
Spreadsheet Basics -- Microsoft Excel
Introduction to Excel 2016
Create a workbook
Interactive practice workbook
Introduction to Excel 2016
MIcrosoft Excel Cheat Sheets
Practice Data base
Spreadsheet Basics - Microsoft Excel
Welcome to Excel 2016
Overview
This course is designed for Microsoft end-users at London Health Sciences Centre and St. Joseph's Health Care, London, Ontario.
As the hospitals are now upgrading from Office 2010 to Office 2016, some changes to the software are evident. This module is intended to refresh and renew Excel knowledge to advance skills for staff who use the software in their positions.
This beginner's module is available as part of a series of modules that may be undertaken by hospital staff as the new software is rolled out. Similar modules are available for other Office apps, such as Word, PowerPoint, and OneNote. A more advanced Excel module is also available for those who may be more skilled at using this product.
At the end of this learning module learners will be able to recognize standard features of Microsoft Excel, create a simple data base and recall simple math functions using the app.
Welcome to Excel 2016
The instructor may want to download and refer to the attached resource entitled Beginning Excel. This book has lots of practice activities that may be used to dive more deeply into different Excel functions and help trouble-shoot when students require additional help.
Let's get started learning the different components of Excel and the vocabulary used in this learning module.
1. View the video below to give you an idea of the basic parts of Excel you may use in your work.
2. Download the "cheat sheets" and save to your desktop. These will help you remember the components of the workbook and worksheet and some various things you can do in Excel.
Create a workbook - activity
- To create a new workbook, follow the steps outlined in the Create a workbook link below, using Excel 2016 or 2019 as installed on your computer. The instructions ask you to create a data base.
- Open the image of a database and try to replicate this practice data using only your keyboard and not the mouse. Press the Tab key to move right and press the Enter key to move down to the next available cell.
- Continue to practice until you can quickly create the data base using only the keyboard.
You may want to use dual monitors to avoid flipping screens back and forth. Try it out!
What else can Excel do?
- Watch the 7 minute tutorial video below to discover some basic math functions in Excel that can be applied immediately to your work.
- After viewing the video, download the practice workbook to take an interactive tour of Excel. Note that the workbook starts with a title Worksheet. Work through the worksheets from left to right as you interact with the activities.
Saving Your Work
Complete the following activity to save the practice workbook you downloaded and worked on in section 3.
- Click the File tab and then the Save As button in the left side of the Backstage view window. The Save As dialog box opens.
- Determine a location for saving on your computer by clicking Browse.
- Click in the File Name box near the bottom of the Save As dialog box.
- Type a new file name.
- Click the Save button.
This new saved workbook may now be used at any time to practice beginner Excel functions.
Image and instructions in this section from the following:
Brown N., Lave B., Romey J., Schatz M., Shingledecker D. Beginning excel. Open Oregon Educational Resources. n.d. Retreived from : https://openoregon.pressbooks.pub/beginningexcel/