%{search_type} search results

• Front Cover; Copyright Page; Table of Contents; Dedication; About the Author; Acknowledgments; Foreword; Quick Start; Part 1
• Excel Environment; Part 2
• Calculating with Excel; Part 3
• Wrangling Data; Part 4
• Making Things Look Good; Afterword; Index; Also Available; Seminars; Back Cover.

Updating the previous edition's tips to make them compatible with Excel 2007, and featuring new tips that are only available in Excel 2007, 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 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 with new and quicker ways to use formulas and spreadsheets.

In diesem praktischen Leitfaden erfahren Sie, wie Sie mithilfe von VBA und Makros nahezu jede Excel-Routineaufgabe automatisieren und zuverlässigere und effizientere Excel-Arbeitsblätter erstellen, um in kürzerer Zeit mehr Aufgaben zu erledigen. Die renommierten Excel-Experten Bill Jelen (MrExcel) und Tracy Syrstad zeigen Ihnen nützliche Makrotechniken und helfen Ihnen dabei, automatisierte, leistungsfähige Berichte zu erstellen und Informationen sofort zu visualisieren, um schnell damit weiterarbeiten zu können. Erfassen und verwenden Sie Daten überall, egal ob am Desktop-Computer, am Tablet oder in der Cloud, und automatisieren Sie die besten neuen Features von Excel 2019 und Excel für Office 365.

Renowned Excel experts Bill Jelen (MrExcel) and Tracy Syrstad help you automate Excel tasks to get more done, faster than ever. 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 wont 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. Youll find simple, step-by-step instructions, real-world case studies, and 50 workbooks packed with examples and complete, easy-to-adapt solutions.

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 powerincluding 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: 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 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.

• Intro
• About the Author
• Acknowledgments
• Introduction
• What Will the Headlines Say About Dynamic Array Formulas?
• This Book Is Not the Comprehensive Guide to Dynamic Arrays
• Dynamic Array Formulas and Their Offspring Are Office 365 Exclusive
• How This Book Is Organized
• Download the Sample Files
• 1
• Getting Started
• Formulas Can Now Spill
• What Happens if A Formula can't spill?
• If Your Formula Points to a Table, the Array Will Expand
• What Is Really Happening Behind the Scenes?
• Using the New Array Reference Notation: E3#
• What About Implicit Intersection?

• 2
• The SORT Function
• A Simple Sort with One Argument
• Sorting with a Single Argument
• A Sort Based on Two or More Columns of Results
• Sort by Column
• A Random Sort Using SORT and RANDARRAY
• What's Left for Ctrl+Shift+Enter?
• 3
• The SORTBY Function
• A Sort by Something That Is Not in the Results
• Performing a Multi-Column Sort without Array Constants
• 4
• The FILTER Function
• Using The FILTER Function With One Condition
• Using FILTER with Multiple Conditions
• 5
• The UNIQUE Function
• Syntax of the UNIQUE Function
• Understanding Unique Versus Distinct

• 6
• Combining Functions
• Nesting Array Functions: SORT and UNIQUE
• Nesting Array Functions: SORT, UNIQUE, and FILTER
• 7
• The SEQUENCE Function
• Generating a Range of Sequential Numbers
• Using SEQUENCE Inside Another Function
• 8
• The RANDARRAY Function
• Generating an Array of Random Numbers with RANDARRAY
• Using RANDARRAY for Modeling and Simulation
• 9
• Why CSE Arrays Were So Hard: Implicit Intersection
• Why CSE Formulas Were So Hard
• A Quick Glossary
• Legacy Excel Used Arrays Far More Often Than We Realized
• Understanding Implicit Intersection

