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

• This book (the second edition) was written to support the Excel 365 - July 2019 version 1902.
• The fourth edition of this book supports the Excel 365 - Jul 2020 version 2002 and is in stock and available from all major online booksellers.

To find the third edition of this book search for:

Learn Excel 365 Expert Skills with The Smart Method: Fourth Edition (ISBN: 978-1-909253-46-9 )

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.

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.

• Smart Method(R) books are #1 best sellers. Every paper printed Smart Method Excel book (and there have been ten 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 way
• Instruction is logically structured into sessions and lessons. With single, self-contained lessons, this book caters for any self-learning or teaching period. Many learners have learned 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.
• Learning success is guaranteed. For over fifteen years, Smart Method courses have been used by 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. This has made the book effective for students of all ages and abilities.
• 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.

You will repeatedly hear the same criticism of most Excel 2019 books: "you have to already know Excel to understand the book". This book is different. If you have no previous exposure to Excel 2019, and your only computer skill is using a web browser, you'll have absolutely no problems working through the lessons. Everything is concisely described in a way that absolutely any student, of any age or ability, can easily understand.

Excel 2019 is a huge application with thousands of features. It could take years of study to master every one of them (and only a tiny number of Excel users ever have). This Essential Skills book makes it easy for absolutely anybody to very rapidly learn Excel 2019 to a standard that will greatly impress most employers because it doesn't confuse by attempting to teach advanced skills that are not common in the workplace.

Our Excel 2019 Expert Skills book comprehensively teaches the rarer Excel skills that less than 10% of Excel users typically master (and many office workers will not have a need for).

• The book will equip you with excellent Excel 2019 for Mac skills, good enough to impress any employer, but it doesn't confuse by attempting to teach skills that are not common in the workplace. Only users who have advanced requirements need progress to the Excel 2019 for Mac Expert Skills book.
• Every lesson is presented on two facing sheets of A4 paper (the pages are much bigger than in any other Excel book). You can complete each self-contained lesson in a few minutes.
• Each lesson has a sample file that models a real-world business problem.
• The teaching method used in the book was developed and refined using over ten years of experience teaching real students Excel skills in classroom courses. The teaching method is fun, absorbing and virtually 100% effective.
• Instruction is logically structured into sessions and lessons. While this makes the book ideal for self-instruction, you can also use it to run your own, highly effective, adult training courses. This has made Smart Method books a popular choice for schools, colleges and universities all over the world.

You'll immediately appreciate the value and relevance of each skill as it is taught. Both IT professionals and absolute beginners will love this book because it avoids needless technical jargon and concisely explains everything you need in a simple and no-nonsense way.

What you will learn

Amongst other things you'll learn how to:

• Create stunning, professional, presentation-quality charts
• Use the new Excel 2019 for Mac Cloud Computing features to share data
• Understand absolute, relative and mixed cell references
• Use the Themes feature to create visually excellent worksheets
• Use Sparklines to visually represent large data sets
• Bring your data alive with Visualizations
• Create custom conditional formatting rules with the Rules Manager
• Create your own formulas with the Formula AutoComplete feature
• Master Excel 2019 for Mac's Fluent User Interface and Ribbon
• Understand the different Excel 2019 for Mac file formats
• Add a professional sheen to your work with 3-D Elements
• Understand and work with three-dimensional worksheet groups

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, RBS, Marks & Spencer, Virgin, O2, BMW... and many, many others.