Excel 2016 Construction Kit #1

Editora:

Smart Method Enterprises Ltd

Código:

491_9781909253100

Vendido e entregue por Um Livro

Sinopse
Características

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 learnMost 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:<ul><li>Create a custom color set.</li><li>Use custom formats.</li><li>Use Spin Button and Check Box form controls.</li><li>Define named ranges and named cells.</li><li>Use the Name Manager to view, delete and edit range names.</li><li>Create a drop-down list using a list validation.</li><li>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. </li><li>Understa

Veja mais