The MS Excel® Formulas Study Brief provides the end-user with a handy reference guide that describes useful and time-saving formulas for this widely-used spreadsheet application. This Study Brief collects and organizes a wealth of need-to-know information in a short format. It is intended to serve as a basic introduction for new users of Microsoft Excel® that want to be more productive quickly, or as a refresher for experienced Excel® users to find additional tips and techniques for working more efficiently. A quick review of Excel® formula basics outlines some key fundamentals, including parts of an MS Excel® formula, types of formulas, functions and operators, how to enter formulas and how to correct common errors. Sample formulas are categorized by function in useful reference charts, providing proper syntax, explanations of use, and real-world examples with actual data. Helpful formulas for working with statistical and math functions, date and time functions, text functions, lookup and reference functions, information functions and logical functions are included. Details about complex and combination formulas are also provided for the advanced user. Study Briefs are concise and visual academic outlines that help students and professionals master key concepts quickly and accurately. Don’t spend your valuable time researching on multiple websites, paging through books or investigating reference sources. Our experts have done the research for you! Compiled in one convenient guide, you will find up-to-date and reliable sources presented in a visual and easy to follow format for everyday use. Choose from our ever-growing library of need-to-know topics in the following subject categories: Business, Math, Reference, Science, Language, History and Technology!