Part of the Microsoft Office 2013 suite of programs, Microsoft Excel 2013 is a full-featured
spreadsheet program that helps you quickly and efficiently develop dynamic, professional
workbooks to summarize and present your data. Microsoft Excel 2013 Step by Step offers a
comprehensive look at the features of Excel that most people will use most frequently.
Who this book is for
Microsoft Excel 2013 Step by Step and other books in the Step by Step series are designed for
beginning-level to intermediate-level computer users. Examples shown in the book gener-
ally pertain to small and medium businesses but teach skills that can be used in organiza-
tions of any size. Whether you are already comfortable working in Excel and want to learn
about new features in Excel 2013 or are new to Excel, this book provides invaluable hands-
on experience so that you can create, modify, and share workbooks with ease.
How this book is organized
This book is divided into 14 chapters. Chapters 1–4 address basic skills such as identify-
ing the different Excel programs, customizing the program window, setting up workbooks,
managing data within workbooks, creating formulas to summarize your data, and format-
ting your workbooks. Chapters 5–10 show you how to analyze your data in more depth
through sorting and filtering, creating alternative data sets for scenario analysis, summariz-
ing data by using charts, and creating PivotTables and PivotCharts. Chapters 11–14 cover
printing, working with macros and forms, working with other Microsoft Office programs,
and collaborating with colleagues.
The first part of Chapter 1 contains introductory information that will primarily be of inter-
est to readers who are new to Excel or are upgrading from Excel 2010 or an earlier ver-
sion. If you have worked with a more recent version of Excel, you might want to skip that