Power Excel 2003 with MrExcel LiveLessons    Mastering the Smartest, Fastest Ways to Use Excel    Bill Jelen    DVD includes:   6+ hours of video instruction     More than 80 tips and techniques  Features that can be learned in less than Five minutes Bill Jelen (“MrExcel”) presents focused, practical videos that teach you powerful new ways to chart, calculate, build PivotTables, automate workbooks, wrangle your data, and more! Click play to follow along as Jelen walks you through using Excel’s most sophisticated features… all you need to do is watch!    You’ve got Microsoft Excel…now get the most out of it, faster and more easily than ever before! In 85 quick video lessons, Bill Jelen (“MrExcel”) shows you all you need to maximize your productivity with Excel 2003, 2002 (XP), or 2000!     Building on the live course he’s taught to thousands of financial professionals, Jelen walks you through Excel’s most powerful features and techniques. Just watch: You’ll master these powerful techniques at your own pace—and get specific answers and solutions immediately, whenever you need them!     These practical, easy-to-use videos cover charting, PivotTables, advanced calculations, worksheet management, macros, and a whole lot more—including tips and tricks that could save you hours every single week!    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 experts.     For anyone who wants to get more done in less time with Excel 2003, 2002 (XP), or 2000—from entrepreneurs to financial analysts, marketers to office managers!    LiveLessons is an eight-hour video course organized into bite-sized, self-contained sessions—you’ll learn key skills in as little as five minutes!  Each session begins with well-defined learning objectives and ends with comprehensive summaries, which help you track your progress.  Follow along as your instructor shows exactly how to get great results in your real-world environment. Bill Jelen is known worldwide as MrExcel. He presents live Excel seminars to accountants throughout the U.S. and has logged more than 60 appearances on The Lab with Leo Laporte. Honored as a Microsoft MVP for Excel, he has produced 500 episodes of his “Learn Excel from MrExcel” video podcast. He writes the monthly Excel column for Strategic Finance magazine.    Microsoft Office Spreadsheets/Desktop Applications   mylivelessons.com   informit.com/que    Contents:   Part 1 Charting  Lesson 1 Creating a Chart Using the Wizard  Lesson 2 Creating a Chart with One Keystroke  Lesson 3 Formatting a Chart Lesson 4 Adding Chart Data  Lesson 5 Noncontiguous Data  Lesson 6 Interactive Chart  Lesson 7 When to Choose Which Chart Type  Lesson 8 Charting Differing Orders of Magnitude  Lesson 9 Pie Chart Tricks  Lesson 10 XY & Bubble Charts  Lesson 11 Histograms & Overlap Charts  Lesson 12 Saving Favorite Chart Settings Lesson 13 Chart Lies   Part 2 Text  Lesson 14 Drag the Fill Handle to Extend a Series  Lesson 15 Create Your Own Series Lesson 16 Joining Text Lesson 17 Rapid Formula Copy  Lesson 18 Convert to Proper Case Lesson 19 Joining Dates  Lesson 20 Converting Formulas to Values  Lesson 21 Breaking Apart Text Lesson 22 Parsing Fixed Width    Part 3 Excel Customizations  Lesson 23 Full Menus  Lesson 24 Toolbar Customization Lesson 25 Resetting Toolbars  Lesson 26 Steve-O Toolbar  Lesson 27 Close All Workbooks  Lesson 28 Recently Used File List  Lesson 29 Data Entry Tricks Lesson 30 Customize All Future Workbooks  Lesson 31 Copy Worksheets Lesson 32 Change All Worksheets  Lesson 33 Arranging Windows    Part 4 Sorting & Subtotals Lesson 34 Data Preparation  Lesson 35 Sorting Basics Lesson 36 Random Sort  Lesson 37 Sorting by Weekday  Lesson 38 Rearranging Columns Lesson 39 Subtotals Lesson 40 Collapsing Subtotals  Lesson 41 Copy Subtotals  Lesson 42 Formatting Subtotals  Lesson 43 Multiple Subtotals  Lesson 44 Filling in Data on Subtotal Rows  Lesson 45 Subtotal Tricks   Part 5 Pivot Tables  Lesson 46 Creating a Pivot Table  Lesson 47 Changing a Pivot Table  Lesson 48 Pivot Gotchas  Lesson 49 Pivot Sorting  Lesson 50 Drill Down  Lesson 51 Summarizing Dates  Lesson 52 Top 10 Report  Lesson 53 Pivot Calculations  Lesson 54 Pivot Formatting  Lesson 55 Unique List Lesson 56 Ad-Hoc Queries  Lesson 57 50 Reports in 5 Seconds  Lesson 58 Making Reports Pivotable   Part 6 Formulas  Lesson 59 AutoSum Tricks  Lesson 60 Formula Auditing  Lesson 61 Three Ways of Entering Formulas  Lesson 62 Relative Versus Absolute Formulas Lesson 63 Discovering Functions  Lesson 64 Goal Seek  Lesson 65 Unusual Functions  Lesson 66 IF Formulas Lesson 67 VLOOKUP  Lesson 68 Super Formulas  Lesson 69 Date & Time   Part 7 Macros  Lesson 70 Recording a Macro  Lesson 71 Recording Navigation  Lesson 72 How Many Rows?  Lesson 73 Event Macros   Part 8 Tips & Tricks  Lesson 74 Finding Records  Lesson 75 Web Queries  Lesson 76 Copying Column Widths  Lesson 77Floating Palettes  Lesson 78 Page Numbering  Lesson 79 Turn Data  Lesson 80 & in Header  Lesson 81 Choose from a List  Lesson 82 Tool Tips for a Cell  Lesson 83 Word Processing in Excel Lesson 84 Mapping Data  Lesson 85 Have a Talk with Excel

