In Excel 2007: Advanced Formulas and Functions, author and trainer Dennis
Taylor demystifies some of the most challenging of the 300+ formulas and
functions in Excel and shows how to put them to their best use. Dennis starts
with a review of the more basic, building-block functions, and a few critical
keyboard shortcuts that will speed up working with Excel data, even on
multiple sheets. He then covers how to perform advanced searching and data
retrieval with Lookup functions, tabulate and sort data with counting and
statistical functions, format data with text and math functions, and even
work with financial data using advanced formulas. Dennis focuses on practical
examples that will help users easily transition to using these formulas and
functions in real-world scenarios.
Download File Size:410.25 MB