Catalog Search Results
Reference Solutions
Conduct market and competitor research as well as business analysis by industry or geography.
More
Author
Pub. Date
2021.
Language
English
Description
Renowned Excel expert Bill Jelen (MrExcel) helps you crunch data from any source with Excel pivot tables. Use Excel pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours, to 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 remarkable flexibility and analytical powerincluding valuable improvements in Excel and Excel in...
Author
Series
Pub. Date
2011
Language
English
Description
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! In this book, Excel legends Bill Jelen ("MrExcel") and Michael Alexander teach PivotTables and PivotCharts step-by-step, using realistic business scenarios that any Excel user can intuitively...
Author
Series
Language
English
Formats
Description
Dive into Microsoft Excel 2019-and really put your spreadsheet expertise to work. This supremely organised reference packs hundreds of timesaving solutions, tips, and workarounds-all you need to make the most of Excel's most powerful tools for analysing data and making better decisions. Renowned Excel expert Bill Jelen offers a complete tour of Excel 2019 and Excel in Office 365, from efficient interface customisations to advanced analysis, visualisations,...
Author
Pub. Date
2013
Language
English
Description
"Explore the most popular and some of the lesser known features of Excel: PivotTables, PowerPivot, Power View, and GeoFlow with MrExcel as your guide! Start-to-finish personal training on Excel 2013: just watch and learn! Simple, quick video walkthroughs of the tasks you perform most often! Great personalized training at a fraction of the cost ... for everyone who doesn't have time to read a book! These video lessons will ensure that you can harness...
Author
Series
Pub. Date
[2019]
Language
English
Description
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 your data and your business. Even if you've never created a pivot table before, this book will help you leverage all their remarkable flexibility and analytical power-including valuable improvements...
Author
Series
Pub. Date
©2004
Language
English
Description
Everyone is looking for ways to save money these days. That can be hard to do for businesses that have complex needs, such as custom software applications. However, VBA and Macros for Microsoft Excel can teach you ways to customize pre-existing software to meet your specific needs. A variety of topics are covered that are sure to give you a solid knowledge of the VBA language. Event programming, user forms, carts, pivot tables, multi-dimensional arrays...
Author
Series
Pub. Date
Ã2005
Language
English
Description
Become a savvy Microsoft Excel user. Pivot tables are a great feature in Excel that help you organize and analyze data, but not many Excel users know how to use pivot tables. Pivot Table Data Crunching offers a comprehensive review of all the functionalities of Pivot Tables from author Bill Jelen, otherwise known as Mr. Excel from www.mrexcel.com, and Michael Alexander, a Microsoft Certified Application Developer. The authors' practical scenarios...
Author
Pub. Date
Ã2013
Language
English
Description
"In 97 quick video lessons, Power Excel 2013 with MrExcel shows how to maximize your productivity Excel's best tools and shortcuts. Expert Bill Jelen simplifies powerful features including PivotTables, PowerPivot, Charting, Flash Fill, VLOOKUP, Combo Chart, Mail Merge, SmartArt, and more! Get more done faster with Excel Web App, the Quick Access Toolbar, and keyboard shortcuts ... control and analyze data more effectively ... communicate more visually...
Author
Language
English
Description
MrExcel 2021 is designed to make the reader far more efficient in their use of Microsoft Excel. Originally designed for Bill Jelen's live Power Excel seminars, the target audience already uses Excel 40 hours a week. These tips are the "aha" tips that uncover secret methods in Excel. The book covers general Excel functions, pivot tables, formulas such as VLOOKUP and the new XLOOKUP. It introduces elements of modern Excel such as the Power Pivot Data...
Author
Language
English
Description
Originally designed for Bill Jelen's live Power Excel seminars, the target audience already uses Excel 40 hours a week. These tips are the "aha" tips that uncover secret methods in Excel. The book covers general Excel functions, pivot tables, and formulas such as VLOOKUP and the new XLOOKUP. It introduces elements of modern Excel such as the Power Pivot Data Model and cleaning data with Power Query. Updated annually, this edition for 2022 adds information...
Author
Series
Pub. Date
2006
Language
English
Description
This book consolidates all the best functionality of pivot tables into one guide that provides you with a meaningful tutorial, offering practical solutions to day-to-day problems. Within just the first 2 chapters, you will be creating basic pivot tables, increasing productivity, and producing reports in minutes instead of hours. Within the first 6 chapters, you will learn how to use pivot tables to quickly highlight your top 10 customers or bottom...
Author
Series
Pub. Date
2007
Language
English
Description
"This book shows you why the macro recorder fails and the steps needed to convert recorded code into code that will work every day with every dataset. The book assumes that you know Excel well, but there is no need for prior programming experience. This book describes everything you could conceivably need to know to automate reports and design applications in Excel VBA. Whether you want to automate reports for your office or design full-blown applications...
Author
Pub. Date
[2022]
Language
English
Description
Renowned Excel experts Bill Jelen (MrExcel) and Tracy Syrstad help you automate Excel tasks to get more done, faster than ever. Use this guide to automate virtually any routine Excel task: save yourself hours, days, maybe even weeks. Make Excel do things you thought were impossible, discover macro techniques you wont find anywhere else, and create automated reports that are amazingly powerful. Bill Jelen and Tracy Syrstad help you instantly visualize...
Author
Pub. Date
[Ã2011]
Language
English
Description
Using Excel 2010, it's possible to create breathtaking charts, graphs, and other data visualizations - and communicate even the most complex data more effectively than ever before. In Charts and Graphs , one of the world's leading Excel experts show exactly how to make the most of Excel 2010's unprecedented visual features. Bill Jelen ("MrExcel") explains exactly when and how to use each type of Excel chart, then walks through creating superb visuals...
Author
Series
Pub. Date
Ã2010
Language
English
Description
AUTOMATE REPORTS BUILD FUNCTIONS VISUALIZE DATA WRITE FAST, RELIABLE SCRIPTS Microsoft Excel 2010 VBA AND MACROS: SAVE TIME AND SUPERCHARGE EXCEL 2010 WITH VBA AND MACROS! Use Excel 2010 VBA and macros to automate virtually any routine task, and save yourself hours, days, maybe even weeks. Then learn how to make Excel do things you thought were simply impossible! This book reveals scripting techniques you won't find anywhere else and shows you how...
Author
Series
Pub. Date
©2013
Language
English
Description
Use Excel 2013's radically revamped charting and graphing tools to communicate more clearly, powerfully, and quickly… so you drive your message home, and get the decisions and actions you're looking for! This book reveals data visualization techniques you won't find anywhere else and shows you how to use Excel 2013 to create designer-quality charts and graphs that stand out from the crowd. It will help you make the most of new features ranging from...
Didn't find it?
Can't find what you are looking for? Try our Materials Request Service. Submit Request