• Breaking Implicit Intersection
• Lifting When a Scalar Is Expected but an Array Is Provided
• Understanding Array Truncation
• Using a Wrapper Function in Legacy Excel
• Preventing Implicit Intersection with Ctrl+Shift+Enter
• From Lifting to Pairwise Lifting
• Broadcasting Makes All Arrays the Same Size
• A Simple Broadcasting Example
• How Do Lifting, Broadcasting, Array Truncation, and Implicit Intersection Affect Dynamic Arrays?
• Why Did Excel Add an Implicit Intersection Operator?
• Answers to the Questions at the Start of this Chapter
• 10- XLOOKUP and Dynamic Arrays

• XLOOKUP is First New Function After Dynamic Arrays
• Returning 12 Columns of VLOOKUP
• Returning 12 Months with MATCH and Several INDEX
• Returning 12 Columns of XLOOKUP without Dynamic Arrays
• Returning 12 Months with one XLOOKUP
• Dynamic Arrays Bug: Copying the Formula
• A Two-Way Lookup with INDEX & MATCH
• A Two-Way Lookup with XLOOKUP
• 11
• Other Functions That Are Now Dynamic Arrays
• Using TODAY and SEQUENCE for a Calendar
• NOW and SEQUENCE
• Generating Sequential Letters with CHAR, SEQUENCE, and TEXTJOIN
• Returning the N Largest Items Using LARGE

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

• Intro
• About the Author
• Dedication
• Acknowledgments
• Foreword
• Why Does Office 365 Have Better Features?
• Should I Buy Office 2019 or Subscribe to Office 365?
• How Can I Use Excel on Dual Monitors?
• How Can I Open The Same Workbook Twice?
• Find Icons on the Ribbon
• Where is File, Exit?
• Where Are My Macros?
• Collapse the Search Box
• Customizing the Ribbon
• Go Wide
• Minimize the Ribbon to Free Up a Few More Rows
• Use a Wheel Mouse to Scroll Through The Ribbon Tabs
• Why Do The Charting Ribbon Tabs Keep Disappearing?
• Use Dialog Launchers For More Choices

• Icon, Dropdowns, and Hybrids
• Zoom is at the Bottom
• Make Your Most-Used Icons Always Visible
• The Excel 2003 Alt Keystrokes Still Work (If You Type Them Slowly Enough)
• Use Keyboard Shortcuts to Access the Ribbon
• Why Do I Have Only 65,536 Rows?
• Which File Format Should I Use?
• Why Does The File Menu Cover The Entire Screen?
• How Do I Close The File Menu?
• Increase the Number of Workbooks in the Recent Files List
• Change All Print Settings in Excel
• I Just Want The Old Print Preview Back
• Get Quick Access to Formatting Options Using the Mini Toolbar

• What Is Protected Mode?
• Use a Trusted Location to Prevent Excel's Constant Warnings
• My Manager Wants Me to Create a New Expense Report from Scratch
• Open a Copy of a Workbook
• Open Excel with Ctrl+Alt+X
• Have Excel Always Open Certain Workbook(s)
• Set up Excel Icons to Open a Specific File on Startup
• Use a Macro to Customize Startup
• Control Settings for Every New Workbook and Worksheet
• Excel Says I Have Links, But I Can Not Find Them
• Automatically Move the Cell Pointer After Enter
• Return to the First Column After Typing the Last Column

• How to See Headings as You Scroll Around a Report
• How to See Headings and Row Labels as You Scroll Around a Report
• Why is the Scrollbar Slider Suddenly Tiny?
• Why Won't My Scrollbar Scroll to My Charts?
• Jump to the Edge of the Data
• Ctrl+Click to Unselect Cells
• Jump to Next Corner of Selection
• Ctrl+Backspace brings the Active Cell into View
• Zoom with the Wheel Mouse
• Copy a Formula to All Data Rows
• Copy the Characters from a Cell ­Instead of Copying an Entire Cell
• A Faster Way To Paste Values
• Quickly Turn a Range on Its Side
• Quickly Rearrange Rows Or Columns

