Excel 365 For Beginners And Advanced Learners: A Step-By-Step Practical Guide To Master Excel

LEGAL NOTICE
INTRODUCTION
CHAPTER ONE
INTRODUCTION TO OFFICE 365
    Why Should You Use Office 365?
    Versions of Microsoft Office 365
CHAPTER TWO
INTRODUCTION TO MICROSOFT EXCEL 365
    What is Excel 365?
    Features of Excel 365
    Importance of Using Excel 365
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