EXCEL 2021: A Complete Step-by-Step Guide from Beginner to Expert | Learn to Use Excel with All the Functions Most Required by Companies and Fundamental … Individuals, in Less Than 20 Minutes a Day

Length: 132 pages
Edition: 1
Language: English
Publication Date: 2021-06-21
ISBN-10: B097PWR98J
Sales Rank: #296986 (See Top 100 Books)

Do you want to be one level ahead of your colleagues when it comes to using Excel so that your boss notices you for your speed and professionalism?

Do you want to learn the best spreadsheet software to be more productive in your business?

Then keep reading…

Microsoft Excel is undoubtedly the most famous spreadsheet in the world and has been on the personal computers of companies and professionals for 32 years. However, statistics show that, despite a history of over thirty years, it is still not used to its full potential by 99% of users.

This is due to the fact that most users do not take a course in order to learn how to use Excel in the best possible way, but learn by themselves, leaving gaps which often waste time during work or do not allow them to achieve the desired level of success.

This practical and theoretical book is written to help you learn the functions of Excel 2021 without any gaps. Starting from the basics, you will be able to master Excel 2021 step by step like a real professional spreadsheet operator.

Specifically, here is a small part of what you will learn from this book:

Microsoft Excel, an Introduction
Microsoft Office 2021: What’s New?
Learn How to use Dynamic Array(FILTER, RANDARRY, SORT , SEQUENCE, SORTBY, and UNIQUE)
Learn How to create charts in excel: types and examples
Learn How to enter basic formulas and calculations in excel
Learn How to select, activate and edit cells in excel
Learn How to Create and manage workbooks and worksheets
Learn How to create a spreadsheet in word
Learn How to format an excel table
Learn powerful and essential Excel Formulas and Functions
Learn How to Illustrate using XLOOKUP
Learn How to Automate Data Analysis with Excel’s Ideas Feature
Find out how to work with charts and graphics
Use Excel for data management, analysis, modeling, and visualization
Basic and Professional Excel tips and tricks
Basic math in Excel
Convert a text file or csv file into an excel spreedsheet
Way to solve common printing issues in Excel

And Much More…

Stop wasting time searching online for videos or articles, with this book you will have everything you need and you will learn Excel functions and formulas that will save your brain time and effort.

Introduction
Chapter 1: Microsoft Excel - An Introduction
    1.1 What is Microsoft Excel?
    1.2 Why Should I Learn Microsoft Excel?
    1.3 Where can You get Microsoft Excel?
    1.4 How to Open Microsoft Excel?
    1.5 What are the most important functions?
    1.6 What are the most important formulas?
    1.7 What are the most important shortcuts?
    1.8 How can you get better at Excel?
    1.9 What jobs use Excel spreadsheets?
    1.10 Versions of Excel
Chapter 2: Understanding Microsoft Excel
    2.1 Understanding the Ribbon
    2.2 Components of Ribbon
    2.3 Customization Microsoft Excel Environment
    2.4 Customization of ribbon
    2.5 Adding custom tabs to the ribbon.
    2.6 Setting the color theme.
    2.7 Settings for formulas
    2.8 Proofing settings
    2.9 Save settings.
    2.10 Best Practices when working with Microsoft Excel.
    2.11 Inserting Symbols
    2.12 Understanding the worksheet (Columns and Rows, Workbooks, Sheets)
Chapter 3: Excel Workbook and Worksheet
    3.1 Excel Workbook
    3.2 Excel Worksheet
    3.3 Difference between Excel Workbook and Worksheet
Chapter 4: How to Create Charts in Excel?
    4.1 What is a chart?
    4.2 When to Use Each Chart and Graph Type in Excel
    4.3 The significance of charts
    4.4 Step by step example of creating charts in Excel.
Chapter 5: How to make Budget in Excel?
    5.1 Why manage Budget?
    5.2 Major elements of a personal finance system
    5.3 Using Excel to record income and expenses and set personal budgets.
    5.4 Formulas for Income sheet
    5.5 Tutorial Exercise 1
    5.6 Expenditure sheet
    5.7 Formulas for Expenditure sheet
    5.8 Tutorial exercise 2
    5.9 Visualizing the data using charts.
    5.10 Tutorial exercise 3
Chapter 6: Making a Calendar in Excel
    6.1 What is a Calendar in Excel?
    6.2 Steps for Creating a Calendar in Excel
    6.3 Templates for Excel Calendar
    6.4 Limitations of Excel Calendars
Chapter 7: Creating Excel Tables
    7.1 What is an Excel Table?
    7.2 Excel Table Benefits and Drawbacks
    7.3 Preparing Your Data
    7.4 Create an Excel Table
    7.5 Sort and Filter the Data
    7.6 Rename an Excel Table
    7.7 Create Excel Table with Specific Style
    7.8 Show Totals in a Table
    7.9 Modify and Add Totals
    7.10 Refer to any Table Column in a Formula
    7.11 Formula Outside the Table
    7.12 Add a Counter Field
    7.13 Print Excel Table Only
Chapter 8: 11 Best Excel Presentation Tips in 2021
    1. Search for templates online
    2.Name your worksheets correctly
    3.Define your header/title
    4. Dos and don'ts of fonts
    5.Create space for breathing room
    6. Add an image
    7.Go off the grid
    8.Zebra striped
    9.Use tables, graphs, and charts
    10.Create cell styles
    11.Show restraint
Chapter 9: 20 Must-Have Excel Skills for Professionals
    1. Excel Shortcut Keys
    2. Data Sorting
    3. Managing Page Layout
    4. Data Validation
    5. COUNTIF/COUNTIFS
    6. Data Filters
    7. Charts
    8. Cell Formatting
    9. Pivot Tables
    10. SUMIF/SUMIFS
    11. Auditing Formulas
    12. VLOOKUP
    13. Conditional Formatting
    14. Flash Fill
    15. Quick Analysis
    16. Power View
    17. Pivot Charts
    18. Moving Columns into Rows
    19. IF Formulas
    20. Workbook
Chapter 10: Uses of Microsoft Excel in Business
    1. Calculating
    2. Checklist
    3. Charting
    4. Mock-ups
    5. Calendars and schedules
    6. Seating charts
    7. Goal planning worksheet
    8. Inventory tracking
    9. Task list
    10. Accounting
    11. Historical logs
    12. Time logs
    13. Forms
    14. Art and animations
    15. CRM
    16. Mailing list
    17. Project management charts
    18. Sudoku puzzles
    19. Word cloud
    20. Quizzes
    21. Trip planner
Chapter 11: Microsoft Office 2021: What’s New?
    11.1 Changing to a One-Time-Purchase Model
    11.2 Two New Versions of Microsoft Office you can Look Forward To
    11.3 Dark Mode Makes Things Easier
    11.4 Other Big Changes from Microsoft in 2021
    11.5 Automate Data Analysis with Excel’s Ideas Feature
    11.6 Simpler Conditional Formulas with MAXIFS, IFS, and MINIFS
    11.7 Dynamic Arrays
    11.8 Analyze the Quality of Your Data with Power Query
Conclusion