Excel: Getting Started
Excel: Getting Started
In this video, you’ll learn the basics of getting started with Excel 2019, Excel 2016, and Office 365. Visit https://edu.gcfglobal.org/en/excel/ge… for our text-based lesson.
This video includes information on:
• Working with the Excel environment, including changing the Ribbon
• Using the Quick Access Toolbar
• Using worksheet views
• Accessing Backstage View
We hope you enjoy!
Content
8.72 -> Excel is a spreadsheet program that allows
you to store, organize, and analyze information.
14.84 -> You can use it to create contact lists…
budgets…
19.7 -> invoices… and just about anything else you
can imagine.
24.7 -> When you open Excel, there's a good chance
you'll be taken to the start screen first.
29.09 -> From here you can access recent workbooks,
or create something new—either from scratch,
33.68 -> or from a template.
35.18 -> In this example, we'll click Blank Workbook.
40.35 -> Next you might want to take a minute to explore
the interface, and make sure you know your
43.73 -> way around.
44.73 -> Let’s begin with the ribbon - which is the
collection of tools and features at the top
48.43 -> of the screen.
50.37 -> The ribbon is divided into tabs like Page
Layout…
53.68 -> Insert… and Home, so you can easily find
what you're looking for.
58.51 -> There are also commands on each tab that have
been organized into groups.
62.3 -> For example, if you look closely at the Font
group, you'll find it has everything you need
66.31 -> to work with text, including options like
bold, italics, font color, and size.
72.33 -> Some groups even have an arrow in the bottom
right corner that you can click to view even
76.11 -> more commands.
79.9 -> If you ever feel like the ribbon is taking
up too much space, you can always hide or
83.76 -> minimize it.
85.11 -> All you have to do is click the arrow in the
upper right corner… then choose the option
89.4 -> you want.
91.88 -> Also in the upper right corner is a place
where you can access your Microsoft account.
95.479 -> Here you can update your photo, manage your
account settings, or switch to a different
99.67 -> account all together.
102.81 -> You can even customize your copy of Excel
to make certain commands more convenient.
107.03 -> Take the quick access toolbar in the upper
left corner.
110.05 -> This area gives you access to frequently used
commands like Save and Undo, no matter where
114.729 -> you are on the ribbon.
116.39 -> To add more commands, just click the tiny
arrow next to the toolbar… then choose the
120.53 -> ones you want.
121.81 -> I'm going to add New and also Quick Print
because I use both of these commands pretty
126.67 -> frequently.
127.67 -> In Excel 2016, you’ll also find a new feature
called Tell Me.
132.81 -> It works like a search bar to help you quickly
find tools or commands you want to use.
137.62 -> Just type in what you want to do, in your
own words.
140.56 -> The results will give you a few options, and
then guide you through the process, as well
144.28 -> as offering additional resources.
147.28 -> Now let's take a look at the workbook itself
(which is also sometimes referred to as a
151.35 -> worksheet, or a spreadsheet).
153.3 -> In this example, I've opened an order list
that I'm working on.
157.05 -> Every worksheet contains cells, columns, and
rows for entering data, plus the formula bar
162.56 -> for working with your data.
164.849 -> If you need to scroll up or down, or even
side to side, you can use the scroll bars
168.95 -> here… and here.
172.709 -> In the bottom right corner, you'll find several
tools that let you change the way your worksheet
176.52 -> is displayed.
178.15 -> To zoom in or out, click and drag the zoom
control.
181.69 -> The number next to the slider will tell you
what the zoom percentage is.
185.96 -> You can also switch between different worksheet
views using the three commands here.
190.17 -> Normal is selected by default.
192.28 -> This mode is great for everyday tasks like
entering and editing data.
196.59 -> Page Layout shows you what the worksheet will
look like on the printed page.
200.19 -> You can also add headers and footers here.
203.25 -> Page Break Preview makes it easy to change
the location of page breaks in your workbook.
207.76 -> This can be especially useful if you're printing
lots of data.
211.7 -> Last but not least, let’s take a quick tour
of the backstage view.
215.43 -> You can get there by clicking the File tab—just
look for it on the far left of the ribbon.
220.32 -> Here you can access all kinds of information
related to your current workbook, and more.
226.18 -> This includes commands like New…
228.23 -> Open…
229.23 -> Save… and Print.
231.59 -> All you have to do is click an item… and
it'll open in the right pane.
236.16 -> This makes it easy to find what you're looking
for—and review your options—all in one
240.29 -> place.
242.209 -> That covers the basics of Excel 2016!
245.069 -> Now that you're comfortable with the interface—including
the backstage view, the ribbon, and the work
250.52 -> area—you're ready to start your first worksheet.
Source: https://www.youtube.com/watch?v=lgIWIPDJuPo