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:
Payments:
Shop with confidence
Seller information
- 98.8% 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
WORLD OF BOOKS LIMITED
Debbie Nicholl
Mulberry House
Woods Way
Goring-by-sea
West Sussex
BN12 4QY
United Kingdom
Value added tax number:
- DE 281042328
- EL 996857788
- ES N8267548I
- FR 27823676960
- GB 922696893
- IT 00185819992
Trade registration number:
- 06437594
I certify that all my selling activities will comply with all EU laws and regulations.
Seller assumes all responsibility for this listing.
eBay item number:393506749974
Postage and packaging
Item doesn't post to United States
Item location:
GB, United Kingdom
Posts 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
| Dispatch time |
|---|
| Will usually dispatch within 1 working 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/VAT for items dispatched to the following states:
| County | VAT rate |
|---|
Returns policy
| After receiving the item, cancel the purchase within | Return postage |
|---|---|
| 30 days | Buyer pays for return postage |
The buyer is responsible for return postage costs.
| Return policy details |
|---|
| Returns accepted |
Most Buy It Now purchases are protected by the Consumer Rights Directive, which allow you to cancel the purchase within seven working days from the day you receive the item. Find out more about your rights as a buyer and exceptions.
Payment details
Payment methods
Registered as a business seller
Seller Feedback (12,708,300)
3***o (828)- Feedback left by buyer.
Past month
Verified purchase
Arroved very quickly, well packaged, thankyou x
7***e (824)- Feedback left by buyer.
Past month
Verified purchase
Arrived quickly condition below average
0***h (209)- Feedback left by buyer.
Past month
Verified purchase
Amazing value & great service. I’ve used WOB many times, thanks again
More to explore:
- Comic Book & Manga Collectable Calendars,
- Non-Fiction Construction Fiction Books & 1900-1949 Publication Year,
- Non-Fiction Construction Fiction Books & 1950-1999 Publication Year,
- 2016 Publication Year Comics, Graphic Comic Books,
- Construction Adult Learning & University Books,
- Construction Non-Fiction Hardcover Books,
- Construction Adult Learning & University Books in English,
- Under 2 Years Fiction & Books,
- Mike Mignola Comics, Graphic Novels & TPBs,
- 1950-1999 Publication Year Paperbacks-Fiction Books