MICROSOFT WORD & EXEL 2021 FOR BEGINNERS & ADVANCED LEARNERS : A STEP-BY-STEP PRACTICAL GUIDE TO MASTERING WORD & EXCEL 2021

INTRODUCTION
INTRODUCTION TO OFFICE 2021
	Why Should You Use Office 2021?
	Versions of Microsoft Office 2021
BOOK ONE
WORD 2021
CHAPTER ONE
GETTING STARTED WITH WORD 2021
	What Is Word 2021
	Versions of Microsoft Word
	Becoming A Microsoft User
	Exploring Word 2021 Screen Interface
	The Title Bar
	Navigating Through the Menu Bar
CHAPTER TWO
USING SPEED TECHNIQUES WHILE WORKING WITH WORD
	Creating a New Document
	Displaying your Documents In Different Ways
	Splitting the Screen
	Techniques Needed to Navigate Through Your Documents
	Using the Shortcut keys
	Using the Navigation Pane
	Using the Go to Command
	Injecting a File into a Document
	Using the Undo and Repeat Command
	Using the Zoom Controls
	Reading Out Your Document With Word 2021
	Saving a File
	Saving a File for the First Time
	Saving Auto Recovery Information
	Opening Files
	Closing a File
CHAPTER THREE
MANIPULATING TEXTS CHAPTER FOUR
	Moving and Copying Text
	Deleting Texts
	Adjusting the Text Alignments
	Modifying the Look of Your Text
	Changing the Fonts in Your Text
	Changing the Font Sizes in Your Text
	Changing the Font Styles in Your Text
	Changing the Font Color of Your Text
	Applying Text Effects to Your Text
	Applying Case to Your Text
	Inserting Symbols into your document
	Speaking Words Rather Than Typing
CHAPTER FOUR
LAYING OUT TEXT AND PAGES
	Inserting Section Break in Your Document
	Deleting a Section Break
	Inserting Page Break
	Deleting Page Break
	Breaking a Line
	Starting a New Page
	Setting Up and Adjusting the Page Margins
	Adjusting Page Margin Using Ruler
	Adjusting Page Margin Using Preset Margins
	Adjusting Page Margin by Using Custom Margins
	Indenting Your Paragraph
	Indent Single Paragraphs with the Tab key
	Indent All Paragraphs with the Ruler
	Indent All paragraphs with the Paragraph Dialog Box
	The Tab Selector
	Working with Page Numbers
	Adding Page Numbers to Your Documents
	Adding Page Number to Header or Footer
	Changing the Page Number Format
	Hiding Page Number on the First Page
	Working with Header and Footer
	Inserting a Header or Footer in Your Document
	Editing Header or Footer in Your Document
	Removing the Header or Footer in Your Document
	Adding Date and Time to Your Header or Footer
	Adjusting Line Spacing
	Adjusting Paragraph Spacing
	Numbered and Bulleted Lists
	Creating a Numbered List
	Creating a Bulleted List
	Creating Your Own Numbered List
	Creating Your Own Bulleted List
	Useful Tips When Using the Number and Bullets List
	Manage a Multilevel List
	Hyphenating Text
	Hyphenating Your Text Automatically
	Hyphenating Your Text Manually
	Removing Hyphenation
	Preventing Text from Being Hyphenated
CHAPTER FIVE
EXPLORING WORD STYLES
	Why Should You Use Styles?
	Components of Styles
	Applying Styles to your Text or Paragraphs
	Applying a Style Set
	Creating a New Style
	Creating a New Style from a Paragraph
	Creating a Style from the Ground up
	Modifying a Style
	Renaming Your Styles
CHAPTER SIX
CONSTRUCTING A PERFECT TABLE IN WORD
	What is a Table
	Creating a table
	Creating a Table by Dragging the Table Menu
	Inserting the Table Using the Insert Table Dialog Box
	Drawing a Table
	Convert Text to Tables
	Creating a Quick Table
	Constructing a Table from an Excel Worksheet
	Navigating Within a Table
	Entering Text and Numbers in Your Tables
	Formatting Your Table
	Adding Row and Columns
	Changing the Size of Your Columns or Row
	Changing the Size of Your Table
	Deleting Columns and Rows
	Aligning Texts in Columns and Rows
	Merging and Splitting Cells
	Sorting Data in a Table
	Applying Table Styles to Your Table
	Adding Borders to Your Table
	Adding Shades to Your Table
	Wrapping Text Around Your Table
	Applying Picture as the Table Background
	Applying Diagonal Lines on Your Table
	Using Mathematics Formulas in Tables
