EXCEL 2022: The All In One Step-by-Step Guide From Beginner To Expert

Chapter 1: Introduction to Microsoft Excel
    Excel in Mobile Phones
        Using a Mobile App to Share an Excel File
        Using a Mobile App to Save an Excel Document
    Where Can I Get an Office Package that Includes Excel?
    Obtaining Free Microsoft Excel
    The Importance of the Microsoft Excel Program
Chapter 2: Terminology: What the Basic Terms Mean
Chapter 3: How to Use and Format Cells
    Basic Cell Navigation
        Fast Page Navigation
        Data Region Edge Navigation
    Cell Selection Extension
        Cell Selection until Data Region Edge
    Cell Data Types
    Entering Data into the Cell
        Identifying a Cell Name
        Quick Summation of Data
    Naming Cells
    How to Wrap Texts in a Cell
        How to Auto Select Different Cells
        Resizing Rows and Columns in a Cell
    How to Copy the Contents of a Cell
        How to Paste the Contents of a Cell
        Can you Change the Font and Font-Size of a Cell?
Chapter 4: How to Enter, Edit, and Manage Data
    Entering and Editing Data Manually
        Entering Data
        Editing Data
        Deleting Data
        Default Content Alignment
    Using AutoFill
        Entering Dates with AutoFill
        AutoFill Incremental Values
        AutoFill the Same Values
    Entering texts in Microsoft Excel worksheets
        The Cursor
        Entering Text
    Adding and Deleting Cells in Excel Worksheet
        The Use of Auto Complete
    Adding an Outline for Your Data
    Adding a Hyperlink
        How to Add Word Art to a Worksheet
    Formatting Tables
Chapter 5: Excel Workbooks Design Options
    Starting a New Workbook
    Opening an Existing Workbook
    Working on Your Excel Sheet
        Zooming in and Out Your Worksheet
    Copying and Pasting of Data
    Adding a New Worksheet
    Renaming a Worksheet
    Highlighting Numbers and Texts
        How to Transpose on your Worksheet
    Coloring a Worksheet
    Saving Your File
    Formatting Your Data
        Formatting Font Style
        Formatting Your Font Size
        Formatting Number Type
        Formatting an Overlap Data
        Repeating a Format Using the Format Painter
        Formatting Data into Table
        Rotating Text Directions
    Hiding and Unhiding Data
    Removing Duplicated Content from Excel Workbook
        Removing Duplicates without Deleting Rows
    Highlighting Cells with Formulas
Chapter 6: How to Organize Data (Rows and Columns)
    Inserting a New Row and Column into Your Table
    Naming Rows and Columns
        Defining Names
        Managing Named Content
    Creating Column and Row Headings
        Creating a Table
    The Shortcut to Remove Blank Rows
        Adding Several Rows in Excel
    Inserting Multiple Rows
        Using a Shortcut to Insert Multiple Rows
    Adding Text to Columns
Chapter 7: Most Used Formulas and Calculations to Save Time
    Basic Formulas
        Is there a difference between a Formula and a Function?
        Step-By-Step Examples
        Additional Examples
        Arithmetic Operators
        Comparison Operators
    How to Enter a Formula
        Arithmetic Operations
    Copy and Paste Formulas
    Calculating Percentages
Chapter 8: How to Use the Drop-Down List and Data Validation
    How to Insert Data Validation
    Editing Data Validation in Excel
    Removing Data Validation in Excel
    Filtering Data in Excel
    Grouping of Data in Excel
    Creating Data Validation Rules
        How to Edit or Remove Data Validation Rules
    Create a Dropdown List
Chapter 9: Everything about the Named Range
    Creating a Named Range
        Method 1
        Method 2
    Editing a Named Range
        Deleting a Named Range
    How to Use a Named Range
Chapter 10: How to Work with Pivot Tables
    Create a Pivot Table from more Than One Existing Table
    Summarizing Data by Date
    Filter and Sort a PivotTable
        Applying a Custom Filter
        Sorting PivotTable Data
    Present Data with Pivot Charts
    Filtering a Pivot Chart
Chapter 11: All about Charts
    Types of Charts
        Column Charts
        Bar Charts
        Line Charts
        Scatter Chart
        Pie Chart
        Area Charts
    Customizing Charts
        Switching the X and Y Axes
        Change the Data Source
        Adding Axis Titles
        Chart Styles
Chapter 12: New Features in Excel for 2021
    Password Protection
    Data Filtering
    Data Sorting
    Built-In Formulae
    Creating Different Charts
    Automatically Edits Results
    File and Replace Command
    Conditional Formatting
    Paste Special
    Flash Fill
    Shortcut Keys
    Hyperlink
    Transpose
    TRIM
    Sparklines
    Remove Duplicate
    Other Operations in Excel 2021
    Future of Excel
Chapter 13: Excel for Accounting—10 Excel Functions You Need to Know
    Accounting
    Excel Is a Problem-Solving Program
    Excel Will Save Your Time
    Formatting Options
    Chart & Graphs for Analysis
    Organize All of Your Data in One Place
    It Boosts Productivity and Increases Performance
    It Enables You to Increase Employee Knowledge with Minimal Cost and Effort
    It Can Boost Your Career Development
    Increasing Your Productivity and Efficiency
    Making You a Better Data Organizer
Chapter 14: How to Make Checklist in Excel
    Task List
    Checklist
    Project Management Charts
    Time Logs
Chapter 15: Excel Functions You Need in 2022
    The Mod Function and How to Use it
    The Round Function and How to Use it
    The Sort Function and How to Use it
    The Sum Function and How to Use it
    The RoundUp Function and How to Use it
    The RandBetween Function and How to Use it
    Math Functions in Excel 2021
    The RoundDown Function and How to Use it
    The SUMIF Function and How to Use it
    Handling a SUMIF Function with Multiple Criteria
Chapter 16: Excel Calendar with Just One Formula
    Creating a Calendar (Calendar Format)
    How to Make a Schedule in Excel
        Creating a Weekly Schedule
Chapter 17: Ultimate Excel Tips and Tricks for 2022
    Renaming a Sheet with a Double Click
    Changing the Case of a Text
    Forming a Text with &
    How to Make Excel Show Leading Zero
    Extending Formula Down
    Changing How Enter Works
    Quick Select Formulas
    Disabling the Excel Start Screen
    Activating Current Date and Time
    The Status Bar
    Deleting Errors Cells
    Striking Through Texts in Excel
    How to Clear Formatting
    Sharing Data Online on Excel
    Free Add-Ins for Excel to Start Using Now
Conclusion
Underlining Commas in a Cell
How to Add Borders to a Cell
Deleting a Cell
How to Drag and Drop a Cell
How to Modify the Text Alignment of your Border in Cells
    Horizontal Alignment
    Vertical Alignment
Duplicating Cell Value
Text Alignment Setting and Alt Shortcut Keys
Moving the Pivot Chart
Generate a PivotTable and a PivotChart Simultaneously
Creating Sparkline Charts
    Adding a Sparkline
Add/Remove Chart Titles
Adding Data Point Labels
Add a Legend
Modify Chart Size
Create a Chart Template