BIBLIO is the largest independent book marketplace in the world, with over 100 million books.

Skip to content

Learn Excel 365 Expert Skills with The Smart Method: Fifth Edition: updated for
Stock photo: cover may vary

Learn Excel 365 Expert Skills with The Smart Method: Fifth Edition: updated for the Jan 2021 Semi-Annual version Paperback - 2021

by Mike Smart

Add to wish list

Reader reviews for Learn Excel 365 Expert Skills with The Smart Method: Fifth Edition: updated for the Jan 2021 Semi-Annual version

From the publisher

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.

Details

  • Title Learn Excel 365 Expert Skills with The Smart Method: Fifth Edition: updated for the Jan 2021 Semi-Annual version
  • Author Mike Smart
  • Binding Paperback
  • Pages 644
  • Volumes 1
  • Language ENG
  • Publisher Smart Method Ltd
  • Publication date 2021-01-14
  • ISBN 9781909253483 / 1909253480
  • Weight 3.35 lbs (1.52 kg)
  • Dimensions 11.69 x 8.27 x 1.3 in (29.69 x 21.01 x 3.30 cm)
  • Category Computers - Spreadsheets

More Copies for Sale

Learn Excel 365 Expert Skills with The Smart Method: Fifth Edition: updated for the Jan 2021...
Stock photo: cover may vary

Learn Excel 365 Expert Skills with The Smart Method: Fifth Edition: updated for the Jan 2021 Semi-Annual version 2008

by Smart, Mike

  • Used
  • Good
  • Paperback
Condition
Good
Binding
Paperback
ISBN 10 / ISBN 13
9781909253483 / 1909253480
Quantity available
1
Seller
Item price
A$10.28
Free Delivery to USA

Show details

Description:
The Smart Method Ltd, 2021-01-14. paperback. Good. 8x1x11.
Add to wish list
Item price
A$10.28
Free Delivery to USA
Learn Excel 365 Expert Skills with The Smart Method: Fifth Edition: updated for the Jan 2021...
Stock photo: cover may vary

Learn Excel 365 Expert Skills with The Smart Method: Fifth Edition: updated for the Jan 2021 Semi-Annual version

by Smart, Mike

  • Used
  • Good
  • Paperback
Condition
Good
Binding
Paperback
ISBN 10 / ISBN 13
9781909253483 / 1909253480
Quantity available
1
Seller
Item price
A$10.35
Free Delivery to USA

Show details

Description:
Smart Method Ltd, 2021. Paperback. Good. Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, Spend Less.Dust jacket quality is not guaranteed.
Add to wish list
Item price
A$10.35
Free Delivery to USA
Learn Excel 365 Expert Skills with The Smart Method: Fifth Edition: updated for the Jan 2021...

Learn Excel 365 Expert Skills with The Smart Method: Fifth Edition: updated for the Jan 2021 Semi-Annual version 2008

by Smart, Mike

  • Used
  • Very good
  • Paperback
Condition
Very good
Binding
Paperback
ISBN 10 / ISBN 13
9781909253483 / 1909253480
Quantity available
1
Seller
Item price
A$40.98
A$16.53 Delivery to USA

Show details

Description:
Paperback. Very Good.
Add to wish list
Item price
A$40.98
A$16.53 Delivery to USA
Learn Excel 365 Expert Skills with The Smart Method: Fifth Edition: updated for the Jan 2021...

Learn Excel 365 Expert Skills with The Smart Method: Fifth Edition: updated for the Jan 2021 Semi-Annual version

by Mike Smart

  • New
  • Paperback
Condition
New
Binding
Paperback
ISBN 10 / ISBN 13
9781909253483 / 1909253480
Quantity available
533
Seller
Item price
A$68.70
A$15.42 Delivery to USA

Show details

Description:
Paperback. New. New Book; Fast Shipping from UK; Not signed; Not First Edition; <p>Excel 365 has taken Excel into a new era. Excel 365 is now massively more powerful than the older Excel 2019 version and supports <strong>dynamic arrays</strong> - a game-changing feature that changes best practice
Add to wish list
Item price
A$68.70
A$15.42 Delivery to USA
Learn Excel 365 Expert Skills with The Smart Method: Fifth Edition: updated for the Jan 2021...
Stock photo: cover may vary

Learn Excel 365 Expert Skills with The Smart Method: Fifth Edition: updated for the Jan 2021 Semi-Annual version 2008

by Mike Smart

  • New
  • Paperback
Condition
New
Binding
Paperback
ISBN 10 / ISBN 13
9781909253483 / 1909253480
Quantity available
10
Seller
Item price
A$72.35
A$19.20 Delivery to USA

Show details

Description:
Paperback / softback. New.
Add to wish list
Item price
A$72.35
A$19.20 Delivery to USA
Learn Excel 365 Expert Skills with The Smart Method: Fifth Edition: updated for the Jan 2021...
Stock photo: cover may vary

Learn Excel 365 Expert Skills with The Smart Method: Fifth Edition: updated for the Jan 2021 Semi-Annual version 2008

by Smart, Mike

  • New
Condition
New
ISBN 10 / ISBN 13
9781909253483 / 1909253480
Quantity available
5
Seller
Item price
A$57.19
A$5.82 Delivery to USA

Show details

Description:
new.
Add to wish list
Item price
A$57.19
A$5.82 Delivery to USA
Learn Excel 365 Expert Skills with The Smart Method: Fifth Edition: updated for the Jan 2021...
Stock photo: cover may vary

Learn Excel 365 Expert Skills with The Smart Method: Fifth Edition: updated for the Jan 2021 Semi-Annual version 2008

by Smart, Mike

  • Used
Condition
New
ISBN 10 / ISBN 13
9781909253483 / 1909253480
Quantity available
5
Seller
Item price
A$57.19
A$5.82 Delivery to USA

Show details

Description:
like new.
Add to wish list
Item price
A$57.19
A$5.82 Delivery to USA
Learn Excel 365 Expert Skills with The Smart Method: Fifth Edition: updated for the Jan 2021...
Stock photo: cover may vary

Learn Excel 365 Expert Skills with The Smart Method: Fifth Edition: updated for the Jan 2021 Semi-Annual version 2008

by Smart, Mike

  • Used
  • Good
  • Paperback
Condition
Good
Binding
Paperback
ISBN 10 / ISBN 13
9781909253483 / 1909253480
Quantity available
1
Seller
Item price
A$59.19
Free Delivery to USA

Show details

Description:
paperback. Good. Access codes and supplements are not guaranteed with used items. May be an ex-library book.
Add to wish list
Item price
A$59.19
Free Delivery to USA