Excel 2021 for Beginners: A Step by Step Practical Guide on How to Use and Master Microsoft Excel’s Features, Functions, and Formulas

Length: 138 pages
Edition: 1
Language: English
Publication Date: 2021-09-29
ISBN-10: B09HKQ2LZ5
ISBN-13: 9798486989117
Sales Rank: #0 (See Top 100 Books)

What if I told you I could make Excel as easy as ABC?

We all know how important this spreadsheet program is and how difficult it is to understand the INS and OUT of Excel. Without visual and practical examples, the basics, formulas, and features of Excel have been difficult for most users to grasp. This book offers some step-by-step guides to work up your Excel skills with readable and practical examples to get you through.

My name is John Bradley, and over my years of using the Excel program, I’ve experienced my fair share of how frustrating and challenging learning excel can get. This has taught me everything I know on how to get past those learning hurdles and inspired me to share my story with others and offer help in the form of this book to assist you in doing the same.

I want to share that knowledge with you now because I know for a fact that it can free so many people from the tiresome process involved in using excel.

In Excel 2021 Guide, here is just a fraction of what you’ll learn:

How to customize your Excel environment
Time-Saving Ways to Insert Data into Excel
How to Modify the Column, Row, and Cell In the Worksheet
How to use the Excel Logic Function
How to use the Excel Text Function
Countless common errors to avoid

And that’s just the tip of the iceberg…

Excel may have seemed like something that was out of reach for many reasons. When I first started, I thought it would take years to learn the ins and outs. In fact, it did. That’s why I’m sharing all of that knowledge with you today in one ultra-convenient place.

You won’t find this level of information anywhere else…

With this book in your hands, you can save yourself time and energy by following all of the tips, tricks, and advice you’ll find within. Gain meaningful knowledge in the step-by-step, easy-to-follow chapters by using this book as a reference for any of the obstacles you might find yourself facing along the way.

Join thousands of others who have taken the leap towards spicing up their Excel skills!

TABLE OF CONTENTS
INTRODUCTION
    Official release date?
    Microsoft Office 2021 new features
    How is Microsoft Office 2021 different from Microsoft 365?
CHAPTER ONE- GETTING STARTED
    How to Open Microsoft Excel
        For Windows 8.1
        For Windows 10
        Exiting Excel 2021
    Excel’s Start Screen
        Turn off the Start screen
    Excel’s Ribbon User Interface
        How to change the Ribbon Display Options
        The Quick Access Toolbar
    Understanding the Worksheet
        How to customize your Excel environment
CHAPTER TWO- USING YOUR WORKSHEET
    How to Create a New Workbook
        Enter data
    Copying or Moving a Worksheet
        How to drag and drop the worksheet
    Saving Your Document
        How pin your favorite save location
    How to Recover Your Document Using Auto-save
        How to share an excel workbook
CHAPTER THREE- CELL
    Understanding the Cell
        How to select a cell and a cell range
    Cell Content
        How to insert content
        How to delete/clear cell content
        How to delete cells
        How to copy and paste cell content
        How to access more paste options
        How to cut and paste cell content
        How to drag and drop cells
        How to use the fill handle
    Cell Borders
        How to add a cell border
    Modifying the Column, Row and Cell In the Worksheet
        How to modify column width
        How to AutoFit column width
        How to modify row height
        How to modify all rows or columns
    Inserting and Hiding Cells
        How to insert rows
        How to hide and unhide a row/column
    Wrapping Text and Merging Cells
        How to wrap text in cells
        How to merge cells using the Merge & Center command
    How to Change the Worksheet Theme Color and Effects
        How to change theme fonts
        How to change theme effects
CHAPTER FOUR- FORMULAS AND FUNCTIONS
    Basic Terms in Excel
    Time-Saving Ways to Insert Data into Excel
        1.Simple insertion: Typing a formula inside the cell
        2. Using Insert Function Option from Formulas Tab
        3.Selecting a Formula from One of the Groups in Formula Tab
CHAPTER FIVE- MS EXCEL TEXT FUNCTION
    Excel TEXT Function Format Codes
    How to Use TEXT Function with Formula Examples
        Concatenate text and number (or date) in a custom format
    Other Excel Text Functions
        Excel LEFT function
        RIGHT function
        TRIM function - quick way to remove extra spaces
CHAPTER SIX- MS EXCEL LOGIC FUNCTION
    Using the AND Function
        Excel AND function - common uses
    Using the OR Function In Excel
        IF function with nested OR
    Using the XOR Function
    Using the NOT Function In Excel
CHAPTER SEVEN- FUNCTIONS OF DATE AND TIME
    Excel DATE Function
        Excel TODAY function
        Shortcuts to get today's date
    Excel NOW Function
        Excel DATEVALUE function
        Excel DAY function
    Excel WEEKDAY Function
        Excel DATEDIF function
CHAPTER EIGHT- COUNTING FUNCTION
    COUNT function
    COUNT(range)
    The COUNTA function
    How Do I Use COUNTIF?