Study Briefs

Advanced MS Excel Formulas

  • Format: eBook
  • Edition: 2016
  • Publisher: Little Green Apples Publishing LLC

Price: $4.99

Available worldwide from:

Buy Advanced MS Excel Formulas on iBooks Buy Advanced MS Excel Formulas on Amazon Buy Advanced MS Excel Formulas on TextbookRush

Description:

The Advanced MS Excel® Formulas Study Brief aims to offer experienced Excel® users advice and techniques for working more productively and efficiently with spreadsheets in this easy-to-follow reference guide. A brief refresher of MS Excel® formula basics outlines some key fundamentals, including alternate ways to enter formulas, explanations of common MS Excel® errors and how to resolve them, as well as useful tips for entering and debugging formullas. Plenty of examples of advanced formulas to reference in solving particular problems are provided. Working with the Visual Basic Editor (VBE) within MS Excel® to create macros is discussed as is the process for creating user defined functions (UDFs) to perform basic tasks. Other sections focus on functions such as adding comments, using SUMIFs, performing two-way lookups, using array formulas, creating charts, taking full advantage of PivotTables, importing data using Web Query function or Visual Basic for Applications (VBA), working with conditional formatting and using various methods for data validation. An annotated list of recommended web resources and useful Internet links are included to encourage more detailed investigation into this topic.

Topics Covered:

  • What is an MS Excel® Formula?
  • Ways to Enter Formulas in MS Excel®
  • Handling Errors in MS Excel® Formulas
  • Tips for Debugging Formulas
  • Using Visual Basic for Applications (VBA)
  • Adding Comments to MS Excel®
  • Using a User-Defined Functions (UDF)
  • Advanced Excel® Formulas
  • Resources

Browse Subjects