• Complain
LitArk » Books » Home and family

Baddey - EXCEL 2020 CRASH COURSE: The Complete Beginner to Expert Guide That Teaches Everything You Need to Know About Microsoft Excel 2020

Here you can read online Baddey - EXCEL 2020 CRASH COURSE: The Complete Beginner to Expert Guide That Teaches Everything You Need to Know About Microsoft Excel 2020 full text of the book (entire story) in english for free. Download pdf and epub, get meaning, cover and reviews about this ebook. year: 2020, genre: Home and family. Description of the work, (preface) as well as reviews are available. Best literature library LitArk.com created for fans of good reading and offers a wide selection of genres:

Romance novel Science fiction Adventure Detective Science History Home and family Prose Art Politics Computer Non-fiction Religion Business Children Humor

Choose a favorite category and find really read worthwhile books. Enjoy immersion in the world of imagination, feel the emotions of the characters or learn something new for yourself, make an fascinating discovery.

No cover
  • Book:
    EXCEL 2020 CRASH COURSE: The Complete Beginner to Expert Guide That Teaches Everything You Need to Know About Microsoft Excel 2020
  • Author:
  • Genre:
  • Year:
    2020
  • Rating:
    5 / 5
  • Favourites:
    Add to favourites
  • Your mark:
    • 100
    • 1
    • 2
    • 3
    • 4
    • 5

EXCEL 2020 CRASH COURSE: The Complete Beginner to Expert Guide That Teaches Everything You Need to Know About Microsoft Excel 2020: summary, description and annotation

We offer to read an annotation, description, summary or preface (depends on what the author of the book "EXCEL 2020 CRASH COURSE: The Complete Beginner to Expert Guide That Teaches Everything You Need to Know About Microsoft Excel 2020" wrote himself). If you haven't found the necessary information about the book — write in the comments, we will try to find it.

Baddey: author's other books


Who wrote EXCEL 2020 CRASH COURSE: The Complete Beginner to Expert Guide That Teaches Everything You Need to Know About Microsoft Excel 2020? Find out the surname, the name of the author of the book and a list of all author's works by series.


No cover
No cover
Baddey
EXCEL 2020 EXPLAINED: A Well-Explained Guide to Master Microsoft Excel Functions and Formulas from Beginner to Expert Level
No cover
No cover
Baddey
EXCEL 2020 CRASH COURSE: The Complete Beginner to Expert Guide That Teaches Everything You Need to Know About Microsoft Excel 2020

EXCEL 2020 CRASH COURSE: The Complete Beginner to Expert Guide That Teaches Everything You Need to Know About Microsoft Excel 2020 — read online for free the complete book (whole text) full work

Below is the text of the book, divided by pages. System saving the place of the last page read, allows you to conveniently read the book "EXCEL 2020 CRASH COURSE: The Complete Beginner to Expert Guide That Teaches Everything You Need to Know About Microsoft Excel 2020" online for free, without having to search again every time where you left off. Put a bookmark, and you can go to the page where you finished reading at any time.

Light

Font size:

↓
↑
Reset

Interval:

↓
↑

Bookmark:

Make
1234567...16
EXCEL 2020
CRASH COURSE
The Complete Beginner to Expert Guide That Teaches Everything You Need to Know About Microsoft Excel 2020

Aaron Baddey
LEGAL NOTICE
The information contained in this book is for information and educational purposes. No part of this book may be duplicated, transmitted or distributed in any form or by any means, including photocopying, recording, and other mechanical or electronic methods, without the prior written permission of the publisher and the author, except in the case of brief quotations embodied in reviews and other non-commercial uses permitted by copyright law.
Copyright 2020 Aaron Baddey
All right reserved
CONTENTS
Versions of Excel
Expanding or Contracting the Formula Bar
INTRODUCTION
Microsoft Excel in no small way is one of the most used software in the world; it has taken organizations to a new level in the business world. This application software is used by most business organizations of all sizes to carry out financial analysis and operations.
As an individual, it is important to understand that almost every job available in the world today requires the basic Excel skills which are the ability to enter and format data, calculate values and summarize with the use of formulas, creating reports, tables and charts, understanding the relevance of shortcuts and getting to learn new tricks and tips that will enhance the use of Microsoft Excel towards the productivity of the organizations involved in the use of it.
Microsoft Excel is an application with over 1000 features and 100 ribbons commands and it is very easy to get confused in the course of using them. More of a reason, this book is written to help you understand the way Excel is to be used and how to access the features you have been looking for with great efficiency. Lets take you on a journey to exploring the full capability of Excel 2020.
CHAPTER ONE
UNDERSTANDING EXCEL 2020

