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

Length: 115 pages
Edition: 1
Language: English
Publication Date: 2021-06-25
ISBN-10: B097ZXXTLL
ISBN-13: 9798527119701
Sales Rank: #2285477 (See Top 100 Books)

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

This eBook contains DIY straightforward steps on how to execute specific tasks in Excel.
How to use Excel features such as tables in rows and columns to perform simple and complicated Arithmetic functions and operations to solve personal, Academic, and business financials.
How to navigate the Excel environment using different icons, such as the Ribbon, command tabs to perform specific tasks.
Over 45+ Excel terms, 25+ functions, and 50+ keyboard shortcuts are discussed in this eBook.
How to use formulas, symbols, and functions to perform calculations is made easy in this guide.
How to generate data and use data to create graphical representations such as graphs and charts to display important information are made explicit.
Working with workbooks, worksheets, cells, tables, and databases are explained in simple terms.
How to link and access external sources using Excel.
Saving, retrieving, sending, and printing works in Excel.
How to use Excel to organize data to make financial statements and analyses for businesses.
Tips on how to avoid mistakes while working in Excel.
Most importantly, you will not want your Excel works to get into the wrong hands, hence you need to secure them by using a password.

Why are you still waiting? Scroll up and click the BUY-NOW button to make this excellent guide yours today!

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