Bill Jelen (Jelen, Bill)

used books, rare books and new books

Find all books by 'Bill Jelen' and compare prices
Find signed collectible books by 'Bill Jelen'

More editions of Charts and Graphs: Microsoft Excel 2010 (MrExcel Library):

  • Don't Fear the Spreadsheet: A Beginner's Guide to Overcoming Excel's Frustrations
    by Tyler Nash, Bill Jelen , Kevin Jones, Tom Urtis
    ISBN 1615470034 (1-61547-003-4)
    Softcover, Holy Macro! Books

    Find This Book

     

    Find signed collectible books: 'Don't Fear the Spreadsheet: A Beginner's Guide to Overcoming Excel's Frustrations'
    Book summary:

    Book by Nash, Tyler, Jelen, Bill, Jones, Kevin, Urtis, Tom

    More editions of Don't Fear the Spreadsheet: A Beginner's Guide to Overcoming Excel's Frustrations:

  • Excel 2013 Charts and Graphs (MrExcel Library)
    by Bill Jelen
    ISBN 0789748622 (0-7897-4862-2)
    Softcover, Que Publishing

    Find This Book

     

    Find signed collectible books: 'Excel 2013 Charts and Graphs (MrExcel Library)'
    Book summary:

    Use Excel 2013s 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 youre looking for!

     

    This book reveals data visualization techniques you wont 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, anywhereeven on the Web and social networks.

     

    Learning advanced Excel techniques has never been easier. Youll 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 2013s 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 productivitysaving 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

  • Excel 2013 In Depth
    by Bill Jelen
    ISBN 0789748576 (0-7897-4857-6)
    Softcover, Que Publishing

    Find This Book

     

    Find signed collectible books: 'Excel 2013 In Depth'
    Book summary:

    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 wont find anywhere else. Excel 2013 In Depth is the fastest, best way to master Excel 2013s 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 2013s most valuable new features. Then, learn how to

     

    • Build more trustworthy, error-resistant, flexible, extensible, intelligent, and understandable spreadsheets
    • Get more productive with Excel 2013s 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 youll 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 cant fix on your own. Whatever you intend to do with Excel 2013, this is the only book youll need!

     

  • Excel 2013 Pivot Table Data Crunching (MrExcel Library)
    by Bill Jelen , Michael Alexander
    ISBN 0789748754 (0-7897-4875-4)
    Softcover, Que Publishing

    Find This Book

     

    Find signed collectible books: 'Excel 2013 Pivot Table Data Crunching (MrExcel Library)'
    Book summary:

    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 whats going on in your business& take control, and stay in control!

     

    Even if youve 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. Youll 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 productivitysaving 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

     

    More editions of Excel 2013 Pivot Table Data Crunching (MrExcel Library):

  • Excel 2013 VBA and Macros (MrExcel Library)
    by Bill Jelen , Tracy Syrstad
    ISBN 0789748614 (0-7897-4861-4)
    Softcover, Que Publishing

    Find This Book

     

    Find signed collectible books: 'Excel 2013 VBA and Macros (MrExcel Library)'
    Book summary:

    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! Youll discover macro
    techniques you wont 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 2013s most valuable new features. Mastering advanced Excel macros has never been easier. Youll find
    simple, step-by-step instructions, real-world examples and case studies, and 50 workbooks packed with bonus
    examples, macros, and solutionsstraight 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 programsand 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 productivitysaving 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

     

  • Jelen, Bill: Excel for Auditors: Audit Spreadsheets Using Excel 97 through Excel 2007 (Excel for Professionals series)
  • Excel for Call Centers (Excel for Professionals series)
    by Bill Jelen , John Cockerill, Colin Taylor
    ISBN 1932802266 (1-932802-26-6)
    Softcover, Holy Macro! Books

    Find This Book

     

    Find signed collectible books: 'Excel for Call Centers (Excel for Professionals series)'
    Book summary:

    Using real-world examples and data to demonstrate and teach practical Excel skills, this book increases clarity of understanding and reduces the time needed to wade through the mountains of data generated every day in all call centers. The methods used include: forecasting call and work demand and capacity; agent tracking and monitoring; determining the number of people needed to handle a given number of calls, e-mails, or other work to meet service levels; creating reports that help manage and direct centers; and creating budgets that are accurate and viable. Both inbound and outbound campaign preparation and design are covered along with trend spotting, re-keying minimization, and episodic problem tracking. Readers of this handy manual will learn to see the big picture and present it to others with impact.

  • Excel for Marketing Managers (Excel for Professionals series)
    by Ivana Taylor, Bill Jelen
    ISBN 1932802134 (1-932802-13-4)
    Softcover, Holy Macro! Books

    Find This Book

     

    Find signed collectible books: 'Excel for Marketing Managers (Excel for Professionals series)'
    Book summary:

    Excel for Marketing Managers The most powerful Microsoft Excel features that can be used to sort through data to produce meaningful marketing analyses are outlined in this manual. Marketing managers will learn the math functions to produce budgets and forecasts, and how to use survey analysis to quickly spot trends using pivot tables and other analysis tools. Ideas for launch schedules, life cycle management, and other date-r... Full description

    More editions of Excel for Marketing Managers (Excel for Professionals series):

  • Excel for Teachers (Excel for Professionals series)
    by Colleen Conmy, Bill Hazlett, Bill Jelen , Adrienne Soucy
    ISBN 1932802118 (1-932802-11-8)
    Softcover, Holy Macro! Books

    Find This Book

     

    Find signed collectible books: 'Excel for Teachers (Excel for Professionals series)'
    Book summary:

    Excel for Teachers Addressing a classroom teacher's need to simultaneously manage a classroom full of students, meet state-mandated assessment standards for students, and track students' performance against a rubric, this overview of Excel shows how to put its features to use immediately in a classroom. Tracking attendance, grades, and books in the school library, creating reports to share with parents at parent-tea... Full description

  • Hazlett, Bill: Excel for the Math Classroom (Excel for Professionals series)
  • Excel Gurus Gone Wild: Do the IMPOSSIBLE with Microsoft Excel
    by Bill Jelen
    ISBN 1932802401 (1-932802-40-1)
    Softcover, Holy Macro! Books

    Find This Book

     

    Find signed collectible books: 'Excel Gurus Gone Wild: Do the IMPOSSIBLE with Microsoft Excel'
    Book summary:

    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.

    More editions of Excel Gurus Gone Wild: Do the IMPOSSIBLE with Microsoft Excel:

  • Excel VBA and Macros with MrExcel LiveLessons (Video Training)
    by Bill Jelen
    ISBN 0789739380 (0-7897-3938-0)
    Softcover, Que Publishing

    Find This Book

     

    Find signed collectible books: 'Excel VBA and Macros with MrExcel LiveLessons (Video Training)'
    Book summary:

    DVD includes:

    • 7+ HOURS OF VIDEO INSTRUCTION
    • 50 TIPS & TECHNIQUES
    • SKILLS YOU CAN LEARN IN Fifteen MINUTES OR LESS

     

    In Excel VBA and Macros with MrExcel, renowned Excel instructor and author Bill Jelen (MrExcel) teaches all the skills youll 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 youll need to successfully use both the Excel macro recorder and the Visual Basic for Applications development environment. Youll learn one step at a time, at your own paceusing hands-on examples that reflect realistic challenges and showcase Excels 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 dont have time to read a huge book on Excel macros and scripting, this is exactly what youve been searching for!

     

    For all serious Excel users: managers, financial pros, entrepreneurs, marketers, analysts, and more.

     

    Looking for a better way to master todays rapidly changing technologies? Want expert help, but dont have the time or energy to read a book? Cant find classroom training worth the money? Discover LiveLessons: self-paced, personal video instruction from the worlds leading technology experts.

    • LiveLessons are video courses, on DVD with a book supplement, that are organized into bite-sized, self-contained sessionsyoull 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 Excels macro recorder and its powerful VBA development environment!

     

    Bill Jelen is called MrExcel for a reason! Nobody knows more about Excel macros and scriptingand nobody knows more about teaching these skills to working professionals! Thought youd 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 / £31.99 U.K.

     

    mylivelessons.com

    informit.com/que

     

    More editions of Excel VBA and Macros with MrExcel LiveLessons (Video Training):

  • Guerilla Data Analysis Using Microsoft Excel
    by Bill Jelen
    ISBN 0972425802 (0-9724258-0-2)
    Softcover, Holy Macro! Books

    Find This Book

     

    Find signed collectible books: 'Guerilla Data Analysis Using Microsoft Excel'
    Book summary:

    This book includes step-by-step examples and case studies that teach users the many power tricks for analyzing data in Excel. These are tips honed by Bill Jelen, MrExcel, during his 10-year run as a financial analyst charged with taking mainframe data and turning it into useful information quickly. Topics include perfectly sorting with one click every time, matching lists of data, data consolidation, data subtotals, pivot tables, and much more.

  • Holy Macro! It's 1,600 Excel VBA Examples
    by Hans Herber, Bill Jelen
    ISBN 0972425810 (0-9724258-1-0)
    Holy Macro! Books

    Find This Book

     

    Find signed collectible books: 'Holy Macro! It's 1,600 Excel VBA Examples'
    Book summary:

    This CD-ROM contains every snippet of Excel VBA code you will ever need. Each example includes a question, answer, the VBA code and a sample Excel workbook demonstrating the code. Completely searchable, this reference is a must for anyone who needs to write Excel macros.

    More editions of Holy Macro! It's 1,600 Excel VBA Examples:

  • Herber, Hans: Holy Macro! It's 1,900 Excel VBA Examples: Every Snippet of Excel VBA Code You'll Ever Need
    Holy Macro! It's 1,900 Excel VBA Examples: Every Snippet of Excel VBA Code You'll Ever Need
    by Hans Herber, Bill Jelen , Tom Urtis
    ISBN 1932380205 (1-932380-20-5)
    Holy Macro! Books

    Find This Book

     

    Find signed collectible books: 'Holy Macro! It's 1,900 Excel VBA Examples: Every Snippet of Excel VBA Code You'll Ever Need'
    Book summary:

    This guide to unleashing the power of Microsoft Excel by using Excels VBA programming language shows nonprogrammers how to solve real-life problems with Excel VBA. The hundreds of concise code samples are accompanied by sample workbooks designed in a question-and-answer format that describes how to do each specific task. Completely searchable, this CD-ROM has the ability to search on any Excel keyword and find all workbooks associated with the keyword.

  • Holy Macro! It's 2,500 Excel VBA Examples: Every Snippet of Excel VBA Code You'll Ever Need
    by Hans Herber, Bill Jelen , Tom Urtis
    ISBN 1932802185 (1-932802-18-5)
    Holy Macro! Books

    Find This Book

     

    Find signed collectible books: 'Holy Macro! It's 2,500 Excel VBA Examples: Every Snippet of Excel VBA Code You'll Ever Need'
    Book summary:

    Holy Macro! it;'s 2, 500 Excel VBA Examples This guide to unleashing the power of Microsoft Excel by using Excel's VBA programming language shows nonprogrammers how to solve real-life problems with Excel VBA. Thousands of concise code samples are accompanied by sample workbooks in a question-and-answer format that describes each specific task. Full description

    More editions of Holy Macro! It's 2,500 Excel VBA Examples: Every Snippet of Excel VBA Code You'll Ever Need:

  • Learn Excel 2007 through Excel 2010 From MrExcel: Master Pivot Tables, Subtotals, Charts, VLOOKUP, IF, Data Analysis and Much More - 512 Excel Mysteries Solved
    by Bill Jelen
    ISBN 1932802444 (1-932802-44-4)
    Softcover, Holy Macro! Books

    Find This Book

     

    Find signed collectible books: 'Learn Excel 2007 through Excel 2010 From MrExcel: Master Pivot Tables, Subtotals, Charts, VLOOKUP, IF, Data Analysis and Much More - 512 Excel Mysteries Solved'
    Book summary:

    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.

    More editions of Learn Excel 2007 through Excel 2010 From MrExcel: Master Pivot Tables, Subtotals, Charts, VLOOKUP, IF, Data Analysis and Much More - 512 Excel Mysteries Solved:

  • Learn Excel 97 Through Excel 2007 from Mr. Excel: 377 Excel Mysteries Solved!
    by Bill Jelen
    ISBN 1932802274 (1-932802-27-4)
    Softcover, Holy Macro! Books

    Find This Book

     

    Find signed collectible books: 'Learn Excel 97 Through Excel 2007 from Mr. Excel: 377 Excel Mysteries Solved!'
    Book summary:

    Learn Excel 2007 from Mr. Excel Deals with computers/software. Full description

    More editions of Learn Excel 97 Through Excel 2007 from Mr. Excel: 377 Excel Mysteries Solved!:

  • Learn Excel from Mr. Excel: 277 Excel Mysteries Solved
    by Bill Jelen
    ISBN 1932802126 (1-932802-12-6)
    Softcover, Holy Macro! Books

    Find This Book

     

    Find signed collectible books: 'Learn Excel from Mr. Excel: 277 Excel Mysteries Solved'
    Book summary:

    Containing 277 business case studies that illustrate nearly every aspect of Excel, this book presents real-life business problems and works them through to their solutions. In addition to exemplary solutions, each case analysis considers alternate approaches and gotchas, and includes a summary of the necessary commands and functions. Excel files that can be downloaded and worked through step-by-step are included for each case.

  • Microsoft Excel 2010 In Depth
    by Bill Jelen
    ISBN 0789743086 (0-7897-4308-6)
    Softcover, Que Publishing

    Find This Book

     

    Find signed collectible books: 'Microsoft Excel 2010 In Depth'
    Book summary:

    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

  • Jelen, Bill: Mr Excel ON EXCEL: Excel 97, 2000, 2002
    Mr Excel ON EXCEL: Excel 97, 2000, 2002
    by Bill Jelen , Joseph Rubin CPA
    ISBN 0972425837 (0-9724258-3-7)
    Softcover, Holy Macro! Books

    Find This Book

     

    Find signed collectible books: 'Mr Excel ON EXCEL: Excel 97, 2000, 2002'
  • Pivot Table Data Crunching
    by Bill Jelen , Michael Alexander
    ISBN 0672327945 (0-672-32794-5)
    Softcover, Que

    Find This Book

     

    Find signed collectible books: 'Pivot Table Data Crunching'
    Book summary:

    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.

  • Pivot Table Data Crunching for Microsoft Office Excel 2007
    by Bill Jelen , Michael Alexander
    ISBN 0789736012 (0-7897-3601-2)
    Softcover, Que Publishing

    Find This Book

     

    Find signed collectible books: 'Pivot Table Data Crunching for Microsoft Office Excel 2007'
    Book summary:

    This book consolidates all the best functionality of pivot tables into one guide that provides you with a meaningful tutorial, offering practical solutions to day-to-day problems.

     

    Within just the first 2 chapters, you will be creating basic pivot tables, increasing productivity, and producing reports in minutes instead of hours.

     

    Within the first 6 chapters, you will learn how to use pivot tables to quickly highlight your top 10 customers or bottom 5 products in profitability; quickly create analysis comparing sales this period to last period by product or region or both; easily summarize daily transactional data by month or quarter or year in a few mouse clicksall without knowing any formulas!

     

    By the end of the book, you will truly be a pivot table guru, automating pivot tables using VBA, creating pivot tables with external data in OLAP cubes, and even creating dynamic reporting systems so that your managers can answer their own queries with a few mouse clicks.

     

    " Take advantage of the numerous pivot table recipes

    " Create powerful summary reports in seconds

    " Build ad-hoc query tools with ease

    " Enhance your Executive Reporting

    " Filter reports to top 10 customers or products

    " Add dynamic charts to reports

    " Quickly summarize daily data by month, quarter, or year

     

     

     

     

    Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1

    1              Pivot Table Fundamentals . . . . . . . . . . . . . . . . . . . . . . . . . . . .11

    2              Creating a Basic Pivot Table . . . . . . . . . . . . . . . . . . . . . . . . . .21

    3              Customizing a Pivot Table . . . . . . . . . . . . . . . . . . . . . . . . . . . .45

    4              Controlling the Way You View Your Pivot Data . . . . . . . . . . . .83

    5              Performing Calculations Within Your Pivot Tables . . . . . . . . 117

    6              Using Pivot Charts and Other Visualizations . . . . . . . . . . . . .141

    7              Analyzing Disparate Data Sources with Pivot Tables . . . . . . 167

    8              Sharing Pivot Tables with Others . . . . . . . . . . . . . . . . . . . . . .189

    9              Working with and Analyzing OLAP Data . . . . . . . . . . . . . . . . 201

    10           Enhancing Your Pivot Table Reports with Macros . . . . . . . . .215

    11           Using VBA to Create Pivot Tables . . . . . . . . . . . . . . . . . . . . . 231

    12           Common Pivot Table Issues and Questions . . . . . . . . . . . . . .291

    A             Finding Pivot Table Commands on the Ribbon . . . . . . . . . . . .315

    More editions of Pivot Table Data Crunching for Microsoft Office Excel 2007:

  • Pivot Table Data Crunching: Microsoft Excel 2010 (MrExcel Library)
    by Bill Jelen , Michael Alexander
    ISBN 0789743132 (0-7897-4313-2)
    Softcover, Que Publishing

    Find This Book

     

    Find signed collectible books: 'Pivot Table Data Crunching: Microsoft Excel 2010 (MrExcel Library)'
    Book summary:

    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
  • More editions of Pivot Table Data Crunching: Microsoft Excel 2010 (MrExcel Library):

  • Jelen, Bill: Power Excel 2003 with MrExcel LiveLessons (Video Training)
  • Jelen, Bill: Power Excel 2007 LiveLesson Bundle (LiveLessons)
  • Power Excel 2007 with MrExcel (Video Training)
    by Bill Jelen
    ISBN 0789738252 (0-7897-3825-2)
    Softcover, Que Publishing

    Find This Book

     

    Find signed collectible books: 'Power Excel 2007 with MrExcel (Video Training)'
    Book summary:

    Power Excel 2007 with MrExcel 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. Full description

  • Jelen, Bill: Power Excel 2010 with MrExcel(LiveLessons)
  • Jelen, Bill: Power Excel 2010 with MrExcel LiveLessons Bundle
  • Jelen, Bill: Power Excel 2013 With Mrexcel Livelessons (Video Training)
  • Jacobs, Kathy: Power One Note: Unleash the Power of One Note
  • PowerPivot Alchemy: Patterns and Techniques for Excel
    by Bill Jelen , Rob Collie
    ISBN 1615470212 (1-61547-021-2)
    Softcover, Holy Macro! Books

    Find This Book

     

    Find signed collectible books: 'PowerPivot Alchemy: Patterns and Techniques for Excel'
    Book summary:

    PowerPivot is an amazing new add-in for Excel 2013 that allows business intelligence pros to process large amounts data. Although it is simple to use in a demo environment, analysts are likely to run into real-life scenarios that are difficult to solve. This guide, dedicated solely to the PowerPivot tool, provides techniques and solutions to real-world problems, including showing the Top N customers by using slicer filters, comparing budget to actuals, drilling across data instead of through data, and joining data from two different sources in a single analysis.

  • PowerPivot for the Data Analyst: Microsoft Excel 2010 (MrExcel Library)
    by Bill Jelen
    ISBN 0789743159 (0-7897-4315-9)
    Softcover, Que Publishing

    Find This Book

     

    Find signed collectible books: 'PowerPivot for the Data Analyst: Microsoft Excel 2010 (MrExcel Library)'
    Book summary:

    ANALYZE HUGE AMOUNTS OF BUSINESS DATA FASTER, MORE EASILY, AND MORE ACCURATELY!

    Use Microsofts 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 nowwithout ITs 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 dataand 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 todays sales to yesterdaysor 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 productivitysaving 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

     

     

     

    More editions of PowerPivot for the Data Analyst: Microsoft Excel 2010 (MrExcel Library):

  • Jelen, Bill: Rev Up to Excel 2010: Upgraders Guide to Excel 2010
  • Syrstad, Tracy: Using Microsoft Excel 2010
    Using Microsoft Excel 2010
    by Tracy Syrstad, Bill Jelen
    ISBN 078974290X (0-7897-4290-X)
    Softcover, Que Publishing

    Find This Book

     

    Find signed collectible books: 'Using Microsoft Excel 2010'
  • Jelen, Bill: Using Microsoft Office Excel 2007
  • Jelen, Bill: VBA and Macros for Microsoft Excel
    VBA and Macros for Microsoft Excel
    by Bill Jelen , Tracy Syrstad
    ISBN 0672326507 (0-672-32650-7)
    Softcover, Que

    Find This Book

     

    Find signed collectible books: 'VBA and Macros for Microsoft Excel'
    Book summary:

    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!

  • VBA and Macros for Microsoft Office Excel 2007
    by Bill Jelen , Tracy Syrstad
    ISBN 0789736829 (0-7897-3682-9)
    Softcover, Que Publishing

    Find This Book

     

    Find signed collectible books: 'VBA and Macros for Microsoft Office Excel 2007'
    Book summary:

    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 doesnt work and you cant 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 Excels 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 Doesnt 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 Whats 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

     

  • VBA and Macros: Microsoft Excel 2010 (MrExcel Library)
    by Bill Jelen , Tracy Syrstad
    ISBN 0789743140 (0-7897-4314-0)
    Softcover, Que Publishing

    Find This Book

     

    Find signed collectible books: 'VBA and Macros: Microsoft Excel 2010 (MrExcel Library)'
    Book summary:

    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 wont 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 2010s most powerful new features. Learning advanced Excel scripting has never been easier. Youll 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 productivitysaving 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

     

     

  • Founded in 1997, BookFinder.com has become a leading book price comparison site:

    Find and compare hundreds of millions of new books, used books, rare books and out of print books from over 100,000 booksellers and 60+ websites worldwide.


    Coauthors & Alternates

    Learn More at LibraryThing

    Bill Jelen
    at LibraryThing