Excel 2021

By JIAYI SIMONDS

Description

Want to learn Microsoft Excel and move the work-from-home job chances to the next level?

Are you looking for a simple way to reformat and reorder data in graphs, charts, and tables?

Do you want to acquire new skills and learn more about what MS 2021 has in plan for you? 

Then this book is the best for you, keep on reading.

Microsoft Excel is a spreadsheet application developed by Microsoft that enables users to coordinate, format, and analyze information using formulas. This package is used in the Microsoft Office suite and is consistent with most Office programs. Microsoft has also announced two new Office versions of which you are likely to be involved: Office LTSC (Long Term Servicing Channel) for business clients and Office 2021 for consumers.

If you are brand new to Excel or have experience and understanding of the platform but want to develop your abilities, or if you want to understand more about its advanced functionality and the feature MS office 2021 has brought, this book will take you to the next stage.

This book can thoroughly train you for almost every career direction involving Excel, even those that involve specialized knowledge of the program. After completing this book, you will have direct access to Excel's functionality and understand how to utilize its formulas, features, capabilities, master pivot tables, macros, formulas, VBA, data processing, and how to secure your first work; as an Excel expert!

This book will cover the following topics:

• Basics of MS Excel
• Versions of MS Excel
• Understanding MS Excel
• Uses of MS Excel
• MS Excel 2021, what's new?
• How to make a budget in MS Excel
• Some MS Excels skills and tips

This guide will provide you with the foundational education you need to know how to use Excel proficiently and earn money with your freshly acquired abilities. Thus, what are you awaiting? Go ahead and get your copy.

• Language: English
• Publisher: JIAYI SIMONDS
• Release date: Jun 28, 2021
• ISBN: 9798201436186

Book preview

Excel 2021

––––––––

A Complete Guide To Master Excel's Fundamentals And Understanding Of Advanced Features Such As Sampling Technique, Business Modelling And Numerous Methods Of Data Analysis

JIAYI SIMONDS

© Copyright 2021 by JIAYI SIMONDS - All rights reserved.

This document is geared towards providing exact and reliable information in regards to the topic and issue covered. The publication is sold with the idea that the publisher is not required to render accounting, officially permitted, or otherwise, qualified services. If advice is necessary, legal or professional, a practiced individual in the profession should be ordered.

- From a Declaration of Principles, which was accepted and approved equally by a Committee of the American Bar Association and a Committee of Publishers and Associations. In no way is it legal to reproduce, duplicate, or transmit any part of this document in either electronic means or in printed format. Recording of this publication is strictly prohibited, and any storage of this document is not allowed unless with written permission from the publisher. All rights reserved. The information provided herein is stated to be truthful and consistent, in that any liability, in terms of inattention or otherwise, by any usage or abuse of any policies, processes, or directions contained within is the solitary and utter responsibility of the recipient reader. Under no circumstances will any legal responsibility or blame be held against the publisher for any reparation, damages, or monetary loss due to the information herein, either directly or indirectly. Respective authors own all copyrights not held by the publisher. The information herein is offered for informational purposes solely and is universal as so. The presentation of the information is without contract or any type of guarantee assurance. The trademarks that are used are without any consent, and the publication of the trademark is without permission or backing by the trademark owner. All trademarks and brands within this book are for clarifying purposes only and are owned by the owners themselves, not affiliated with this document.

Contents

Introduction

Chapter No: 1 Introduction To Microsoft Excel

1.1 What is Microsoft Excel?

1.2 History of MS Excel

1.3 Features of Microsoft Excel

1.4 How to open Microsoft excel?

1.5 The Function library

1.6 Some time-saving ways to insert data into Excel

1.7 Microsoft Excel shortcut keys

1.8 Some important Excel formulas

1.9 Mistakes to avoid while dealing with formulas in Excel:

1.10 Excel tricks that can turn someone into an Excel expert

Chapter No: 2 Versions of Microsoft Excel

2.1 Microsoft Excel 1985

2.2 Microsoft Excel 2002 and Microsoft Excel 2003

2.3 Windows Microsoft Excel 2007

2.4 Mac Microsoft Excel 2008

2.5 Microsoft Excel 2010

2.6 Mac Microsoft Excel 2011

2.7 Windows Microsoft Excel 2013

2.8 Microsoft Excel 2016 and Microsoft 365 for windows

2.9 Microsoft Excel 2019

2.10 Microsoft Office 2021

2.11 Microsoft Excel for MAC

2.12 Today's Microsoft Excel

2.13 Microsoft Excel's Future

Chapter No: 3 How to determine the version of Excel you are already using?

3.1 Find the version of Microsoft Excel 2007

3.2 Find the version of Microsoft Excel 2010

3.3 Find the version of Microsoft Excel 2013

3.4 Find the version of Microsoft Excel 2016

3.5 Find the version of Microsoft Excel for Mac

3.6 Find the Microsoft Excel version with the VBA code

