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
For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.
The primary goal of the GO! Series, aside from teaching computer applications, is ease of implementation, with an approach that is based on clearly defined projects.
Teaching and Learning Experience
This program will provide a better teaching and learning experience—for you and your students. Here’s how:Engage Students with a Project-Based Approach: GO!’s project-based approach teaches students to solve real problems as they practice and learn the features. Motivate Students with Clear Instruction: Based on professor and student feedback, this text has been designed to offer clear instruction for full student comprehension. Teach the Course You Want in Less Time: The GO! series’ one-of-a kind instructional system provides you with everything you need to prepare for class, teach the material, and assess your students.
NOTE: This is the standalone book, if you want the book/access code order the ISBN below;
ALERT: Before you purchase, check with your instructor or review your course syllabus to ensure that you select the correct ISBN. Several versions of Pearson's MyLab & Mastering products exist for each title, including customized versions for individual schools, and registrations are not transferable. In addition, you may need a CourseID, provided by your instructor, to register for and use Pearson's MyLab & Mastering products.
NOTE: Make sure to use the dashes shown on the Access Card Code when entering the code.
0133908755 / 9780133908756 GO! with Microsoft Excel 2013 Comprehensive & MyITLab with Pearson eText -- Access Card -- for GO! with Office 2013 Package *
Package consists of:
0133417336 / 9780133417333 GO! with Microsoft Excel 2013 Comprehensive
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.