Excel 101: A Beginner’s & Intermediate’s Guide for Mastering the Quintessence of Microsoft Excel (2010-2019 & 365) in no time!

Length: 94 pages
Edition: 1
Language: English
Publisher: 3dtech
Publication Date: 2021-10-27
ISBN-10: 3949804366
ISBN-13: 9783949804366
Sales Rank: #0 (See Top 100 Books)

Sick of seeing “#VALUE!” ? Have you never worked with Microsoft Excel before or do you already know basic functions and elements? Would you like to master the most important features and functions of Microsoft Excel?

Well, if you feel addressed by even one of these questions, this book is the right choice for you! Learn the essential functions of Microsoft Excel (applicable for the versions: 2019, 2016, 2013, 2010 and Office 365). Whether you want to create professional tables, charts, data sheets, analyses or forecasts you will literally master Excel with this guide in no time!

The author of the book is an engineer & Excel expert, who guides you from the basics such as: tables, charts and calculations to the more advanced Developer tools. Step by step and with numerous illustrations as well as colored markings & other didactic hints, you will learn Excel´s most important features.

With this book you can become an Excel professional with minimal (time) effort! After a short introduction to the basic terms, simple functions as well as advanced features are explained in detail throughout this book. Although all functions of the Microsoft Excel ribbon are discussed in detail all features are explained on about 90 pages, avoiding any unnecessary information in order to save your precious time!

Content of the book (short form):

1) Excel Interface & recommended settings

2) Start, Basics Tips & Shortcuts

3) Insert

4) Draw

5) Page Layout

6) Formulas

7) Data

8) Review

9) Developer

10) Excel error messages

This book is generally intended for all people who are interested in mastering Excel or who (have to) work with it in private or professional life. No matter if you use Microsoft Excel 2019, 2016, 2013, 2010 or Excel from Microsoft Office 365, this book offers the essential functions – the quintessence – of the spreadsheet and calculation program. Use this book to start or expand your private and professional (Excel) success.

Legal information

Preface (Important Information about the Book!)

Table of Contents

1 Excel Interface & Settings

1.1 Excel Interface & Important Sections

1.2 Recommended Settings

2 Start, Basic-Tips & Shortcuts

2.1 Shortcuts

2.2 Quick-Analysis Tool

2.3 Formatting in a Nutshell

2.3.1 Adjust Column & Row Width automatically

2.3.2 Insert Options

2.3.3 Autofill & Pattern Recognition

2.3.4 Cell Name & Hide Cell Value

2.4 Unit Conversion

2.5 Find and Replace

2.6 Sort

3 Insert

3.1 Tables

3.1.1 Simple Tables

3.1.2 PivotTables

3.2 Illustrations and Add-Ins

3.3 Charts

3.4 Sparklines

3.5 Slicer

4 Draw

5 Page Layout

6 Formulas

6.1 Relative and Absolute Cell References

6.2 Function Library, Define Names & Formula Evaluation

6.3 Basic Formulas & Important Functions

7 Data

7.1 Get/Transform Data and Queries & Connections

7.2 Filter

7.3 Data Tools

7.4 What-If Analysis

7.5 Forecast Worksheet

8

9 Developer

9.1 Create Code & Macros

9.2 Creating more complex Macros

9.3 Add-Ins: "Data Analysis" & "Solver"

10 Excel Error Messages

10.1 Error #####

10.2 Error #NUM!

10.3 Error #VALUE!

10.4 Error #NA

10.5 Error #NULL!

10.6 Error #NAME?

10.7 Error #DIV/0!

10.8 Error #REF!

10.9 Editing locked & Links, Macros without Function

10.10 Circular Reference

10.11 Number becomes Date

11 Closing Statement