Excel 2021: A complete guide for you to understand the utility and functioning of MS Excel

Length: 101 pages
Edition: 1
Language: English
Publication Date: 2021-11-08
ISBN-10: B09LD67QZ7
Sales Rank: #0 (See Top 100 Books)

Are you technologically smart and eager to master new computer programmes?

Do you want to understand how to use a spreadsheet to organise and store vast amounts of data and which Microsoft application to use?

Have you heard of Microsoft Excel and want to learn more about how to use it and how it works?

Have you started working with Microsoft Excel and are still having trouble with it?

You’re meant to operate with Microsoft Excel, but you’re unfamiliar with its features, formulae, functions, and tools?

Don’t be concerned. This book contains the answers to all of your questions.

MS Excel is a Microsoft spreadsheet programme that employs formulas and functions to organise statistics and records. Excel analysis is used by companies of various types all around the world to do financial research. It allows users to store, organise, calculate, and manipulate data using formulae on a spreadsheet system divided into rows and columns.

MS Excel has shown to be a valuable tool for financial and commercial analysis.

The capacity to organise enormous volumes of data into logical spreadsheets and charts in a logical and organised manner. It’s a lot easier to understand and digest data when it’s organised, especially when it’s utilised to produce graphs and other visual data representations.

This book is a tutorial that will teach you how to use MS Excel.

The following chapters are covered in this book: –

Elements of Microsoft Excel
Editing in Excel
Working with Charts

Advanced Data Retrieval
Functions
Shortcut keys in Excel

This book will teach you the basics of how to use the software so you can get started with your MS Excel work. This book includes screenshots for each stage and operation so that you can follow along effortlessly. This book will assist you in getting started with MS Excel projects.

So, don’t waste any more time wondering; purchase your book now and get started.

Introduction
Chapter 1: Elements of Microsoft Excel
    1.1 What is Microsoft Excel, and how does it work?
    1.2 How to work with excel?
    1.3 Excel's menu
    1.4 Minimal Hierarchy
        1.4.1 Series 1: CELL, ROW/COLUMN, WORKSHEET, WORKBOOK FILE OF EXCEL
        1.4.2 Series 2: CELL CALCULATION CHARTING SAVE PREVIEW/PRINT:
        1.4.3 Series 3: Editing Data Entry (changing contents of the cell) Copy/Cut/Paste Data Preview:
        1.4.4 Series 4: Preview of Data Entry Manipulation Analytical Charting Linking:
    1.5 Data Entry
    1.6 Selection Zone
    1.7 Handling of Workbooks and Worksheets
Chapter 2: Editing in Excel
    2.1 Edit the contents of the cells
    2.2 Cells, rows, and columns can be cleared or deleted
    2.3 Remove any cell's contents, formats, or comments
    2.4 Undo & Redo Mistakes
    2.5 Separate text in different cells
    2.6 Replace or find data
    2.7 Text and numbers can be found and replaced
    2.8 Make use of a filtering editing technique
    2.9 Display a subset of rows in a list by using filters
    2.10 You can use wildcard characters to find text or numbers
    2.11 Make columns out of copied text data
Chapter 3: Working with Charts
    3.1 Why Charts are used?
    3.2 The fundamental idea
    3.3 Elements of a Chart
    3.4 Various Type of Charts
    3.5 Creating a Chart
    3.6 Create a Chart in one step
    3.7 Make a chart out of non-adjacent selections
    3.8 Select a different chart type
    3.9 Saving & Retrieval of Charts
Chapter 4: Advanced Data Retrieval
    4.1 Pivot Table
    4.2 Creation of a pivot table report
    4.3 Deletion of a Pivot Table report
    4.4 QUERY: A Reliable inquiry counter
    4.5 How to Retrieve Data
Chapter 5: Functions
    5.1Date & Time Functions
    5.2 Information Functions
    5.3Logical Functions
    5.4Lookup & Reference Functions
Chapter 6: Shortcut Keys in Excel
    6.1 Moving and scrolling in a worksheet or workbook
    6.2 Keys for previewing and printing a document
    6.3 Key for working with worksheets, charts, and macros
    6.4 Keys for use with Pivot Table and PivotChart reports.
    6.5 First and Fast Tip
Conclusion