Excel 365 Advanced Topics: Leverage More Powerful Tools to Enhance Your Productivity

— —

Nathan George

Excel 365 Advanced Topics

Leverage More Powerful Tools to Enhance Your Productivity

Nathan George

$53.95 $46.22

Paperback

Not in-store but you can order this
How long will it take?

Availability Information

We source books from suppliers in Australia and overseas. For books we don't currently have in stock, the time it takes to get them from our suppliers can vary widely - from a few days to a few months - so we check each book with each supplier to determine the expected time it will take to be supplied to us.

We then advise you accordingly. If the time taken to get any book is too long for you, you can let us know and we will cancel or adjust your order, and refund as required.

To find out the anticipated arrival time for specific items prior to ordering, please contact us by phone or email:

Phone +61 2 9264 3111, or 1800 4 BOOKS (1800 4 26657) if outside Sydney:
option 1 Abbey's Bookshop (Crime, History, Science, Kids & more) • info@abbeys.com.au
option 2 Language Book Centre (ESL & Foreign Languages) • language@abbeys.com.au
option 3 Galaxy Bookshop (Sci-fi, Fantasy, Romance, Graphic Novels) • sf@galaxybooks.com.au

QTY:

English

GTech Publishing
01 March 2023

Spreadsheet software

Summary
Details

Gain expert Excel skills and easily perform complex tasks

Whether you have basic Excel skills or you're a power user, Excel 365 Advanced Topics is full of tips, techniques, and tools that will save you time and effort in performing challenging tasks in Excel. When building complicated spreadsheet solutions, using the right tool in Excel can increase the accuracy and efficiency of your work. This book does not only show you how to use specific features but also in what context those features need to be used.

Get real-world solutions for your data

Excel 365 Advanced Topics focuses on a selection of topics relevant to real-world productivity tasks you're likely to perform at home or at work requiring more than a basic knowledge of Excel. Even if you're an Excel power user, you'll find lots of ideas and tips in this book that will save you time and effort.

Includes tons of examples and readymade formulas that you can copy and use in your own worksheets. The downloadable practice files enable you to follow the book hands-on, which is the best way to learn.

This book covers Excel for Microsoft 365 (2023 update).

In this book, you'll learn how to:

Transform data in Excel using the Power Query Editor. Remove duplicate rows from a data list. Consolidate data from different worksheets or workbooks. Import and use data from external sources like Microsoft Access databases, CSV text files, and websites. Troubleshoot and fix formula errors with various tools. Use functions like IFS and SUMIFS to create simpler but more efficient conditional formulas in place of convoluted nested IF functions. Use modern dynamic array functions like TEXTBEFORE, TEXTAFTER, and TEXTSPLIT to manipulate text strings. Carry out financial calculations with functions like PV, FV, and NPV. Use Macros to automate Excel tasks. Analyze different data scenarios and create projections with What-If Analysis tools. Dynamically analyze large sets of data with Pivot Tables and Pivot Charts. Protect your workbook, worksheets, or specific cells in your worksheets from unauthorized or accidental changes.

By: Nathan George
Imprint: GTech Publishing
Country of Publication: United Kingdom
Dimensions: Height: 235mm, Width: 191mm, Spine: 16mm
Weight: 526g
ISBN: 9781915476098
ISBN 10: 1915476097
Pages: 304
Publication Date: 01 March 2023
Audience: General/trade , ELT Advanced
Format: Paperback
Publisher's Status: Active

PERHAPS A GIFT VOUCHER FOR MUM?: MOTHER'S DAY

Excel 365 Advanced Topics

Leverage More Powerful Tools to Enhance Your Productivity

Nathan George

$53.95 $46.22

Paperback

See Also

Contact Abbeys

Contact Galaxy

Contact Language

Contact Us

About ABBEY'S