Beginners Guide to Microsoft Excel for Senior Citizens: The Ultimate Users Guide to Mastering the Fundamentals of Microsoft Excel

154 Pages·3.485 MB·English

by  Eric Gale

Beginners Guide to

MICROSOFT
EXCEL

For Senior Citizens

The Ultimate Users Guide to Mastering the
Fundamentals of Microsoft Excel

ERIC GALE
1
Copyright
All rights reserved. No part of this publication EXCEL MADE EASY FOR BEGINNERS may be
reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic,
mechanical, photocopying, recording, and scanning without permission in writing by the author.

Printed in the United States of America
© 2020 by Eric Gale

Dorween Publishing House
USA | UK | CANADA

2
About the Author

Eric Gale is a seasoned ICT consultant
with over 27 years of experience in the
ICT industry. He has a compelling
passion for teaching, writing, and
imparting knowledge through books,
lectures, interviews, and podcasts. He enjoys figuring out how to
break down complex problems into easy to understand formats.
Eric holds a Bachelor's and a Master's Degree in Computer
Science and Information Communication Technology,
respectively, from University of California, Berkeley.

3
Table of Contents
Copyright ............................................................. 2
CHAPTER 1 .................................................... 12
Common Uses of Excel ..................... 12
First things to do as you open Excel ........ 13
How to Use Built-In Excel Templates ...... 15
Exploring the Excel Interface ............... 16
Basic Excel Terminologies .................. 18
The Quick Access Tool Bar ................. 22
The Clipboard ............................... 27
4
Saving and Sharing Your Workbooks ...... 28
How to Use Save As to Make a Copy ...... 31
How to Use AutoRecover ................... 32
How to Export Workbooks .................. 33
CHAPTER 2 .................................................... 37
THE CELL BASICS ........................ 37
Understanding Cells ......................... 37
Cell Structures ............................... 37
How to Name a Cell ......................... 37
Spreadsheet .................................. 39
 How to Delete a Spreadsheet ............ 40
 How to Name a Spreadsheet ............. 40
 Rearranging Spreadsheets ................ 41
5
 How to add a Color to a Spreadsheet Tab
41
 Protecting a Spreadsheet ................. 41
 Move or Copy a Spreadsheet ............ 41
Columns, Rows, and Cells in Excel ......... 42
How To Select An Entire Column Or Row . 42
How to Select a Group of Columns, Rows, Or
Cells .......................................... 44
How to Select Scattered Columns, Rows, or
Cells .......................................... 46
How to Select Adjacent Columns, Rows, or
Cells .......................................... 46
How to Move a Cell, Column, or Row ..... 47
How to Insert/ Delete a Cell, Column, or Row
............................................... 48
6
How to Adjust the Size of a Cell, Column or
Row .......................................... 50
How to Adjust the Size to Fit Your Data ... 52
Fill Handle ................................... 53
CHAPTER 3 .................................................... 57
BASIC FORMATTING ............................. 57
Formatting Colors, Fonts, and Shading ..... 57
How to Add Dates, Currency, Percentage and
Decimals ..................................... 68
Formatting Cells and Conditional Formatting
............................................... 74
Format Table ................................. 74
Conditional Formatting ...................... 75
CHAPTER 4 .................................................... 77
7
COMMON EXCEL FORMULAS YOU
MUST KNOW ................................................ 77
 SUM ...................................... 77
 COUNT ................................... 78
 COUNT A ................................ 78
 LEN ....................................... 78
 VLOOKUP ............................... 79
 IF STATEMENTS ....................... 80
HOW TO APPLY SIMPLE FORMULAS . 81
Building an Equation ........................ 82
The AutoSum Tool .......................... 85
Finding the Maximum Value ................ 93
Finding the Minimum Value of a Set of
Numbers ..................................... 95
8
Finding the average value of a Set of Numbers
............................................... 96
Counting a Set of Values .................... 96
Subtraction, Multiplication and Division in
Excel ......................................... 97
Multiplication ................................ 99
Division .................................... 100
Analyze Data Using Quick Analysis Tool 101
Data Filtering and Sorting ................. 102
Freezing Panes ............................. 106
Types of Cell References in Excel ........ 107
 Relative References .................... 107
 Absolute References ................... 109
CHAPTER 5 ................................................. 116
CHARTS ................................... 116
9
Types Of Charts In Excel ................. 116
How to Create Charts in Excel ............ 117
CHAPTER 6 ................................................. 124
PIVOT TABLE BASICS ........................ 124
Pivot Table Requirements ................. 124
Creating a Pivot Table ..................... 125
Chapter 7 ....................................................... 127
PRINTING IN EXCEL ........................... 127
Tools for Printing in Excel ................ 127
Shortcut For Print Preview ................ 130
Page Layout ................................ 132
Margins .................................... 132
Setting Custom Margins ................... 133
How to Change Margins by Dragging .... 134
10