Power Excel 2003 with MrExcel LiveLessons (Video Training)

Computers & Technology

Jelen, Bill

Software

Que Publishing

Renowned Excel experts Bill Jelen (MrExcel) and Tracy Syrstad help you automate Excel tasks to get more done, faster than ever.\nUse 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 Microsoft Excel. You’ll find simple, step-by-step instructions, real-world case studies, and 50 workbooks packed with examples and complete, easy-to-adapt solutions.\nBy 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 PivotTables to summarize, analyze, explore, and present data Leverage more of Excel VBA’s power with classes, collections, and Advanced Filter Make the most of User-Defined Functions (UDFs), including new LAMBDA functions Build sophisticated UserForm custom dialogs to collect data from other Excel users Integrate data from the Internet, Access and SQL Server databases, and other sources Automatically generate charts, visualizations, sparklines, and Word documents Extend Excel’s power by controlling other Office programs and Windows itself Create Office Add-ins to expand worksheet functionality or streamline retrieval of external information Get started creating brand-new TypeScript applications for Excel Online\nAbout 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

Microsoft Excel VBA and Macros (Office 2021 and Microsoft 365) (Business Skills)

Syrstad, Tracy

Microsoft Press

Renowned Excel expert Bill Jelen (MrExcel) helps you crunch data from any source with Excel pivot tables. Use Excel pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours, to take control of your data and your business. Even if you've never created a pivot table before, this book will help you leverage all their remarkable flexibility and analytical power--including valuable improvements in Excel and Excel in Office 365. Drawing on years of Excel experience, Bill Jelen offers practical "recipes" for solving real business problems, helps you avoid common mistakes, and presents tips and tricks you'll find nowhere else. By reading this book, you will: <ul> <li>Master easy, powerful ways to create, customize, change, and control pivot tables</li> <li>Control all future pivot tables using new pivot table defaults</li> <li>Transform huge data sets into clear summary reports</li> <li>Instantly highlight your most profitable customers, products, or regions</li> <li>Use Power Query to quickly import, clean, shape, and analyze disparate data sources</li> <li>Build geographical pivot tables with 3D Map</li> <li>Construct and share state-of-the-art dynamic dashboards</li> <li>Revamp analyses on the fly by dragging and dropping fields</li> <li>Build dynamic self-service reporting systems</li> <li>Share your pivot tables with colleagues</li> <li>Create data mashups using the full Power Pivot capabilities of Excel and Excel in Office 365</li> <li>Automate pivot tables with macros and VBA</li> <li>Save time by adapting reports with GetPivotData</li> <li>Discover today's most useful pivot table tips and shortcuts</li> </ul>