What is Excel?
In our previous book on Microsoft Excel, we have been able to establish what Excel is all about, but for reference purpose, we will be doing a reappraisal of what was previously discussed.
Excel is an application software that provides worksheets with rows and columns that are used to enter organize and process data into a useful end. This is a software program that uses a spreadsheet to organize numbers and data with formulas and functions. This program software is used by most business organizations of all sizes to carry out financial analyses and operations.
Unlike a word processor, Excel organizes the data in columns and rows. The rows and columns intersect a cell. Each cell contains a single data, such as text, a numerical value, or a formula.

Who Created Excel?
The Excel you see today as one of the leading software programs was developed by Doug Klunder ( lead developer), Jabe Blumenthal (Program manager) Charles Simonyi , and Bills Gate (the founder of Microsoft) corporation in a room at Lion Inn in Bellevue for 3 days to plan what Excel would look like.
The purpose of developing Excel was to make Excel full of features that no one will be able to compete with and most importantly to beat Lotus 1-2-3 in speed and memory which was the then dominating spreadsheet in the market at that time.
Excel was released in 1985 as Mac until 1987 when it was changed to Windows run time environment for the PC. Excel hits its peak in the early Nineties when Window 3.3 surfaced and the only spreadsheet that could work on it was Excel.
Versions of Excel
There are have been 30 different versions of Excel, starting from 1985 up to this present day. Currently, the most used of them all are Excel 2016, 2019, 365, and 2020.
All these versions of Excel are different from each other and their differences cut across both the Windows and Macs. The versions are stated below:
  • Excel 365
  • Excel 2020
  • Excel 2019
  • Excel 2016 and 365
  • Excel 2013 (Windows)
  • Excel 2011 (Mac)
  • Excel 2010 (Windows)
  • Excel 2008 (2011)
  • Excel 2007 (Windows)
  • Excel 2004 (Mac)
  • Excel 2003 (Windows)
  • Older Windows versions are 2002, 2000, 97, 95, 4.0, 3.0, and 2.0
  • Older Mac versions are 2001, 2000, 98, 5, 4, 3, 2 and 1
  • OS/2 versions are 2.2, 2.3 and 3
Features of Excel
As we have been discussing at the initial stage of this book that Excel is one of the most powerful software programs used by almost all business organizations in the world. Now lets talk about a few of its features that have made it relevant especially at this time
  • Password protection: Excel allows you to protect your workbook from unauthorized users from accessing your information by allowing you to create a password.
  • Data filtering: The data filtering tool is a quick and easy way to locate and work with a set of data within a range. A filtered range only shows the rows that meet the criteria specified for a column. There are two commands available in Excel for filtering range which are AutoFilter and Advanced Filter
  • Data sorting: Data sorting is a process of arranging data in a particular logical order. With Excel, you can sort out data in your worksheet either by ascending or descending order
  • Built-in formulae: One of the major operations carried out in Excel is the use of formulas to solve certain problems. With the consciousness that there some works that can be done faster with formulas, Excel is installed with some formulas which are always coming in handy, and some of them are SUM, MIN, MAX, AVERAGE, COUNTIF, COUNTA, TRIM, etc.
  • Creating different charts : Excel allows you to create different charts such as line graphs, pie charts, bar graphs, etc. to illustrate your data in such a way that can be understood easily.
  • Automatically edits results : Excel automatically edits results if any change or correction is made in the cell.
  • File and replace command: Excel allow you to find any data you need whether texts or numbers in the worksheet and replace them with a new one
  • Conditional formatting: Conditional formatting, one of the important features of Excel is used to change the format of the cell. With this feature, you can use the basic font and cell formatting tools such as font colour, number font, cell borders, cell fill colour, etc. You can also change the format of your graphical display of data even with this same feature.
  • Paste Special : while using the copy and paste feature in Excel, you may end up copying the format or formula you dont need when in reality, you only need the value.to avoid this, the paste special feature allows you to bring over the elements of the copied cells rather than copying the format or format alongside it.
  • Flash fill : While on the worksheet working on a task that follows the same sequence, Excel allows you to select the entire range of the cells by pressing Ctrl+E and then apply the action to the entire range.
  • Shortcut keys: This is a feature of Excel that allows you to carry out some operations by just pressing two or three keys altogether. The following are good examples of the Shortcut keys:
