Excel 2021 For Beginners And Advanced Learners.

LEGAL NOTICE
TABLE OF CONTENT
INTRODUCTION
CHAPTER ONE
INTRODUCTION TO OFFICE 2021
	Why Should You Use Office 2021?
	Versions of Microsoft Office 2021
CHAPTER TWO
INTRODUCTION TO MICROSOFT EXCEL 2021
	What is Excel 2021?
	Features of EXCEL 2021
	Importance of Using EXCEL 2021
CHAPTER THREE
GETTING FAMILIAR WITH EXCEL SCREEN INTERFACE
	Excel’s Start Screen
	Excel’s Workbook User Interface
	Navigating Through the Excel Ribbon
	Components of Excel Ribbons
	Customizing the Quick Access Toolbar
CHAPTER FOUR
UNDERSTANDING THE BASICS OF EXCEL
	What is a workbook
	What is a Worksheet
	Understanding Columns, Rows, and Cell Address.
	The Kinds of Data a Worksheet Accepts
	Hints to Observe Before Entering Data
	Entering Data into the Cells
	Editing Your Worksheet Data
	Copying and Moving Data in a Worksheet Cells
	Moving Around in a Worksheet
	Applying Formatting to Numbers
	Displaying Numbers with a Thousand Separator (Comma)
	Displaying Numbers with Currency Symbols
	Displaying Numbers as Percentage
	Changing the Date Format in your Cell
	Changing the Time Format in your Cell
	The Flash Fill Command
	Combining Data Using the Flash Fill
	Extracting Data with Flash Fill
	The AutoFill Command
	Entering a Series of Value Using AutoFill
	Copying Data Using the AutoFill
	Saving a File
	Saving a File for the First Time
	The Document Auto Recovery Command
	Learning Data Validation
	Applying the Data Validation to Cells
	Transferring the Data Validation to Other Cells in the Worksheet
	Removing the Data Validation From your Cells
	Filtering Data in Excel
	Grouping of Data in Excel
CHAPTER FIVE
FORMATTING AND MANAGING THE WORKSHEET
	Numbers and Text Alignment in Rows and Columns
	The Vertical Alignment
	The Horizontal Alignment
	Changing Text and Number Orientation
	Wrapping Text in Your Worksheet
	Merging Cells
	Inserting Rows and Columns
	Inserting a Row
	Inserting a Column
	Deleting Rows and Columns
	Adjusting Rows and Columns Size
	Adjusting the Height of the Row
	Adjusting the Column Width
	Changing the Column Width to Automatically Fit the Contents
	Changing the Row Height to Automatically Fit the Contents
	Resizing All Columns and Rows to Fit the Data or Content
	Freezing and Splitting Rows and Columns
	Freezing Your Rows and Columns
	Unfreezing Panes Rows and Columns
	Splitting in Worksheet
	Hiding and Unhiding the Rows and Columns
	Hiding the Columns
	Unhiding the Columns
	Hiding the Rows
	Unhiding the Rows
	Managing Your Worksheet
	Renaming Your Worksheet
	Selecting Worksheets.
	Rearranging Worksheets
	Inserting a New Worksheet
	Copying a Worksheet
	Deleting a Worksheet
	Adding Color to the Worksheet Tab
	Using the Comments in Your Worksheet
	Adding Comment to Your Worksheet
	Viewing the Comment on the Your Worksheet
	Editing a Comment in Your Worksheet
	Deleting a Comment
	Showing or Hiding All Comments
	Showing or Hiding Comments Individually
	Hiding Your Worksheet
	Protecting Your Worksheet
CHAPTER SIX
CUSTOMIZING THE WORKSHEET
	Changing the Worksheet Theme
	Changing the Theme Color
	Changing the Theme Fonts
	Changing the Theme Effects of Your Worksheet
	Changing the Font, Font Style, and Font Size
	Changing the Font of Your Worksheet
	Changing the Font Style of Your worksheet
	Changing the Font Size of Your Worksheet
	Changing the Font Color of Your Worksheet
	Changing the Cell Background Color of Your Worksheet
	Applying Borders to Your Worksheet
	Removing Border from Your Worksheet
	Removing Gridlines From Your Worksheet
	Changing the Color of Gridlines in a Worksheet
	Using the Cell Styles in Your Worksheet
	Applying Cell Styles to Your Worksheet
	Creating a Custom Cell Style
	Creating a Cell style by Modifying an Existing cell Style
	Duplicating an Existing Cell Style
	Removing Cell Styles from a Worksheet
	Deleting a Cell Style from a Worksheet