Microsoft Excel Pivot Table Data Crunching (Office 2021 and Microsoft 365) (Business Skills)

<div>Conquer Microsoft Excel -- from the inside out!</div> <div> </div> <div> </div> <div>Dive into Microsoft Excel -- and really put your spreadsheet expertise to work. This supremely 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.</div> <div> </div> <div> </div> <div>Renowned Excel expert Bill Jelen offers a complete tour of Excel in Office 365, from efficient interface customizations to advanced analysis, visualizations, and dashboards. Discover how experts tackle today's key tasks -- and challenge yourself to new levels of mastery. Topics include:</div> <div> </div> <div> <ul> <li>Customizing the Excel workspace</li> <li>Best practices for designing and managing worksheets</li> <li>Creating formulas and functions</li> <li>Performing statistical, what-if, and other data analysis</li> <li>Core to advanced charting techniques</li> <li>Using graphics and sparklines</li> <li>Managing databases and tables</li> <li>Automating Excel with macros and custom functions</li> <li>Collaborating in Excel online, in the cloud, and more</li> <li>Extending Excel</li> </ul> </div>

Microsoft Excel Inside Out (Office 2021 and Microsoft 365)

Microsoft Office Excel 2007 in Depth

Pearson/Education

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 Excel

Programming

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

Business & Money

Alexander, Michæl

Management & Leadership

Que Pub

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 clicks–all 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

Pivot Table Data Crunching for Microsoft Office Excel 2007

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 <ul>
<li> Implementing 1-Click Charting 
</li> <li> Incorporating Drag &amp; Drop and Dynamic Charts 
</li> <li> Creating Amazing Effects 
</li> <li> Using Charting Templates and Macros 
</li> <li> Mastering Glow, Shadow, Sparklines, Dashboards, and More 
</li> <li> Eliminating Chart Junk 
</li> <li> Structuring Spreadsheets with Business Diagrams, SmartArt Graphics, and Pivot Charts 
</li> <li> Develop your Charting expertise instantly with proven techniques 
</li> </ul>
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. <ul>
<li> Master effective visual display of data 
</li> <li> Choose the right chart type to convey your message 
</li> <li> Learn time-saving workarounds 
</li> <li> Create charts that most people think you can’t create with Excel 
</li> <li> Understand what a Radar chart is and when you might use it 
</li> <li> Summarize a million rows of data in a single pivot table chart 
</li> <li> Present data graphically without charts 
</li> <li> Employ SmartArt graphics to show process or relationship charts 
</li> <li> Utilize VBA to create charts 
</li> <li> Put your data on a map 
</li> <li> Export your charts to the web or PowerPoint 
</li> <li> Detect chart lies 
</li> </ul>
 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

Charts and Graphs for Microsoft Office Excel 2007

