Excel 2013/2016: Get Your Hands Dirty - Softcover

Akrasi, Sam

Softcover

ISBN 10: 154340751X ISBN 13: 9781543407518

Publisher: Xlibris Corporation, 2019

Synopsis

This book is not for beginners. It does not teach you how to move around worksheets; neither does it teach you how to copy the contents of one cell to the other. The book assumes that you have worked with Excel for at least six months. We start by introducing you to the Ribbon and how to customize the user interface. You learn how to automate worksheet operations with macros. We take you through creating custom formats, data validation, worksheet outlines, data consolidation, error checking, etc. We look at intermediate and advanced functions such as Indirect, Match, Find, etc. and show you how to combine these functions to solve real-world problems. We discuss business models and apply statistical and financial functions. The rest of the topics we treat include using table formulas, creating range names, using names for formulas, Date and Time functions, error checking, workbook/worksheet protection, etc. We look at the Lookup functions (Vlookup, Hlookup, etc.) and the functions that can be used in lieu of the lookup functions to perform more complex lookups. Every chapter of the book contains exercises to reinforce your learning experience. We believe that practice makes perfect, so at the end of the book, we provide you with over 120 hands-on exercises (step-by-step answers provided). We guarantee that after going through all the exercises in the book, you will be on your way to becoming an Excel expert.

Edition details

• Publisher: Xlibris Corporation
• Publication date: 2019
• Language: English
• ISBN 10: 154340751X
• ISBN 13: 9781543407518
• Binding: Paperback
• Number of pages: 202