Excel 2010 Tutorial For Beginners #1 - Overview (Microsoft Excel)
Summary
TLDRThis tutorial introduces Microsoft Excel 2010 by guiding viewers through creating a simple spreadsheet for tracking donut sales. It covers adding a title, entering data for January to March, and using Excel's auto-fill feature for dates. The video demonstrates entering sales figures, using the AutoSum tool for totals, and formatting the spreadsheet with bold, borders, and colors. It also shows how to apply currency formatting and adjust decimal places. Finally, it introduces creating a 2D column chart and highlights Excel's dynamic updating of calculations and charts when data changes.
Takeaways
- 📊 Creating a simple spreadsheet in Excel 2010 involves inputting text, numbers, and formulas.
- 🖱️ Excel offers automated features like series completion (e.g., filling in months) by dragging the mouse.
- 🍩 The example in the video focuses on sales data for a donut business, specifically their best-selling products.
- 💡 Calculations, such as summing totals, can be done quickly with the 'AutoSum' feature.
- 🔢 Totals can be calculated both horizontally for months and vertically for product lines using simple selections and the 'AutoSum' function.
- 🎨 Formatting tools, such as bold text, merging cells, and applying borders, help enhance the spreadsheet's visual presentation.
- 💷 Currency formatting is applied to the sales figures, and users can customize the currency symbol (e.g., pound, dollar).
- 📈 Creating a chart is easy by selecting data and inserting a column chart, which provides a visual representation of the sales figures.
- 🔄 Changes made to the data automatically update calculations and charts in real-time, demonstrating Excel's dynamic nature.
- 🖥️ Excel is a powerful tool for organizing data, saving time, and creating interactive, professional-looking spreadsheets for presentations.
Q & A
What is the main purpose of the video?
-The main purpose of the video is to provide a first look at Microsoft Excel 2010 and demonstrate how to create a simple spreadsheet including text, numbers, calculations, and a chart.
What is the business name used in the spreadsheet example?
-The business name used in the spreadsheet example is 'ABC Donuts Limited'.
How does the video demonstrate entering months into cells?
-The video shows how to enter months into cells by typing 'January' into cell B2 and then using the mouse pointer at the bottom right of the cell to click and drag across to automatically fill in 'February' and 'March'.
What automated feature of Excel is highlighted in the video?
-The video highlights Excel's ability to automatically complete a series of dates when dragging the fill handle.
What are the three best-selling donuts mentioned in the video?
-The three best-selling donuts mentioned are Jam, Custard, and Chocolate donuts.
How does the video show creating a total row for the sales figures?
-The video demonstrates creating a total row by selecting the cells where totals are needed, clicking the 'AutoSum' button under the Home tab, and letting Excel automatically calculate and insert the totals.
What is the purpose of applying bold formatting to certain cells?
-Applying bold formatting to certain cells, such as the title and labels, is done to make them stand out and be more visually prominent.
How does the video explain adding a border to the spreadsheet cells?
-The video explains adding a border to the spreadsheet cells by selecting the cells, clicking on the 'Borders' button, and choosing the 'All Borders' option to apply a stronger grid around the cells.
What is the significance of applying currency symbols to numbers in the spreadsheet?
-Applying currency symbols to numbers indicates that the figures represent monetary values rather than quantities, which can help clarify the data's context.
How does the video illustrate the dynamic nature of Excel spreadsheets?
-The video illustrates the dynamic nature of Excel spreadsheets by showing how changes in data, such as updating sales figures, automatically update linked calculations and charts.
What is the final step demonstrated in the video to enhance the spreadsheet's visual appeal?
-The final step demonstrated is adding a chart to the spreadsheet by selecting the data range, clicking on the 'Insert' menu, and choosing a 2D column chart.
Outlines
📊 Creating a Simple Spreadsheet with Excel 2010
The first paragraph introduces a video tutorial on Microsoft Excel 2010, demonstrating how to create a basic spreadsheet with text, numbers, calculations, and a simple chart. The example uses a business selling donuts, entering months (January to March) and best-selling donut types (Jam, Custard, Chocolate) with their corresponding sales figures. The tutorial also shows how to use Excel's automated features like autofill to complete date ranges and the 'AutoSum' feature to calculate totals for both rows and columns. The formatting of the spreadsheet is enhanced using functions like 'Merge and Center,' font size adjustments, and bold formatting for labels and totals.
🎨 Formatting and Enhancing the Spreadsheet
The second paragraph focuses on refining the spreadsheet’s appearance. It includes applying borders, grid lines, and fill colors to make the spreadsheet visually appealing. The tutorial highlights how to format cells using different colors for titles and totals, and how to apply currency symbols to sales numbers. The user learns how to remove unnecessary decimal points and change the default currency format if needed. The section wraps up by demonstrating how to create a 2D column chart based on selected data, excluding totals that would distort the visual representation. The paragraph emphasizes the advantages of an electronic spreadsheet by showing how changes to the data automatically update calculations and charts, offering a practical example of this feature.
Mindmap
Keywords
💡spreadsheet
💡Microsoft Excel 2010
💡calculations
💡chart
💡text
💡autosum
💡formatting
💡currency symbols
💡data series
💡merge and center
💡dynamic updates
Highlights
Introduction to creating a simple spreadsheet in Microsoft Excel 2010.
Adding a title to the spreadsheet: 'ABC Donuts Limited'.
Entering months into cells to automatically generate a series.
Entering sales data for best-selling donuts.
Using the right arrow key to move between cells for data entry.
Adding a new row for totals using the 'AutoSum' button.
Creating a grand total for each product line.
Observing the formula bar to see the calculation Excel uses.
Merging and centering cells for the title.
Increasing font size and applying bold formatting to the title.
Applying bold formatting to labels and the grand total.
Adding a border to the cells for a clearer grid.
Applying colors to cells for better visual distinction.
Adding currency symbols to numbers for clarity.
Adjusting decimal places for currency values.
Updating the chart automatically when data changes.
Demonstrating the instant update of totals and charts with data entry.
Encouraging viewers to learn more Excel features to become experts.
Transcripts
hello and welcome to a first look at
Microsoft Excel 2010 in this overview
video I'm going to create a simple
spreadsheet including text numbers
create some calculations and add a
simple chart as well at the end the
first thing I need to do is add a title
for my spreadsheet so I'm going to call
this one business name ABC Donuts
limited and the spreadsheet will be
about the bestsellers best-selling
Donuts so press the Enter key wants to
finish typing move down to the next row
and I could just use the arrow key to
come in to sell beats who are there
type the word January into b2 and I'd
like the next two cells to contain the
next two months so February and March
but I'm going to get Excel to do that
for me by putting the mouse pointer at
the bottom right of the cell there and
then just click and drag across and
you'll see that Excel automatically
completes that series of dates there's
lots of automated features like that
built into Excel and we'll explore some
of those later on
in future tutorials okay so let's come
back to column a and click into cell a3
there and I'm gonna enter my three best
selling Donuts well for this business
anyway if you prefer other Donuts then
you can enter your own names I don't
mind
so those are my labels for my little
spreadsheet the main labels and I'm
going to enter some sales numbers now or
sales figures and let's say in January
for jam donuts we sold maybe 100 pounds
worth
press the right arrow key to move across
here in February we'll say 150 and in
March will say 195 just use again the
arrow keys to move around so if a
custard let's say we had maybe 150 sold
in January hundred ninety five in
February and maybe 250 March big surge
there and for chocolate let's say we
sold hundred and seventy five in January
two hundred in February
and maybe 2:25 in March okay so those
are the figures and I'm going to add a
new row on now to create some totals so
I'm going to add a label at the
beginning of the row total just press
the right arrow key again move across
and they can create the totals very
quickly just click and drag across to
select those three cells where I want my
totals to appear and then make sure you
have the Home tab highlighted and if you
come across the right-hand side of the
Home tab you'll see the autosum button
there just click that and it'll
automatically pop the totals in for me I
also want to have totals down in column
E here for each of the product lines and
a grand total to appear at the end of
the total row so I'm going to add a new
label at the top layer in cell e2 again
call it total press the Enter key and
then just select the four cells there
where like my totals to appear again
just click that autosum button and Excel
puts the totals in there for me and you
may notice above the spreadsheet in this
formula bar here you can actually see
the calculation that Excel is using to
create the result okay so I have my
numbers and calculations all entered and
I want to now Adobe form I think as a
spreadsheet looking a bit playing there
first thing I'm going to do here is
select to the cells a1 across to e1 and
then click on this merge and center
button here click on that you'll see
what happens it merges those cells
together and centers my title I can then
increase the size of that little bit by
clicking the drop down arrow on the font
size button there and as I move the
mouse down the numbers you'll see that I
get an instant preview so I can see if I
select a size that's too big or too
small
before I actually click on the
appropriate one I'm just going to choose
font size 14 for now and also apply bold
formatting there make it stand out I'm
also going to select all the labels so
I'm going to select total March February
and January then hold down the ctrl key
in simultaneous
select gem right down to total so all
the labels click on B for bold again to
make those standouts and I'm also going
to apply bold formatting to my grand
total so it's click on that one cell and
I like that I'm also going to select all
the cells from six right back up to a-1
and apply a border a grid around all the
cells and to do that just click on this
drop down borders button here select the
all borders option and if I click away
you'll see it's applied a stronger grid
around the cells Excel does obviously
have a grid of its own but when you
print your spreadsheet by default that
grin doesn't appear so by applying if
you like a formatted grid if that will
show up when you print okay I'm gonna
apply some colors as well here now if I
click in my title this time to click on
the drop down where the fill color tool
is and as you see again as I move over
these different options it gives me a
live preview I'm just going to select
this maybe a light blue there for the
title and I'm going to select all the
cells again from e2 right back to a2
again hold down the control key select
a3 down to a six so I have all the
titles selected and this time we'll
apply a different color maybe though I
like to green there and just to make my
grand total stand out as well I'll
choose another color for that and we'll
maybe go for this light orange color one
more thing I'll do here is actually
apply currency symbols to my numbers
because it may not be obvious that I'm
talking about currency values as opposed
to quantities so I'm going to select all
the numbers in this case from b3 down to
e6 and over in the number section of the
Home tab there's a button there currency
and if I just click on that you'll see
it applies the currency formatting it
also applies to decimal places now in
this particular case I don't want those
so I'm going to come across a bit
further on number section two this
button here that will decrease the
decimal numbers or decimal places
I just click that twice it'll take those
decimals away lead with whole values
again now my currency is pound signs by
default because I'm in the UK and that's
what my computer set to show if you're
in the USA for example it's probably
defaulted to the dollar symbol however
if you do want to change it then next to
that currency button there's a small
drop-down arrow and it does offer the
three most common currencies as options
and there are many more available as
well by selecting more accounting
formats so if I just press the Escape
key that'll cancel that menu if I just
click away you will see my final
spreadsheet there now one last bit of
formatting who will actually do is
select all my total figures apart from
the grand total of already formatted and
just make those bold as well click away
again now I might want to use these
numbers as part of a presentation so I'd
like to make the spreadsheet look a bit
more interesting and to do that I'm
going to add a chart and I'm going to
select to create a chart cells a2 down
to d5 and ever includes obviously all
the titles there and all the numbers but
it does exclude the main title and it
does exclude the total figures as well
because the total figures would distort
the chart and I don't want to include
those so once I've got my selection
click on the insert menu click on the
column chart button and simply select
the first option 2d column chart once
I've clicked on that the chart appears I
can then click and drag that to
reposition it below my data and then
click away so there we have a nice chart
and my data now the nice thing about a
spreadsheet electronic spreadsheet as
opposed to a paper-based one is that any
changes you make will automatically
update all the linked calculations so in
this case I have total calculations
linked to the main data and I've also
got the chart linked as well and I can
demonstrate how that works by if I click
in cell b3 which my sales for January
for gem
let's say I've made a mistake and the
figure for that should have been 200 I'm
not 100 so if I type in there 200 before
I press the Enter key keep an eye on the
total figure down the bottom there
you'll also notice it's the grand total
changes and also if you look at the blue
bar on the chart when I press the Enter
key you'll see that all those things
instantly change and I'm going to undo
that this controls that to undo and
let's make it even more dramatic change
it to 250 and again you'll see how it
all updates instantly as soon as I enter
the new value so hope I've shown you
there that Excel it's not only a great
way of organizing information it's also
a great time-saver so whenever you
update your data all the calculations
and any chance that are linked to that
data instantly update it's very useful
tool so now you've seen how easy it is
to create a simple spreadsheet let's go
on and work on other examples show your
more features in Excel and turn you into
I hope an excel expert so thank you very
much for watching this I hope you found
some things in there that were useful
and I'll see you next time
Weitere ähnliche Videos ansehen
Cómo usar HOJA DE CÁLCULO en google drive fácil. Parte 1
Gantt Chart Excel Tutorial - How to make a Basic Gantt Chart in Microsoft Excel
SAP ABAP Eğitimi 55 - OO ALV Cell Style
Microsoft Excel 2019 - Full Tutorial for Beginners in 17 MINUTES!
TLE 7- MATATAG CURRICULUM LESSON (1ST QTR)- CREATING SPREADSHEETS W/CONDITIONAL FORMATTING
Google Sheets - Conditional Formatting
5.0 / 5 (0 votes)