Excel Formulas

EXCEL FORMULAS

1

Excel Formulas

This set of instructions is written for Excel 2010 users however the concepts can be applied to any spreadsheet application.

Contents Planning ........................................................................................................................................................ 2 Data Organization ......................................................................................................................................... 3 Formulas ....................................................................................................................................................... 3 Functions ....................................................................................................................................................... 4 List of Functions ........................................................................................................................................... 5 Getting Help .................................................................................................................................................. 6 Keyboard Shortcuts in Excel 2010................................................................................................................ 6 References ..................................................................................................................................................... 6

EXCEL FORMULAS

2

Planning

Before creating a spreadsheet there are a few questions to ask: • What is the purpose of the spreadsheet? o e.g. a budget, track sales, analyze numbers, create charts for presentations, etc. Determine the type of data you are working with. o Is it currency, percentage, or number needing a comma? o How many decimal places are needed? How is the information to be organized? o By time? (Day, month, or quarter?) o By category? (Income, expenses, etc.)

Figure 1: Common data formats

•

•

•...