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 willDramatically 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
Dive into Microsoft Excel 2019–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. Renowned Excel expert Bill Jelen offers a complete tour of Excel 2019 and 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.
Enter formulas more efficiently, and fully control operators and dates Master the most widely-used functions in Excel Integrate external data from the web and other sources Easily transform complex datasets with Power Query Quickly summarize millions of records with Pivot Tables Perform ad hoc analyses with slicers and other filters Create advanced data mashups with Power Pivot Solve complex problems with What-If, Scenario Manager, Goal Seek, and Solver Automate repetitive tasks by editing recorded VBA code Demystify data with conditional formatting and other visualization techniques Use the newest maps, charts, and data types in Excel Show geographical changes over time with animated 3D maps Use dynamic array functions: SORT, FILTER, UNIQUE, SORTBY and SEQUENCE Find insights using Excel’s new artificial intelligence Collaborate via Excel 2019’s breakthrough CoAuthoring tools Publish Power BI Desktop dashboards based on Excel data
Excel 2019 in easy steps starts with the basics and then reveals the key clever features on offer – all in easy steps! Areas covered include:
· Creating, editing and manipulating worksheets
· Formulas, Functions, Tables, and importing data
· Handy templates to give you a head start
· Macros for everyday tasks to save time
· Charts to get an overview of your data
· What-if, Goal Seek and Optimization
· Using the Excel Online app to share and collaborate on spreadsheets and workbooks
· Adding images and illustrations to your spreadsheet to impress your colleagues!
This primer illustrates how to use Excel to manage your finance and data effectively and easily – both at home and at work. Whether you’re upgrading to Excel 2019 or new to spreadsheets, use this guide to get more out of Microsoft Excel!
Table of Contents:
2. Begin with Excel
3. Manage Data
4. Formulas and Functions
5. Excel Tables
6. Advanced Functions
7. Control Excel
9. Macros in Excel
10. Templates and Scenarios
11. Links and Connections
You’re beyond the basics, so dive right in and really put Excel formulas and functions to work! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and workarounds. It’s all muscle and no fluff. Discover how the experts increase their data analysis capabilities using Excel 2003, 2007, or 2010—and challenge yourself to new levels of mastery.Customize Excel formulas using 350+ built-in functions Create reusable formulas for common calculations Learn smarter ways to calculate date and time values Systematically search worksheets with lookup and reference functions Perform advanced calculations using mathematical, statistical, and financial functions Build complex formulas by nesting one function inside of another Analyze profit margins and more with new functions in Excel 2010 Develop your own functions with Visual Basic for Applications (VBA) NOTE: The sample Excel files that accompany the book were updated on 12/4/2012. Click the Companion Content link to download the files.
Use Microsoft’s free PowerPivot add-in for Excel 2010 to analyze immense amounts of data from any source, perform state-of-the-art business analysis far more easily, and make better decisions in less time!
Simple, step-by-step instructions walk you through installing PowerPivot, importing data, using PivotTables with PowerPivot, using super-powerful DAX functions and measures, reporting to print or SharePoint, and a whole lot more.
Whatever your Excel data analysis experience, this book will help you use PowerPivot to get the right answers, right now—without IT’s help!Import and integrate data from spreadsheets, SQL Server, Access, Oracle, text files, Atom data feeds, and other sources Analyze multiple tables together, without complicated VLOOKUPs Format, sort, and filter data in the PowerPivot window Add calculated columns using new DAX functions Create powerful reports from PowerPivot data—and format them so executives instantly get your point Discover PivotTable tricks that work even better in PowerPivot Control multiple PivotTable elements on one worksheet, with one set of Excel 2010 Slicers Use DAX Measures to quickly perform tasks that were difficult or impossible with Calculated Fields Compare today’s sales to yesterday’s–or to sales from the parallel period last fiscal year. Use Named Sets to prepare asymmetric reports, show actuals for past months and plan for future months.
Full Color: Figures and code appear as they do in Excel 2016
Beyond the Basics…Beneath the Surface...In Depth
Do more in less time!
Experienced with Excel? Don’t let Excel 2016 make you feel like a beginner again! This new full-color edition of the bestselling book has been completely overhauled. Gone is unnecessary and rarely used content; emphasis is on the most-used and new aspects of Excel 2016. The result is a focused book where every topic is relevant and worth learning. Excel 2016 In Depth is the fastest, smartest way to master Excel 2016’s full power and updated interface. You’ll discover how to leverage Excel’s new tools for charting, business analysis, data visualization, forecasting, and more.
• Quickly clean your data with Excel 2016’s powerful Get & Transform tools
• Discover Excel 2016’s newest charts: waterfall, histogram, Pareto, sunburst, TreeMap, and Box and Whisker
• Use Forecast Sheets to forecast the future, including seasonal adjustments
• Pivot data on maps with 3D Maps, and animate your maps over time
• Create formulas, charts, subtotals, and pivot tables faster than ever
• Create amazing PowerPivot data mashups that integrate information from anywhere
• Automate repetitive functions using Excel macros
• Solve real-world business intelligence analysis problems
• Use PowerPivot Data Model to create pivot tables from multiple data sets without VLOOKUP
• Share workbooks on the Web and social networks
• Leverage Excel to create highly interactive web pages and online surveys
• Quickly apply attractive, consistent formats
This book is part of Que’s Content Update Program. As Microsoft updates features of Excel, sections of this book will be updated or new sections will be added to match the updates to the software. See inside for details.