Microsoft Excel Basics – Creating Sums in Excel

Creating sums in excel is not that hard after all. I know most people see Microsoft Excel spreadsheets and automatically think they are difficult. As you will see in this tutorial, making sums in Excel is just a matter of knowing the formulas. Once you learn the Microsoft Excel basics it is easy to learn the more difficult features and use Microsoft Excel to your advantage. I believe that everyone can find the use for this fantastic software. Even the stay at home mum can make a family budget in Excel as the uses for this program are endless. You will most likely need to know how to create a basic spreadsheet and then can move onto to this tutorial with that background knowledge.

How to Use Sums in Excel to Create a Formula?

To use sums in Microsoft Excel, we first need to know the address of each cell. If you look at the screen shot below I have two arrows pointing to a particular cell. This shows you the address of that cell in Excel. As you can see it is D4. Therefore the cell to the right on the same row would be E4. Once you understand this we can now look at Excel Sums.

Microsoft Excel Basics – Sums in Excel

Remember this is a Microsoft Excel basics tutorial so I am going to focus on the four main ingredients to make sums in excel. As you can see I have listed the Excel sums that I would like to explain.
- = minus
* = multiply
/ = division
+ = plus

Microsoft Excel Basics – Sums in Excel

This tutorial is equal to learning one plus one. In the screenshot below I have a table that I have made and it shows the sum I created to add up totals for me automatically. As you can see I have used =N3-K3. This means that the K3 cell will be subtracted from the N3 cell. If I wanted to add the cells together I would have =N3+K3. If I wanted to divide I would have =N3/K3.

To find the total of two cells:

1.  Click on the empty cell where you want the answer to appear. This is the total of the two cells that we are going to add together.
2.  Put = in the cell.
3.  Then click on the cell that is first in the Excel sum.
4.  Now type in your minus, plus,divided by, or times, sign.
5.  Now click on the second cell that goes into this sum.
In the screen shot above I clicked on O3, then typed the = sign, clicked on N3, then typed the – sign, then clicked on K3.
Once you have made your tables and sums in Excel you can now use that data to create a graph.

Reade more >>

Tab Color In Excel

Did you know you can color the tabs in Excel?
This can be really helpful if you’re trying to draw attention to the tabs, make sure a tab is seen as an exception, etc.  It’s really simple to do – just right-click the tab, select tab color and then the color you want to use.
Now you can color your Excel Tabs.

Reade more >>

Working with Large Lists in Microsoft Excel

There are a lot of times when you’re working with a data sheet containing a lot of information where you essentially want to filter the information – find only those rows that have information you care about.  It’s a pretty simple thing to do with the handy AutoFilter feature in Microsoft Excel.  Just highlight your data (be sure to get all of it – all rows and columns in your data table) and select Data, Filter, AutoFilter.
When you do, you’ll notice new list box arrows at the top of each column.  Click that list box arrow and you’ll have several options for selecting information.  You’ll be able to select specific values, ranges of values, top n values and so-forth.  It’s really a great way to help manage large number of rows of data – and make it more straightforward to work with in your analysis.
If you have multiple columns of data, you can select first from one, then the other.  The filters will, in essence, be combined.  For example if one column was State and one was City, working with the entire data set could be tedious.  Add in the AutoFilter and then select State of Arizona.  Next, you can select Miami and you’ll only be looking at the Miami in Arizona, not in Florida.  Simple example, but hopefully you get the idea.
To return to “regular” unfiltered mode, just select Data, Filter, AutoFilter again and the list boxes will be removed.
Now! easily filter your data in Microsoft Excel.

Reade more >>

Quick Current Date and Time in Excel

Do you know that you can enter Current Date and Time in Microsoft Excel.

• To enter Current Date in a cell Press Ctrl+; (semicolon ) it will inserts Current Date in your current Cell.
• To enter Current Time  in a cell Press Ctrl+Shift+: (colon ) it will inserts Current Time in your current Cell.

Know you know, how to insert Current Date and Time Microsoft Excel, next time when need to insert Current Date and Time in any cell of worksheet try these Keyboard Shortcust.
Enjoy Micorsoft Excel.

Reade more >>

Sheet Tabs Navigation In Excel

If you created a large workbook in Microsoft Excel and having problem to navigate sheet tabs then, there is two solutions to this:

1. Right click on one of the arrows to the left of the sheet tabs, a list will appear that contains the names of all the tabs in current workbook. You can then select a tab from the list and this will takes you to the tab.
2. Use Ctrl + Page Down to move forward a worksheet.  Ctrl + Page Up moves backwards.  Ensure Num Lock is off.

Happy Navigation of Sheet Tabs!!

Reade more >>