Your hands-on guide to building effective Power BI dashboards Expand your expertise-and teach yourself how to create world-class Power BI business analysis dashboards that bring data to life for better decision-making.
Master two of the most powerful features of Excel Even if you use Excel all the time, you may not be up to speed on two of Excel's most useful features.
250 + ready-to-use, powerful DAX formulasDevelop effective business intelligence (BI) solutions and drive faster, better decision making across your enterprise with help from an experienced database consultant and trainer.
Take your Excel formulas to the next level with this updated reference John Walkenbach's name is synonymous with excellence in computer books that decipher complex technical topics.
A practical guide to building fully operational financial cash flow models for structured finance transactions Structured finance and securitization deals are becoming more commonplace on Wall Street.
Advanced techniques for Excel power users Crunch and analyze Excel data the way the professionals do with this clean, uncluttered, visual guide to advanced Excel techniques.
A well-balanced and accessible introduction to the elementary quantitative methods and Microsoft Office Excel applications used to guide business decision making Featuring quantitative techniques essential for modeling modern business situations, Introduction to Quantitative Methods in Business: With Applications Using Microsoft Office Excel provides guidance to assessing real-world data sets using Excel.
The complete guide to Excel 2019 Whether you are just starting out or an Excel novice, the Excel 2019 Bible is your comprehensive, go-to guide for all your Excel 2019 needs.
Millions of users create and share Excel spreadsheets every day, but few go deeply enough to learn the techniques that will make their work much easier.
Full-color, step-by-step guide to the new release of the world's most popular spreadsheet applicationGet up and running with Excel 2013 right away--the QuickSteps way.
Utilise Excel 2013 capabilities to build effective financial models Using Excel for Business Analysis, Revised Edition provides practical guidance for anyone looking to build financial models.
The advanced tools accountants need to build automated, reliable, and scalable reports using Excel Learn about the functions that work together to automate many of the processes involved in Management Reporting.
A comprehensive guide to gaining a 360-degree overview of the VBA programming language and learning how to build your own programs for automating routine tasksKey FeaturesExtend the capabilities of Excel and other Office applications with the help of Microsoft VBATake your Excel programming skills to the next level by creating custom applications with dialogue boxes and the range objectAutomate repetitive and monotonous office work with VBA Excel programmingBook DescriptionVisual Basic for Applications (VBA) is a programming language developed by Microsoft to automate tasks in MS Office applications.
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!
USE EXCEL'S STATISTICAL TOOLS TO TRANSFORM YOUR DATA INTO KNOWLEDGE Nationally recognized Excel expert Conrad Carlberg shows you how to use Excel 2016 to perform core statistical tasks every business professional, student, and researcher should master.
Newly updated for Excel 2002, Writing Excel Macros with VBA, 2nd Edition provides Excel power-users, as well as programmers who are unfamiliar with the Excel object model, with a solid introduction to writing Visual Basic for Applications (VBA) macros and programs for Excel.