With this book, you'll learn to apply the power of Excel functions and formulas to make your work and other tasks easier. Compare 15-year vs. 30-year mortgage terms, choose between leasing or buying a car, compute classroom grades, create an amortization table, evaluate investment performance, calculate the real cost of credit card purchases, or forecast college expenses and savings. All of this and more is possible when you master functions and formulas...

"From basic Excel functions, such as creating and editing worksheets, to sharing and reviewing worksheets, to editing macros with Visual Basic, it provides you with a broad scope of the most common Excel applications and functions--including formatting worksheets, setting up formulas, protecting worksheets, importing data, charting data, and performing statistical functions. The book covers importing data, building and editing worksheets, creating...

Expert Paul McFedries helps you master key Excel tools for building more powerful spreadsheets. Use Excel 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 the latest improvements to arrays, formula error handling, and statistics. McFedries' step-by-step projects walk you through handling key...

Dive into Microsoft Excel 2019-and really put your spreadsheet expertise to work. This supremely organised reference packs hundreds of timesaving solutions, tips, and workarounds-all you need to make the most of Excel's most powerful tools for analysing data and making better decisions. Renowned Excel expert Bill Jelen offers a complete tour of Excel 2019 and Excel in Office 365, from efficient interface customisations to advanced analysis, visualisations,...

"Microsoft Excel in easy steps guides you through the essential functions of Microsoft Excel--whether you are new to Excel and the spreadsheet concept, or just upgrading from an older version. This edition is illustrated using the most up-to-date version of Excel in Microsoft 365 at the time of printing"--

PivotTables, one of Excel's most powerful features, let you interactively analyze, summarize, and explore large amounts of data with just a few mouse clicks. You can slice and dice data in many different ways, apply different summaries, and insert custom calculations to go beyond Excel's built-in aggregations. This collection of Shortcuts helps you get the most out of PivotTables, quickly and easily.

PivotTables, one of Excel's most powerful features, let you interactively analyze, summarize, and explore large amounts of data with just a few mouse clicks. You can slice and dice data in many different ways, apply different summaries, and insert custom calculations to go beyond Excel's built-in aggregations. This collection of Shortcuts helps you get the most out of PivotTables, quickly and easily.

PivotTables, one of Excel's most powerful features, let you interactively analyze, summarize, and explore large amounts of data with just a few mouse clicks. You can slice and dice data in many different ways, apply different summaries, and insert custom calculations to go beyond Excel's built-in aggregations. This collection of Shortcuts helps you get the most out of PivotTables, quickly and easily.

PivotTables, one of Excel's most powerful features, let you interactively analyze, summarize, and explore large amounts of data with just a few mouse clicks. You can slice and dice data in many different ways, apply different summaries, and insert custom calculations to go beyond Excel's built-in aggregations. This collection of Shortcuts helps you get the most out of PivotTables, quickly and easily.