Special Edition Using Microsoft Office Excel 2007 will ease the upgrade path to the lastest version of Microsoft best-selling spreadsheet program. The author, "Mr. Excel " 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. Among other skills, you will learn how to create amazing data visualizations using conditional formatting and in-cell data bars. This is the only book you need on Microsoft Office Excel 2007! “ Excel 2007 is the biggest, most exciting release of Excel ever. This book’s straightforward approach explains the most important features of Excel 2007 in a thorough, easy-to-understand format. Further, it clearly compares older versions of Excel with Excel 2007, which makes for a seamless transition to this newest version of the program. It is a must-have desk reference for today’s business professional.” –David Gainer, Group Program Manager, Microsoft Excel THE ONLY EXCEL BOOK YOU NEED We crafted this book to grow with you, providing the reference material you need as you move toward Excel proficiency and use of more advanced features. If you buy only one book on Excel, Special Edition Using Microsoft® Office Excel® 2007 is the book you need. 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 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, Special Edition Using Microsoft® Office Excel® 2007 is the bookthat will make it all better. Learn quickly and efficientlyfrom a true Excel master using the tried and true SpecialEdition Using formula for success. Here, you’ll findinformation that’s undocumented elsewhere–even inMicrosoft’s own Help systems. You’ll learn from finelycrafted, real-life examples built by an author who livesand dies by the integrity of his spreadsheets. Excel’s backbone is its formulas and functions. Master those and you will master your spreadsheets. Special Edition Using Microsoft Office® Excel® 2007 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! CONTENTS Introduction I Mastering the New User Interface 1 Introducing the Ribbon User Interface . . . . . . . . . . . . . 21 2 The Quick Access Toolbar . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41 3 The Mini Toolbar and Other U.I. Improvements . . . 53 4 Keyboard Shortcuts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 65 5 Galleries, Live Preview, and Themes . . . . . . . . . . . . . . . . 87 6 The Excel Options Dialog . . . . . . . . . . . . . . . . . . . . . . . . . . 103 II A Tour of What’s New 7 The Big Grid . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 121 8 Fabulous Table Intelligence . . . . . . . . . . . . . . . . . . . . . . . . 131 9 Visualizing Data in Excel . . . . . . . . . . . . . . . . . . . . . . . . . . . . 153 10 Using Pivot Tables to Analyze Data . . . . . . . . . . . . . . . . 191 11 Formatting Pivot Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 215 12 Pivot Table Data Crunching for Excel 2007 . . . . . . . 237 13 Removing Duplicates and Filtering . . . . . . . . . . . . . . . . 271 14 Sorting Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 287 15 Using Excel Charts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 299 16 Using SmartArt, Shapes, WordArt, and Text Boxes . . 327 17 Using Pictures and Clip Art . . . . . . . . . . . . . . . . . . . . . . . . 351 III Working in a Legacy Environment 18 File Format Differences . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 365 19 Working with Prior Versions of Excel . . . . . . . . . . . . . . 371 IV Calculating with Excel 20 Understanding Formulas . . . . . . . . . . . . . . . . . . . . . . . . . . . 385 21 Controlling Formulas . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 409 22 Understanding Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . 431 23 Using Everyday Functions: Math, Date and Time, and Text Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 451 24 Using Powerful Functions: Logical, Lookup, and Database Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 525 25 Using Financial Functions . . . . . . . . . . . . . . . . . . . . . . . . . . 587 26 Using Statistical Functions . . . . . . . . . . . . . . . . . . . . . . . . . 631 27 Using Trig, Matrix, and Engineering Functions . . . . 735 28 Connecting Worksheets, Workbooks, and External Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 797 29 Using Super Formulas in Excel . . . . . . . . . . . . . . . . . . . . 823 30 Using Names in Excel . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 841 31 Using What If, Scenario Manager, Goal Seek, and Solver . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 863 V Formatting and Sharing Information 32 Formatting Worksheets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 891 33 Printing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 925 34 Sharing Workbooks with Others . . . . . . . . . . . . . . . . . . . 941 35 More Tips and Tricks for Excel 2007 . . . . . . . . . . . . . . 949 VI More Power 36 Automating Repetitive Functions Using VBA Macros . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 969 37 Interacting with Other Office Applications . . . . . . 1005 38 A Tour of the Best Add-Ins for Excel . . . . . . . . . . . . . 1019 Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1025

Special Edition Using Microsoft(R) Office Excel 2007

See the best price to sell, buy, or rent books by Jelen, Bill. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Books by Jelen, Bill