Ctrl + E - Flash fill
Ctrl + A To highlight all
  • Hyperlink: The Hyperlink function in excel allows you to create the shortcut of a file or website address for easy access. To locate a hyperlink, click on the Insert tab , in the Links group and then select Hyperlink.
  • Transpose: This is a function in Excel that allows you to the direction of a range of cells to another. A good example is when a range of cells is inputted horizontal and now return to vertical.
Next page
1234567...16
Light

Font size:

↓
↑
Reset

Interval:

↓
↑

Bookmark:

Make

Similar books «EXCEL 2020 CRASH COURSE: The Complete Beginner to Expert Guide That Teaches Everything You Need to Know About Microsoft Excel 2020»

Look at similar books to EXCEL 2020 CRASH COURSE: The Complete Beginner to Expert Guide That Teaches Everything You Need to Know About Microsoft Excel 2020. We have selected literature similar in name and meaning in the hope of providing readers with more options to find new, interesting, not yet read works.


24 Excel MVPs - Excel Insights: A Microsoft MVP guide to the best parts of Excel
Excel Insights: A Microsoft MVP guide to the best parts of Excel
24 Excel MVPs
Excel Insights: A Microsoft MVP guide to the best parts of Excel
No cover
No cover
Abbey
MY EXCEL GUIDE; Beginners, Intermediate, Advanced : Microsoft Excel
Steve Bradley - EXCEL 2022: The All-in-One Beginner to Expert Illustrative Guide | Learn the Basic Fundamentals, the Essential Functions and Formulas in Less Than 10 Minutes per Day With Step-by-Step Tutorials
EXCEL 2022: The All-in-One Beginner to Expert Illustrative Guide
Steve Bradley
EXCEL 2022: The All-in-One Beginner to Expert Illustrative Guide
No cover
No cover
Steven Jones
Excel: The Complete User’s Guide To Microsoft Excel; How To Become An Excel Expert In No Time! (Excel, Microsoft Office, Excel Shortcuts)
No cover
No cover
JORDAN
EXCEL 2021 FOR BEGINNERS: THE COMPLETE DUMMY TO EXPERT PRACTICAL GUIDE WITH EXAMPLES THAT TEACHES EVERYTHING YOU NEED TO KNOW ABOUT MICROSOFT EXCEL 2021 (FORMULAS, FUNCTIONS, VBA & MACROS INCLUSIVE)
No cover
No cover
Baddey
EXCEL 2020 EXPLAINED: A Well-Explained Guide to Master Microsoft Excel Functions and Formulas from Beginner to Expert Level
No cover
No cover
Jordan
ICDL Excel: A step-by-step guide to spreadsheets using Microsoft Excel
No cover
No cover
McFedries
MOS Study Guide for Microsoft Excel Expert Exam MO-201
No cover
No cover
Smadi M
Microsoft Excel Trining: Make Excel work for you
No cover
No cover
Melnyk
Excel VBA: Step by Step Guide to Learn Excel VBA Programming with Screenshots and Example Code
No cover
No cover
SMITH
Excel VBA & Excel Pivot Tables Crash Course: Ultimate Crash Course to Learn It Well and Become an Expert in VBA, Excel Macros & Pivot Tables. Smarter Way to Learn it faster and Remember it longer.
No cover
No cover
Fischer
Excel: QuickStart Guide - From Beginner to Expert (Excel, Microsoft Office)
Reviews about «EXCEL 2020 CRASH COURSE: The Complete Beginner to Expert Guide That Teaches Everything You Need to Know About Microsoft Excel 2020»

Discussion, reviews of the book EXCEL 2020 CRASH COURSE: The Complete Beginner to Expert Guide That Teaches Everything You Need to Know About Microsoft Excel 2020 and just readers' own opinions. Leave your comments, write what you think about the work, its meaning or the main characters. Specify what exactly you liked and what you didn't like, and why you think so.