Please note: In order to keep Hive up to date and provide users with the best features, we are no longer able to fully support Internet Explorer. The site is still available to you, however some sections of the site may appear broken. We would encourage you to move to a more modern browser like Firefox, Edge or Chrome in order to experience the site fully.

Supporting your high street Find out how »
Learn Excel 365 Expert Skills with The Smart Method : Fourth Edition: updated for the Jul 2020 Semi-Annual version 2002, Paperback / softback Book

Learn Excel 365 Expert Skills with The Smart Method : Fourth Edition: updated for the Jul 2020 Semi-Annual version 2002 Paperback / softback

Paperback / softback

Item not Available

Description

<p>The new <em>Excel 365 July 2020 semi-annual release</em> is a landmark version that takes Excel into a new era. Excel 365 is now massively more powerful than the older Excel 2019 version and this book includes comprehensive coverage of all the new Excel 365 only features.</p><p>The new release introduces <strong>dynamic arrays</strong> - a game-changing feature that changes best practice for many common data analysis tasks. Dynamic arrays are comprehensively covered in a new 54 page session within this new 4th edition.</p><p>The 4th edition also comprehensively covers the new <strong>XLOOKUP</strong> function (the modern replacement for Excel 2019&#39;s old VLOOKUP function).&nbsp; Also new for this 4th edition is coverage for the new <strong>XMATCH, UNIQUE, FILTER, SORT, SORTBY, SEQUENCE</strong> and <strong>RANDARRAY </strong>dynamic array functions (none of these exist in Excel 2019). In this book you&#39;ll also learn about <strong>spilled ranges, linked data types, fuzzy logic </strong>and a host of other Excel 365-only features.</p><p>Here are some of the reasons that you should choose this book: </p><ul><li><b>It provides a thorough (and easy to understand) coverage of&nbsp; Power Pivot, Power Query, and DAX</b>. Excel 365 now includes <em>Power Pivot</em>. Unlike most other books, this book will teach you the relational database and data modeling skills needed to create optimal Power Pivot <em>Star Schema</em> data models incorporating DAX measures.&nbsp; You&#39;ll conform to 24 best-practice Power Pivot rules, ensuring excellence in your future real-world data model designs.</li><li><b>It covers the latest Excel 365 semi-annual version of Excel (Jul 2020).</b> This is the <em><strong>only</strong></em> book that has a new edition published twice a year (to match the new Excel 365 version).&nbsp; This means that the screen grabs will exactly match what you see on your screen and that any new features are covered.&nbsp; 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).&nbsp; </li><li><b>It won&#39;t waste your time by teaching basic Excel 365 skills that you already know.</b> This isn&#39;t a beginner&#39;s book. If you are an absolute beginner, you need our <em>Excel 365 Essential Skills</em> book. By assuming that you are already able to use Excel&#39;s basic features, far more ground can be covered.</li><li><b>It teaches to true Expert level. </b>This <em>Expert Skills </em>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. </li></ul>

Information

£24.99

Item not Available
Item not Available
Sign in to add to wishlist
 
Free Home Delivery

on all orders

 
Pick up orders

from local bookshops

Information