Books by Bill Jelen

This well-organized reference packs hundreds of timesaving solutions, tips, and workaroundsGÇôall students need to make the most of ExcelGÇÖs most powerful tools for analyzing 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 customizations to advanced analysis, visualizations, and dashboards. Discover how experts tackle todayGÇÖs key tasksGÇôand challenge yourself to new levels of mastery.

Learn how to 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 youGÇÖve never created a pivot table before, this book will help you leverage all their remarkable flexibility and analytical powerGÇöincluding valuable improvements in Excel 2019 and Excel in Office 365. Drawing on more than 45 combined years of Excel experience, Bill Jelen and Michael Alexander offer practical GÇ£recipesGÇ¥ for solving real business problems, help you avoid common mistakes, and present tips and tricks youGÇÖll find nowhere else.

This book shows students how to make Excel do things you thought were impossible, discover macro techniques you won't find anywhere else, and create automated reports that are amazingly powerful. Bill Jelen and Tracy Syrstad help students instantly visualize information, so they can act on it… capture data from anywhere, and use it anywhere… automate Excel 2019's best new features. Students will find simple, step-by-step instructions, real-world case studies, and workbooks packed with bonus examples, macros, and solutions-straight from MrExcel!

Excel 2016 In Depth is the fastest, smartest way to master Excel 2016's full power and updated interface. Students will discover how to leverage Excel's new tools for charting, business analysis, data visualization, forecasting, and more.