Excel 2021: Get Excel-Savvy from Scratch in No Time. The Ultimate Guide to Effortless Learning through a Highly Intuitive Approach, with Step-By-Step Illustrated Instructions and Practical Examples

Length: 245 pages
Edition: 1
Language: English
Publication Date: 2021-11-12
ISBN-10: B09LSKS46D
ISBN-13: 9798766086567
Sales Rank: #0 (See Top 100 Books)

Excel skills are widely demanded in the job market, they are vital for most office-based professionals today, and stronger Excel skills can open the door to promotion and leadership opportunities.

Here’s what you’ll find in this guide:

Module A: you will discover how Excel works and how to do basic operations; whether you are a beginner or already know the basics, it is always useful to review!
Module B: you will learn how to format texts and cells, enter data, move between rows and columns, and all Excel essential functions to move on to the more advanced steps,
Module C: you will find everything you need to know about creating tables and charts, how to insert

INTRODUCTION
    WHAT EXCEL HAS BECOME
    WHO IS THIS BOOK FOR
    HOW THIS BOOK CAN HELP TO HIT GOALS
    MICROSOFT OFFICE LATEST VERSIONS OVERVIEW
MODULE A
CHAPTER 1: EXCEL OVERVIEW
    THE EXCEL USER INTERFACE
        Creating a New Excel Workbook
        Saving Your Excel Workbook
        Ribbon – Tabs – Groups – Lunch buttons
        Customizing the Ribbon
        Customize the excel Quick Access Toolbar
    EXCEL STARTUP SCREEN
        Using AutoSave
        Recover autosave
        Undo and Redo
        Cut, Copy, and Paste
        Getting Help in Excel
    EXCEL WORKBOOK
        Excel Worksheet
        How To Remove The Gridlines From Your Worksheet
        Closing Your Workbook and Closing Excel
        Cells
        Allow a set of entries to be entered into a cell
        Choose the range of values a cell will allow
        Managing Notes in Cells
CHAPTER 2: EXCEL FUNDAMENTALS
    WORKING WITH CELLS AND RANGES
    Copying and moving cells
    Add comments and Cell Formatting
        Different Kinds of Cell References
        Naming cells
        How to create a cell reference on the same worksheet
        Adding and deleting cells in Excel worksheet
    ROWS AND COLUMNS
    How to select an entire row and column
        Naming rows and columns
        How to Extend Columns and Rows of a Cell
        Resizing Rows and Columns
        How to delete Blank Rows
    WORKING WITH THE WORKSHEETS
    Add a worksheet:
    Renaming the worksheet:
    Delete a worksheet:
        Moving Worksheets Between Workbooks
        How to Cover and Uncover a Worksheet
        How to Reference Worksheets in Another Workbook
    ENTERING DATA
        Entering text
        Copying, Moving and Deleting Data
        Numbers and dates
        Find and Replace Data
MODULE B
CHAPTER 3: FORMATTING
    FONT FORMAT
        Formatting Font Style
        Formatting Your Font Size
        Formatting with Bold, Italics and Underline
        Formatting Your Font Color
        Formatting the Bottom Border
        Formatting Data into Table
    7 BEST COMMANDS FOR DATA FORMATTING
    Format pointer
    Text and Cell Alignments
    Wrap Text
    Merge and center
    Applying Cell Styles
    Conditional Formatting
    Formatting Text Fields
    NUMBER FORMATS
    Applying number formats
    Using number formats correctly
    Percentage formats
    Date formats
    FORMATTING CELLS
    To change the font size
    To change the font color
CHAPTER 4: EXCEL ESSENTIAL FEATURES
    PASTE SPECIAL
    ENTERING DATA
    How to Insert Date and Time in a Cell
    AUTOFILL
    SORT AND FILTER
    Sorting Data
    Filtering Data
    FREEZE PANE
        How to Freeze Columns and rows
    SPLIT UP TEXT INFORMATION BETWEEN COLUMNS
    MAKE THE SAME CHANGE ACROSS MULTIPLE WORKSHEETS
CHAPTER 5: PAGE SET UP and PRINTING
    WORKING WITH PAGE LAYOUT
    How to insert page breaks in Excel
    Orientation
    Page Margins
    Scaling
    Excel print area
    How to print comments in Excel
        Page layout
    FIT TO PRINT in ONE PAGE
    PRINTING A SPECIFIC RANGE OF CELLS
    PRINTING
    Printing a Worksheet
    What Do You Want to Print?
    Making Multiple Copies
    How to add a print button to Excel Quick Access Toolbar
    How to print formulas in Excel
    PRINTING HEADERS AND FOOTERS
    PRINTING CHARTS
MODULE C
CHAPTER 6: EXCEL TABLES
    HOW TO CREATE TABLES
    Creating an Excel Table
    HOW TO APPLY FORMATTING TO THE TABLE
    Choosing a Table Style
    HOW TO ENTER DATA INTO AN EXISTING EXCEL TABLE
    You don’t have to keep the table
    Adding new rows to the table
    HOW YOU CAN SORT AND FILTER DATA
    Sorting Data in a Table
    Filtering Table Data
    ADDING ROWS OR COLUMNS TO A TABLE
        Adding a Totals Row to Your Table
    HOW TO USE EXCEL TABLE SLICER
CHAPTER 7: IMAGES, SMARTART, SHAPES, and CHARTS
    CHARTS
    How to Make an Excel Chart
    How to Make an Excel Table
    Types of chart
    How to insert a chart in Excel
    How to add a title to a chart
    How to change chart type in Excel
    How to change chart style in excel
    How to change chart layout in Excel
    How to move a chart
    SHAPES
    SMARTART
    How To Add Extra Data To Your Excel Charts
    IMAGES
CHAPTER 8: TEMPLATES
    INTRO TO EXCEL TEMPLATES
    Using templates
    CREATING A CUSTOM TEMPLATE
    EXISTING EXCEL TEMPLATES
    Working with Templates
    How to use them
To use the Italic, Bold, and Underline commands
Fill colors and Cell borders
Change and customize style borders
Align text in a cell
Format Painter
Copy Cell Formatting
CREATE DROP-DOWN MENUS
PRINT TITLES