• Quickly Copy Worksheets
• Use Group Mode to Change All Worksheets
• Find Text Numbers
• Why Can't Excel Find a Number?
• Mix Formatting In A Single Cell
• Enter a Series of Months, Days, or More by Using the Fill Handle
• Have the Fill Handle Fill Your List of Part Numbers
• Teach Excel to Fill A, B, C
• Add Total to the End of Jan, Feb ... Dec
• Put Date & Time in a Cell
• Use Excel as a Word Processor
• Add Excel to Word
• Use Hyperlinks to Create an Opening Menu for a Workbook
• Spell check a Region
• Stop Excel from AutoCorrecting Certain Words

Updating the previous edition's tips to include features in Office 365 and Excel 2019, 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 up users, leaving readers with not only answers to their specific dilemmas but also new and quicker ways to use formulas and spreadsheets.

• Intro; About the Author; Why Have a Book on Subtotals; Preparing Your Data and Adding Subtotals; How to Set up Your Data for Subtotals; How to Fit a Multiline Heading into One Cell; No Tiny Blank Columns Between Columns; How to Sort Data; Sort Days of the Week; Sort a Report into a Custom Sequence; Add Subtotals to a Data set; Subtotal Tricks & Techniques; Use Group & Outline Buttons to Collapse Subtotaled Data; Manually Apply Groups; Group Report Sections; Subtotals Above Each Group; Copy Just Totals from Subtotaled Data; Sort Largest Customers to the Top; Format the Subtotal Rows.

• Add Other Text to the Subtotal LinesSubtotal One Column and Count Another Column; Subtotal by Month With Daily Dates; Subtotals by Product Within Region; Add a Page Break For each Group; My Manager Wants a Blank Line After Each Subtotal; Add a Calculation Only to the Subtotal Rows; Shift Subtotals One Column to the Right; Finding G/L Accounts Not in Balance; Why Is Final Subtotal Row Appearing After Many Blank Rows?; Enter a Grand Total of Data Manually Subtotaled; Why Does Subtotal Dialog Sometimes Default to Count?; Adding Subtotals to Dozens of Columns; Can You Get Medians?

• Horizontal SubtotalsSubtotals Don't Work with Tables; Using the SUBTOTAL function without Invoking the Command; Adding a Total Visible Below a Filtered Data Set; Using 109 For Rows Manually Hidden; The 9 Basic Arguments; The 9 New Arguments; SUMIF or COUNTIF of Filtered Data; Introducing AGGREGATE; New Arguments for What to Ignore; New Arguments for AggregatE Function Number; Some Functions Require a Fourth Argument in AGGREGATE; How is SMALL or LARGE Different From MIN or MAX?; Doing MINIFS or MAXIFS Before They Existed; Using VBA with Subtotals; Creating Subtotals Using VBA.

• VBA & TEXTJOIN to Subtotal Dozens of ColumnsReplacing Subtotals With Power Query; Using Power Query to Get #2 View of Subtotals; Index.

• Intro
• Title Page
• Copyright Page
• Dedication Page
• Contents at a Glance
• Table of Contents
• About the Author
• Introduction
• Who This Book Is For
• How This Book Is Organized
• About the Companion Content
• Acknowledgments
• Support and Feedback
• Part I The Excel Interface
• Chapter 1 What's New in Excel 2019
• Office 365 Is the Future
• Forward-Looking Features in Excel 2019
• Power Query Is Still the Best New Feature in Excel 2019
• Co-Authoring Allows Multiple People to Edit the Same Workbook at the Same Time
• Improvements to PivotTables

• New Calculation Functions in Excel 2019
• Two New Charts in 2019
• Inserting Icons and 3D Models
• Using the Inking Tools in Excel 2019
• Suggesting Ideas to the Excel Team
• Accessibility Improvements Across Office
• Changes to the Ribbon and Home Screen
• Collecting Survey Data in Excel Using Office 365
• Future Features Coming to Office 365
• Dynamic Array Functions in Office 365
• Chapter 2 Using the Excel Interface
• Using the Ribbon
• Using the Quick Access Toolbar
• Using the Full-Screen File Menu
• Using the New Sheet Icon to Add Worksheets

