Learn Excel 2016 Essential Skills with the Smart Method

Learn Excel 2016 Essential Skills with the Smart Method
Author :
Publisher :
Total Pages : 160
Release :
ISBN-13 : 1909253103
ISBN-10 : 9781909253100
Rating : 4/5 (00 Downloads)

Book Synopsis Learn Excel 2016 Essential Skills with the Smart Method by : Mike Smart

Download or read book Learn Excel 2016 Essential Skills with the Smart Method written by Mike Smart and published by . This book was released on 2018-01-17 with total page 160 pages. Available in PDF, EPUB and Kindle. Book excerpt: This book is suitable for both Excel beginners and seasoned experts. In this Excel 2016 book you'll learn how to use and apply advanced Excel skills to construct a robust Excel business application that would be well beyond the powers of most advanced Excel users. Even if you only have very basic Excel skills, the book is designed in such a way that you'll be able to construct a complex, polished professional Excel 2016 application. In constructing this project you'll discover new and interesting ways to use many of Excel 2016's more powerful and complex features. This book will teach you best-practice when applying your Excel skills to large real-world projects. This book won't only teach you Excel skills. You'll also learn a best-practice design and development methodology that will stand you in good stead when working on future Excel projects. What you will learn Most Excel tutorials and reference books teach how to use individual Excel features but don't show how you can combine them into a robust and complex Excel application. In this book you will combine 80 key Excel skills to produce a single advanced Excel application. Here are just a few of the skills you'll use: Create a custom color set. Use custom formats. Use Spin Button and Check Box form controls. Define named ranges and named cells. Use the Name Manager to view, delete and edit range names. Create a drop-down list using a list validation. Use and understand the practical use of over 20 Excel functions including VLOOKUP, COUNTIF, DAY, MONTH, DATE, IFERROR, CHAR, IF, IFERROR, LEN, MOD, ROW, TEXT and WEEKDAY. Understand date serial numbers. Understand precedence rules. Format date serial numbers using a custom format. Create a formula-driven conditional format. Use the conditional format Rules Manager. Calculate the correct date (in any year) for Martin Luther King Day, President's Day, Labor Day, Columbus Day, Thanksgiving Day, New Year's Day, Independence Day, Christmas Day and Veterans Day, Easter Sunday and Memorial Day. Use structured table references. Concatenate text. Calculate the phases of the moon using Synodic Months and the MOD function. Create user-friendly validation error messages. Use Smart Tags. Lock cells, hide columns, hide entire worksheets and protect worksheets to prevent users from making unwanted changes. 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, The British Museum, The National Gallery, Pokerstars, Marks & Spencer, Virgin, O2, BMW... and many, many others.


Learn Excel 2016 Essential Skills with the Smart Method Related Books

Learn Excel 2013 Expert Skills with the Smart Method
Language: en
Pages: 0
Authors: Mike Smart
Categories: Business
Type: BOOK - Published: 2014-04 - Publisher: Smart Method Limited

DOWNLOAD EBOOK

This book is very, very different to any other computer book you have ever read. The Smart Method provides an entirely new and better way to learn Excel. You'll
Learn Excel 2016 Essential Skills with the Smart Method
Language: en
Pages: 160
Authors: Mike Smart
Categories: Computers
Type: BOOK - Published: 2018-01-17 - Publisher:

DOWNLOAD EBOOK

This book is suitable for both Excel beginners and seasoned experts. In this Excel 2016 book you'll learn how to use and apply advanced Excel skills to construc
Learn Excel 2013 Essential Skills with the Smart Method
Language: en
Pages: 0
Authors: Mike Smart
Categories: Electronic spreadsheets
Type: BOOK - Published: 2013-12 - Publisher:

DOWNLOAD EBOOK

This book is very, very different to any other computer book you have ever read. The Smart Method provides an entirely new and better way to learn Excel. You'll
Microsoft Excel 2010 Inside Out
Language: en
Pages: 1711
Authors: Craig Stinson
Categories: Computers
Type: BOOK - Published: 2010-08-31 - Publisher: Pearson Education

DOWNLOAD EBOOK

You're beyond the basics, so dive in and really put your spreadsheet skills to work! This supremely organized reference is packed with hundreds of timesaving so
Data Smart
Language: en
Pages: 432
Authors: John W. Foreman
Categories: Business & Economics
Type: BOOK - Published: 2013-10-31 - Publisher: John Wiley & Sons

DOWNLOAD EBOOK

Data Science gets thrown around in the press like it'smagic. Major retailers are predicting everything from when theircustomers are pregnant to when they want a