Category Archives: Microsoft Excel Tutorials

How to add in Excel

How to add in Excel

How to add in Excel manually
How to add in Excel manually
How to add in Excel using SUM
How to add in Excel using SUM

 

A Tutorial on how to add in Microsoft Excel.

Numbers in Excel can be added in several ways  including:

  1. Typing in the numbers and formula all at once for simple additions
  2. Adding together numbers in existing cells by typing a formula
  3. Adding numbers in cells by clicking the Insert Function (fx) button and clicking SUM
  4. Adding numbers in cells by clicking the Autosum function from the formulas menu.

The first method can be accomplished by clicking a Cell and typing the = sign followed by the first number you want to add followed by the + sign and the second number you want to add followed by another + sign and another number for as many numbers as you want. Example: =9+5+7.

Continue reading How to add in Excel

How to use Auto Fill in Excel

How to use Auto Fill in Microsoft Excel

A tutorial showing how to automatically copy or increment data in Excel spreadsheet cells using Auto Fill.

 

Data in a spreadsheet cell can be filled into other cells just by dragging the cell down or double-clicking on the last row in a series.

The Auto Fill can either repeat the contents of cells or increment the contents of cells and formulas. Sometimes the autofill will increment when you wish to repeat. You have the option to correct this after the Auto Fill takes place by clicking on the autofill options.
Continue reading How to use Auto Fill in Excel