Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                
Everand Logo

Welcome to Everand!

  • Discover millions of ebooks, audiobooks, and so much more with a free trial

    From $11.99/month after trial. Cancel anytime.

    Excel 2019 Beginner: Excel Essentials 2019, #1
    Excel 2019 Beginner: Excel Essentials 2019, #1
    Excel 2019 Beginner: Excel Essentials 2019, #1
    Ebook188 pages3 hours

    Excel 2019 Beginner: Excel Essentials 2019, #1

    By M.L. Humphrey

    ()

    Read preview

    About this ebook

    In Excel for Beginners, M.L. Humphrey introduced readers to the power of Microsoft Excel. Now in Excel 2019 Beginner comes a guide that is tailored specifically for users of Excel 2019.

     

    In this book, M.L. Humphrey walks users of Excel 2019 through the basics of using the program by focusing on what they need to know to use Excel on a day-to-day basis.

     

    Topics covered include navigating Excel, inputting data, formatting it, manipulating it, and printing the results.

     

    Excel is an incredibly powerful tool, and by the time you're done with this book you'll know what you need to know in order to work with it on a daily basis.

     

    So what are you waiting for? Get started today.

    LanguageEnglish
    PublisherM.L. Humphrey
    Release dateJan 4, 2021
    ISBN9781393009351
    Excel 2019 Beginner: Excel Essentials 2019, #1
    Author

    M.L. Humphrey

    Hi there Sci Fi fans, my name is Maurice Humphrey. I am a Vermont native, husband, father, grandfather, well over 60, Navy veteran, retired IBM engineer, retired printer repairman, Graduated: Goddard Jr. College, VT Technical College, and Trinity College. Over the years I've written technical articles, taught technical classes, and presented at technical conventions. I've been reading science fiction for over 50 years now. First books were "Journey to the Centre of the Earth" by Jules Verne and "The Stars Are Ours" by Andre Norton. I've read and collected many great stories, and a considerable amount of junk ones as well. I'd say by now that I probably have a good idea of what I consider a good story.

    Read more from M.L. Humphrey

    Related to Excel 2019 Beginner

    Titles in the series (3)

    View More
    View More

    Related ebooks

    Enterprise Applications For You

    View More
    View More

    Related podcast episodes

    Related articles

    • UNLIMITED

      Make Office Better

      Sep 22, 2021

      Make Office Better
      2 min read

    • UNLIMITED

      Miscrosoft Excel

      Feb 8, 2021

      Miscrosoft Excel
      5 min read

    • UNLIMITED

      Formatting in Numbers

      Nov 4, 2019

      Formatting in Numbers
      2 min read

    • UNLIMITED

      Summary Sheet In Numbers

      Sep 24, 2019

      Summary Sheet In Numbers
      2 min read

    • UNLIMITED

      Add Data Bars To Cells

      Jul 28, 2021

      Add Data Bars To Cells
      1 min read

    • UNLIMITED

      See Ways To Illustrate Your Data

      Sep 6, 2021

      Microsoft has launched a tool in Excel that provides suggestions on how to illustrate your data. To use it, you’ll either need to be running Excel 2019 or the online version of Excel at www.snipca.com/39295 (it works with free accounts – click ‘Creat

      1 min read

    • UNLIMITED

      Create An Attractive Data Dashboard In Excel

      Sep 22, 2021

      What you need: Windows 7, 8.1 or 10; Excel 2010 onwards Time required: 20 minutes A dashboard is a great way to visualise the data in your Excel spreadsheets, so you can track and analyse the information they contain. Dashboards can include charts, g

      3 min read

    • UNLIMITED

      Make Office Better

      Aug 25, 2021

      MICROSOFT WORD & EXCEL Regular Wikipedia users should consider installing an Office add-in that adds content to your your documents and spreadsheets. First, open Word or Excel, then click the Insert menu, followed by ‘Get Add-ins’. In the screen that

      2 min read

    • UNLIMITED

      Data Analysis In Numbers

      May 30, 2022

      Data Analysis In Numbers
      2 min read

    • UNLIMITED

      Make Office Better

      Nov 4, 2020

      Make Office Better
      2 min read

    • UNLIMITED

      Formatting in Numbers

      Aug 27, 2019

      Formatting in Numbers
      2 min read

    • UNLIMITED

      Make Office Better

      Dec 7, 2022

      Make Office Better
      2 min read

    • UNLIMITED

      Make Office Better

      May 10, 2023

      Make Office Better
      2 min read

    • UNLIMITED

      Make Office Better

      Oct 12, 2022

      Make Office Better
      2 min read

    • UNLIMITED

      Formatting in Numbers

      Oct 15, 2019

      Formatting in Numbers
      2 min read

    • UNLIMITED

      Make Office Better

      Jan 18, 2023

      You can change how information looks in headers and footers depending on whether a page is odd or even. This lets you show, for example, page numbers on the right for odd pages, and on the left for even pages. The precise location of this option vari

      2 min read

    • UNLIMITED

      Make Office Better

      Feb 16, 2022

      Make Office Better
      2 min read

    Related categories

    Reviews for Excel 2019 Beginner

    0 ratings

    0 ratings0 reviews

    What did you think?

    Tap to rate

    Review must be at least 10 words

      Book preview

      Excel 2019 Beginner - M.L. Humphrey

      Excel 2019 Beginner

      ALSO BY M.L. HUMPHREY

      Listing of all books by M.L. Humphrey

      Excel Essentials 2019

      Excel 2019 Beginner

      Excel 2019 Intermediate

      Excel 2019 Formulas & Functions

      Word Essentials 2019

      Word 2019 Beginner

      Word 2019 Intermediate

      PowerPoint Essentials 2019

      PowerPoint 2019 Beginner

      PowerPoint 2019 Intermediate

      Access Essentials 2019

      Access 2019 Beginner

      Access 2019 Intermediate

      EXCEL 2019 BEGINNER

      EXCEL ESSENTIALS 2019 BOOK 1

      M.L. HUMPHREY

      CONTENTS

      Introduction

      Basic Terminology

      Absolute Basics

      Navigating Excel

      Inputting Your Data

      Formatting

      Manipulating Your Data

      Printing

      Conclusion

      Control Shortcuts

      About the Author

      Copyright

      INTRODUCTION

      Microsoft Excel is an amazing program and I am so grateful to have learned it because I use it all the time as a small business owner as well as personally.

      It allows me to organize and track key information in a quick and easy manner and to automate a lot of the calculations I need.

      For example, on a personal level I have a budget worksheet that lets me track whether my bills have been paid, how much I need to keep in my bank account, and where I am financially.

      In my professional career I’ve used it in a number of ways, from analyzing a series of financial transactions to see if a customer was overcharged to performing a text-based comparison of regulatory requirements across multiple jurisdictions.

      (While Excel works best for numerical purposes, it is often a good choice for text-based analysis as well, especially if you want to be able to sort your results or filter out and isolate certain results.)

      The purpose of this specific guide is to teach you the basics of what you need to know to use Microsoft Excel on a daily basis. By the time you’re done with this book you should be able to do over 95% of what you need to do in Microsoft Excel and should have a solid enough grounding in how Excel works and the additional help resources available that you can learn the rest.

      The series does continue with Excel 2019 Intermediate, which covers more advanced topics such as pivot tables, charts, and conditional formatting, and Excel 2019 Formulas & Functions, which goes into more detail about how formulas and functions work in Excel and then discusses about a hundred of those functions, sixty in detail.

      You are welcome to continue with those books but you shouldn’t have to in order to work in Excel on a daily basis. This book should be enough for that.

      It was written specifically for Excel 2019, so all of the screenshots in this book are from Excel 2019 which, as of the date I’m writing this, is the most recent version of Excel.

      However, because this book is about the basics of Excel, even if you are working in a different version of Excel most of what we’ll cover here should be the same. The basic functions of Excel (like copy, paste, save, etc.) haven’t changed much in the twenty-five-plus years I’ve been using the program.

      If you previously purchased Excel for Beginners which was written using Excel 2013, most of the content of this book is the same and you probably don’t need to buy this book as well.

      The visual appearance of Excel 2019 has been changed just enough from the 2013 version to be annoying, so it may help to have the updated screenshots, but don’t feel that you need to buy this book to use Excel 2019 if you’ve already read Excel for Beginners.

      This book is not a comprehensive guide to Excel. The goal here is to give you a solid grounding in Excel that will let you get started using it without bogging down in a lot of information you don’t need when you’re getting started.

      In this book I will often cover multiple ways of doing the same thing to show you the various options available to you. I may not cover all of the possible ways of doing something (I think we’re up to five or six ways of doing the same thing on some of this stuff), but I will usually cover at least two ways.

      I highly recommend learning any of the control shortcuts that I give you. For example, to copy something you can use the Control key and the C key (which I will write as Ctrl + C). The reason to learn these shortcuts is because they have not changed in all the years I’ve been using Excel. Which means that even when Microsoft issues the next version of Excel and moves things around a bit (which they will because that’s one major way they make money is through new product releases) you’ll still know at least one easy way to perform the core tasks.

      Also, when in doubt go with the right-click and open a dialogue version of doing something because that too seems to have remained relatively stable over the years and versions of Excel.

      If what I just said didn’t make sense to you, don’t worry. The first thing we’re going to do is cover basic terminology so that you know what I’m talking about when I say things.

      Alright then. Let’s get started with that.

      BASIC TERMINOLOGY

      First things first, we need to establish some basic terminology so that you know what I’m talking about when I refer to a cell or a row or a column, etc.

      COLUMN

      Excel uses columns and rows to display information. Columns run across the top of the worksheet and, unless you've done something funky with your settings, are identified using letters of the alphabet. As you can see below, they start with A on the far left side and march right on through the alphabet (A, B, C, D, E, etc.).

      If you scroll far enough to the right, you'll see that they continue on to a double alphabet (AA, AB, AC, etc.).

      Columns A through E

      ROW

      Rows run down the side of the worksheet and are numbered starting at 1 and up to 1,048,576 in Excel 2019.

      (Be aware that earlier versions of Excel have less rows in a worksheet so that if you have a lot of data that uses all of the available rows your file may not be compatible with earlier versions of Excel.)

      You can click into any cell in a blank worksheet, hold down the ctrl key, and hit the down arrow to see just how many rows your version of Excel has. To return to the first row use the ctrl key and the up arrow.

      Rows 1 through 6

      CELL

      A cell is a combination of a column and row that is identified by the letter of the column it's in and the number of the row it's in.

      For example, Cell A1 is the cell in the first column and the first row of the worksheet. When you've clicked on a specific cell it will have a darker border around the edges like in the image below.

      Cell A1

      CLICK

      If I tell you to click on something, that means to use your mouse (or trackpad) to move the arrow on the screen over to a specific location and left-click or right-click on the option. (See the next definition for the difference between left-click and right-click).

      If you left-click, this selects the item. If you right-click, this generally creates a dropdown list of options to choose from.

      If I don't tell you which to do, left- or right-click, then left-click.

      LEFT-CLICK/RIGHT-CLICK

      If you look at your mouse or your trackpad, you generally have two flat buttons to press. One is on the left side, one is on the right. If I say left-click that means to press down on the button on the left. If I say right-click that means press down on the button on the right.

      (If you're used to using Word you may already do this without even thinking about it. So, if that's the case then think of left-click as what you usually use to select text and right-click as what you use to see a menu of choices.)

      Not all track pads have the left- and right-hand buttons. In that case, you’ll basically want to press on either the bottom left-hand side of the track pad or the bottom right-hand side of the trackpad.

      Enjoying the preview?
      Page 1 of 1