• Navigating Through Many Worksheets Using the Controls in the Lower Left
• Using the Mini Toolbar to Format Selected Text
• Expanding the Formula Bar
• Zooming In and Out on a Worksheet
• Using the Status Bar to Add Numbers
• Switching Between Normal View, Page Break Preview, and Page Layout View Modes
• Chapter 3 Customizing Excel
• Performing a Simple Ribbon Modification
• Adding a New Ribbon Tab
• Sharing Customizations with Others
• Questions About Ribbon Customization
• Using the Excel Options Dialog Box
• Options to Consider
• Five Excel Oddities
• Chapter 4 Keyboard Shortcuts

• Using Keyboard Accelerators
• Using the Shortcut Keys
• Using My Favorite Shortcut Keys
• Using Excel 2003 Keyboard Accelerators
• Part II Calculating with Excel
• Chapter 5 Understanding Formulas
• Getting the Most from This Chapter
• Introduction to Formulas
• Entering Your First Formula
• Three Methods of Entering Formulas
• Entering the Same Formula in Many Cells
• Use the Table Tool to Copy a Formula
• Chapter 6 Controlling Formulas
• Formula Operators
• Understanding Error Messages in Formulas
• Using Formulas to Join Text
• Copying Versus Cutting a Formula

• Automatically Formatting Formula Cells
• Using Date Math
• Troubleshooting Formulas
• Chapter 7 Understanding Functions
• Working with Functions
• Getting Help with Excel Functions
• Using AutoSum
• Chapter 8 Using Everyday Functions: Math, Date and Time, and Text Functions
• Math Functions
• Date and Time Functions
• Text Functions
• Examples of Math Functions
• Examples of Date and Time Functions
• Examples of Text Functions
• Chapter 9 Using Powerful Functions: Logical, Lookup, and Database Functions
• Examples of Logical Functions
• Examples of Information Functions

Dive into Microsoft Excel 2019-and really put your spreadsheet expertise to work. This supremely organised reference packs hundreds of timesaving solutions, tips, and workarounds-all you need to make the most of Excel's most powerful tools for analysing data and making better decisions. Renowned Excel expert Bill Jelen offers a complete tour of Excel 2019 and Excel in Office 365, from efficient interface customisations to advanced analysis, visualisations, and dashboards. Discover how experts tackle today's key tasks-and challenge yourself to new levels of mastery. Enter formulas more efficien.

• Intro; Dedication; About the Author; About the Contributors; Foreword; Introduction;
• Part 1: The Top 54 Tips; #1 Double-Click the Fill Handle to Copy a Formula; #2 Break Apart Data; #3 Filter by Selection; Bonus Tip: Total the Visible Rows; #4 The Fill Handle Does Know 1, 2, 3a Bonus Tip: Fill Jan, Feb ..., Dec, Total; Bonus Tip: Fill 1 to 100,000 in a Flash; #5 Fast Worksheet Copy; Bonus Tip: Put the Worksheet Name in a Cell; Bonus Tip: Add a Total Row and a Total Column with One AutoSum; Bonus Tip: Power Up the Status Bar Statistics.

• Bonus Tip: Create a SUM That Spears Through All WorksheetsBonus Tip: Use INDIRECT for a Different Summary Report; #6 Use Default Settings for All Future Workbooks; Bonus Tip: Understand that Changes are Cumulative; Bonus Tip: Replace the Comma Style in Book.xltx; #7 Recover Unsaved Workbooks; #8 Create Perfect One-Click Charts; #9 Paste New Data on a Chart; Bonus Tip: Create Interactive Charts; Bonus Tip: Show Two Different Orders of Magnitude on a Chart; #10 New in Excel
• 2016: Create Waterfall Charts and More; Bonus Tip: Create Funnel Charts in Office 365.

