Learn Excel 365 Expert Skills with The Smart Method: Fifth Edition: updated for the Jan 2021 Semi-Annual version 2008
Language: English
Published by Smart Method Enterprises Ltd, 2021
- Softcover
- Used
Seller: World of Books Inc, Montgomery, IL, U.S.A.World of Books Inc
AbeBooks seller since March 23, 2026
Condition: Used - Good
£ 6.04
Quantity: 1 available
Add to basketItem description from seller
Excel 365 has taken Excel into a new era. Excel 365 is now massively more powerful than the older Excel 2019 version and supports dynamic arrays - a game-changing feature that changes best practice for many common data analysis tasks. Dynamic arrays are comprehensively covered in a comprehensive 54 page session.This book also covers Excel 365's new XLOOKUP function (the modern replacement for Excel 2019's old VLOOKUP function). You'll also find lessons that comprehensively cover the XMATCH, UNIQUE, FILTER, SORT, SORTBY, SEQUENCE and RANDARRAY dynamic array functions (none of which exist in Excel 2019). You'll also learn about spilled ranges, linked data types, fuzzy logic and a host of other Excel 365-only features.Here are some of the reasons that you should choose this book: It provides a thorough (and easy to understand) coverage of Power Pivot, Power Query, and DAX. Excel 365 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 covers the latest Excel 365 semi-annual version of Excel (Jan 2021). This is the only book that has a new edition published twice a year (to match each new Excel 365 version). This means that the screen grabs will exactly match what you see on your screen and that any new features are covered. It can be very frustrating to attempt to learn Excel 365 using an out-of-date book (and impossible to learn to use Excel 365 effectively using an Excel 2019 book). 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 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.…
Seller Inventory # CIN1909253480G
- Title
- Learn Excel 365 Expert Skills with The Smart Method: Fifth Edition: updated for the Jan 2021 Semi-Annual version 2008
- Author
- Mike Smart
- Publisher
- Smart Method Enterprises Ltd
- Publication year
- 2021
- Condition
- Good
- Binding
- Paperback
- Language
- English
- ISBN 10
- 1909253480
- ISBN 13
- 9781909253483
- Edition
- 5th or later Edition
THERE IS A NEWER EDITION OF THIS BOOK
A new Excel 365 current version is released every month and automatically updated on your computer. New editions of this book are published when significant new features are added.
- This book (the fifth edition) was written to support the Excel 365 - Jan 2021 version 2008.
- The sixth edition of this book supports the Excel 365 - Jan 2022 version 2201 and is in stock and available here on Amazon.
To find the sixth edition of this book search Amazon for:
Learn Excel 365 Essential Skills with The Smart Method: Sixth Edition
Unless you have a special need for the older version we recommend that you do not purchase this book but, instead, purchase the up-to-date version above.
This book is also available for Excel 2019 and Excel 2021.
Companies who have taken Smart Method courses include:
AOL Time Warner, The United States Army, Daimler Chrysler, Motorola, HSBC, Barclays, American Express, Allied Irish Banks, Imperial Tobacco, Volvo, The BBC, British Petroleum, The Foreign and Commonwealth Office, Unilever, The Institute of Chartered Accountants, The Ministry of Defence, Keele University, Deutsche Bank, HBOS, Transport For London, The Performing Rights Society, Scottish Power, The Office of the Parliamentary Ombudsman, BAE Systems, Marks & Spencer, Virgin, O2, BMW... and many, many others.
"Synopsis" may belong to another edition of this title.
World of Books Inc
Montgomery, IL, U.S.A.
AbeBooks seller since March 23, 2026
Shipping rates within U.S.A.
| Item | 4 to 12 business days | 3 to 6 business days |
|---|---|---|
| First item | £ 0.00 | £ 8.18 |
Payment methods
Store description
Founded in 2002, World of Books is a leading online destination for buying and selling both preloved and new books, committed to making sustainable reading accessible to all. With a mission to help people read more and waste less, World of Books offers a huge range of affordable, high-quality books — giving both new and preloved titles a second life. The company also operates World of Books – Sell Your Books, an easy-to-use platform that allows customers to trade in unwanted books for cash, helping to keep books in circulation while promoting sustainability. As a Certified B Corp, World of Books is driven by a vision to become the world’s largest and most sustainable dedicated online bookstore. The company measures its success through the positive environmental impact it creates, the value it provides to customers, and its ability to operate profitably while supporting its sustainable mission …
Specialty
Second Hand - All GenreSeller's business information
SBYB, Inc.
900 Knell Road
Montgomery, IL U.S.A. 60538
Right of withdrawal
If you are a consumer you can withdraw from the contract in accordance with the following. Consumer means any natural person who is acting for purposes which are outside his trade, business, craft or profession.
Information regarding the right of withdrawal
Statutory right to withdraw
You have the right to withdraw from this contract within 14 days without giving any reason.
The withdrawal period will expire after 14 days from the day on which you acquire, or a third party other than the carrier and indicated by you acquires, physical possession of the last good or the last lot or piece.
To exercise the right of withdrawal, electronically fill in and submit a clear statement on our website, under "My Purchases" in "My Account". We will communicate to you an acknowledgement of receipt of such a withdrawal on a durable medium (e.g. by e-mail) without delay.
To meet the withdrawal deadline, it is sufficient for you to send your communication concerning your exercise of the right of withdrawal before the withdrawal period has expired.
Effects of withdrawal
If you withdraw from this contract, we will reimburse to you all payments received from you, including the costs of delivery (except for the supplementary costs arising if you chose a type of delivery other than the least expensive type of standard delivery offered by us).
We may make a deduction from the reimbursement for loss in value of any goods supplied, if the loss is the result of unnecessary handling by you.
We will make the reimbursement without undue delay, and not later than 14 days after the day on which we are informed about your decision to withdraw from this contract.
We will make the reimbursement using the same means of payment as you used for the initial transaction, unless you have expressly agreed otherwise; in any event, you will not incur any fees as a result of such reimbursement.
We may withhold reimbursement until we have received the goods back, or you have supplied evidence of having sent back the goods, whichever is the earliest.
You shall send back the goods or hand them over to World of Books Inc, Montgomery, Illinois, U.S.A., without undue delay and in any event not later than 14 days from the day on which you communicate your withdrawal from this contract to us. The deadline is met if you send back the goods before the period of 14 days has expired. You will have to bear the direct cost of returning the goods. You are only liable for any diminished value of the goods resulting from the handling other than what is necessary to establish the nature, characteristics and functioning of the goods.
Exceptions to the right of withdrawal
The right of withdrawal does not apply to:
- The delivery of newspapers, journals or magazines with the exception of subscription contracts; and
- The supply of digital content which is not supplied on a tangible medium (e.g. on a CD or DVD) if you accepted when you placed your order that we could start to deliver it, and that you could not withdraw once delivery had started.