Hands-On Lab 1: Introduction To Excel For The Web: Estimated Time Needed: 20 Minutes

Download as pdf or txt
Download as pdf or txt
You are on page 1of 11

3/26/22, 1:13 AM https://cf-courses-data.s3.us.cloud-object-storage.appdomain.

cloud/IBMDeveloperSkillsNetwork-DA0130EN-SkillsNetwork/Hands-on Labs/Lab 1 - Access to the environment - Excel for the web/in…

Hands-on Lab 1: Introduction to Excel for the web


Estimated time needed: 20 minutes

Microsoft Excel is the most widely used spreadsheet software even three decades after its initial release. For all these years it has been
available as a standard application that needed to be installed on your desktop; but it is not just a desktop app anymore. Now, you can even
use Excel when you're online by using 'Excel for the web' - and run it right in your web browser without installing anything on your desktop!

'Excel for the web' (sometimes referred to as Excel Online) can be used at no charge as part of a free Microsoft account. Although it does not
have all of the capabilities of the desktop and paid online versions, the free web version provides many of the key features.

Software Used in this Lab


The instruction videos in this course use the full Excel Desktop version as this has all the available product features, but for the hands-on labs
we will be using the free 'Excel for the web' version as this is available to everyone.

Although you can use the Excel Desktop software if you have access to this version, it is recommended that you use Excel for the web for the
hands-on labs as the lab instructions specifically refer to this version, and there are some small differences in the interface and available
features.

Dataset Used in this Lab


The dataset used in this lab comes from the following source: https://www.kaggle.com/sudalairajkumar/indian-startup-funding under a CC0:
Public Domain license.
Acknowledgement and thanks also goes to https://trak.in who were generous enough to share the data publicly for
free.

We are using a modified subset of that dataset for the lab, so to follow the lab instructions successfully please use the dataset provided with
the lab, rather than the dataset from the original source.

Objectives
After completing this lab, you will be able to:

Sign up for a Microsoft Account to use Excel for the web


Sign in, upload and open a workbook in Excel for the web

Exercise 1: Sign-up for a Microsoft Account to Use Excel


for the web
In this exercise, you will sign up for a Microsoft Account to use Excel for the web.

If you already have a Microsoft account, you can skip Exercise 1 and proceed to Exercise 2 directly.

1. Go to www.office.com. Click Sign in

https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/IBMDeveloperSkillsNetwork-DA0130EN-SkillsNetwork/Hands-on Labs/Lab 1 - Access to the environment - Excel for the web/instructions.md.html 1/11
3/26/22, 1:13 AM https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/IBMDeveloperSkillsNetwork-DA0130EN-SkillsNetwork/Hands-on Labs/Lab 1 - Access to the environment - Excel for the web/in…

2. Click Create one!

3. Enter your existing email id with which you want to create a Microsoft account. Click Next.

https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/IBMDeveloperSkillsNetwork-DA0130EN-SkillsNetwork/Hands-on Labs/Lab 1 - Access to the environment - Excel for the web/instructions.md.html 2/11
3/26/22, 1:13 AM https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/IBMDeveloperSkillsNetwork-DA0130EN-SkillsNetwork/Hands-on Labs/Lab 1 - Access to the environment - Excel for the web/in…

4. Enter your password and click Next.

5. Enter the code you received by email. Click Next.

https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/IBMDeveloperSkillsNetwork-DA0130EN-SkillsNetwork/Hands-on Labs/Lab 1 - Access to the environment - Excel for the web/instructions.md.html 3/11
3/26/22, 1:13 AM https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/IBMDeveloperSkillsNetwork-DA0130EN-SkillsNetwork/Hands-on Labs/Lab 1 - Access to the environment - Excel for the web/in…

6. Enter your phone number and click Send Code.

7. Enter the access code you received as a text on your phone, then click Next.

https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/IBMDeveloperSkillsNetwork-DA0130EN-SkillsNetwork/Hands-on Labs/Lab 1 - Access to the environment - Excel for the web/instructions.md.html 4/11
3/26/22, 1:13 AM https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/IBMDeveloperSkillsNetwork-DA0130EN-SkillsNetwork/Hands-on Labs/Lab 1 - Access to the environment - Excel for the web/in…

