Picture 1 of 2
Excel 2016 Construction Kit #1: Calendar and Year Planner by Smart, Mike Book
8M+ feedback. Millions of books, dvds & more in stock!
Last item available
Condition:
Last One / 1 sold
Postage:
Located in: GB, United Kingdom
Delivery:
Varies
Returns:
Coverage:
Read item description or contact seller for details. See all detailsSee all details on coverage
(Not eligible for eBay purchase protection programmes)
Seller information
- 98.7% positive feedback
Registered as a Business Seller
Seller assumes all responsibility for this listing.
eBay item number:393506749974
Item specifics
- Condition
- Title
- Excel 2016 Construction Kit #1: Calendar and Year Planner
- Book Title
- Excel 2016 Construction Kit #1: Calendar and Year Planner
- ISBN
- 1909253103
- EAN
- 9781909253100
- Binding
- Paperback / softback
- Date of Publication
- 20180117
- Release Title
- Excel 2016 Construction Kit #1: Calendar and Year Planner
- Artist
- Smart, Mike
- Brand
- N/A
- Colour
- N/A
- Publication Year
- 2018
- Type
- Textbook
- Format
- Paperback
- Language
- English
- Publication Name
- Excel 2016 Construction Kit #1: Calendar and Year Planner
- Item Height
- 297mm
- Publisher
- T.H.E. Smart Method LTD
- Item Width
- 210mm
- Subject
- Computer Science
- Number of Pages
- 158 Pages
About this product
Product Information
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.
Product Identifiers
Publisher
T.H.E. Smart Method LTD
ISBN-13
9781909253100
eBay Product ID (ePID)
20046560966
Product Key Features
Publication Name
Excel 2016 Construction Kit #1: Calendar and Year Planner
Format
Paperback
Language
English
Subject
Computer Science
Publication Year
2018
Type
Textbook
Number of Pages
158 Pages
Dimensions
Item Height
297mm
Item Width
210mm
Additional Product Features
Country/Region of Manufacture
United Kingdom
Item description from the seller
Business seller information
Value Added Tax Number:
- DE 281042328
- EL 996857788
- ES N8267548I
- FR 27823676960
- GB 922696893
- IT 00185819992
Seller assumes all responsibility for this listing.
eBay item number:393506749974
Postage and handling
Item does not ship to United States
Item location:
GB, United Kingdom
Post to:
Belgium, Bosnia and Herzegovina, Brazil, Canada, Chile, Czech Republic, Denmark, Estonia, Finland, France, Georgia, Greece, Hong Kong, Hungary, Iceland, India, Ireland, Israel, Italy, Japan, Jordan, Kuwait, Latvia, Liechtenstein, Lithuania, Luxembourg, Malaysia, Maldives, Malta, Montenegro, Morocco, Netherlands, New Zealand, Norway, Peru, Poland, Portugal, Republic of Croatia, Rwanda, Singapore, Slovakia, Slovenia, South Korea, Spain, Sri Lanka, Sweden, Thailand, Worldwide
Excludes:
Afghanistan, Australia, Austria, Germany, Libya, Nauru, Russian Federation, Somalia, Switzerland, Ukraine, United States, Yemen
Handling time |
---|
Will usually ship within 1 business day of receiving cleared payment. |
Taxes |
---|
Taxes may be applicable at checkout. Learn moreLearn more about paying tax on eBay purchases. |
Sales Tax for an item #393506749974
Sales Tax for an item #393506749974
Seller collects sales tax for items shipped to the following states:
State | Sales Tax Rate |
---|
Return policy
After receiving the item, contact seller within |
---|
30 days after the buyer receives it |
The buyer is responsible for return postage costs.
Seller feedback (12,780,232)
d***h (658)- Feedback left by buyer.
Past month
Verified purchase
Very happy with the item thank you 😊
i***w (3254)- Feedback left by buyer.
Past month
Verified purchase
Superb
e***5 (19)- Feedback left by buyer.
Past month
Verified purchase
Good reliable service