Price: $19.99 - $13.00
(as of Dec 06, 2024 21:04:30 UTC – Details)
This book is also available for Excel 2021 and Excel 365. Here are some of the reasons that you should choose this book to learn Excel 2019 for Windows:
It provides a thorough (and easy to understand) coverage of Power Pivot, Power Query, and DAX. Excel 2019 now includes Power Pivot. Unlike most other books, this book will teach you the relational database and data modeling skills needed to create optimal Power Pivot Star Schema data models incorporating DAX measures. You’ll conform to 24 best-practice Power Pivot rules, ensuring excellence in your future real-world data model designs.It won’t waste your time by teaching basic Excel 2019 skills that you already know.This isn’t a beginner’s book. If you are an absolute beginner, you need our Excel 2019 Essential Skills book. By assuming that you are already able to use Excel’s basic features, far more ground can be covered.It teaches to true Expert level. This Expert Skills book teaches Excel to an extremely high level of competence that is very rarely found in the workplace (even amongst top professionals). At Expert level your skills will be greater and broader than almost all other Excel users and you will understand (and be able to effectively use) absolutely every Excel and Power Pivot feature. You’ll have a complete mastery of skills that are often even a mystery to Excel power users.Learning success is guaranteed. For over fifteen years, Smart Method courses have been used by large corporations, government departments and the armed forces to train their employees. The book is ideal for teaching or self-learning because it has been constantly refined (during hundreds of classroom courses) by observing which skills students find difficult to understand and then developing simpler and better ways of explaining them. This has made the book effective for students of all ages and abilities.Smart Method® books are #1 best sellers.Every paper printed Smart Method Excel book (and there have been thirty-four of them starting with Excel 2007) has been an Amazon #1 best seller in it’s category. This provides you with the confidence that you are using a best-of-breed resource to learn Excel.It is the book of choice for teachers.As well as catering for those wishing to learn Excel by self-study, Smart Method books have long been the preferred choice for Excel teachers as they are designed to teach Excel and not as reference books. Books follow best-practice adult teaching methodology with clearly defined objectives for each learning session and an exercise to confirm skills transfer.It is written in plain English. Advanced concepts are explained without needless technical jargon. Everything is concisely described in a simple, no-nonsense way.
Companies who have taken Smart Method courses include:
The United States Army, Daimler Chrysler, Motorola, HSBC, Barclays, American Express, Allied Irish Banks, Imperial Tobacco, Volvo, BMW, Time Warner, Virgin, Pokerstars, Unilever, Deutsche Bank, The BBC, British Petroleum, The Foreign and Commonwealth Office, The Institute of Chartered Accountants, The Ministry of Defence, Keele University, HBOS, Transport For London, Scottish Power, BAE Systems, RBS, The British Museum, The National Gallery, Marks & Spencer, O2… and many, many others.
From the Publisher
Here are just a few of the things you will learn with this book
It is often said that the ability to fully understand Pivot Tables separates competent Excel users from Excel novices. The above grab shows two pivot tables and two slicers combined into a dashboard. The book will teach you absolutely everything there is to know about Pivot Tables. including slicers, calculated fields, calculated items, grouping, filter fields and multiple summations.
The core idea behind Power Maps (also known as 3D Maps) is to show visualizations of Excel data upon the surface of a map but this doesn’t begin to describe the huge feature set of this powerful Excel tool.
The book covers Power Maps in depth and that includes geocoding, data cards, multiple layers, annotations, scenes and fly-pasts. You’ll even create a HD video as you fly over your data.
The above form was created in a few minutes using Excel’s simple-to-use Form Controls.
This book will teach you how to add Option Buttons, Check Boxes, Combo Boxes, Spin Buttons, Buttons and many other controls. Once added they are really easy to bring to life. The screen grab above shows a Mortgage Calculator that you’ll create in one of the book’s sessions.
Excel Names make cell references easy to read in formulas. In the above example the formula =Sales-Cost leaves no room for error.
The book will teach you all there is to know about names and that includes single-cell names, range names, two-dimensional range names, dynamic formula-based names and named constants.
Excel Experts don’t use old-fashioned A1 style references when referencing dynamic data. They use tables and modern structured table references.
The book will teach you the professional way to work with tables and structured references and not ranges and A1 style references.
Excel only supports a million rows, but when Excel teams with Power Pivot, Excel can analyse billions of rows of data in the blink of an eye using a Power Pivot Data Model.
The book will teach you to create the special Star Schema data models required by Excel using Power Query and Power Pivot. This new way of working is often called Modern Data Analysis.
This isn’t an ordinary Excel pivot table – it’s an Excel Power Pivot Table (also called an OLAP Pivot Table). You can see that it can analyse multiple related tables.
The book will teach you how to prepare the relational data models needed to work with Power Pivot tables. You’ll then have the power to work faster and smarter than ever before.
Excel can directly access the aggregated data that resides within a Power Pivot data model using the CUBEVALUE function.
This book will teach you how to automatically and instantly create CUBEVALUE functions with their associated MDX queries so that you can access aggregations within a Power Pivot data model directly from an Excel worksheet.
DAX functions are very different to Excel functions but you’ll find many that are named just like their Excel counterparts.
The book will teach you important DAX concepts including calculated columns, calculated measures, implicit measures, explicit measures, row and filter context and the DISTINCOUNT , CALCULATE and ALL functions.
Publisher : The Smart Method Ltd (December 14, 2018)
Language : English
Paperback : 558 pages
ISBN-10 : 1909253359
ISBN-13 : 978-1909253353
Item Weight : 3.17 pounds
Dimensions : 8.27 x 1.26 x 11.69 inches
