Getting Familiar With Excel

523 Pages·2007·10.44 MB·English

by  The Excel Master Guidebook Series.

DISCLAIMER
Copyright © The Excel Master Guidebook Series

All Rights Reserved
The entire rights of the content found in this eBook are reserved with the publisher. The
replication or republication of any part of this book in any form, or by any mean,
electronic, mechanical, photocopied, recorded, scanned or otherwise, is strictly prohibited
without getting the consent from the author of the book. Any such action that comes to the
notice of publisher is punishable by law.
Notes to the Reader:
The author of the book does not contradict any other information found about the subject
of this book on any other source. This eBook is solely for educational purposes and should
be taken as such. The author takes no responsibility for any misappropriation of the
contents stated in this eBook and thus cannot be held liable for any damages incurred
because of it.
While the author of this book has made utmost efforts to obtain updated and accurate
information contained herein, the author or the publisher of the book cannot be held liable
for any damage or loss caused by the content of this book. The author of the book does not
warranty the accuracy of the contents and disclaim all warranties with respect to the
information contained herein, its accuracy and applications.
The advice presented in this book may not be suitable for everyone. This book is not a
substitute for professional advice and should not be taken as such. Neither the author nor
the publisher of this book is engaged in rendering professional services. If expert
assistance and guidance is needed, then professional help should be sought.
INTRODUCTION
fficially released in January 2013, the latest version of Excel 2013 took the
market by its amazingly easy-to-user interface and incredibly advanced features.
O
It is no longer a simple spreadsheet calculator. Microsoft Excel has evolved into
a full-fledged software that can be applied to any aspect of life, let it be academic,
personal or business.
So what do you intend to use Excel for? To maintain your shopping list? Or perhaps some
office work like financial analysis, statistics, payroll, billing etcetera? Well, Excel is not
just limited to these basic functions. It is a lot more than what you think it is.
Excel allows you to make user forms, generate and sort through unending data lists, create
interactive charts and graphs and much more. There is no limit to what Excel can do. And
whatever the limitations were in the previous versions have now been removed in Excel
2013.
Excel 2013 is a marvel. You will be amazed to learn what wonders it can do. However
none of the Excel features will provide you any benefit if you don’t know how to use it.
Excel 2013 is definitely miraculous but it does not perform miracles on its own. You need
to make a few clicks to make the miracles happen. This is where this book intervenes. It
tells you all there is to know, in the easiest way possible about this enigmatic software.
But before you move on to find out what this book contains, you need to know if this book
is for you.
Is This Book for You?
The Excel Master Guidebook Series offers a detailed walkthrough on all the basic as well
as the advanced features of Excel 2013. It is designed for all types of users. Whether you
are a beginner, intermediate or advanced user, this book has something to offer to all.
It serves as an excellent guide for users who are new to Excel and are trying it
for the first time. It contains everything that a beginner needs to know.
If you have a little know-how of Excel, this book will teach you the advanced
usage of Excel 2013 and ways to adapt it to your own needs.
The books contains numerous advanced techniques and exclusive tips that will
make the advanced users explore Excel all over again. The examples presented in
this book are surely going to make your experience of Excel more exhilarating than
ever.
How This Book Is Organized?
The Excel Master Guidebook Series consist of seven books, each containing several
chapters. Following is a brief description of each part to give you an idea of what the
books contain.
Book I: Getting Familiar with Excel 2013
This part introduces you to the new and advanced features of Excel 2013. The second
chapter of this part sheds light on the basic layout and procedures of Excel. You will also
find some handy and exciting tips on customizing your Excel and making it more
powerful.
Book II: The Basics Explained
This book contains walkthroughs and tips on the basic applications of Excel 2013. You
will learn how to work on a workbook, protect your worksheets, formatting techniques,
working with templates, printing worksheets and much more!
Book III: Formulas and Functions
This book talks about the most popular and valuable feature of Excel; that is, the formulas
and functions. From the basics of entering formulas, to simple mathematical functions,
array formulas and advanced statistical functions, this book covers all you need to know to
excel at Excel’s formulas. The last chapter of this book gives you some real handy tips on
making an error free worksheet.
Book IV: Chart and Graphics
This book covers extensively the colorful charting and other exciting pictorial features of
Excel. You will discover some exclusive tricks on using Excel’s graphical tools and
Sparkline graphics.
Book V: Data Management and Analysis
This book introduces you to the powerful data analysis tools of Excel. You will learn to
work with the handy What-If Analysis tool, the extensive data lists in Excel, the valuable
Pivot Table and much more!
Book VI: Working With Macros and VBA Programming
This book introduces you to the Excel’s amazing macro recorder. We have talked in detail
about the recorder’s mechanism and applications. You will also learn how to keep your
important and frequently needed macros at hand, so that you can use them easily and
quickly. This book also talks about the basic and common applications of the official
programming language of excel, Visual Basic for Applications. You will learn how to use
the Visual Basic editor to create and edit macros. The second chapter in this part tells you
about a very exciting and handy feature of VBA; that is, its ability to let you create user
defined functions in Excel.
Book VII: Shortcuts & Function List
This book contains an extensive list of keyboard shortcuts to perform different tasks in
Excel. There is also a list of all the functions built-in Excel 2013.