8. You are now done with the sign up procedure. Now since you are signed in after sign up at this stage, you can proceed directly to Task B
of Exercise 2.

https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/IBMDeveloperSkillsNetwork-DA0130EN-SkillsNetwork/Hands-on Labs/Lab 1 - Access to the environment - Excel for the web/instructions.md.html 5/11
3/26/22, 1:13 AM https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/IBMDeveloperSkillsNetwork-DA0130EN-SkillsNetwork/Hands-on Labs/Lab 1 - Access to the environment - Excel for the web/in…

Exercise 2: Sign-in, Upload and Open a Workbook in


Excel for the web
In this exercise, you will sign in to Excel for the web, open a new workbook and then upload and open a workbook.

Task A: Sign in to Excel for the web


1. Go to www.office.com. Click Sign in.

2. Enter your sign in email.

3. Enter your password.

https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/IBMDeveloperSkillsNetwork-DA0130EN-SkillsNetwork/Hands-on Labs/Lab 1 - Access to the environment - Excel for the web/instructions.md.html 6/11
3/26/22, 1:13 AM https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/IBMDeveloperSkillsNetwork-DA0130EN-SkillsNetwork/Hands-on Labs/Lab 1 - Access to the environment - Excel for the web/in…

4. You are now signed in.

Task B: Open a new workbook in Excel for the web


1. Click on the Excel icon.

https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/IBMDeveloperSkillsNetwork-DA0130EN-SkillsNetwork/Hands-on Labs/Lab 1 - Access to the environment - Excel for the web/instructions.md.html 7/11
3/26/22, 1:13 AM https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/IBMDeveloperSkillsNetwork-DA0130EN-SkillsNetwork/Hands-on Labs/Lab 1 - Access to the environment - Excel for the web/in…

2. Click New blank workbook.

3. You have successfully opened a new workbook in Excel for the web.

https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/IBMDeveloperSkillsNetwork-DA0130EN-SkillsNetwork/Hands-on Labs/Lab 1 - Access to the environment - Excel for the web/instructions.md.html 8/11
3/26/22, 1:13 AM https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/IBMDeveloperSkillsNetwork-DA0130EN-SkillsNetwork/Hands-on Labs/Lab 1 - Access to the environment - Excel for the web/in…

Task C: Upload and Open a workbook in Excel for the web


1. Download the file indian_startup_funding_Lab1.xlsx.

2. To upload and open a workbook in Excel for the web, click the App Launcher (cube of dots) in the top left corner. Click Excel icon. Then
click Upload and open... and select the indian_startup_funding_Lab1.xlsx file.

3. The file will be uploaded to your OneDrive of the Microsoft Account you signed up and used to open Excel for the web.
https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/IBMDeveloperSkillsNetwork-DA0130EN-SkillsNetwork/Hands-on Labs/Lab 1 - Access to the environment - Excel for the web/instructions.md.html 9/11
3/26/22, 1:13 AM https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/IBMDeveloperSkillsNetwork-DA0130EN-SkillsNetwork/Hands-on Labs/Lab 1 - Access to the environment - Excel for the web/in…

4. You have successfully uploaded and opened a workbook in Excel for the web.

Congratulations! You have completed Lab 1, and you are ready for the next
topic.

Author
Sandip Saha Joy

Other Contributor(s)
Steve Ryan

Changelog
Date Version Changed by Change Description

2020-09-10 1.2 Steve Ryan Added software/dataset info

2020-05-30 1.1 Steve Ryan Modified refs to Excel Online and Excel on the web

https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/IBMDeveloperSkillsNetwork-DA0130EN-SkillsNetwork/Hands-on Labs/Lab 1 - Access to the environment - Excel for the web/instructions.md.html 10/11
3/26/22, 1:13 AM https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/IBMDeveloperSkillsNetwork-DA0130EN-SkillsNetwork/Hands-on Labs/Lab 1 - Access to the environment - Excel for the web/in…

Date Version Changed by Change Description

2020-05-28 1.0 Sandip Saha Joy Initial version created

© IBM Corporation 2020. All rights reserved.

https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/IBMDeveloperSkillsNetwork-DA0130EN-SkillsNetwork/Hands-on Labs/Lab 1 - Access to the environment - Excel for the web/instructions.md.html 11/11

You might also like