Michael Alexander

Provides information on how to use Excel for business intelligence, including tips on using PivotTables, Excel charts, and representing data trends, and methods for creating effective dashboards.

Most books offer a very high-level overview of VBA, often providing readers with benign examples designed only to illustrate a particular topic. Analysts don't have the luxury of taking a few weeks time-out to learn VBA. The scenarios and issues they are facing require immediate help in the form of Excel Macros.

Learn the essentials of using Microsoft Access to store data, analyze information, build reports, create applications and much more! With "Microsoft Access 2019 bible", you'll gain a solid understanding of how Access works from the ground up. Starting with basic database concepts, you'll work your way through detailed instruction on building effective tables, creating powerful analytical queries, creating robust applications with Access forms, and...

"Excel 365 is Microsoft's latest cloud-based version of its world-famous spreadsheet app. Powerful and user-friendly, it's an ideal solution for businesses and people looking to make sense of--and draw intelligence from--their data. The Excel 365 Bible carries over the best content from the best-selling Excel 2019 Bible while reflecting how a new generation uses Excel in Excel 365. The authoring team with their decades of Excel and business intelligence...

"Excel 2016 Formulas is fully updated to cover all of the tips, tricks, and techniques you need to maximize the power of Excel 2016 through the use of formulas. This comprehensive book explains how to create financial formulas, release the power of array formulas, develop custom worksheet functions with VBA, debug formulas, and much more. Whether you're a beginner, a power user, or somewhere in between this is your essential go-to for the latest on...