We specialize in hard to find items
All Categories
Learn Excel 365 Expert Skills with The Smart Method: Fifth Edition: updated for the Jan 2021 Semi-Annual version 2008
Share Tweet
*Price and Stocks may change without prior notice
*Packaging of actual item may differ from photo shown
- Electrical items MAY be 110 volts.
- 7 Day Return Policy
- All products are genuine and original
About Learn Excel 365 Expert Skills With The Smart
Important. This book is specifically written for Excel 365 for Windows. If you are an Excel 2021 user you need the Excel 2021 version of this book. There are many differences between the Windows and Apple Mac Excel versions. We don’t recommend that you learn Excel using an Apple Mac version. 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 fifth edition was completely updated in January 2021. 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, 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. This book is also available for Excel 2021 and Excel 2019. 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.