CHAPTER SEVEN
USING THE PROOFING TOOLS
	The Proofing Tools
	Checking for Spelling Errors in Your Documents
	Preventing Text from Being Spell Checked
	Correcting Grammatical Errors
	Correcting Grammatical Errors Using Editor Task Pane
	Ignoring Errors
	Customizing Spelling & Grammar Check
	Hiding Spellings and Grammar Errors in a Document
	Finding and Replacing Text
	Find Text Command
	Advanced Find Command
	The Replace Command
	Getting the Right Words with Thesaurus
	Proofing Text Written in Foreign Language
	Marking Text as Foreign Language Text
	Translating Foreign Language
CHAPTER EIGHT
DESKTOP PUBLISHING WITH WORD
	Using Themes on Your Document
	Choosing A New Theme
	Choosing a New Style Set
	Choosing a New Set of Colors for Your Themes
	Changing the Fonts
	Dressing Up Your Pages
	Decorating the Page of Your Document with Border
	Adding a Background Color to Your Page
	Getting Word 2021 Help with Cover Letters
	Applying Charts, Diagrams, Shapes, and Photos to Your Documents.
	Inserting Chart in Your Document
	Inserting Diagrams in Your Document
	Inserting Shapes in Your Documents
	Inserting Picture in Your Document
	Wrapping Text Around Image
	Positioning an Object on a Page
	Working with Text Box
	Inserting a Text Box
	Resizing a Text Box
	Moving a Text Box
	Modifying Text Boxes
	Using the Drop Cap
	Using the Watermark
	Inserting Watermark
	Inserting Custom Text Watermark
	Inserting Custom Picture Watermark
	Applying Newspaper Columns in Your Documents
	Page Orientation
	Changing Page Orientation
	Printing on Different Size Paper
	Displaying Online Video in a document
CHAPTER NINE
GETTING WORD’S HELP WITH OFFICE CHORES
	Highlighting Part of a Document
	Using Comments on a Document
	Replying a Comment
	Resolving a Comment
	Deleting Comments
	Moving Around from One Comment to Another
	Tracking Changes to Documents
	Turning Track Changes On and Off
	How to Show and Hide Track Changes
	Deleting Text with Track Changes
	Inserting Text with Track Changes
	Replacing Text with Track Changes
	Changing Formatting with Track Changes
	Accept or Reject Track Changes
CHAPTER TEN
WORKING WITH TOOLS FOR REPORTS AND SCHOLARLY PAPERS
	Alphabetizing a List
	Collapsing and Expanding the Parts of Your Document
	Navigating Your Document Using the Table of Content
	Creating a Table of Content
	Updating Your Table of Content
	Removing Table of Content
	Customizing Your Table of Content
	Indexing a Document
	Marking the Entries in Your Document
	Creating the Index
	Editing the Index
	Putting Footnotes and Endnotes in Your Documents
	Inserting a Footnote
	Inserting an Endnote
	Customizing the Footnotes and Endnotes
	Editing, Moving and Deleting Footnotes or Endnotes
CHAPTER ELEVEN
SHORTCUT KEYS IN WORD 2021
	Frequently Used Shortcuts
	Ribbon Keyboard Shortcuts
	Navigating the Document Keyboard Shortcuts
	Preview and Print Document Keyboard Shortcuts
	Select Text and Graphics Keyboard Shortcuts
	Edit Text and Graphics Keyboard Shortcuts
	Align and Format Paragraph Keyboard Shortcuts
	Format Characters Keyboard Shortcuts
	Keyboard Shortcuts to Review a Document
	Keyboard Shortcuts for Switching the Document View
	The Function Keys
	Ctrl + Function Keys
	Shift + Function Key
	Alt + Function Key
CHAPTER TWELEVE
TIPS AND TRICKS ON WORD 2021
	Saving Word File as a PDF
	Changing Word File into a Web Page
	Customizing Keyboard Shortcuts in Words
	Customizing the Status Bar
	Changing the Screen Background of Your Word Environment
	Locking a File with a Password
	Removing a Password from a File
	Renaming Tabs in Word 2021
	Auto Update Date and Time
CONCLUSION ON WORD
BOOK TWO
EXCEL 2021
CHAPTER ONE
INTRODUCTION TO MICROSOFT EXCEL 2021
	What is Excel 2021?
	Features of EXCEL 2021
	Importance of Using EXCEL 2021
CHAPTER TWO
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 THREE
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 FOUR
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 FIVE
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 SIX
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
	Understanding the Formula Operators
	The Order of Operator Precedence in Excel Formulas
	Editing the Formula
	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 SEVEN
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 EIGHT
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 NINE
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 TEN
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 ON EXCEL
INDEX