Use Microsoft 365 Excel and Excel 2021 pivot tables and pivot charts to produce powerful, dynamic reports in minutes: take control of your data and your business! Even if you've never created a pivot table before, this book will help you leverage all their flexibility and analytical power-- including important recent improvements in Microsoft 365 Excel.
This condensed syntax reference presents the essential Excel function syntax in a well-organized format that can be used as a quick and handy reference.
Interested in the basics? You'll learn to create spreadsheets and workbooks and navigate the user interface. If you're ready for more advanced topics you can skip right to the material on creating visualizations, crafting custom functions, and using Visual Basic for Applications to script automations.
New coverage ranges from one-click data analysis to STOCKHISTORY, dynamic arrays to Power Query, and includes six new chapters. Practice with over 900 problems, many based on real challenges faced by working analysts.
Get more done quickly with Microsoft Word, Excel, PowerPoint, and Outlook. Jump in wherever you need answers―brisk lessons and detailed screenshots show you exactly what to do, step by step.