Price: $29.99
(as of Mar 02, 2025 13:54:55 UTC – Details)
Important. This book is specifically written for Excel 365 for Windows. There is also an Excel 2021 and Excel 2019 version of this book.
Here are some of the reasons that you should choose this book to learn Excel 365 Expert Skills:
It is up to date. New editions of our Excel 365 books are published when significant new features are added. This sixth edition was completely updated in January 2022.It covers important new Excel 365 features. Excel 365 is constantly improving and some of the new features change best-practice for common data analysis tasks. This book will teach you to master Dynamic Arrays and use the new XLOOKUP, XMATCH, UNIQUE, FILTER, SORT, SORTBY, SEQUENCE and RANDARRAY dynamic array functions. You’ll also learn about spilled ranges, linked data types, custom data types, fuzzy logic and a host of other recently added features.It provides a thorough (and easy to understand) coverage of Power Pivot, Power Query and DAX. Excel 365 now bundles several OLAP related “Power” tools that could be regarded as separate applications. These new tools are comprehensively covered in three dedicated sessions at the end of the book rather than being jumbled up with regular Excel lessons.It teaches to true Expert level. This 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 feature.It provides the fastest possible way to master Expert skills. With single, self-contained lessons, this book caters for any self-learning or teaching period. Many learners have mastered Excel by setting aside just a few minutes each day to complete a single lesson. Others have worked through the entire book in two or three days.It won’t waste your time by teaching basic Excel 365 skills that you already know. This isn’t a beginner’s book. If you are an absolute beginner, you need our Excel 365 Essential Skills book. By assuming that you are already able to use Excel’s basic features, far more ground can be covered.It provides a thorough (and easy to understand) coverage of data modeling. This book will teach you the relational database and data modeling skills needed to create optimal Power Pivot Star Schema and Snowflake data models incorporating DAX measures. You’ll use 24 best-practice Power Pivot rules, ensuring excellence in your future real-world data model designs.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 its category. This provides you with the confidence that you are using a best-of-breed resource to learn Excel.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 Institute of Chartered Accountants, The Ministry of Defence, Keele University, HBOS, 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
The Data Insights feature is one of Excel 365’s killer features that will make users want to upgrade from Excel 2021.
The book will show you how to use the new Data Insights feature to work faster and smarter with Excel 365. The above Pivot Chart was created in two clicks and has spotted that two customers are purchasing far more than others.
Natural Language Queries are a new feature for the Jan 2022 sixth edition. This is one of Excel 365’s most impressive features. You can ask questions about your data just by typing in a plain English query.
The book will teach you to leverage upon this amazing new feature to produce complex analysis results in seconds.
Custom Data Types are a new feature for the Jan 2022 sixth edition. Excel now has the ability to create objects with multiple properties that you can use directly in your worksheets.
The book will teach you how to use custom data types to create the multi-lingual form shown above without using any formulas.
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.
The 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.
Fuzzy Logic gives Excel the ability to match data even when the match isn’t perfect.
The book will teach you to perform Fuzzy Logic using Jaccard similarity. All of the above mis-spellings were automatically matched perfectly. This feature could save you many hours of work when working with external data.
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.
Excel’s new Dynamic Arrays feature has changed best-practice for many common business problems.
The book will teach you all of the new Dynamic Array functions: XLOOKUP (the modern replacement for VOOKUP), XMATCH, UNIQUE, SORT, SORTBY, FILTER, RANDARRY and SEQUENCE. You’ll also learn to use Spilled Arrays.
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.
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 (February 7, 2022)
Language : English
Paperback : 655 pages
ISBN-10 : 1909253502
ISBN-13 : 978-1909253506
Item Weight : 3.75 pounds
Dimensions : 8.27 x 1.48 x 11.69 inches