• Bonus Tip: Create Filled Map Charts in Office 365#11 Add Meaning to Reports Using Data Visualizations; #12 Sort East, Central, and West Using a Custom List; #13 Sort Left to Right; Bonus: Another Way to Move Columns; #14 Sort Subtotals; Bonus Tip: Fill in a Text Field on the Subtotal Rows; Bonus Tip: Format the Subtotal Rows; Bonus Tip: Copy the Subtotal Rows; #15 Sort and Filter by Color or Icon; #16 Consolidate Quarterly Worksheets; #17 Create a Year-over-Year Report in a Pivot Table; Bonus Tip: Change the Calculation in a Pivot Table; #18 Find the True Top Five in a Pivot Table.

• #19 Specify Defaults for All Future Pivot TablesBonus Tip: Change What Drives You Crazy About Excel; Bonus Tip: Make Pivot Tables Expandable Using Ctrl+T; Bonus Tip: Use Ctrl+T with VLOOKUP and Charts; #20 Replicate a Pivot Report for Each Rep; #21 Use a Pivot Table to Compare Lists; Bonus Tip: Show Up/Down Markers; Bonus Tip: Compare Two Lists by Using Go To Special; #22 Build Dashboards with Sparklines and Slicers; Bonus Tip: Make Your Workbook into a Web App; Bonus Tip: Line Up Dashboard Sections with Different Column Widths; Bonus Tip: Use Picture Lookup.

• #23 See Why GETPIVOTDATA Might Not Be Entirely Evil#24 Eliminate VLOOKUP with the Data Model; Bonus Tip: Count Distinct; #25 Compare Budget Versus Actual via Power Pivot; Bonus Tip: Portable Formulas; #26 Use F4 for Absolute Reference or Repeating Commands; Bonus Tip: Use a Named Range Instead of Absolute References; #27 Quickly Convert Formulas to Values; Bonus Tip: Skip Blanks While Pasting; #28 See All Formulas at Once; Bonus Tip: Highlight All Formula Cells; Bonus Tip: Trace Precedents to See What Cells Flow into a Formula; Bonus Tip: See Which Cells Depend on the Current Cell.

• Cover; Title Page; Credits; Table of Contents; About the Author; Dedication; Foreword; Acknowledgments; Why Does Office 365 Have Better Features?; Which Version of Office 365 Has Power Pivot?; Why Do I Have to Sign in to Excel?; How Can I Use Excel on Dual Monitors?; How Can I Open The Same Workbook Twice?; Find Icons on the Ribbon; Where is File, Exit?; Where Are My Macros?; Customizing the Ribbon; Go Wide; Minimize the Ribbon to Free Up a Few More Rows; Use a Wheel Mouse to Scroll Through The Ribbon Tabs; Why Do The Charting Ribbon Tabs Keep Disappearing?

• Use Dialog Launchers For More ChoicesIcon, Dropdowns, and Hybrids; Zoom is at the Bottom; Make Your Most-Used Icons Always Visible; The Excel 2003 Alt Keystrokes Still Work (If You Type Them Slowly Enough); Use Keyboard Shortcuts to Access the Ribbon; Why Do I Have Only 65,536 Rows?; Which File Format Should I Use?; Why Does The File Menu Cover The Entire Screen?; How Do I Close The File Menu?; Increase the Number of Workbooks in the Recent Files List; Change All Print Settings in Excel; I Just Want The Old Print Preview Back; Get Quick Access to Formatting Options Using the Mini Toolbar.

• What Is Protected Mode?Use a Trusted Location to Prevent Excel's Constant Warnings; My Manager Wants Me to Create a New Expense Report from Scratch; Open a Copy of a Workbook; Open Excel with Ctrl+Alt+X; Have Excel Always Open Certain Workbook(s); Set up Excel Icons to Open a Specific File on Startup; Use a Macro to Customize Startup; Control Settings for Every New Workbook and Worksheet; Excel Says I Have Links, But I Can Not Find Them; Automatically Move the Cell Pointer After Enter; Return to the First Column After Typing the Last Column; Enter Data in a Circle (Or Any Pattern).