CHAPTER SEVEN
THE EXCEL FORMULA AND FUNCTIONS
	What is a Formula
	What is a Function
	Getting Familiar with The Formula Tab
	Categories of Data Excel’s Formula Accepts
	Inserting Formulas into your Worksheet
	Editing the Formula
	Understanding the Formula Operators
	The Order of Operator Precedence in Excel Formulas
	Manipulating the Order of Precedence Using the Parentheses
	Cell Referencing
	Types of Cell References
	Relative References
	Absolute Cell Reference and Multiple cell Reference
	REFERENCING OTHER WORKSHEETS IN A WORKBOOK
	How to Copy Formula from One Cell to Another
	Copying Formula Down a Column
	Copying a Formula Down a Column Without Copying the Formatting
	Copying Formula to the Entire Column
	Copying Formula to Non-adjacent Cells/Range
	Entering a Formula into Multiple Cells with a Single Key Stroke
	Copying Excel Formula Without the Formatting Using the Copy & Paste Features
	Dealing with Errors in Your Formula
	Excel Formula Error Messages
	Using the Error Checker Button
	Tracing Cell References
	Tracing Precedents
	Tracing Dependents
	Working with a Function
	UNDERSTANDING THE FUNCTIONS ARGUMENTS
	Locating the Arguments in a Function
	Taking a Look at Commonly Used Functions in Excel
	SUM for Adding Up Data
	AVERAGE for Averaging Data
	Deriving the function of a Cell Using FORMULATEXTS
	Counting the number of Data Items Using COUNT
	Counting All Data Type Using the COUNTA
	Counting Blank Spaces Using COUNTBLANK
	CONCATENATE for Combining Values
	Finding the Lowest Number Using MIN
	Finding the Highest Number Using MAX
	Counting Text Characters with LEN Function
	Changing the Orientation of the Cells With TRANSPOSE
	Capitalizing the First Letter of your Text String with PROPER
	Removing Spaces With TRIM
	Finding the Position of a Substring in a Text String Using the SEARCH Function
	Finding the Position of a Substring in a Text String Using the FIND Function
	Making Logical Comparison with Values Using the IF Functions
	Checking the Current Date and Time with TODAY and NOW
CHAPTER EIGHT
TABLES AND CHARTS IN EXCEL
	Creating a Table
	Changing Your Table Style
	Removing the Table
	Renaming a Table
	Filtering the Data in Your Table
	Grouping of Data in Your Table
	Sorting Out Data in Your Table
	Adding Slicer in Your Table
	Creating Pivot Table
	Inserting Recommended PivotTable in Your Data
	Working with Charts in Excel
	Types of Charts
	Creating a Chart with Your Data
	Changing the Chart Styles
	Changing the Chart Layout
	Changing the Chart Types
	Switching the Rows and Columns in Your Chart
	Moving Your Charts from One Worksheet to Another
	Creating Pivot Chart
CHAPTER NINE
SOLVING COMMON PRINTING PROBLEMS IN EXCEL
	Changing the Excel Worksheet Orientation Before Printing
	Printing One or Several Worksheets
	Printing an Entire Workbook
	Printing a Selection
	Printing Excel Tables
	Printing Charts Without Worksheet Data in Excel
	Printing Formula in Excel
	Printing Gridlines in Excel Worksheet
	Printing Out Comment in Excel
	Setting the Print Area Before Printing
	Inserting the Page Break Before Printing Excel Worksheet
	Using the Preview Option Before Printing Your Worksheet
	Scaling to Fit Before Printing Your Worksheet
CHAPTER TEN
EXCEL SHORTCUTS
	Editing Shortcut
	Navigation shortcuts
	File shortcuts
	Formula shortcuts
	Paste special shortcuts
	Ribbon Navigation shortcuts
	Clear shortcuts
	Selection shortcuts
	Data editing shortcut
	Data editing (inside a cell) shortcuts
	Other shortcuts
CHAPTER ELEVEN
TIPS AND TRICKS
	Removing Duplicates Values from Your Worksheet
	Deleting Error Cells
	Changing Negative Values to Positive Values in Your Worksheet
	Disabling the Excel Start Screen
	How to Make Excel Show leading Zero?
	Changing the Screen Background of Your Excel Environment
	Locking a File with a Password
	Saving Excel File as a PDF
CONCLUSION
INDEX