Price: $24.99
(as of Jan 18, 2025 09:19:15 UTC – Details)
Important. This book is specifically written for Excel 365 for Windows. There is also an Excel 2021 and Excel 2019 version of this book.
Here are some of the reasons that you should choose this book to learn Excel 365:
It is up to date. New editions of our Excel 365 books are published when significant new features are added. This sixth edition was completely updated in January 2022.Absolutely anybody can learn Excel using this book. You will repeatedly hear the same criticism of most Excel books: “you have to already know Excel to understand the book”. This book is different. If you have no previous exposure to Excel 365, and your only computer skill is using a web browser, you’ll find it really easy to work through the lessons. Everything is concisely described in a way that absolutely any student, of any age or ability, can easily understand.It provides the fastest possible way to learn Excel. 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 a single day.It focuses upon skills used in the real world of business. This book makes it easy to master Excel to a standard that will greatly impress most employers because it doesn’t confuse by including skills that are not commonly used by most office workers. Click Amazon’s Look Inside feature to review the vast number of Excel skills you will master. By the end of the book, you’ll be able to very quickly create sophisticated worksheets like the one shown on the cover of the book (and the screen grabs if you scroll down this page).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 wayLearning success is guaranteed. For over fifteen years, Smart Method® courses have been used by colleges, universities, large corporations, government departments and the armed forces to train their employees. The book is ideal for teaching or self-learning because it has been constantly refined (during hundreds of classroom courses) by observing which skills students find difficult to understand and then developing simpler and better ways of explaining them.It is the book of choice for teachers. As well as catering for those wishing to learn Excel by self-study, Smart Method® books have long been the preferred choice for Excel teachers as they are designed to teach Excel and not as reference books. Books follow best-practice adult teaching methodology with clearly defined objectives for each learning session and an exercise to confirm skills transfer.
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.
From the Publisher
Here are just a few of the things you will learn with this book.
The Excel 365 Filled Map Chart shown above is very useful for showing geographical information by shading different areas based upon data.
This book will teach you to create filled map charts just like the one shown above in seconds.
The Data Insights feature is one of Excel 365’s killer features that will make users want to upgrade from Excel 2021. This book will show you how to use the new Data Insights feature to work faster and smarter with Excel 365.
The above Pivot Chart was created in two clicks and has spotted that two customers are purchasing far more than others.
Natural Language Queries are one of Excel 365’s most impressive features. You can ask questions about your data just by typing in a plain English query.
This book will teach you to leverage upon this amazing new feature to produce complex analysis results in seconds.
The Excel designers knew that a picture paints a thousand words. This book will enable you to bring your data alive with a mastery of all of Excel’s conditional formatting and sparkline features. Your data will never look the same again as you add data bars, color scales, icon sets and control when they appear with Excel’s sophisticated Rules Manager.
This book will teach you the correct, professional way to create formulas.
You’ll learn both the mouse method and keyboard method. You’ll master absolute, relative and mixed cell references (like the ones shown in the example above).
The Excel function library now has over 500 functions but most Excel users only master a handful of them.
This book will teach show you how to use Excel’s Formula AutoComplete feature to quickly add functions to your workbooks.
This book won’t just teach you chart basics. It will teach you absolutely everything there is to know about charts. You’ll create bar charts, pie charts, line charts and dual axis charts. You’ll master chart elements, chart filters, callouts, styles, axis, titles, plot area, callouts… and absolutlely every other Excel chart skill.
Excel now has extensive cloud computing features that you simply cannot ignore. You’ll learn to e-mail tiny links to your workbooks rather than use huge e-mail attachments. Excel now allows multiple users to work together on the same workbook via the Internet – wherever they are. The book dedicates an entire session to mastering cloud computing skills.
Flash Fill is an amazing Excel feature that most Excel users don’t understand. The concatenated names in the example above were automatically created by Flash Fill.
You’ll learn how to take Flash Fill to the max and to use Automatic, Manual and Multiple Example Flash Fills to solve common business problems.
Publisher : The Smart Method Ltd (January 18, 2022)
Language : English
Paperback : 387 pages
ISBN-10 : 1909253499
ISBN-13 : 978-1909253490
Item Weight : 1.96 pounds
Dimensions : 8.27 x 0.88 x 11.69 inches
Customers say
Customers find the book’s instructions clear and easy to follow, even for beginners. They appreciate the author’s superior explanations and teaching methods. The writing style is well-written and simple, making it an enjoyable read.
AI-generated from the text of customer reviews