Chapter No: 4 How to Use Microsoft Excel?

4.1 Use of the Ribbon

4.2 Components of the Ribbon

4.3 Microsoft Excel Environment Customization

4.4 Customization of ribbon

4.5 Adding custom tabs to the ribbon

4.6 Choosing a color theme

4.7 Settings for formulas

4.8 Proofing settings

4.9 Save settings

4.10 Best Practices when working with Microsoft Excel

4.11 Inserting Symbols

4.12 Understanding the worksheet (Rows, Columns, Workbooks, Sheets)

Chapter No: 5 Uses of Microsoft excel

5.1 Calculation

5.2 Accounting

5.3 Data entry and storage

5.4 Charting

5.5 Inventory tracking

5.6 Calendars and schedules

5.7 Business data collection and verification

5.8 Making a plan

5.9 Seating charts

5.10 Goal planning worksheet

5.11 Managerial and Administrative duties

5.12 Mock-ups

5.13 Getting stuff done

5.14 Task list

5.15 Checklist

5.16 Accounting and budgeting

5.17 Project management charts

5.18 Time logs

5.19 Creating Forms

5.20 Data Analysis

5.21 Quizzes

5.22 Reporting and Visualizations

5.23 Mailing list

5.24 Historical logs

5.25 Art and animations

5.26 Sudoku puzzles

5.27 Word cloud

5.28 Manage expenses

5.29 Forecasting

5.30 Trip planner

Chapter No: 6 Microsoft office 2021

6.1 Converting to a one-time-purchase model

6.2 Two new office versions to look forward to

6.3 Dark Mode simplifies things

6.4 Other significant changes headed to Microsoft in 2021

6.5 Utilize Excel's ideas feature to Automate Data Analysis

6.6 Using MAXIFS, IFS, and MINIFS to create simplified conditional formulas

6.7 XLOOKUP: A more powerful and user-friendly alternative to VLOOKUP

6.8 Dynamic Arrays

6.9 Utilize Power Query to evaluate the quality of the data

Chapter No: 7 Some Excel Presentation tips and Professional skills

7.1 Name the worksheets correctly

7.2 Get a template online

7.3 Define your header or title

7.4 Font do's and do nots

7.5 Create some space for breathing room

7.6 Add an image

7.7 Go off the grid

7.8 The Zebra stripes: Microsoft Excel jungle law

7.9 Use tables, charts, and graphs

7.10 Create cell styles

7.11 Show restraint

7.12 Data Filters

7.13 Data Sorting

7.14 Pivot Tables

7.15 SUMIF or SUMIFS

7.16 COUNTIF or COUNTIFS

7.17 Excel shortcut keys

7.18 Charts

7.19 Cell Formatting

7.20 Managing Page Layout

7.21 Data validation

7.22 Workbook

7.23 Vlookup

7.24 Pivot charts

7.25 Flash fill

7.26 Quick analysis

7.27 Power view

7.28 Conditional formatting

7.29 Moving columns into rows

7.30 IF formulas

7.31 Auditing formulas

Chapter No: 8 How to create Budget in Excel?

8.1 The fundamental components of a personal finance system

8.2 Excel spreadsheets for tracking income and expenses and creating personal budgets

8.3 Formulas for Income sheet

8.4 Exercise 1 of the Tutorial

8.5 Expenditure sheet

8.6 Formulas for Expenditure sheet

8.7 Visualizing the data using charts

Chapter No: 9 Various Methods for Managing or Creating Workbooks/Worksheets

9.1 Design a blank workbook

9.2 Using the excel system to design a template for opening a workbook

9.3 Open a previously created workbook

9.4 An illustration from the business world

9.5 Native or non-native Excel files

9.6 Linking Excel to the External Sources

9.7 Worksheet operations

9.8 Excel worksheet operations

Conclusion

Introduction

Microsoft Excel is a spreadsheet application developed by Microsoft that enables users to coordinate, format, and analyze information using formulas. This package is used in the Microsoft Office suite and is consistent with most Office programs. As with other Microsoft Office services, Microsoft Excel could also be purchased in the cloud through Office 365. Excel operates in the same way as a database, with formulas, records, and functions organized in columns (represented by letters) and the rows (represented by numbers) that can be used to conduct complex calculations. Microsoft released the first version of Excel in 1985, and by the 1990s, it had become one of the world's most widely used and significant computing tools. Excel is also a commonly popular technology installed on almost every private and professional computer on the planet. Simply, Excel is the most convenient tool for organizing and managing financial records, which is why so many companies use it. It enables enough customization and adaptability in its application.

Another reason to use Excel is the simplicity of use. With little to no experience or training, a user can open a workbook, begin inputting data, and review and analyze data. Microsoft Excel is an extremely useful and versatile data collection and documentation tool. It is a spreadsheet application that includes columns and rows, with each intersection of the column and a row being referred to as a cell. Each cell contains a single piece of data or information. By grouping the data