Hello and welcome to the guided project.
Introduction to basic Excel.
My name is Karen G.M. and I will be your instructor today. Currently I work as a safety consultant for the K
through 12 industry.
I have a passion for keeping my customers data
and information in an easy to read format.
Extell has used both my professional and private life.
Being able to store and organize larger pieces of information
to have as a ready reference.
Makes keeping track of customers and even projects in day
to day life so much easier.
By the end of this project you will learn how to create
an Excel spreadsheet and use the data within your spreadsheet
to analyze and organize your information for easy access.
Excel is an electronic spreadsheet program that is used
for storing, organizing and manipulating data.
Electronic spreadsheet programs were originally based
on paper spreadsheets used for the accounting industry.
As such.
The basic layout of a computerized spreadsheet is the same
as the paper.
Ones Related data is sorted tables which are collection
of small rectangular boxes or cells organized into rows
and columns.
Due to its extreme versatility and power excels become
one of the most used software programs in the business world
since its launch in 1985.
Indeed, the personal computing renaissance of the
80s and 90s was largely driven by the many uses of Excel
and other spreadsheet software.
All versions of Excel and other spreadsheet programs
can store several spreadsheet pages in a single computer.
Find the saved computer file is often referred
to as a workbook and each page within the workbook is called
a separate work sheet.
A spreadsheet is a database that allows you to organize your
data and analyze for comparison any number of items you
may need.
You will be able to create a spreadsheet, format
the information as you need and create simple formulas
to give you more in depth information for the task at hand.
Let's look at your completed spreadsheet and analysis.
You get an idea of what we're going to accomplish
in this guided project, you will create a spreadsheet
of information from scratch, use formulas to answer simple
questions and assist in some decision making.
Let's say you work for a company known as the Acme company.
Your company is getting ready to move a large group of staff
from one office to another, you're going to have different
needs for each department to help them move multiple floors
and needs to provide precise directions to the movers.
To make it a seamless move a spreadsheet allows you to take
that database information and be able to use formulas
to answer simple questions your movers may have.
So let's get started.
First of all, let's begin with making sure you have a copy
of Microsoft Excel.
If you already have Excel loaded on your computer, please
open that program.
Now, if you do not have the Excel program, please go to the
following web page to obtain a free copy the web pages www
dot Microsoft dot com dash ian us back slash Microsoft dash
365 back slash free dash office dash online dash four dash
the the dash web.
This allows you to sign up for free at at the website, click
on the sign up for free button and pause the video
until you complete the sign up and then restart your video.
Now that you have your session and ready for excel, you
should be at the Excel start screen.
Once you're there, locate and select a blank workbook, this
is what this will look like.
It will be new, click on that Once you do that, this
will allow you to access the Excel interface.
When you look at the cell screen, you see a rectangular table
or grid of rose and columns.
The horizontal als rose are identified by numbers
123 etcetera and the vertical columns by letters
of the alphabet, A.
B, C, etcetera.
For any column that goes beyond the number, 26 columns
have been identified by two or more letters such as column A,
A, B, A, C.
Or even a A, A B etcetera.
The intersection point between a column and row is the small
rectangular box known as a cell.
The cell is a basic unit for storing data in the worksheet
and because each worksheet contains millions of these cells,
each one is identified by its cell reference.
A cell reference is a combination of the column letter
and the row number such as a three B six And even a 345.
In these cell references, the column letter is always listed
first. This concludes this task.
If you need additional time to complete this task, please
pause the video now, Congratulations.
In this task, we learned what Excel is used for, downloaded
a free copy of Microsoft 365 XL and have a blank spreadsheet
ready for data entry, we identified the naming of the columns,
rows and cells.
In the next task, we will learn the parts of the Excel window
and how to navigate them.
