Learn How To Use Excel 2010 Pdf

Learn how to use excel 2010 pdf

Learn how to use excel 2010 pdf

Microsoft Excel is a powerful spreadsheet application that can be used for anything from a simple database all the way up to a full fledged Windows application full with windows forms, macros, and add-ons. You can use Excel to calculate a car loan payment, graph data, manage customer records, keep an address book, etc. Excel is currently used by most large financial institutions for daily financial data analysis. It has a huge range of financial functions, formulas, and add-ons that allows you to use Excel to store and analyze data in a simple, quick way.

Open Excel and a new workbook will automatically be created. A Workbook is the top level object in Excel. It contains Worksheets, which hold all the actual data that you will be working with.

excel 2010 tutorial for beginners pdf

A workbook starts off with three worksheets, but you can add or delete worksheets at any time as long as there is at least one worksheet in a given workbook. Now depending on the version of Excel you are using, the following screen may look completely different.

Learn how to use excel 2010 pdf

Microsoft has changed the interface wildly from Office to to and finally in Office just makes the look more clean, but the overall layout is still the same. Across the top, you have the Excel ribbon with multiple tabs and also a bunch of little icons at the top in the Quick Access Toolbar.

Subscribe to Online Tech Tips

These little icons let you perform very common Excel functions like adding or deleting rows in the worksheet or freezing panes, etc. If you want to customize the ribbon interface, i.

By default, it shows you the popular commands, but you can click on the dropdown to see all the possible options for different tabs. Also, one option I really like is choosing Commands Not in the Ribbon from the dropdown.

The great escape susan elizabeth phillips pdf download

This is the default number that every Excel workbook starts off with. This is where you can perform many common tasks such as opening a workbook, creating a new one, printing and more.

Excel Tutorials for Beginners

The best way to learn anything is to actually do something useful and Excel is the best example of this! Sounds like a simple problem and it is once you get the formula in your head! In Excel, the columns are labeled starting from A and continuing to Z and beyond. A cell is simply a particular row number and column, i. A1 is the very first cell in an Excel worksheet.

Microsoft Excel Basics Tutorial – Learning How to Use Excel

The grid is now nicely centered with all the data directly underneath the headings. Click on cell A1 and drag the mouse while holding the button down to cell D1. Right click and select Format Cells.

Now there are two options you have at this point.

Excel 2010

This floating menu is kind of a popular options toolbar that lets you quickly change the font, change the text size, format the cell as money or percentage, lets you change the background or font color and add borders to the cell. If you have to do some more advanced formatting not available in the quick toolbar, then go ahead and open the dialog.

Tom rachman the imperfectionists pdf viewer

In the Format Cells dialog, click on the Patterns tab and select a color from the palette. I chose yellow to make it distinct. This time go to the Border tab. Click on the Outside and Inside buttons and you should see the small display box directly below the buttons change accordingly with the borders.

Click OK and you should now have black lines between all of the cells. You can do this type of formatting for your data also in the way you feel appropriate.

Get started with these tips for beginners

So we want to first calculate the average grade for our 5 students after their 1st three exams. Add a header called Sum in column F and Avg in column G and format them the same way we did the other header cells. When you type in the first parenthesis, Excel will display a little label showing you what types of variables this function takes.

The word SUM is a built-in function in Excel which calculates the sum of a specified range of cells. At this point after the first parenthesis, you can select the range of cells you want to sum up!

Learn how to use excel 2010 pdf

No need to type the cells one by one! Go ahead and select cells B2 to D2 and you will see that the formula is automatically updated and is in blue. And now you have the sum of the numbers!

Not too hard right!? However, you might say that it would be a royal pain to do this for a set of or students!

Excel 2010 Tutorial For Beginners Pdf

Click on cell F2 and then move your mouse slowly to the lower right edge of the cell. Press Enter and you now have entered your own average forumla! You can use parenthesis and perform all the math functions in this same way. Excel will calculate the average for the rest of the cells using your formula. Here is the formula, which I got from this site. Final Grade would be the 70 since that is the passing score we are assuming, Exam Worth is. So the equation would become:.

You should now see the grade required and also the formula in the formula bar above the column names.

First Steps Into Excel

As you can see below, Student A needs to get at least a 49 to make sure they get a 70 passing score for their final grade. Again, grab the bottom black box of the cell and drag it down to the bottom of the data set.

And viola! Hope this helped!

Learn how to use excel 2010 pdf

Please leave your comments on this Excel tutorial! Founder of Online Tech Tips and managing editor.

He began blogging in and quit his job in to blog full-time. He has over 15 years of industry experience in IT and holds several technical certifications.

Convert Excel 2010 spreadsheets to PDF

Read Aseem's Full Bio. We hate spam too, unsubscribe at any time. How to Open a File with No Extension.