Excel - How to

Microsoft Excel Pivot Table Data Crunching shares practical “recipes” for solving real business problems, expert insights for avoiding mistakes, and advanced tips and tricks you’ll find nowhere else.

Microsoft excel step by step is learning made easy. Get more done, more quickly, with Microsoft Excel. Jump in wherever you need answers―brisk lessons and detailed screenshots show you exactly what to do, step by step.

Master business modeling and analysis techniques with Microsoft Excel and transform data into bottom-line results. Microsoft Excel 365 data analysis and business modeling is a hands-on, scenario-focused guide helps you use today’s Excel to ask the right questions and get accurate, actionable answers.

Data Visualization with Excel Dashboards and Reports fills the gap between handling data and synthesizing data into meaningful reports.  This title will show readers how to think about their data in ways other than columns and rows.

Excel VBA in easy steps neatly demonstrates VBA (Visual Basic for Applications) Macro programming in a clear and concise manner, so you can get more from the popular Microsoft Excel spreadsheet application. Use this guide to learn the key features constructively

Looking for ready-made Excel macros that will streamline your workflow? Look no further! Excel Macros For Dummies, 2nd Edition helps you save time, automate, and be more productive–even with no programming experience at all. 

 Microsoft Excel can perform many statistical analyses, but thousands of business users and analysts are now reaching its limits. R, in contrast, can perform virtually any imaginable analysis―if you can get over its learning curve. In R for Microsoft® Excel Users, Conrad Carlberg shows exactly how to get the most from both programs.

There are more than 400 built-in functions in Excel 2019, from AGGREGATE to Z.TEST. The question is which ones will make your work easier? How and why should you use a particular function in your formulas? Excel Formulas and Functions For Dummies offers thorough but easy-to-read coverage of powerful Excel functions.

Ideal for those already familiar with basic Excel features, this updated Third Edition of Neil J. Salkind's Excel Statistics: A Quick Guide shows readers how to utilize Microsoft® Excel's functions and Analysis ToolPak to answer simple and complex questions about data. Part I explores 35 Excel functions, while Part II contains 20 Analysis ToolPak tools.