Learn Excel in One PDF Book
if you are the student of CMA, CA, ICMA, ACCA, Accounting then you have to know excel properlyFree Download Excel Book
Free Download Excel eBook
Free Download Excel Learning Book
Introduction
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 generally
pertain to small and medium businesses but teach skills that can be used in organizations
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 handson
experience so that you can create, modify, and share workbooks with ease.
Free Download Excel Book
Free Download Excel eBook
Free Download Excel Learning Book
How this book is organized
This book is divided into 14 chapters. Chapters 1–4 address basic skills such as identifying
the different Excel programs, customizing the program window, setting up workbooks,
managing data within workbooks, creating formulas to summarize your data, and formatting
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, summarizing
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 interest
to readers who are new to Excel or are upgrading from Excel 2010 or an earlier version.
If you have worked with a more recent version of Excel, you might want to skip that
material.
Free Download Excel Book
Free Download Excel eBook
Free Download Excel Learning Book
Contents
Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .xi
Who this book is for . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .xi
How this book is organized . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .xi
Download the practice files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xii
Your companion ebook . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xv
Getting support and giving feedback . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xv
Errata . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xv
We want to hear from you . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xvi
Stay in touch . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xvi
1 Getting started with Excel 2013 3
Identifying the different Excel 2013 programs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4
Identifying new features of Excel 2013 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6
If you are upgrading from Excel 2010 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6
If you are upgrading from Excel 2007 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7
If you are upgrading from Excel 2003 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9
Working with the ribbon . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10
Customizing the Excel 2013 program window . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13
Zooming in on a worksheet . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13
Arranging multiple workbook windows . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14
Adding buttons to the Quick Access Toolbar . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18
Customizing the ribbon . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .20
Maximizing usable space in the program window . . . . . . . . . . . . . . . . . . . . . . . . . . . 23
Creating workbooks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25
Modifying workbooks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30
Modifying worksheets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34
Inserting rows, columns, and cells . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 35
Merging and unmerging cells . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 39
Key points . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 43
Free Download Excel Book
Free Download Excel eBook
Free Download Excel Learning Book
2 Working with data and Excel tables 45
Entering and revising data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 46
Managing data by using Flash Fill . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 50
Moving data within a workbook . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 54
Finding and replacing data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 58
Correcting and expanding upon worksheet data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 62
Defining Excel tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 67
Key points . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 72
3 Performing calculations on data 75
Naming groups of data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 76
Creating formulas to calculate values . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 81
Summarizing data that meets specific conditions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 90
Working with iterative calculation options and automatic workbook calculation . . . . . . . . . 94
Using array formulas . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 96
Finding and correcting errors in calculations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 99
Key points . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 105
4 Changing workbook appearance 107
Formatting cells . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 108
Defining styles . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 113
Applying workbook themes and Excel table styles . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 119
Making numbers easier to read . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 125
Changing the appearance of data based on its value . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 131
Adding images to worksheets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 138
Key points . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 142
Introduction
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 generally
pertain to small and medium businesses but teach skills that can be used in organizations
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 handson
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 identifying
the different Excel programs, customizing the program window, setting up workbooks,
managing data within workbooks, creating formulas to summarize your data, and formatting
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, summarizing
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 interest
to readers who are new to Excel or are upgrading from Excel 2010 or an earlier version.
If you have worked with a more recent version of Excel, you might want to skip that
material.
This book has been designed to lead you step by step through all the tasks you’re most
likely to want to perform with Excel 2013. If you start at the beginning and work your way
through all the exercises, you will gain enough proficiency to be able to create and work
with most types of Excel workbooks. However, each topic is self-contained, so you can jump
in anywhere to acquire exactly the skills you need.
Entering and revising data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 46
Managing data by using Flash Fill . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 50
Moving data within a workbook . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 54
Finding and replacing data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 58
Correcting and expanding upon worksheet data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 62
Defining Excel tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 67
Key points . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 72
3 Performing calculations on data 75
Naming groups of data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 76
Creating formulas to calculate values . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 81
Summarizing data that meets specific conditions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 90
Working with iterative calculation options and automatic workbook calculation . . . . . . . . . 94
Using array formulas . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 96
Finding and correcting errors in calculations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 99
Key points . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 105
4 Changing workbook appearance 107
Formatting cells . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 108
Defining styles . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 113
Applying workbook themes and Excel table styles . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 119
Making numbers easier to read . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 125
Changing the appearance of data based on its value . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 131
Adding images to worksheets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 138
Key points . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 142
Introduction
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 generally
pertain to small and medium businesses but teach skills that can be used in organizations
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 handson
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 identifying
the different Excel programs, customizing the program window, setting up workbooks,
managing data within workbooks, creating formulas to summarize your data, and formatting
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, summarizing
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 interest
to readers who are new to Excel or are upgrading from Excel 2010 or an earlier version.
If you have worked with a more recent version of Excel, you might want to skip that
material.
This book has been designed to lead you step by step through all the tasks you’re most
likely to want to perform with Excel 2013. If you start at the beginning and work your way
through all the exercises, you will gain enough proficiency to be able to create and work
with most types of Excel workbooks. However, each topic is self-contained, so you can jump
in anywhere to acquire exactly the skills you need.
if you read this book, this is complete book for excel
Free Download Excel Book
Free Download Excel eBook
Free Download Excel Learning Book
Free Download Excel Book
Free Download Excel eBook
Free Download Excel Learning Book
For Download Click the below link
No comments:
Post a Comment