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

Microsoft Excel Pivot Table Data Crunching Including Dynamic Arrays, Power Query, and Copilot (Business Skills)

Microsoft Press

Microsoft Excel VBA and Macros: Your Guide to Efficient Automation (Business Skills)

Syrstad, Tracy

<p>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:<br />
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<br />
• For everyone who wants to get more done with Microsoft Excel in less time<br />
• For business and financial professionals, entrepreneurs, students, and others who need to efficiently manage and analyze data</p>

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

Children's Books

Literature & Fiction

<p><p>Renowned Excel expert Bill Jelen (MrExcel) helps you crunch data from any source with Excel pivot tables.</p> <p>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.</p> <p>By reading this book, you will:</p> <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></p>

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

<p><div><b>Conquer Microsoft Excel -- from the inside out!</b></div> <div><br /></div> <div><br /></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><br /></div> <div><br /></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><br /></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></p>

Microsoft Excel Inside Out (Office 2021 and Microsoft 365)

<p>This book takes a deep-dive into the current domain of Indian politics and pre-empts the course the young republic will take in decades to come. In its format, the authors interview many prominent young and dynamic politicians in India-below the age of 50-from across the country and the vast<br /> political parties' spectrum. The exercise taps into their brand of politics; local, national, and global concerns; challenges and goals, as well as the political future each of them imagines for their constituencies and the country. The interviews include those from Priyanka Gandhi, Rahul Gandhi,<br /> Akhilesh Yadav, Omar Abdullah, Aditya Thakeray etc.<br /></p>

<p>Geopolitics is a slippery term. From great power politics and speculation about resource scrambles, to everyday encounters and objects such as smart phones, it affects citizens, corporations, international bodies, social movements, and governments. Geopolitics is far more than simply the impact of geographical features such as rivers, mountains, and climate on political developments. Geography matters but not necessarily in the way that pundits and presidents assume. <br><br>In this Very Short Introduction, Klaus Dodds tours the field of geopolitics, encompassing both its intellectual historical origins and its current concerns. As people struggle to cross borders, moving a few feet either side of a territorial boundary can be a matter of life or death, dramatically highlighting the connections between place and politics. Even far away from the front lines of states, geopolitics remains an important part of everyday life. A country's connectivity, location, size, and resources all affect how the people that live there understand and interact with the wider world. In this third edition Dodds includes new sections considering the rise of populism and economic nationalism as examples of how states, people, and corporations manage territorial frames for political projects such as Make America Great Again, One Belt, One Road, and Brexit. <br><br>ABOUT THE SERIES: The Very Short Introductions series from Oxford University Press contains hundreds of titles in almost every subject area. These pocket-sized books are the perfect way to get ahead in a new subject quickly. Our expert authors combine facts, analysis, perspective, new ideas, and enthusiasm to make interesting and challenging topics highly readable.<br></p>

Microsoft Office Excel 2007 in Depth

Pearson/Education

<p>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, <i>VBA and Macros for Microsoft Excel</i> 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!</p>

VBA and Macros for Microsoft Excel

Programming

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

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.

Power Excel 2003 with MrExcel LiveLessons (Video Training)

Microsoft Excel Pivot Table Data Crunching Including Dynamic Arrays, Power Query, and Copilot (Business Skills)

Microsoft Excel VBA and Macros: Your Guide to Efficient Automation (Business Skills)

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

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

Microsoft Excel Inside Out (Office 2021 and Microsoft 365)

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

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

Microsoft Office Excel 2007 in Depth

VBA and Macros for Microsoft Excel