ebook img

Getting Familiar With Excel PDF

523 Pages·2007·10.44 MB·English
Save to my drive
Quick download
Download
Most books are stored in the elastic cloud where traffic is expensive. For this reason, we have a limit on daily download.

Preview Getting Familiar With Excel

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.

See more

The list of books you might like

Most books are stored in the elastic cloud where traffic is expensive. For this reason, we have a limit on daily download.