{"title":"Bill Jelen","description":"\u003cp\u003eDive into the world of Microsoft Excel with Bill Jelen, also known as MrExcel! Unlock the power of spreadsheets with his guides – perfect for both beginners and seasoned pros looking to sharpen their skills.\u003c\/p\u003e","products":[{"product_id":"special-edition-using-microsoft-office-excel-2007-book-bill-jelen-9780789736116","title":"Special Edition Using Microsoft Office Excel 2007","description":"Sudoku fur Nussknacker 3 bereitet langes Ratselvergnugen durch 400 neue, knifflige Zahlenratsel. Fur jedes Ratsel gibt es nur eine richtige Losung. Die kopfstehende Auflosung finden Sie direkt auf jeder Seite, lastiges Suchen und Blattern entfallt.","brand":"WoB","offers":[{"title":"GB \/ LIKE_NEW \/ INTERNAL","offer_id":49515135369489,"sku":"GOR013146772","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ GOOD \/ INTERNAL","offer_id":49646190919953,"sku":"GOR005227387","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49973898674449,"sku":"GOR002473765","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ GOOD \/ SBYB","offer_id":51694825734417,"sku":"CIN078973611XG","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":52816685957393,"sku":"CIN078973611XVG","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/078973611X.jpg?v=1750979418"},{"product_id":"charts-and-graphs-book-bill-jelen-9780789743121","title":"Charts and Graphs","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 and customizing them with themes, colors, and effects. Jelen shows how to craft charts that illuminate trends, differences, and relationships; how to create stock analysis charts; how to use Excel's flexible PivotCharts; and even how to present data on maps with Microsoft MapPoint. You will discover how to make the most of Excel 2010's new Sparklines and other in-cell visualizations; how to incorporate additional images and shapes with SmartArt; how to export charts for use outside of Excel; and how to generate dynamic, customized charts automatically with Excel VBA. There's even a full chapter on assessing the truth of charts created in Excel - and recognizing when someone's trying to lie to you! This book is part of the new MrExcel Library series.        Everything Excel users need to know to communicate visually - from trend analysis to stock charting, geographical mapping to Excel 2010's new In-Cell Data Bars and Sparklines   From basic through leading-edge techniques - including the automatic generation of custom charts with VBA   Part of the brand-new MrExcel Library series, edited by Excel legend Bill Jelen","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49516343722257,"sku":"GOR006258259","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ GOOD \/ SBYB","offer_id":49852012167441,"sku":"CIN0789743124G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":52817363796241,"sku":"CIN0789743124VG","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0789743124.jpg?v=1750849322"},{"product_id":"brilliant-microsoft-excel-2007-vba-macros-book-bill-jelen-9780273714057","title":"Brilliant Microsoft Excel 2007 VBA \u0026 Macros","description":"There are an estimated 400 million Excel users, very few of whom know how to use Excel VBA effectively. This book is designed to get Excel users up and running with Excel VBA. Users will quickly learn how to automate reports and design applications.","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49519227961617,"sku":"GOR003914539","price":0.0,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0273714058.jpg?v=1751356128"},{"product_id":"learn-excel-97-2010-from-mr-excel-book-bill-jelen-9781932802443","title":"Learn Excel 97-2010 from Mr Excel","description":"Updating the previous edition's tips to make them compatible with Excel 2010, and featuring tips that are only available in Excel 2010, this new edition of Mr. Excel's popular software guide even incorporates suggestions sent in by readers. Each featured topic has a problem statement and description, followed by a broad strategy for solving the problem. Mr. Excel then walks readers through the specific steps to solve the issue. Alternate strategies are also provided, along with common gotchas that trip users up, leaving readers with not only answers to their specific dilemmas but also new and quicker ways to use formulas and spreadsheets.","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49519298707729,"sku":"GOR005634304","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ WELL_READ \/ SBYB","offer_id":50394624753937,"sku":"CIN1932802444A","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ GOOD \/ SBYB","offer_id":50394626949393,"sku":"CIN1932802444G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ GOOD \/ INTERNAL","offer_id":51847840727313,"sku":"GOR007920583","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":53469201334545,"sku":"CIN1932802444VG","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/1932802444.jpg?v=1750835642"},{"product_id":"excel-2013-vba-and-macros-book-bill-jelen-9780789748614","title":"Excel 2013 VBA and Macros","description":"SAVE TIME AND SUPERCHARGE EXCEL 2013 WITH VBA AND MACROS!      Use Excel® 2013 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! You’ll discover macro techniques you won’t find anywhere else and learn how to create automated reports that are amazingly powerful and useful. Bill Jelen and Tracy Syrstad show how to instantly visualize information, so you and your colleagues can understand and act on it…how to capture data from anywhere, and use it anywhere…how to automate Excel 2013’s most valuable new features. Mastering advanced Excel macros has never been easier. You’ll find simple, step-by-step instructions, real-world examples and case studies, and 50 workbooks packed with bonus examples, macros, and solutions–straight from MrExcel.         Get started fast with Excel 2013 macro development    Write macros that use Excel 2013 enhancements, including Timelines and the latest pivot table models    Work efficiently with ranges, cells, and R1C1-style formulas    Build super-fast applications with arrays    Write Excel 2013 VBA code that works on older versions of Excel    Create custom dialog boxes to collect information from your users    Use error handling to make your macros more resilient    Use web queries and new web service functions to integrate data from anywhere    Master advanced techniques such as classes, collections, and custom functions    Build sophisticated data mining and business analysis applications    Read and write to both Access and SQL Server databases   Control other Office programs–and even control Windows itself    Start writing Excel Apps similar to those in the Excel App Store  About MrExcel Library:  Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will     Dramatically increase your productivity–saving you 50 hours a year or more   Present proven, creative strategies for solving real-world problems   Show you how to get great results, no matter how much data you have   Help you avoid critical mistakes that even experienced users make","brand":"WoB","offers":[{"title":"US \/ GOOD \/ SBYB","offer_id":49521480335633,"sku":"CIN0789748614G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49586812092689,"sku":"GOR007067492","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ GOOD \/ INTERNAL","offer_id":49649862181137,"sku":"GOR006003458","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ WELL_READ \/ INTERNAL","offer_id":49854862360849,"sku":"GOR013799817","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ LIKE_NEW \/ SBYB","offer_id":50365753557265,"sku":"CIN0789748614LN","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":52105238610193,"sku":"CIN0789748614VG","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0789748614.jpg?v=1751296921"},{"product_id":"vba-and-macros-book-bill-jelen-9780789743145","title":"VBA and Macros","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 to create automated reports that are amazingly powerful and useful. It helps you instantly visualize information so you can understand and act on it. It also shows you how to capture data from anywhere and use it anywhere, and helps you automate Excel 2010 s most powerful new features. Learning advanced Excel scripting has never been easier. You ll find simple, step-by-step instructions, real-world examples and case studies, and 50 workbooks packed with bonus examples, macros, and solutions, straight from MrExcel. Work efficiently with ranges, cells, and R1C1-style formulas Build super-fast applications with arrays Customize the Excel 2010 Ribbon to run your macros Write Excel 2010 VBA code that works on older versions of Excel Create custom dialog boxes to collect information from your users Use error handling to make your VBA scripts more resilient Use Web queries to import data from virtually any online source Master advanced techniques such as classes and collections Use Excel VBA to control other Office programs even control Windows itself, via the Windows API Create add-ins to share or sell your programs About MrExcel Library: Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will Dramatically increase your productivity saving you 50 hours a year or more Present proven, creative strategies for solving real-world problems Show you how to get great results, no matter how much data you have Help you avoid critical mistakes that even experienced users make","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49523013779729,"sku":"GOR002660251","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ GOOD \/ SBYB","offer_id":50053187141905,"sku":"CIN0789743140G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":50406305235217,"sku":"CIN0789743140VG","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0789743140.jpg?v=1750946541"},{"product_id":"mrexcel-xl-book-bill-jelen-9781615470402","title":"MrExcel XL","description":"The 40 essential tips that all Excel users need to know. Crowdsourced by more than 300 contributors who collaborated on choosing the 40 best Excel tips, \u003ci\u003eMrExcel XL \u003c\/i\u003eprovides users with a concise book that can be absorbed in under an hour. Includes a bonus 30 tips, keyboard shortcuts, Excel jokes, Excel cocktails. Anyone who uses Excel will be able to turn to any page and pick up tips that will save them hours of work.","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49525674213649,"sku":"GOR013254024","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ GOOD \/ INTERNAL","offer_id":49665332609297,"sku":"GOR013538212","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ GOOD \/ SBYB","offer_id":50177986396433,"sku":"CIN1615470409G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":50270535614737,"sku":"CIN1615470409VG","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ WELL_READ \/ SBYB","offer_id":50386927354129,"sku":"CIN1615470409A","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/1615470409.jpg?v=1751057096"},{"product_id":"excel-gurus-gone-wild-book-bill-jelen-9781932802405","title":"Excel Gurus Gone Wild","description":"Drawn from actual excel conundrums posted on the author's website, www.mrexcel.com, this high-level resource is designed for people who want to stretch Excel to its limits. Tips for solving 100 incredibly difficult problems are covered in depth and include extracting the first letter of each word in a paragraph, validating URL's, generating random numbers without repeating, and hiding rows if cells are empty. The answers to these and other questions have produced results that have even surprised the Excel development team.","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49525685911825,"sku":"GOR005378035","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":50095750742289,"sku":"CIN1932802401VG","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ WELL_READ \/ SBYB","offer_id":50101507227921,"sku":"CIN1932802401A","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ GOOD \/ SBYB","offer_id":50265186238737,"sku":"CIN1932802401G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ NEW \/ INGRAM","offer_id":51289363742993,"sku":"NIN9781932802405","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ GOOD \/ INTERNAL","offer_id":53075752288529,"sku":"GOR009182599","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ NEW \/ INGRAM","offer_id":53250625339665,"sku":"NLS9781932802405","price":0.0,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/1932802401.jpg?v=1750900776"},{"product_id":"excel-2016-vba-and-macros-book-bill-jelen-9780789755858","title":"Excel 2016 VBA and Macros","description":"MASTER CORE EXCEL 2016 TOOLS FOR BUILDING POWERFUL, RELIABLE SPREADSHEETS!       Use this guide to automate virtually any routine task: save yourself hours, days, maybe even weeks! 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 you  instantly visualize information, so you can act on it… capture data from anywhere, and use it anywhere… automate Excel 2016’s best new features. You’ll find simple, step-by-step instructions, real-world case studies, and 50 workbooks packed with bonus examples, macros, and solutions–straight from MrExcel!                  Get started fast with Excel macro development              Work efficiently with ranges, cells, and formulas              Build super-fast applications with arrays              Automate Excel’s new pivot table enhancements              Collect user data with custom dialogs              Make your macros more reliable and resilient              Pull data from the Internet with web queries              Use advanced classes, collections, and custom functions              Build sophisticated business analysis solutions              Read and write to Access or SQL Server databases              Control other Office programs, and Windows itself              Write code that also works on older Excel versions              Start writing Office Store-style Excel Apps           About MrExcel Library       Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will                  Dramatically increase your productivity–saving you 50 hours a year or more              Present proven, creative strategies for solving real-world problems              Show you how to get great results, no matter how much data you have              Help you avoid critical mistakes that even experienced users make       This book is part of Que’s Content Update Program. As Microsoft updates features of Excel, sections of this book will be updated or new sections will be added to match the updates to the software. See inside for details.","brand":"WoB","offers":[{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":49530684473617,"sku":"CIN0789755858VG","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49537717993745,"sku":"GOR007804998","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"GB \/ LIKE_NEW \/ INTERNAL","offer_id":49567325126929,"sku":"GOR009503175","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"GB \/ GOOD \/ INTERNAL","offer_id":49642002481425,"sku":"GOR012492294","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ GOOD \/ SBYB","offer_id":49725365027089,"sku":"CIN0789755858G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ WELL_READ \/ INTERNAL","offer_id":52700756246801,"sku":"GOR013140386","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0789755858.jpg?v=1769688717"},{"product_id":"microsoft-office-excel-2007-in-depth-book-bill-jelen-9780273721611","title":"Microsoft Office Excel 2007 In Depth","description":"Microsoft Office Excel 2007 In Depth will ease the upgrade path to the latest version of Microsoft best-selling spreadsheet program. The author introduces you to the new interface, allowing you to quickly get back up-to-speed in performing your job, and will then introduce the powerful new features available in Excel 2007 Summary: This book has been crafted to grow with the user, providing the reference material needed for move towards Excel proficiency and use of more advanced features. If you buy only one book on Excel, Microsoft Office Excel 2007 In Depth is the one to choose.  Does your life play out in a spreadsheet? Do numbers in columns and rows make or break you in the work world? Tired of having numbers kicked in your face by other Excel 2007 power users who make your modest spreadsheets look paltry compared to their fancy charts and pivot tables?  If you answered yes to any of these questions, Microsoft Office Excel 2007 In Depth is the book that will make it all better. Learn quickly and efficiently from a true Excel master using the In Depth formula for success. Here, you'll find information that's undocumented elsewhere even in Microsoft's own Help systems.  You'll learn from finely crafted, real-life examples built by an author who lives and dies by the integrity of his spreadsheets.  Excel's backbone is its formulas and functions. Master those and you will master your spreadsheets. Microsoft Office Excel 2007 In Depth provides more down and dirty help with your formulas and functions than you'll find in any other book! See how it's done in real life! Don't settle for lame pivot table and chart examples found in other books  This book provides beautifully detailed examples that not only show you how it should be done, but how to be the local worksheet hero!  Author:  Bill Jelenis an accomplished Excel author and the principal behind the leading Excel website, MrExcel.com. As an Excel consultant, he has written Excel VBA solutions for over 300 clients around the English-speaking world. His website hosts over 10 million page views annually. Prior to founding MrExcel.com, Jelen spent twelve years in the trenches, - working as a financial analyst for finance, marketing, accounting and operations departments of a $500 million public company.","brand":"WoB","offers":[{"title":"GB \/ LIKE_NEW \/ INTERNAL","offer_id":49531121762577,"sku":"GOR013242271","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49607454753041,"sku":"GOR003129408","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"GB \/ WELL_READ \/ INTERNAL","offer_id":53157125816593,"sku":"GOR010837500","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"GB \/ GOOD \/ INTERNAL","offer_id":53366330556689,"sku":"GOR004194717","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0273721615.jpg?v=1750812724"},{"product_id":"microsoft-excel-2010-in-depth-book-bill-jelen-9780789743084","title":"Microsoft Excel 2010 In Depth","description":"Excel 2010 In Depth is the beyond-the-basics, beneath-the-surface guide for everyone who wants to streamline their work with Excel 2010, and get more done in less time. Legendary Excel expert Bill Jelen provides specific, tested, proven solutions to the problems Excel users run into every day: challenges other books ignore or oversimplify. Jelen thoroughly covers all facets of working with Excel 2010, and adds new chapters on Excel Web App which allows multiple users to edit a spreadsheet simultaneously. New coverage also includes: Slicer, which offers dynamic filtering of PivotTables; Sparklines, which add data visualization to any cell; Calculation engine which improves the speed and accuracy of math, financial, and statistical functions; and the new version of Solver. As with all In Depth books, Excel 2010 In Depth presents comprehensive coverage, breakthrough techniques, exclusive shortcuts, quick access to information, troubleshooting help for tough problems, and real-world examples with nothing glossed over or left out. Step-by-step instructions with icons guide readers through essential tasks such as designing tables, entering data, importing external data, designing and executing queries, and designing data entry forms and printed reports. Additional chapters on advanced form and report design emphasize data entry efficiency and presentation clarity.        By Bill Jelen, aka MrExcel, an Excel MVP and the principal behind the leading Excel website, MrExcel.com  Covers all aspects of working with Excel 2010, from its updated Ribbon interface to its breakthrough collaboration and improved business intelligence  For everyone who wants to get the most out of Excel 2010, from casual users to corporate professionals","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49532439626001,"sku":"GOR005582430","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"GB \/ GOOD \/ INTERNAL","offer_id":49598377034001,"sku":"GOR004714678","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ LIKE_NEW \/ INTERNAL","offer_id":49620098416913,"sku":"GOR010269954","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ GOOD \/ SBYB","offer_id":53357789479185,"sku":"CIN0789743086G","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0789743086.jpg?v=1751011638"},{"product_id":"excel-2013-pivot-table-data-crunching-book-bill-jelen-9780789748751","title":"Excel 2013 Pivot Table Data Crunching","description":"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 stay in control!       Even if you’ve never created a pivot table before, this book will help you leverage all their amazing flexibility and analytical power. In just the first seven chapters, you learn how to generate complex pivot reports complete with drill-down capabilities and accompanying charts. Then, you go even further, discovering how to build a comprehensive, dynamic pivot table reporting system for any business task or function.       Learning advanced pivot table and pivot chart techniques for Excel 2013 or the newest Office 365 has never been easier. You’ll find simple, step-by-step instructions, real-world case studies, even complete, easy recipes for solving your most common business analysis problems.       •   Create, customize, and change your pivot tables and pivot charts   •   Transform gigantic data sets into crystal-clear summary reports   •   Summarize and analyze data even faster with new Excel 2013 recommended pivot tables   •   Instantly highlight your most (and least) profitable customers, products, or regions   •   Quickly filter pivot tables using slicers   •   Use dynamic dashboards using Power View to see exactly where your business stands right now   •   Revamp analyses on the fly by simply dragging and dropping fields   •   Build dynamic self-service reporting systems your entire team can use   •   Use PowerPivot or the Data Model to create pivot tables from multiple data sources and worksheets   •   Work with and analyze OLAP data, and much more       About MrExcel Library:  Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these  books will   •   Dramatically increase your productivity—saving you 50 hours a year or more   •   Present proven, creative strategies for solving real-world problems    •   Show you how to get great results, no matter how much data you have   •   Help you avoid critical mistakes that even experienced users make        CATEGORY: Spreadsheets   COVERS: Microsoft Office Excel 2013","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49532615164177,"sku":"GOR005815259","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ GOOD \/ SBYB","offer_id":49875497517329,"sku":"CIN0789748754G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ GOOD \/ INTERNAL","offer_id":52511460360465,"sku":"GOR014545655","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":53632348684561,"sku":"CIN0789748754VG","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0789748754.jpg?v=1751434375"},{"product_id":"pivot-table-data-crunching-for-microsoft-office-excel-2007-book-bill-jelen-9780789736017","title":"Pivot Table Data Crunching for Microsoft Office Excel 2007","description":"Aims to consolidate functionality of pivot tables. This title is intended to help automate pivot tables using VBA, create pivot tables with external data in OLAP cubes, and create reporting systems.","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49536656507153,"sku":"GOR002246917","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ GOOD \/ SBYB","offer_id":51705119408401,"sku":"CIN0789736012G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":52816008708369,"sku":"CIN0789736012VG","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0789736012.jpg?v=1750703512"},{"product_id":"excel-2016-pivot-table-data-crunching-book-bill-jelen-9780789756299","title":"Excel 2016 Pivot Table Data Crunching","description":"Excel® 2006 PIVOT TABLE DATA CRUNCHING       CRUNCH 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 your business… take control, and stay in control! Even if you’ve never created a pivot table before, this book will help you leverage all their amazing flexibility and analytical power. Drawing on more than 40 combined years of Excel experience, Bill Jelen and Michael Alexander offer practical “recipes” for solving real business problems, help you avoid common mistakes, and present tips and tricks you’ll find nowhere else!       • Create, customize, and change pivot tables    • Transform huge data sets into clear summary reports   • Analyze data faster with Excel 2016’s new recommended pivot tables   • Instantly highlight your most profitable customers, products, or regions   • Quickly import, clean, and shape data with Power Query vBuild geographical pivot tables with Power Map   • Use Power View dynamic dashboards to see where your business stands   • Revamp analyses on the fly by dragging and dropping fields   • Build dynamic self-service reporting systems   • Combine multiple data sources into one pivot table   • Use Auto grouping to build date\/time-based pivot tables faster vCreate data mashups with Power Pivot    • Automate pivot tables with macros and VBA           About MrExcel Library       Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will       • Dramatically increase your productivity–saving you 50 hours a year or more   • Present proven, creative strategies for solving real-world problems   • Show you how to get great results, no matter how much data you have   • Help you avoid critical mistakes that even experienced users make       Bill Jelen is MrExcel, the world’s #1 spreadsheet wizard. Jelen hosts MrExcel.com, the premier Excel solutions site, with more than 20 million page views annually. A Microsoft MVP for Excel, his best-sellers include Excel 2016 In Depth. Michael Alexander, Microsoft Certified Application Developer (MCAD) and Microsoft MVP, is author of several books on advanced business analysis with Excel and Access. He has more than 15 years of experience developing Office solutions.          CATEGORY:   Spreadsheets   COVERS:   Microsoft Excel 2016","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49540006936849,"sku":"GOR008261059","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"GB \/ LIKE_NEW \/ INTERNAL","offer_id":49899744198929,"sku":"GOR011018911","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ GOOD \/ SBYB","offer_id":50485115617553,"sku":"CIN0789756293G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":51118892056849,"sku":"CIN0789756293VG","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0789756293.jpg?v=1751448513"},{"product_id":"excel-vba-and-macros-with-mrexcel-livelessons-video-training-book-bill-jelen-9780789739384","title":"Excel VBA and Macros with MrExcel LiveLessons (Video Training)","description":"DVD includes:           7+ HOURS OF VIDEO INSTRUCTION    50 TIPS \u0026amp; TECHNIQUES    SKILLS YOU CAN LEARN IN Fifteen MINUTES OR LESS      Overview           In Excel VBA and Macros with MrExcel, renowned Excel instructor and author Bill Jelen (MrExcel) teaches all the skills you'll need to automate virtually any routine task with Excel and build powerful Excel macros! This package brings together nearly eight hours hours of personalized, expert video training: 50 quick, practical video lessons that demonstrate all the skills you'll need to successfully use both the Excel macro recorder and the Visual Basic for Applications development environment. You'll learn one step at a time, at your own pace-using hands-on examples that reflect realistic challenges and showcase Excel's remarkable capabilities. Along the way, Jelen will take you from the absolute basics through PivotTables and data filtering.           Excel VBA and Macros with MrExcel delivers the power of the best classroom training at a small fraction of the cost. If you don't have time to read a huge book on Excel macros and scripting, this is exactly what you've been searching for!            For all serious Excel users: managers, financial pros, entrepreneurs, marketers, analysts, and more.           Looking for a better way to master today's rapidly changing technologies? Want expert help, but don't have the time or energy to read a book? Can't find classroom training worth the money? Discover LiveLessons: self-paced, personal video instruction from the world's leading technology experts.           LiveLessons are video courses are organized into bite-sized, self-contained sessions-you'll learn key skills in as little as fifteen minutes!    Each lesson begins with well-defined learning objectives and ends with comprehensive summaries, which help you track your progress.    Follow along as your trainer shows you how to make the most of Excel's macro recorder and its powerful VBA development environment!            Bill Jelen is called MrExcel for a reason! Nobody knows more about Excel macros and scripting-and nobody knows more about teaching these skills to working professionals! Thought you'd never write your own Excel macros and programs? Think again! You will...and you can start in just minutes!           Bill Jelen, known worldwide as MrExcel, presents live Excel seminars across the United States and appears in over 800 podcast episodes. His 20 Excel books include Special Edition Using Excel 2007 and VBA and Macros for Microsoft Excel. His website, MrExcel.com, answers 30,000 Excel questions per year.           System Requirements           OS: Windows 98, 2000, XP, and Windows Vista; Mac OS X; versions of Linux with the Flash 8 Player or later.    Multimedia: DVD drive, an 1024x768 or higher display, and a sound card with speakers.    Computer: 500MHz or higher, 128MB RAM or more            Microsoft Office Spreadsheets\/Desktop Applications           $49.99 USA \/ $59.99 CAN \/ GBP31.99 U.K.           mylivelessons.com     informit.com\/que","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49545509667089,"sku":"GOR007544823","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0789739380.jpg?v=1751076001"},{"product_id":"excel-2013-in-depth-book-bill-jelen-9780789748577","title":"Excel 2013 In Depth","description":"Get more out of Microsoft Excel® 2013: more productivity and better answers for greater success! Drawing on his unsurpassed Excel experience, Bill Jelen (“Mr Excel”) brings together all the intensely useful knowledge you need: insights, techniques, tips, and shortcuts you just won’t find anywhere else. Excel 2013 In Depth is the fastest, best way to master Excel 2013’s full power; get comfortable with its updated interface; and leverage its new tools for everything from formulas, charts, and functions to dashboards, data visualization, and social media integration. Start by taking a quick “tour” of Excel 2013’s most valuable new features. Then, learn how to           Build more trustworthy, error-resistant, flexible, extensible, intelligent, and understandable spreadsheets    Get more productive with Excel 2013’s new Start Screen and Timelines    Create formulas, charts, subtotals, and pivot tables faster with new Flash Fill and Analysis Lens    Quickly apply attractive, consistent formats    Master every function you’ll ever need,- including powerful new web services functions    Solve real-world business intelligence analysis problems    Create amazing PowerPivot data mashups that integrate information from anywhere    Use Power View to generate stunningly intuitive maps, dashboards, and data visualizations    Share workbooks on the Web and social networks    Leverage the improved Excel Web App to create highly interactive web pages and online surveys    Automate repetitive functions using Excel macros    Supercharge your workbooks with new apps from the Excel App Store        Like all In Depth books, Excel 2013 In Depth delivers complete coverage with detailed solutions, and troubleshooting help for tough problems you can’t fix on your own. Whatever you intend to do with Excel 2013, this is the only book you’ll need!","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49549020135697,"sku":"GOR006812306","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ GOOD \/ SBYB","offer_id":49980300755217,"sku":"CIN0789748576G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ WELL_READ \/ INTERNAL","offer_id":50004756627729,"sku":"GOR013834455","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ GOOD \/ INTERNAL","offer_id":50898973491473,"sku":"GOR006549984","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0789748576.jpg?v=1750882998"},{"product_id":"powerpivot-alchemy-book-bill-jelen-9781615470211","title":"PowerPivot Alchemy","description":"Rob Collie (PowerPivotPro) and Bill Jelen (MrExcel) join forces in this combined sequel to their best-selling Power Pivot books. Alchemy sets aside the fundamentals of past books and provides a series of practical, easy-to-follow patterns for dozens of common analysis, reporting, and dashboarding needs. Three bonus chapters introduce you to the newer members of the Power BI family -- Power Query, Power View, and Power Map. Whether you are starting your transformation from old school Excel User to Modern Data Professional or a veteran of the Power BI arts, this book will dramatically expand your data superpowers.","brand":"WoB","offers":[{"title":"GB \/ LIKE_NEW \/ INTERNAL","offer_id":49556273234193,"sku":"GOR013651223","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ GOOD \/ SBYB","offer_id":50396116680977,"sku":"CIN1615470212G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":50396120875281,"sku":"CIN1615470212VG","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ GOOD \/ INTERNAL","offer_id":51483675722001,"sku":"GOR011041658","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":51614900879633,"sku":"GOR007645273","price":0.0,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/1615470212.jpg?v=1750927512"},{"product_id":"excel-for-auditors-book-bill-jelen-9781932802160","title":"Excel for Auditors","description":"Providing the tools and techniques necessary for finding errors and fraud in audits, this guide for auditors looking to better validate their Microsoft Excel spreadsheets provides techniques for performing a risk assessment and gathering spreadsheet and other data from company systems. Performing audit data analysis using data and analytical management functions and pinpointing the common errors in spreadsheets with focused Excel tests is discussed, as are the best practices for error and fraud prevention when developing spreadsheets. This reference is fully updated to reflect Excel 12.\u003cbr\u003e","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49565613392145,"sku":"GOR004719024","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ GOOD \/ SBYB","offer_id":49802710188305,"sku":"CIN1932802169G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ NEW \/ INGRAM","offer_id":51055339372817,"sku":"NIN9781932802160","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":52951552033041,"sku":"CIN1932802169VG","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ NEW \/ INGRAM","offer_id":53250624782609,"sku":"NLS9781932802160","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"GB \/ GOOD \/ INTERNAL","offer_id":53269972648209,"sku":"GOR006089647","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/1932802169.jpg?v=1751437228"},{"product_id":"excel-2016-in-depth-book-bill-jelen-9780789755841","title":"Excel 2016 In Depth","description":"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.","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49566516085009,"sku":"GOR008366302","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"GB \/ NEW \/ GARDNERS","offer_id":49730669117713,"sku":"NGR9780789755841","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"GB \/ GOOD \/ INTERNAL","offer_id":50145691369745,"sku":"GOR012197336","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":50512246407441,"sku":"CIN078975584XVG","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ GOOD \/ SBYB","offer_id":50762991894801,"sku":"CIN078975584XG","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/078975584X.jpg?v=1769681025"},{"product_id":"microsoft-excel-2019-inside-out-book-bill-jelen-9781509307692","title":"Microsoft Excel 2019 Inside Out","description":"You’re beyond the basics—so dive in and really put your spreadsheet skills to work! This supremely organized reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds. It’s all muscle and no fluff. Learn how the experts tackle Excel—and challenge yourself to new levels of mastery. Includes companion eBook and sample files.     Topics include:            Customizing the Excel workspace Best practices for designing and managing worksheets Creating formulas and functions Performing statistical, what-if, and other data analysis Core to advanced charting techniques Using graphics and sparklines Managing databases and tables Automating Excel with macros and custom functions Collaborating in Excel online, in the cloud, and more Extending Excel","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49566938857745,"sku":"GOR012759547","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ NEW \/ GARDNERS","offer_id":49733183111441,"sku":"NGR9781509307692","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ GOOD \/ SBYB","offer_id":50238821368081,"sku":"CIN1509307699G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":50240118096145,"sku":"CIN1509307699VG","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ LIKE_NEW \/ INTERNAL","offer_id":50459252195601,"sku":"GOR013959953","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/1509307699.jpg?v=1750717368"},{"product_id":"power-excel-with-mrexcel-book-bill-jelen-9781615470389","title":"Power Excel with MrExcel","description":"Updating the previous edition's tips to include features in Excel 2013, this new edition of Mr. Excel's popular software guide even incorporates suggestions sent in by readers. Each featured topic has a problem statement and description, followed by a broad strategy for solving the problem. Mr. Excel then walks readers through the specific steps to solve the issue. Alternate strategies are also provided, along with common scenarios that trip users up, leaving readers with not only answers to their specific dilemmas but also new and quicker ways to use formulas and spreadsheets.","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49575211729169,"sku":"GOR013676035","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ GOOD \/ SBYB","offer_id":50131063734545,"sku":"CIN1615470387G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ WELL_READ \/ SBYB","offer_id":52812443648273,"sku":"CIN1615470387A","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":53336416125201,"sku":"CIN1615470387VG","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/1615470387.jpg?v=1751119432"},{"product_id":"excel-2013-charts-and-graphs-book-bill-jelen-9780789748621","title":"Excel 2013 Charts and Graphs","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 Power View to Recommended Charts, and instantly share your insights with anyone, anywhere–even on the Web and social networks.       Learning advanced Excel techniques has never been easier. You’ll find simple, step-by-step instructions, real-world  examples and case studies, and more than a dozen YouTube videos, straight from MrExcel!       •      Create stunning data visualizations instantly with Excel 2013’s new Recommended Charts   •      Use charts to instantly reveal trends, differences, and relationships   •      Map your data with Excel 2013, MapPoint, and the new GeoFlow add-in   •      Quickly generate combo charts that once required complex, frustrating procedures   •      Use sparklines to imbue worksheets with more context and insight   •      Highlight and clarify the meaning of data with DataBars, color scales, icon sets, and other conditional formatting tools   •      Post charts to Facebook, Twitter, or LinkedIn, directly from Excel   •      Build stock charts that help you make smarter investments   •      Solve “non-standard” problems such as noncontiguous data or custom data sequences   •      Generate new charts automatically with Excel VBA   •      Uncover visual tricks that people use to lie with Excel       About MrExcel Library:  Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks  and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these  books will:       •      Dramatically increase your productivity–saving you 50 hours a year or more   •      Present proven, creative strategies for solving real-world problems    •      Show you how to get great results, no matter how much data you have   •      Help you avoid critical mistakes that even experienced users make","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49575305380113,"sku":"GOR011929259","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"GB \/ GOOD \/ INTERNAL","offer_id":49762780905745,"sku":"GOR009426484","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ GOOD \/ SBYB","offer_id":51334219530513,"sku":"CIN0789748622G","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0789748622.jpg?v=1750979423"},{"product_id":"microsoft-excel-2019-pivot-table-data-crunching-book-bill-jelen-9781509307241","title":"Microsoft Excel 2019 Pivot Table Data Crunching","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 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 “recipes” for solving real business problems, help you avoid common mistakes, and present tips and tricks you’ll find nowhere else.        By reading this book, you will:    • Master easy, powerful ways to create, customize, change, and control pivot tables    • Control all future pivot tables using new pivot table defaults    • Transform huge data sets into clear summary reports    • Instantly highlight your most profitable customers, products, or regions    • Use Power Query to quickly import, clean, shape, and analyze disparate data sources    • Build geographical pivot tables with 3D Map    • Construct and share state-of-the-art dynamic dashboards    • Revamp analyses on the fly by dragging and dropping fields    • Build dynamic self-service reporting systems    • Share your pivot tables with colleagues    • Create data mashups using the full Power Pivot capabilities of Excel 2019 and Excel in Office 365    • Automate pivot tables with macros and VBA    • Save time by adapting reports with GetPivotData    • Discover today’s most useful pivot table tips and shortcuts","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49578032693521,"sku":"GOR011936027","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ GOOD \/ SBYB","offer_id":49617477009681,"sku":"CIN1509307249G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ NEW \/ GARDNERS","offer_id":49734426755345,"sku":"NGR9781509307241","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":50094650687761,"sku":"CIN1509307249VG","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/1509307249.jpg?v=1769686379"},{"product_id":"microsoft-excel-2019-vba-and-macros-book-bill-jelen-9781509306114","title":"Microsoft Excel 2019 VBA and Macros","description":"Renowned Excel experts Bill Jelen (MrExcel) and Tracy Syrstad explain how to build more powerful, reliable, and efficient Excel spreadsheets.       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 won’t find anywhere else, and create automated reports that are amazingly powerful. Bill Jelen and Tracy Syrstad help you instantly visualize information to make it actionable; capture data from anywhere, and use it anywhere; and automate the best new features in Excel 2019 and Excel in Office 365. You’ll find simple, step-by-step instructions, real-world case studies, and 50 workbooks packed with examples and complete, easy-to-adapt solutions.       By reading this book, you will:        Quickly master Excel macro development Work more efficiently with ranges, cells, and formulas Generate automated reports and quickly adapt them for new requirements Learn to automate pivot tables to summarize, analyze, explore, and present data Use custom dialog boxes to collect data from others using Excel Improve the reliability and resiliency of your macros Integrate data from the internet, Access databases, and other sources Automatically generate charts, visualizations, sparklines, and Word documents Create powerful solutions with classes, collections, and custom functions Solve sophisticated business analysis problems more rapidly          About This Book        For everyone who wants to get more done with Microsoft Excel in less time For business and financial professionals, entrepreneurs, students, and others who need to efficiently manage and analyze data","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49578273505553,"sku":"GOR010238395","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"GB \/ WELL_READ \/ INTERNAL","offer_id":49631603917073,"sku":"GOR013737150","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ NEW \/ GARDNERS","offer_id":49734458343697,"sku":"NGR9781509306114","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ LIKE_NEW \/ INTERNAL","offer_id":49762993668369,"sku":"GOR011960740","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":50135090004241,"sku":"CIN1509306110VG","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ GOOD \/ SBYB","offer_id":50162296291601,"sku":"CIN1509306110G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ GOOD \/ INTERNAL","offer_id":51885724860689,"sku":"GOR012397178","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/1509306110.jpg?v=1769686033"},{"product_id":"powerpivot-for-the-data-analyst-book-bill-jelen-9780789743152","title":"PowerPivot for the Data Analyst","description":"ANALYZE HUGE AMOUNTS OF BUSINESS DATA FASTER, MORE EASILY, AND MORE ACCURATELY!    Use Microsoft’s free PowerPivot add-in for Excel 2010 to analyze immense amounts of data from any source, perform state-of-the-art business analysis far more easily, and make better decisions in less time!    Simple, step-by-step instructions walk you through installing PowerPivot, importing data, using PivotTables with PowerPivot, using super-powerful DAX functions and measures, reporting to print or SharePoint, and a whole lot more.    Whatever your Excel data analysis experience, this book will help you use PowerPivot to get the right answers, right now—without IT’s help!       •  Import and integrate data from spreadsheets, SQL Server, Access, Oracle, text files, Atom data feeds, and other sources   •  Analyze multiple tables together, without complicated VLOOKUPs    •  Format, sort, and filter data in the PowerPivot window   •  Add calculated columns using new DAX functions    •  Create powerful reports from PowerPivot data–and format them so executives instantly get your point   •  Discover PivotTable tricks that work even better in PowerPivot   •  Control multiple PivotTable elements on one worksheet, with one set of Excel 2010 Slicers    •  Use DAX Measures to quickly perform tasks that were difficult or impossible with Calculated Fields   •  Compare today’s sales to yesterday’s–or to sales from the parallel period last fiscal year.   •  Use Named Sets to prepare asymmetric reports, show actuals for past months and plan for future months.       About MrExcel Library:  Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will   •  Dramatically increase your productivity–saving you 50 hours a year, or more   •  Present proven, creative strategies for solving real-world problems    •  Show you how to get great results, no matter how much data you have   •  Help you avoid critical mistakes that even experienced users make","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49583710732561,"sku":"GOR006258258","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ GOOD \/ SBYB","offer_id":50182711705873,"sku":"CIN0789743159G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ LIKE_NEW \/ INTERNAL","offer_id":50751401296145,"sku":"GOR010525951","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":51423664144657,"sku":"CIN0789743159VG","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0789743159.jpg?v=1751139266"},{"product_id":"brilliant-microsoft-excel-2007-pivot-tables-book-bill-jelen-9780273714071","title":"Brilliant Microsoft Excel 2007 Pivot Tables","description":"Excel 2007 is one of the most powerful office and business productivity tools available. However, most users learn only a small percentage of the program's features. This book will teach users to develop their skills so they can produce powerful spreadsheet solutions for all their business needs.    Brilliant Excel Formulas and Functions not only takes users through Excel's intermediate and advanced formula-building features, it also explains why these features are useful and shows how to use them in everyday situations. Throughout the book there are no-nonsense, step-by-step tutorials and lots of practical examples aimed directly at business users","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49588463927569,"sku":"GOR002126864","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0273714074.jpg?v=1751101831"},{"product_id":"mrexcel-lx-the-holy-grail-of-excel-tips-book-bill-jelen-9781615470631","title":"MrExcel LX The Holy Grail of Excel Tips","description":"\u003cb\u003eUnlock the power of Excel with essential tips and tricks!\u003c\/b\u003e\u003ci\u003eMrExcel LX\u003c\/i\u003e is your concise guide to mastering Excel, packed with 125 actionable tips that can be absorbed in under two hours. Whether you're a beginner or an experienced user, this guide provides shortcuts and techniques to save you hours of work. \u003cp\u003eDiscover how to streamline data analysis, create complex formulas with ease, and manage worksheets like a pro. From keyboard shortcuts to advanced functions, this guide covers everything you need to boost your Excel skills and increase productivity. Perfect for anyone looking to enhance their efficiency and become an Excel guru!\u003c\/p\u003e \u003cul\u003e \u003cli\u003eMaster essential Excel tips and tricks\u003c\/li\u003e \u003cli\u003eStreamline data analysis and formula creation\u003c\/li\u003e \u003cli\u003eIncrease productivity and efficiency\u003c\/li\u003e \u003c\/ul\u003e","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49599409422609,"sku":"GOR012068453","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ WELL_READ \/ SBYB","offer_id":49879141843217,"sku":"CIN1615470638A","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ GOOD \/ INTERNAL","offer_id":50315414405393,"sku":"GOR013923562","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ GOOD \/ SBYB","offer_id":50396125528337,"sku":"CIN1615470638G","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/1615470638.jpg?v=1764843718"},{"product_id":"charts-and-graphs-for-microsoft-office-excel-2007-book-bill-jelen-9780789736109","title":"Charts and Graphs for Microsoft Office Excel 2007","description":"\u0026lt;\u0026gt;It is easy to create a bad looking chart in Excel. This book teaches you how to unlock the beautiful formatting options available to make incredible looking charts. The first section will talk about how to decide which chart type to use. Subsequent chapters will walk through each chart type, how to create them, how to utilize them, and special options available for each chart. The book discusses themes, colors, creating metallic charts, shadows, transparency, etc. The book also handles anything graphical in Excel. It will show the new In-Cell Data Bar charts available in Excel 2007. A section will talk about creating business flowcharts with IGX Graphics and how to display product pictures in Excel, and a section on VBA will cover creating 100's of charts using the macro language.          More than a how-to and reference, this book also provides the why-tos and when-tos, with serious consideration given to layout best practices and design possibilities-a very well-rounded resource.    -Kathy Villella, CEO, PowerFrameworks.com        Implementing 1-Click Charting  Incorporating Drag \u0026amp; Drop and Dynamic Charts  Creating Amazing Effects  Using Charting Templates and Macros  Mastering Glow, Shadow, Sparklines, Dashboards, and More  Eliminating Chart Junk  Structuring Spreadsheets with Business Diagrams, SmartArt Graphics, and Pivot Charts  Develop your Charting expertise instantly with proven techniques    After 15 years with no updates to the Excel charting engine, Microsoft has provided a complete rewrite of the chart rendering engine in Excel 2007. However, no amount of soft glow or glass bevel effects will help you communicate your point if you use the wrong chart type. This book helps you choose the right charting type and shows you how to make it look great.         This book shows you how to coax Excel to create many charts you might not have believed were possible. You'll learn techniques that allow you to ditch the Microsoft defaults and actually create charts that communicate your point. You'll learn why the Excel stock charts are so restrictive and how you can easily turn any line chart into a stock chart-without any limitations. You'll also learn how to add invisible series to make columns float in midair. Learn how to create charts right in Excel cells using the new Excel 2007 data bars-or even the decades-old REPT function!         In no time, this book will have you creating charts that wow your audience and effectively communicate your message.        Master effective visual display of data  Choose the right chart type to convey your message  Learn time-saving workarounds  Create charts that most people think you can't create with Excel  Understand what a Radar chart is and when you might use it  Summarize a million rows of data in a single pivot table chart  Present data graphically without charts  Employ SmartArt graphics to show process or relationship charts  Utilize VBA to create charts  Put your data on a map  Export your charts to the web or PowerPoint  Detect chart lies    ABOUT THE AUTHOR    Bill Jelen is MrExcel! He is principal behind the leading Excel website, MrExcel.com. He honed his Excel wizardry during his 12-year tenure as a financial analyst for a fastgrowing public computer firm. Armed with only a spreadsheet, he learned how to turn thousands of rows of transactional data into meaningful summaries in record time. He is an accomplished author of books on Excel and is a regular guest on The Lab on TechTV Canada. You can find Bill at your local accounting group chapter meeting entertaining audiences with his humorous and informative Power Excel seminar. His website hosts more than 12 million page views annually.                    Introduction       1 Introducing Charts in Excel 2007       2 Customizing Charts       3 Creating Charts That Show Trends       4 Creating Charts That Show Differences       5 Creating Charts That Show Relationships       6 Creating Stock Analysis Charts       7 Advanced Chart Techniques       8 Creating and Using Pivot Charts       9 Presenting Data Visually Without Charts       10 Presenting Your Excel Data on a Map Using Microsoft MapPoint       11 Using SmartArt Graphics and Shapes       12 Exporting Your Charts for Use Outside of Excel       13 Using Excel VBA to Create Charts    14 Knowing When Someone Is Lying to You with a Chart       Appendix A: Charting References       Index","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49600519962897,"sku":"GOR005542016","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0789736101.jpg?v=1750703512"},{"product_id":"pivot-table-data-crunching-book-bill-jelen-9780789734358","title":"Pivot Table Data Crunching","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 and real-world advice demonstrate the benefits of Pivot Tables and how to avoid the common pitfalls of every day data crunching. Each solution presented in the book can be accomplished with resources available in the Excel interface, making Pivot Table Data Crunching a beneficial resource for all levels of Excel users.","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49600644710673,"sku":"GOR001975545","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ WELL_READ \/ SBYB","offer_id":50365585916177,"sku":"CIN0789734354A","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ GOOD \/ SBYB","offer_id":50365587194129,"sku":"CIN0789734354G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":51155430703377,"sku":"CIN0789734354VG","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0789734354.jpg?v=1750785961"},{"product_id":"brilliant-microsoft-excel-2007-charts-graphs-book-bill-jelen-9780273714040","title":"Brilliant Microsoft Excel 2007 Charts \u0026 Graphs","description":"After 15 years with no updates to the Excel charting engine, Microsoft has provided a complete rewrite of the chart rendering engine in Excel 2007.This book will teach users to develop their skills so they can produce great looking charts that communicate clearly.    Brilliant Excel Charts and Graphs teaches techniques that enable users to discard the Microsoft defaults and create charts that can communicate effectively. The first section explains how to decide which chart type to use and subsequent chapters walk through each of the chart types, how to create them, how to utilize them and special options available for each chart . Throughout the book there are no-nonsense, step-by-step tutorials and lots of practical examples aimed directly at business users","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49600736952593,"sku":"GOR006474171","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ GOOD \/ INTERNAL","offer_id":49636660019473,"sku":"GOR004708363","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/027371404X.jpg?v=1750812719"},{"product_id":"guerilla-data-analysis-using-microsoft-excel-book-bill-jelen-9780972425803","title":"Guerilla Data Analysis Using Microsoft Excel","description":"This book includes step-by-step examples and case studies that teach users the many power tricks for analyzing data in Excel. These tips have been honed by Oz du Soleil, a former financial analyst charged with taking mainframe data and turning it into useful information quickly, and Mr. Excel himself, Bill Jelen. Topics include data quality, validation, perfectly sorting with one click, matching lists of data, data consolidation, data subtotals, pivot tables, pivot charts, tables, and much more. This new edition has been updated for Excel 2013.","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49602739437841,"sku":"GOR001472487","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"GB \/ GOOD \/ INTERNAL","offer_id":49617054335249,"sku":"GOR002436213","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ WELL_READ \/ SBYB","offer_id":50375872774417,"sku":"CIN0972425802A","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ GOOD \/ SBYB","offer_id":50375874838801,"sku":"CIN0972425802G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":51451404484881,"sku":"CIN0972425802VG","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0972425802.jpg?v=1751203488"},{"product_id":"vba-and-macros-for-microsoft-excel-book-bill-jelen-9780789731296","title":"VBA and Macros for Microsoft Excel","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 and Web queries are just a few of the areas you will learn about in this book. Written by the principal behind the leading Excel Web site, www.mrexcel.com, this book is sure to save you time and money!","brand":"WoB","offers":[{"title":"GB \/ GOOD \/ INTERNAL","offer_id":49622455943441,"sku":"GOR004273734","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49624848204049,"sku":"GOR001685948","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"GB \/ WELL_READ \/ INTERNAL","offer_id":49631134974225,"sku":"GOR003453309","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ GOOD \/ SBYB","offer_id":50468345512209,"sku":"CIN0789731290G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":51324594716945,"sku":"CIN0789731290VG","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ WELL_READ \/ SBYB","offer_id":53625878610193,"sku":"CIN0789731290A","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ LIKE_NEW \/ INTERNAL","offer_id":53650179457297,"sku":"GOR012294252","price":0.0,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0789731290.jpg?v=1751441115"},{"product_id":"pivot-table-data-crunching-book-bill-jelen-9780789743138","title":"Pivot Table Data Crunching","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 understand. Jelen and Alexander go far beyond merely explaining PivotTables and PivotCharts: they present practical \"recipes\" for solving a wide range of business problems. Drawing on more than 30 combined years of Excel experience, they provide tips and tricks you won't find anywhere else, and show exactly how to sidestep common mistakes. Coverage includes: \" Creating PivotTables, customizing them, and changing the way you view them \" Performing calculations within PivotTables \" Using PivotCharts and other visualizations \" Analyzing multiple data sources with PivotTables \" Sharing PivotTables with others \" Working with and analyzing OLAP data \" Making the most of Excel 2010's powerful new PowerPivot feature \" Using Excel 2010's Slicer to dynamically filter PivotTables \" Enhancing PivotTables with macros and VBA code This book is part of the new MrExcel Library series, edited by Bill Jelen, world-renowned Excel expert and host of the enormously popular Excel help site, MrExcel.com.      Teaches PivotTables, PivotCharts, and Excel 2010's new PowerPivot feature through real-world scenarios that make intuitive sense to users at all levels  Includes proven PivotTable recipes for instant on-the-job results  Helps Excel users avoid common pitfalls and mistakes  Part of the brand-new MrExcel Library series, edited by Excel legend Bill Jelen","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49630004478225,"sku":"GOR005634306","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ GOOD \/ SBYB","offer_id":50101357379857,"sku":"CIN0789743132G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ WELL_READ \/ INTERNAL","offer_id":50335849480465,"sku":"GOR008684858","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":52815695380753,"sku":"CIN0789743132VG","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0789743132.jpg?v=1751422453"},{"product_id":"vba-and-macros-for-microsoft-office-excel-2007-book-bill-jelen-9780789736826","title":"VBA and Macros for Microsoft Office Excel 2007","description":"“In this day and age of ‘too much information and not enough time,’ the ability to get to the bottom line quickly and in a concise method is what excels companies to the top of their industry. The techniques in this book will allow you to do things you only dreamt of.”  —Jerry Kohl, president of Brighton Collectibles     Develop your Excel macro programming skills using VBA instantly with proven techniques     Automate Reports   Handle Errors   Master Pivot Tables   Produce Charts   Build User-Defined Functions   Migrate to Excel 2007   Query Web Data   Build Dialog Boxes   Use Data Visualizations   Automate Word        You are an expert in Excel, but the macro recorder doesn’t work and you can’t make heads or tails out of the recorded code. If this is you, buy this book. Macros that you record today might work today but not tomorrow. Recorded macros might handle a dataset with 14 records but not one with 12 or 16 records. These are all common problems with the macro recorder that unfortunately cause too many Excel gurus to turn away from writing macros. 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 for others, this book is for you.    Learn VBA syntax as easy-to-understand English Automate Excel’s power tools: Pivot Tables, Charts, Advanced Filters Save hours per week by automating redundant tasks Create applications built on top of Excel with custom dialog boxes Automatically produce hundreds of Excel reports in seconds Understand how changes in Excel 2007 impact your VBA macros  Introduction   1  1 Unleash the Power of Excel with VBA      7  2 This Sounds Like BASIC, So Why Doesn’t It Look Familiar?       29   3 Referring to Ranges 61   4 User-Defined Functions     75  5 Looping and Flow Control   101  6 R1C1-Style Formulas        121  7 What’s New in Excel 2007 and What's Changed  135  8 Create and Manipulate Names in VBA      143  9 Event Programming 155  10 UserForms--An Introduction       177  11 Creating Charts    197  12 Data Mining with Advanced Filter          249  13 Using VBA to Create Pivot Tables         281  14 Excel Power         337  15 Data Visualizations and Conditional Formatting  373  16 Reading from and Writing to the Web              393  17 XML in Excel 2007 413  18 Automating Word  421  19 Arrays       441  20 Text File Processing    449  21 Using Access as a Back End to Enhance Multi-User Access to Data   461  22 Creating Classes, Records, and Collections       477  23 Advanced UserForm Techniques  493  24 Windows Application Programming Interface (API)       517  25 Handling Errors     529  26 Customizing the Ribbon to Run Macros   543  27 Creating Add-Ins  569  Index  577","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49640051048721,"sku":"GOR002126610","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":50590947180817,"sku":"CIN0789736829VG","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0789736829.jpg?v=1751446360"},{"product_id":"mrexcel-live-book-bill-jelen-9781615470563","title":"MrExcel LIVe","description":"The 54 essential tips that all Excel users need to know. MrExcel LIVe provides users with a concise book that can be absorbed in under an hour. Includes a section with keyboard shortcuts. Anyone who uses Excel will be able to turn to any page and pick up tips that will save them hours of work.","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49641389424913,"sku":"GOR012434936","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":51684951163153,"sku":"CIN1615470565VG","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ GOOD \/ SBYB","offer_id":51694704165137,"sku":"CIN1615470565G","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/1615470565.jpg?v=1751311004"},{"product_id":"microsoft-excel-inside-out-office-2021-and-microsoft-365-book-bill-jelen-9780137559534","title":"Microsoft Excel Inside Out (Office 2021 and Microsoft 365)","description":"Conquer Microsoft Excel—from the inside out!          Dive Into Microsoft Excel for Office 2021 and Microsoft 365 and really put your spreadsheet expertise to work. This supremely well-organized reference packs hundreds of timesaving solutions, tips, and workarounds—all you need to make the most of Excel's most powerful tools for analyzing data and making better decisions. Renowned Excel expert Bill Jelen offers a complete tour of Excel and its latest innovations, from advanced analysis and visualizations to dashboards. Discover how experts tackle today's key tasks—and challenge yourself to new levels of mastery.                     Save time with galleries, keyboard accelerators, and other shortcuts. Enter formulas more efficiently, and fully control operators and dates. Use new data types to return photos, arrays, or weather history— and even create your own. Master Excel's most widely-used functions. Integrate external data from the web and other sources. Use the new XLOOKUP function to retrieve data more efficiently, with fewer errors. Store powerful specialized logic in LAMBDA functions—and avoid their limitations. Easily transform complex datasets with Power Query. Quickly summarize millions of records with pivot tables. Perform ad hoc analyses and create advanced data mashups. Use Analyze Data's artificial intelligence to get answers and auto-generate pivot tables. Solve complex problems with What-If, Scenario Manager, Goal Seek, and Solver. Automate repetitive tasks by editing recorded VBA code. Demystify data with conditional formatting and other visualization techniques. Make the most of Excel's newest maps and charts. Add visual power with icons, 3D models, and animated 3D maps.","brand":"WoB","offers":[{"title":"US \/ GOOD \/ SBYB","offer_id":49725961666833,"sku":"CIN0137559534G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ NEW \/ GARDNERS","offer_id":49739327209745,"sku":"NGR9780137559534","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":50893143081233,"sku":"GOR014109073","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ GOOD \/ INTERNAL","offer_id":51687170933009,"sku":"GOR014360995","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ NEW \/ INGRAM","offer_id":53135008727313,"sku":"NIN9780137559534","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0137559534.jpg?v=1780479772"},{"product_id":"microsoft-excel-pivot-table-data-crunching-office-2021-and-microsoft-365-book-bill-jelen-9780137521838","title":"Microsoft Excel Pivot Table Data Crunching (Office 2021 and Microsoft 365)","description":"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! Even if you've never created a pivot table before, this book will help you leverage all their flexibility and analytical power— including important recent improvements in Microsoft 365 Excel. Drawing on more than 30 years of cutting-edge Excel experience, MVP Bill Jelen (“MrExcel”) shares practical “recipes” for solving real business problems, expert insights for avoiding mistakes, and advanced tips and tricks you'll find nowhere else.         By reading this book, you will:        Master easy, powerful ways to create, customize, change, and control pivot tables Transform huge datasets into clear summary reports Instantly highlight your most profitable customers, products, or regions Use the data model and Power Query to quickly analyze disparate data sources Create powerful crosstab reports with new dynamic arrays and Power Query Build geographical pivot tables with 3D Maps Construct and share state-of-the-art dynamic dashboards Revamp analyses on the fly by dragging and dropping fi elds Build dynamic self-service reporting systems Share your pivot tables with colleagues Create data mashups using the full Power Pivot capabilities in modern Excel versions Generate pivot tables using either VBA on the Desktop or Typescript in Excel Online Save time and avoid formatting problems by adapting reports with GetPivotData Unpivot source data so it's easier to work with Use new Analyze Data artificial intelligence to create pivot tables","brand":"WoB","offers":[{"title":"GB \/ NEW \/ GARDNERS","offer_id":49741406011665,"sku":"NGR9780137521838","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ GOOD \/ SBYB","offer_id":50012928999697,"sku":"CIN0137521839G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":51865040355601,"sku":"GOR012959105","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":51878019531025,"sku":"CIN0137521839VG","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ NEW \/ INGRAM","offer_id":53222500106513,"sku":"NIN9780137521838","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0137521839.jpg?v=1769688866"},{"product_id":"mrexcel-23-book-bill-jelen-9781615470792","title":"MrExcel 23","description":"\u003cb\u003eExcel tips to skyrocket white-collar productivity.\u003c\/b\u003e\u003cbr\u003e \u003cbr\u003e 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 2021 adds information on LET and LAMBDA functions, amazing new data types, dynamic array formulas, and more.","brand":"WoB","offers":[{"title":"GB \/ NEW \/ GARDNERS","offer_id":49752276697361,"sku":"NGR9781615470792","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ NEW \/ INGRAM","offer_id":51039955812625,"sku":"NIN9781615470792","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":53597520068881,"sku":"CIN1615470794VG","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/1615470794.jpg?v=1770893879"},{"product_id":"power-excel-with-mrexcel-2017-edition-book-bill-jelen-9781615470495","title":"Power Excel with MrExcel - 2017 Edition","description":"Updating the previous edition's tips to include features in Excel 2016, this new edition of MrExcel's popular software guide even incorporates suggestions sent in by readers. Each featured topic has a problem statement and description, followed by a broad strategy for solving the problem. MrExcel then walks readers through the specific steps to solve the issue. Alternate strategies are also provided, along with common scenarios that trip users up, leaving readers with not only answers to their specific dilemmas but also new and quicker ways to use formulas and spreadsheets.","brand":"WoB","offers":[{"title":"US \/ GOOD \/ SBYB","offer_id":49773138313489,"sku":"CIN1615470492G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":50327683989777,"sku":"GOR013928668","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ WELL_READ \/ SBYB","offer_id":51721213149457,"sku":"CIN1615470492A","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":53063000162577,"sku":"CIN1615470492VG","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/1615470492.jpg?v=1751024448"},{"product_id":"power-excel-2010-with-mrexcel-livelessons-video-training-dvd-9780789743930","title":"Power Excel 2010 with MrExcel LiveLessons (Video Training)","description":"7+ Hours of Video Instruction   You’ve got Microsoft Excel 2010…now get the most out of it, faster and more easily than ever before! In 90 quick video lessons, Power Excel 2010 with MrExcel shows how to maximize your productivity with Microsoft Excel 2010’s best tools and shortcuts. Expert Bill Jelen simplifies powerful features including PivotTables, PowerPivot, Sparklines, Goal Seek, Cell Styles, Color Scales, Icon Sets, Data Bars, Web Queries, Backstage View, and more! Get more done faster with customized workbooks, the Quick Access Toolbar, and keyboard shortcuts…control and analyze data more effectively…communicate more visually with new charting tools and SmartArt…and plenty more! Just watch: You’ll master high-powered Microsoft Excel 2010 skills at your own pace–and get specific answers and solutions immediately, whenever you need them! For anyone who wants to master Microsoft Excel 2010 fast–from novices to experienced power users.       Bill Jelen is MrExcel, as well as an Excel MVP. He is an accomplished Excel author and the principal behind the leading Excel website, MrExcel.com. As an Excel consultant, he has written Excel VBA solutions for hundreds of clients around the English-speaking world. His website hosts more than 12 million page views annually. Jelen is author of the five-star reviewed Guerilla Data Analysis Using Microsoft Excel, co-author of VBA and Macros for Microsoft Excel, co-author of Pivot Table Data Crunching, and author of Learn Excel From Mr. Excel.        Part 1 Excel Interface 1 - Ribbon, QAT, Mini Toolbar, Live Preview  2 - Finding Icons  3 - Customizing the Ribbon  4 - Backstage View  5 - Recent Documents  6 - Keyboard Shortcuts  7 - Zoom Slider and Page Layout  8 - Unlocking the Big Grid  9 - Data Entry Tricks  10 - Customize All Future Workbooks  11 - Copy Worksheets  12 - Change All Worksheets  13 - Arranging Windows  14 - Saving Workbook to PDF  15 - Saving Workbook to Excel Web App    Part 2 Text Formulas 16 - Drag the Fill Handle 17 - Create Your Own Series 18 - Joining Text 19 - Rapid Formula Copy 20 - Convert to Proper Case 21 - Joining Dates 22 - Formulas to Values 23 - Breaking Apart Text 24 - Parsing Fixed Width   Part 3 Formulas 25 - AutoSum Tricks 26 - Formula Auditing 27 - Three Ways of Entering Formulas 28 - Relative Versus Absolute Formulas 29 - Tables and Table Formulas 30 - Discovering Functions 31 - Goal Seek 32 - IF Formulas 33 - VLOOKUP 34 - Date and Time   Part 4 Sorting \u0026amp; Filtering 35 - Data Preparation 36 - One-Click Sorting 37 - Sorting by Color 38 - Sorting by Weekday 39 - Rearranging Columns 40 - Filter by Selection 41 - Other ways to Filter 42 - Remove Duplicates   Part 5 Subtotals 43 - Subtotals 44 - Collapsing Subtotals 45 - Copy Subtotals 46 - Formatting Subtotals 47 - Sorting Subtotals 48 - Changing Sum to Count in 1 column 49 - Data Consolidate 50 - Easy-XL   Part 6 Pivot Tables 51 - Creating a Pivot Table 52 - Changing a Pivot Table 53 - Pivot Gotchas 54 - Pivot Formatting 55 - Drill Down 56 - Pivot Calculations 57 - Summarizing Dates 58 - Pivot Sorting 59 - Filtering Row Fields  60 - Top 10 Report 61 - Filtering a Pivot Table with Slicers 62 - Slicers on Two Pivot Tables 63 - 50 Reports in 5 Seconds 64 - Using GetPivotData   Part 7 PowerPivot 65 - Getting Data into PowerPivot 66 - Adding Calculations in PowerPivot 67 - Linking Tables in PowerPivot 68 - Creating Pivot Table in PowerPivot 69 - Sorting in PowerPivot   Part 8 Charting and SmartArt 70 - Creating and Formatting a Chart 71 - Adding or Removing Chart Data 72 - Saving Favorite Chart Settings 73 - Charting Differing Orders of Magnitude 74 - Pie Chart Tricks 75 - Sparklines 76 - Labeling Sparklines 77 - Creating SmartArt 78 - Smart Art Formulas   Part 9 Visual Impact 79 - Cell Styles and Document Themes 80 - Color Scales, Icon Sets, Data Bars 81 - Icons for Only a Subset 82 - Paired Bar Charts with Negative Data Bars 83 - Picture Tools and WordArt 84 - Picture Background Removal 85 - Insert Screen Clipping 86 - Equation Editor   Part 10 Tips \u0026amp; Tricks 87 - Web Queries 88 - Turn Data 89 - Choose from a List 90 - ToolTips for a Cell 91 - Word Processing in Excel 92 - Have a Talk with Excel       LiveLessons Video Training series publishes hundreds of hands-on, expert-led video tutorials covering a wide selection of technology topics designed to teach you the skills you need to succeed. This professional and personal technology video series features world-leading author instructors published by your trusted technology brands: Addison-Wesley, Cisco Press, IBM Press, Pearson IT Certification, Prentice Hall, Sams, and Que. Topics include: IT Certification, Programming, Web Development, Mobile Development, Home \u0026amp; Office Technologies, Business \u0026amp; Management, and more. View All LiveLessons http:\/\/www.quepublishing.com\/imprint\/series_detail.aspx?st=87397","brand":"WoB","offers":[{"title":"US \/ GOOD \/ SBYB","offer_id":49896303984913,"sku":"CIN0789743930G","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0789743930.jpg?v=1750817596"},{"product_id":"mrexcel-2021-book-bill-jelen-9781615470716","title":"MrExcel 2021","description":"\u003cb\u003eUnlock the Secrets of Excel Mastery\u003c\/b\u003e. This comprehensive guide, designed for everyday Excel users, unveils hidden techniques to boost your productivity and efficiency. Updated for 2021, this edition covers everything from basic functions to advanced features like Power Pivot and Power Query. \u003cp\u003eDiscover the power of LET and LAMBDA functions, explore amazing new data types, and master dynamic array formulas. Whether you're looking to streamline data analysis, automate tasks, or simply enhance your spreadsheet skills, \u003ci\u003eMrExcel 2021\u003c\/i\u003e provides the tools and knowledge you need to take your Excel game to the next level. Perfect for those who want to unmask Excel's full potential and transform their workflow.\u003c\/p\u003e","brand":"WoB","offers":[{"title":"US \/ GOOD \/ SBYB","offer_id":50396129722641,"sku":"CIN1615470719G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":51090473058577,"sku":"GOR011403956","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ LIKE_NEW \/ SBYB","offer_id":51834738245905,"sku":"CIN1615470719LN","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/1615470719.jpg?v=1751342871"},{"product_id":"power-excel-2019-with-mrexcel-book-bill-jelen-9781615470600","title":"Power Excel 2019 with MrExcel","description":null,"brand":"WoB","offers":[{"title":"US \/ GOOD \/ SBYB","offer_id":50413763199249,"sku":"CIN1615470603G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":51285488632081,"sku":"GOR010141578","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":51330392490257,"sku":"CIN1615470603VG","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ WELL_READ \/ SBYB","offer_id":53346926297361,"sku":"CIN1615470603A","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ GOOD \/ INTERNAL","offer_id":53356945670417,"sku":"GOR014873302","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/1615470603.jpg?v=1751119433"},{"product_id":"learn-excel-97-through-excel-2007-from-mr-excel-book-bill-jelen-9781932802276","title":"Learn Excel 97 Through Excel 2007 from Mr Excel","description":null,"brand":"WoB","offers":[{"title":"- \/ - \/ -","offer_id":50732172902673,"sku":"","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":50732173132049,"sku":"GOR002083730","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/1932802274.jpg?v=1751446960"},{"product_id":"microsoft-excel-pivot-table-data-crunching-including-dynamic-arrays-power-query-book-bill-jelen-9780135408797","title":"Microsoft Excel Pivot Table Data Crunching Including Dynamic Arrays, Power Query, and Copilot","description":"Learn to use pivot tables and pivot charts in Microsoft Excel to produce powerful, dynamic reports in minutes: take control of your data and your business! Even if you’ve never created a pivot table before, this book will help you leverage their flexibility and analytical power—and includes exploration of new array functions and Copilot capabilities in analysis creation. Drawing on more than 30 years of cutting-edge Excel experience, MVP Bill Jelen (“MrExcel”) shares practical “recipes” for solving real business problems, expert insights for avoiding mistakes, and advanced tips and tricks you’ll find nowhere else.   By reading this book, you will:     Master easy, powerful ways to create, customize, change, and control pivot tables Use Copilot and Analyze Data features to create pivot tables Transform huge datasets into clear summary reports Instantly highlight your most profitable customers, products, or regions Pivot data with powerful dynamic arrays and Power Query Use PIVOTBY and GROUPBY functions to create reports without needing to refresh Build geographical pivot tables with 3D Maps Construct and share state-of-the-art dynamic dashboards Revamp analyses on the fly by dragging and dropping fi elds Build dynamic self-service reporting systems Share your pivot tables with colleagues Create data mashups using the full Power Pivot capabilities in modern Excel versions Generate pivot tables using either VBA on the Desktop or Typescript in Excel Online or on the Desktop Embrace GetPivotData for better looking reports and learn how to prevent it for quick reporting Unpivot source data so it’s easier to use   About This Book     For everyone who wants to get more done with Microsoft Excel in less time For business and financial professionals, entrepreneurs, students, and others who need to efficiently manage and analyze data","brand":"WoB","offers":[{"title":"US \/ NEW \/ INGRAM","offer_id":50999372415249,"sku":"NIN9780135408797","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ NEW \/ GARDNERS","offer_id":51215685845265,"sku":"NGR9780135408797","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ LIKE_NEW \/ SBYB","offer_id":52879963947281,"sku":"CIN0135408792LN","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ NEW \/ INGRAM","offer_id":53134553940241,"sku":"NLS9780135408797","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ GOOD \/ SBYB","offer_id":53229431193873,"sku":"CIN0135408792G","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0135408792.jpg?v=1780135151"},{"product_id":"mrexcel-2025-book-bill-jelen-9781615470884","title":"MrExcel 2025","description":"Excel tips to skyrocket white-collar productivity. 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 XLOKUP. It introduces elements of modern Excel such as the Power Pivot Data Model and cleaning data with Power Query. Updated annually, this edition for 2024 adds information on Copilot and Python in Excel.","brand":"WoB","offers":[{"title":"US \/ NEW \/ INGRAM","offer_id":52509400498449,"sku":"NIN9781615470884","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ NEW \/ INGRAM","offer_id":53250610528529,"sku":"NLS9781615470884","price":0.0,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/9781615470884.jpg?v=1778752724"},{"product_id":"mrexcel-2022-book-bill-jelen-9781615470778","title":"MrExcel 2022","description":"\u003cb\u003eInspiring Excel tips designed to save 100 hours per year.\u003c\/b\u003e \u003cp\u003e\u003c\/p\u003e 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 on collaboration features, LET and LAMBDA functions, amazing new data types, dynamic array formulas, and more.","brand":"WoB","offers":[{"title":"GB \/ NEW \/ INGRAM","offer_id":53250617049361,"sku":"NLS9781615470778","price":0.0,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/9781615470778.jpg?v=1773530187"},{"product_id":"power-excel-2007-with-mrexcel-video-training-book-bill-jelen-9780789738257","title":"Power Excel 2007 with MrExcel (Video Training)","description":"Designed for Excel 2007 users, this video tutorial features demonstrations of more than 50 techniques that viewers can immediately apply in their own workbooks. This DVD package includes a 96-page booklet with an outline of the topics.","brand":"WoB","offers":[{"title":"- \/ - \/ INTERNAL","offer_id":53450242130193,"sku":null,"price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ GOOD \/ SBYB","offer_id":53450242457873,"sku":"CIN0789738252G","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/9780789738257.jpg?v=1776891614"}],"url":"https:\/\/www.worldofbooks.com\/en-ie\/collections\/author-books-by-bill-jelen.oembed?page=2","provider":"World of Books ","version":"1.0","type":"link"}