• How to See Headings as You Scroll Around a ReportHow to See Headings and Row Labels as You Scroll Around a Report; Why is the Scrollbar Slider Suddenly Tiny?; Why Won't My Scrollbar Scroll to My Charts?; Jump to the Edge of the Data; Jump to Next Corner of Selection; Ctrl+Backspace brings the Active Cell into View; Zoom with the Wheel Mouse; Copy a Formula to All Data Rows; Copy the Characters from a Cell ƯInstead of Copying an Entire Cell; A Faster Way To Paste Values; Quickly Turn a Range on Its Side; Quickly Rearrange Rows Or Columns; Quickly Copy Worksheets.

• Use Group Mode to Change All WorksheetsFind Text Numbers; Why Can't Excel Find a Number?; Mix Formatting In A Single Cell; Enter a Series of Months, Days, or More by Using the Fill Handle; Have the Fill Handle Fill Your List of Part Numbers; Teach Excel to Fill A, B, C; Add Total to the End of Jan, Feb ... Dec; Put Date & Time in a Cell; Use Excel as a Word Processor; Add Excel to Word; Use Hyperlinks to Create an Opening Menu for a Workbook; Spell check a Region; Stop Excel from AutoCorrecting Certain Words; Use AutoCorrect to Enable a Shortcut.

• Pivot table fundamentals
• Creating a basic pivot table
• Customizing a pivot table
• Grouping, sorting and filtering pivot data
• Performing calculations in pivot tables
• Using pivot charts and other visualizations
• Analyzing disparate data sources with pivot tables
• Sharing pivot tables with others
• Working with and analyzing OLAP data
• Mashing up data with power pivot
• Dashboarding with Power view and 3D map
• Enhancing pivot tables with macros
• Using VBA to create pivot tables
• Advanced pivot table tips and techniques
• Dr. Jekyll and Mr. GetPivotData.

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.
(source: Nielsen Book Data)

• Introduction
• Pivot table fundamentals
• Creating a basic pivot table
• Customizing a pivot table
• Controlling the way you view your pivottable
• Performing calculations within your pivot tables
• Using pivot charts and other visualizations
• Analyzing disparate data sources with pivottables
• Sharing pivottables with others
• Working with and analyzing olap data
• Mashing up data with powerpivot
• Powerview
• Enhancing pivottables with macros
• Using VBA to create pivot tables
• Advanced pivottable tips and tricks
• Dr. Jekyll and Mr. GetPivotData
• Index.

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 .
(source: Nielsen Book Data)

SAVE TIME AND SUPERCHARGE EXCEL 2013 WITH VBA AND MACROS! Use Excel (R) 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 .
(source: Nielsen Book Data)

"Explore the most popular and some of the lesser known features of Excel: PivotTables, PowerPivot, Power View, and GeoFlow with MrExcel as your guide! Start-to-finish personal training on Excel 2013: just watch and learn! Simple, quick video walkthroughs of the tasks you perform most often! Great personalized training at a fraction of the cost ... for everyone who doesn't have time to read a book! These video lessons will ensure that you can harness the power of Excel faster and more easily than ever before! In 89 quick video lessons, Excel PivotTables, PowerPivot, Power View, and GeoFlow with MrExcel shows how to increase your productivity and optimize Excel's best tools and features. Expert Bill Jelen simplifies powerful features including formatting, calculations, sort & filter, DAX calculated fields, troubleshooting, animation and more! Truly harness the power built into Excel! Just watch: You'll master high-powered skills at your own pace--and get specific answers and solutions immediately, whenever you need them! For anyone who wants to master Microsoft Excel 2013 fast--from novices to experienced power users."--Resource description page.

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!