Best 10 Excel Features That a Business Should Be Putting Into Use.

Those that only use Excel as a fancy desktop calculator are not in any way tapping into the power of the Spread Sheet.


AutoSum Feature

You would significantly increase your business efficiency and time savings if the following features were understood, learnt and put into use.



1. AutoSum features. There are other options available with this button: Average, Count Numbers, Max and Min.

2. Formatting cells for text, size, colour and border including conditional formatting.

Formatting Cells

3. Formatting cells for Number, Time, Date and Currency.

4. Using Fill (Pull Down) to replicate formulas.

5. Setting a Print Area.

6. Saving your spread sheet as a PDF file.

7. Using the $ sign to lock cell references for fixed and variable reference values (absolute references) e.g. C4*$A$1

8. Protecting Sheets to prevent unwanted editing or entry into certain cells.

Fill Feature

9. Producing a selection list using the List option in Data Validation.

10. Adding a Filter to columns.



Learning the above is not hard and would take relatively little time.

Does anyone feel there are other features that should be in this list?