Microsoft Excel Formulas and Functions (Office 2021 and Microsoft 365)

₹656.00 ₹820.00 Save ₹164.00 (20%)

In Stock & Ready to Ship

ISBN-13: Available on request

Binding: Paperback

Pages: Standard

Language: English

              Use Excel 365 and Excel 2021 core features to build spreadsheets that solve business problems and deliver reliable answers. Drawing on his unsurpassed experience, Paul McFedries helps you make the most of formulas and functions, including recent improvements ranging from dynamic arrays to XLOOKUP and LET. McFedries step-by-step projects walk you through handling key tasks, from building timesheets to projecting cash flow and aging receivables. His practical examples and clear instructions demystify intermediate-to-advanced-level formula construction, and help you leverage Excels most useful functions in your everyday work.

Contents:

Part I: Mastering Excel Formulas

 Building basic formulas
Creating advanced formulas
Troubleshooting formulas
Part II: Harnessing the power of Functions

Understanding functions
Working with text functions
Working with logical and information functions
Working with lookup functions
Working with date and time functions
Working with math functions
Part III: Building Business formulas

Implementing basic business formulas
Building descriptive statistical formulas
Building inferential statistical formulas
Applying regression to track trends and make forecasts
Building loan formulas
Working with investment formulas
Building discount formulas
Part IV: Building Business Models

Analyzing data with tables
Analyzing data with PivotTables
Using Excel’s business modeling tools
Solving complex problems with Solver
            

Title	Microsoft Excel Formulas and Functions (Office 2021 and Microsoft 365)
ISBN-13	—
ISBN-10	—
Publisher / Imprint	Microsoft Press
Binding	Paperback
Edition	1st Edition
Publication Date	2026
Number of Pages	—