-
Excel Dashboards & Reports For Dummies, 4th Edition
Author Michael Alexander
It’s time for some truly “Excel-lent” spreadsheet reportingBeneath the seemingly endless rows and columns of cells, the latest version of Microsoft Excel boasts an astonishing variety of features and capabilities. But how do you go about tapping into some of that power without spending all of your d....
Release Date 2022/04 -
Excel Power Pivot & Power Query For Dummies, 2nd Edition
Author Michael Alexander
Learn to crunch huge amounts of data with PowerPivot and Power QueryDo you have a ton of data you need to make sense of? Microsoft’s Excel program can handle amazingly large data sets, but you’ll need to get familiar with PowerPivot and Power Query to get started. And that’s where Dummies comes in. ....
Release Date 2022/03 -
Author Michael Alexander , Dick Kusleika
Your personal, hands-on guide to the latest and most useful features in Microsoft Excel 365Excel 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 intellige....
Release Date 2022/03 -
Excel 2019 Power Programming with VBA
Author Dick Kusleika , Michael Alexander
Maximize your Excel experience with VBAExcel 2019 Power Programming with VBA is fully updated to cover all the latest tools and tricks of Excel 2019. Encompassing an analysis of Excel application development and a complete introduction to Visual Basic for Applicati....
Release Date 2019/05 -
Microsoft Excel 2019 Pivot Table Data Crunching
Author Michael Alexander , Bill Jelen
Renowned Excel experts Bill Jelen (MrExcel) and Michael Alexander help you crunch data from any source with Excel 2019 pivot tables. Use Excel 2019 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours, to take control of yo....
Release Date 2019/01 -
Author John Walkenbach , Richard Kusleika , Michael Alexander
The complete guide to Excel 2019Whether 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. Whether you use Excel at work or at home, you will be guided through the powerful new featur....
Release Date 2018/10 -
Excel Power Pivot and Power Query For Dummies
Author Michael Alexander
A guide to PowerPivot and Power Query no data cruncher should be without!Want to familiarize yourself with the rich set of Microsoft Excel tools and reporting capabilities available from PowerPivot and Power Query? Look no further! Excel PowerPivot & Power Quer....
Release Date 2016/04 -
Excel 2016 Power Programming with VBA
Author Richard Kusleika , Michael Alexander
Maximize your Excel experience with VBAExcel 2016 Power Programming with VBA is fully updated to cover all the latest tools and tricks of Excel 2016. Encompassing an analysis of Excel application development and a complete introduction to Visual Basic for Applicati....
Release Date 2016/02 -
Excel Dashboards and Reports for Dummies, 3rd Edition
Author Michael Alexander
Make the most of your data using the power of ExcelWhen you think of data, do you think of endless rows and columns in spreadsheets? Excel Dashboards and Reports For Dummies, 3rd Edition shows you how to make the most of your data—and puts an end to mind-numbing sp....
Release Date 2016/01 -
Author Richard Kusleika , Michael Alexander
Leverage the full power of Excel formulasExcel 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 formula....
Release Date 2016/01 -
Author Richard Kusleika , Michael Alexander
Master database creation and managementAccess 2016 Bible is your, comprehensive reference to the world's most popular database management tool. With clear guidance toward everything from the basics to the advanced, this go-to reference helps you take advantage of ....
Release Date 2015/11 -
Excel® 2016 Pivot Table Data Crunching
Author Michael Alexander , Bill Jelen
Excel® 2016 PIVOT TABLE DATA CRUNCHINGCRUNCH DATA FROM ANY SOURCE, QUICKLY AND EASILY, WITH EXCEL 2016 PIVOT TABLES!Use Excel 2016 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours… understand exactly what’s going on in y....
Release Date 2015/11 -
Author Michael Alexander
Ready-made Excel macros that will streamline your workflowExcel Macros For Dummies helps you save time, automate, and be more productive, even with no programming experience at all. Each chapter offers practical macros that you can implement right away, with practi....
Release Date 2015/06 -
101 Ready-to-Use Excel Formulas
Author Michael Alexander , Dick Kusleika
Mr. Spreadsheet has done it again with 101 easy-to-apply Excel formulas101 Ready-to-Use Excel Formulas is filled with the most commonly-used, real-world Excel formulas that can be repurposed and put into action, saving you time and increasing your productivity. Each....
Release Date 2014/08 -
Excel Dashboards and Reports For Dummies, 2nd Edition
Author Michael Alexander
Create dynamic dashboards and put your data on display with For DummiesNo matter what business you're in, reports have become a staple of the workplace, but what good is a report if no reads it, or even worse, understands it? This all new edition of Excel Dashboard....
Release Date 2014/03 -
Office 2013 Bible: The Comprehensive Tutorial Resource
Author Faithe Wempen , Dick Kusleika , Michael Alexander , John Walkenbach , Lisa A. Bucki
The best of the best from our Excel, Word, Access, and PowerPoint Bibles!Learn the sought-after features of the core applications from the Office 2013 suite. This Office 2013 Bible features the best-of-the-best content from the Excel 2013 Bible, by "Mr. Spreadsheet"....
Release Date 2013/07 -
Excel Dashboards and Reports, 2nd Edition
Author John Walkenbach , Michael Alexander
Learn to use Excel dashboards and reports to better conceptualize dataUpdated for all the latest features and capabilities of Excel 2013, this go-to resource provides you with in-depth coverage of the individual functions and tools that can be used to create compell....
Release Date 2013/05 -
Author Michael Alexander
Full-color, step-by-step tasks walk you through everything you want to do with Excel 2013. Step-by-step instructions with callouts to Excel 2013 screenshots that show you exactly what to do. Help when you run into Excel 2013 problems or limitations. Tips and Notes ....
Release Date 2013/05 -
Author Dick Kusleika , Michael Alexander
A comprehensive reference to the updated and new features of Access 2013As the world's most popular database management tool, Access enables you to organize, present, analyze, and share data as well as build powerful database solutions. However, databases can be co....
Release Date 2013/04 -
Excel 2013 Pivot Table Data Crunching
Author Michael Alexander , Bill Jelen
CRUNCH ANY DATA, FROM ANY SOURCE, QUICKLY AND EASILY, WITH EXCEL 2013 PIVOT TABLES!Use Excel 2013 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours… understand exactly what’s going on in your business… take control, and s....
Release Date 2013/01 -
Author John Walkenbach , Michael Alexander
Save time and be more productive with this helpful guide to Excel macros!While most books about Excel macros offer only minor examples, usually aimed at illustrating a particular topic, this invaluable resource provides you with the tools needed to efficiently and e....
Release Date 2012/06 -
Pivot Table Data Crunching: Microsoft
Author Michael Alexander , Bill Jelen
PivotTables may be Excel's most powerful feature, but Microsoft has estimated that only 15% of Excel users take advantage of them. That's because PivotTables (and their companion feature, PivotCharts) have a reputation for being difficult to learn. Not any more! I....
Release Date 2010/10 -
Author John Walkenbach , Michael Alexander
The go to resource for how to use Excel dashboards and reports to better conceptualize dataMany Excel books do an adequate job of discussing the individual functions and tools that can be used to create an "Excel Report." What they don't offer is the most effective....
Release Date 2010/09 -
Author Michael Alexander
This year, millions of beginner-to-intermediate-level users will be searching for the easiest possible way to master Excel 2010's new features - and, with Easy Microsoft Excel 2010, you'll find exactly what you're looking for. This full-color, utterly simple, ste....
Release Date 2010/06 -
The Excel® Analyst's Guide to Access®
Author Michael Alexander
The ultimate handbook for Excel analysts who need reporting solutions using AccessExcel and Access are intended to work together. This book offers a comprehensive review of the extensive analytical and reporting functionality that Access provides and how it enhances....
Release Date 2010/04 -
Excel® 2007 VBA Programmer's Reference
Author Michael Alexander , Rob Bovey , Stephen Bullen , John Green
Get ready to take your Excel applications to the next level by harnessing the power of the VBA language. This comprehensive resource will help you gain more control over your spreadsheets by using VBA while also showing you how to develop more dynamic Excel applicat....
Release Date 2007/03