In this chapter I will help you bring your worksheets to life, Excel Functions can enhance your ability to extract meaningful informations from a set of raw data. Without Functions and Formulas, a spreadsheet is just a collection of text and numbers.
While Excel is well known as a robust office software, many people creates surprisingly fragile spreadsheets, it is just too easy to make an accidental change and not know your spreadsheet is broken. Always keep this in mind when using Excel spreadsheets to take important business decisions…
Also, without solid math knowledge, your formulas may be wrong, without you knowing it. At this stage, my advice for you is to use Excel proffesional developers to build more reliable spreadsheets.
Before starting to dissect Excel Functions, you need to understand the parts of an Excel Function, and how Excel Intellisense can help you. All you need to know about formula basics, such as: function arguments, operators, Absolute and Relative References in Formulas, using Names in Formulas, is concentrated in this section:
If you already know Formula Basics, you can go directly to the Excel Functions List, to work on real examples of the most useful functions:
| Text Functions | Date & Time Functions | Information Functions | Logical Functions | Lookup & Reference Functions | Math & Trigonometry Functions |
| Read All | (Read All) | (Read All) | (Read All) | (Read All) | (Read All) |
| SUBSTITUTE | |||||
| LEN |