EXCEL 2021 The Comprehensive Beginners to Advanced Users Guide to Master Microsoft Excel 2021. Learn the Essential Functions, New Features, Formulas, Tips and Tricks, and Many More

Copyright
CHAPTER ONE
1 1 INTRODUCTION
1 2 THE INTERESTING ADVENT OF MICROSOFT EXCEL
1 3 WHAT IS MICROSOFT EXCEL?
1 4 VERSIONS OF MICROSOFT EXCEL
1 5 SYSTEM SPECIFICATIONS FOR MICROSOFT EXCEL 2021
CHAPTER TWO
2 1 HOW TO OPEN MICROSOFT EXCEL 2021
2 2 THE ENVIRONMENT OF MICROSOFT EXCEL 2021
2 3 HOW TO CUSTOMIZE MS EXCEL ENVIRONMENT
i  HOW TO CHANGE TEXT FONTS
ii  HOW TO CHANGE FONT COLORS
iii  HOW TO CHANGE THEME
iv  HOW TO CHANGE THEME COLORS
V  HOW TO CHANGE THEME FONT
2 4 WORKING WITH MS EXCEL 2021
2 5 WHAT IS MICROSOFT EXCEL RIBBON?
(A) COMPONENTS OF EXCEL RIBBON
2 6 WORKING WITH COMMAND IN MICROSOFT EXCEL
2 7 TO CREATE A NEW TAB
2 9 PROOFING OPTIONS
CHAPTER THREE
3 1 BASIC TERMS IN MS EXCEL 2021
3 2 FORMULAS IN MS EXCEL 2021
3 3 BASIC FORMULAS IN MS EXCEL 2021
3 4 HOW TO USE FORMULAS IN MS EXCEL 2021
3 5 FUNCTIONS IN MS EXCEL 2021
3 6 BASIC FUNCTIONS IN MS EXCEL 2021
3 7 MICROSOFT 365 SPREADSHEET NEW FUNCTIONS
3 8 HOW TO USE FUNCTIONS IN MS EXCEL 2021
3 9 THE IMPORTANCE OF FUNCTIONS
3 10 TIPS ON HOW TO AVOID MISTAKES WHEN WORKING
WITH FORMULAS IN MICROSOFT EXCEL
3 11 USE OF APOSTROPHES IN MS EXCEL 2021
CHAPTER FOUR
4 1 WORKING WITH WORKBOOK IN MS EXCEL 2021
4 2 HOW TO MAKE A CELL ACTIVE IN MS EXCEL 2021
4 3 TEXT FUNCTIONS IN MS EXCEL 2021
CHAPTER FIVE
5 1 HOW TO GENERATE A SPREADSHEET IN MS
WORD
5 2 USER INTERFACE IN MS EXCEL
5 3 HOW TO IMPORT A SPREADSHEET INTO MS EXCEL
CHAPTER SIX
6 1 HOW TO CREATE CHARTS IN EXCEL
6 2 TYPES OF CHARTS
TO CREATE A PIE CHART
HOW TO CREATE A BAR CHAT
To create a Scatter Chart
To create an Area Chart
To create a Line chart
6 3 THE IMPORTANCE OF CHARTS IN MS EXCEL
CHAPTER SEVEN
7 0 GRAPHS IN MICROSOFT EXCEL
7 1 TYPES OF GRAPHS IN MS EXCEL
7 2 HOW TO CREATE GRAPHS IN MS EXCEL
7 3 HOW TO CUSTOMIZE GRAPHS IN MS EXCEL
THE IMPORTANCE OF GRAPHS IN MS EXCEL
CHAPTER EIGHT
8 1 WORKING WITH TABLES IN MS EXCEL
Basic Features in Excel Tables
8 2 HOW TO CREATE A TABLE IN EXCEL
8 3 TYPES OF TABLE STYLES
8 5 How to customize a table style
8 6 How to format the components of a table
8 7 How to use Find and Replace in Ms excel
CHAPTER NINE
9 1 THE PIVOT TABLE
9 2 How to create a Pivot Table
9 3 TWO-DIMENSIONAL PIVOT TABLE
9 4 THE IMPORTANCE OF A PIVOT TABLE
9 5 SORT AND FILTER IN EXCEL
9 5 WORKING WITH ROW IN A TABLE
9 7 MACROS AND MACRO RECORDING
9 8 HOW TO RECORD MACRO IN EXCEL
CHAPTER TEN
10 1 HOW TO INSERT SYMBOLS IN MS EXCEL
10 2 HOW TO INSERT SPECIAL SYMBOLS IN MS EXCEL
10 3 HOW TO ADD CURRENCY
CHAPTER ELEVEN
11 1 HOW TO USE FORWARD AND BACKWARD IN MS
EXCEL
11 2 HOW TO CREATE SHAPES IN EXCEL
11 2 Word-Art IN EXCEL
CHAPTER TWELVE
12 1 WHAT IS A BASIC DATABASE?
12 2 HOW TO GENERATE A DATABASE
12 3 A MASTER DATABASE
12 4 WHAT IS A RELATIONAL DATABASE?
12 5 HOW TO PERFORM RELATIONAL DATABASES
CHAPTER THIRTEEN
13 1 THE MASK WIZARD
13 2 THE INPUT MASKS
13 3 HOW DO YOU INSERT A MASK IN EXCEL?
13 4 HOW TO CUSTOMIZE AN INPUT MASK
13 5 EXAMPLES OF INPUT MASKS
13 6 USING AN EMAIL ADDRESS TO SPECIFIC INPUT MASKS
CHAPTER FOURTEEN
14 1 HOW TO ZOOM IN AND ZOOM OUT OF WORKBOOKS
To zoom to a specific percentage
14 2 HOW TO OPEN A PREVIOUSLY CREATED WORKBOOK
14 3 WHAT ARE NATIVE OR NON-NATIVE EXCEL FILES
14 4 HOW TO HIDE AND UNHIDE EXCEL WORKSHEET
CHAPTER FIFTEEN
15 1 HOW TO NAME A CELL
15 2 WHAT ARE HYPERLINKS
15 3 WORKING WITH PAGE LAYOUT
15 4 DATA VALIDATION
15 5 ALERT MESSAGES
15 6 HOW TO ACTIVATE THE DEVELOPER TAB
15 8 THE PRINT AREA IN A WORKSHEET
15 9 HOW TO LINK MS EXCEL TO EXTERNAL SOURCES
15 10 SIGNATURE IN MS EXCEL
15 11 KEYBOARD SHORTCUTS
CHAPTER SIXTEEN
16 1 BENEFITS AND USEFULNESS OF USING
MICROSOFT EXCEL
16 2 MS EXCEL 2021 COMPATIBILITY WITH PREVIOUS
VERSION
CONCLUSION
ABOUT THE AUTHOR