|
Published:
October 23, 2018

Excel 2019 For Dummies

Overview

The bestselling Excel book on the market — now in a new edition covering the latest version of Excel!

Excel is the spreadsheet and data analysis tool of choice for people across the globe who utilize the Microsoft Office suite to make their work and personal lives easier. It is estimated that 1 in 7 people on the planet use Microsoft Office! If you’re one of them, and want to get up to speed on the latest changes in Excel, you’ve come to the right place.

Excel 2019 For Dummies has been updated to reflect the major changes and features made to Excel and covers everything you need to know to perform any spreadsheet task at hand. It includes information on creating and editing worksheets, formatting cells, entering formulas, creating and editing charts, inserting graphs, designing database forms, adding database records, using seek-and-find options, printing, adding hyperlinks to worksheets, saving worksheets as web pages, adding existing worksheet data to an existing webpage, pivot tables, pivot charts, formulas and functions, Excel data analysis, sending worksheets via e-mail, and so much more!

  • Get to know the new Excel interface  
  • Become a pro at the spreadsheet and data analysis tool that’s available as part of the Microsoft Office suite
  • Find time-tested and trusted advice from bestselling author and expert Greg Harvey
  • Use Excel to streamline your processes and make your work life easier than ever  before

Written by a bestselling author and seasoned educator, Excel 2019 For Dummies makes it easier than ever to get everything out of this powerful data tool.

Read More

About The Author

Greg Harvey began training business people to use computers and software back in the days of DOS. He is the author of numerous For Dummies books, including all editions of Excel All-in-One For Dummies, Excel Workbook For Dummies, and Excel For Dummies . He has worked as an independent trainer and as an instructor at Golden Gate University.

Sample Chapters

excel 2019 for dummies

CHEAT SHEET

At first glance, you might have a little trouble making sense of the Excel 2019 worksheet window with its many components. Just keep in mind that when you’re unsure of the purpose of a particular command button displayed in the Excel worksheet window, all you have to do is to position the mouse pointer on that button’s icon to have Excel display the button’s name, its shortcut keys (if it has them), and, often, a short description of the button’s function.

HAVE THIS BOOK?

Articles from
the book

When you think "Excel charts," you probably envision a conservative-looking pie or column chart, the kind that financial wizards have been churning out since the 1990s. Excel still makes those charts (very well), but there are also many other options for presenting data in fresh ways that will make your audience sit up and take notice.
Many of the worksheets that you create with Excel require the entry of a series of sequential dates or numbers. For example, a worksheet may require you to title the columns with the 12 months, from January through December, or to number the rows from 1 to 100.Excel’s AutoFill feature makes short work of this kind of repetitive task.
The Conditional Formatting button in Excel 2019 enables you to apply provisional formatting to a cell range based solely on the categories into which its current values fall. The cool thing about this kind of conditional formatting is that should you edit the numbers in the cell range so that their values fall into other categories, Excel 2019 automatically changes their cell formatting to suit.
Excel 2019 offers multiple ways to display your data. After creating an Excel pivot table, you can create a pivot chart to display its summary values graphically in two simple steps: Click the PivotChart command button in the Tools group on the Analyze tab under the PivotTable Tools contextual tab to open the Insert Chart dialog box.
To begin to work on a new Excel 2019 spreadsheet, you simply start entering information in the first sheet of the Book1 worksheet window.Here are a few simple guidelines (a kind of data-entry etiquette) to keep in mind when you create an Excel spreadsheet in Sheet1 of a new workbook: Whenever you can, organize your information in tables of data that use adjacent (neighboring) columns and rows.
Of all the Office 2019 applications, Excel has the most extensive collection of new features. Many of the improvements are within advanced features such as Power Pivot and Get & Transform, but there are plenty of improvements, like new functions and chart types, to make the average user smile as well. This article outlines some of the best new Excel features and explains how to access them.
At first glance, you might have a little trouble making sense of the Excel 2019 worksheet window with its many components. Just keep in mind that when you’re unsure of the purpose of a particular command button displayed in the Excel worksheet window, all you have to do is to position the mouse pointer on that button’s icon to have Excel display the button’s name, its shortcut keys (if it has them), and, often, a short description of the button’s function.
Here’s a formatting technique for formatting in Excel2019 that doesn’t require you to do any prior cell selecting. (Kinda figures, doesn’t it?) The Format as Table feature is so automatic that the cell cursor just has to be within the table of data prior to you clicking the Format as Table command button in the Styles group on the Home tab.
How you enter values into an Excel 2019 worksheet determines the type of number format that they get. Here are some examples of how the Excel number format works: If you enter a financial value complete with the dollar sign and two decimal places, Excel assigns a Currency number format to the cell along with the entry.
Excel macros allow you to automate commands to simplify your tasks. Excel 2019 enables you to add an optional Developer tab to the Ribbon that contains its own Record Macro command button (among other command buttons that are very useful when doing more advanced work with macros). To add the Developer tab to the Excel 2019 Ribbon, follow these two steps: Click File → Options or press Alt+FT to open the Excel Options dialog box.
Excel pivot tables are so very versatile because they enable you to easily analyze summaries of large amounts of data by using a variety of summary functions (although totals created with the SUM function will probably remain your old standby). When setting up the original Excel pivot table, you make several decisions: what summary function to use, which columns (fields) the summary function is applied to, and which columns (fields) these computations are tabulated with.
By assigning descriptive names to cells and Excel ranges, you can go a long way toward keeping on top of the location of important information in a worksheet. Rather than try to associate random cell coordinates with specific information in Excel 2019, you just have to remember a name. You can also use range names to designate the cell selection that you want to print or use in other Office 2019 programs, such as Microsoft Word or Access.
When you create a new Excel pivot table, you’ll notice that Excel 2019 automatically adds drop-down buttons to the Report Filter field, as well as the labels for the column and row fields. These drop-down buttons, known officially as filter buttons in Excel, enable you to filter all but certain entries in any of these fields, and in the case of the column and row fields, to sort their entries in the table.
After creating the field names in Excel and one record of the data list and formatting them as a table, you’re ready to start entering the rest of its data as records in subsequent rows of the list. The most direct way to do this in Excel 2019 is to press the Tab key when the cell cursor is in the last cell of the first record.
When viewing your workbook in Excel 2019, page setup can make a world of difference, Excel 2019 gives you lots of options for setting up your page. The Page Setup group of the Page Layout tab contains the following important command buttons in Excel 2019: Margins button to select one of three preset margins for the report or to set custom margins on the Margins tab of the Page Setup dialog box.
Excel 2019 lets you create customer headers and footers. Most of the time, the stock headers and footers available on Excel’s Header button’s and Footer button’s drop-down menus are sufficient for your report-printing needs. Occasionally, however, you may want to insert information not available in these list boxes or in an arrangement that Excel doesn’t offer in the ready-made headers and footers.
Excel 2019 offers a ton of great features, including the summary report or summary worksheet. The Excel summary report recaps or totals the values stored in a bunch of other worksheets in the workbook.The best way that to learn how to create a summary worksheet is to walk through the procedure of making one (entitled Total Projected Income) for a fictional company.
You can tell right away that an Excel 2019 formula has gone haywire because instead of a nice calculated value, you get a strange, incomprehensible message. This weirdness, in the parlance of Excel 2019 spreadsheets, is an error value. Its purpose is to let you know that some element — either in the formula itself or in a cell referred to by the formula — is preventing Excel from returning the anticipated calculated value.
Microsoft offers several Office Online web apps for Word, Excel, PowerPoint, and OneNote as part of your Windows account and OneDrive storage in the cloud. You can use Excel Online to edit worksheets saved on your OneDrive online right within your web browser.This comes in real handy for those occasions when you need to make last-minute edits to an Excel sheet but don’t have access to a device on which Excel 2019 is installed.
Excel 2019 makes it easy to insert online 2-D and 3-D graphic images into your worksheet. The Online Pictures dialog box enables you to use Microsoft’s Bing search engine to search the entire web for 2-D images to use in your Excel sheet. If that’s not enough, you can also download images that you’ve saved in the cloud on your Windows OneDrive.
Excel 2019 offers a wide variety of keystrokes for moving the cell cursor to a new cell. When you use one of these keystrokes, the program automatically scrolls another part of the worksheet into view, if required by the size of your device’s screen and its resolution. The following table summarizes these keystrokes, including how far each one moves the cell pointer from its starting position.
Every data list you put together in Excel will have some kind of preferred order for maintaining and viewing the records. Depending on how you sort Excel to view that list, you may want to see the records in alphabetical order by last name. In the case of a client data table, you may want to see the records arranged alphabetically by company name.
Excel 2019 runs only under the Windows 10 operating system. This means that if your PC is running Windows 7 or (heaven forbid) Windows 8, you must upgrade before you can successfully install and run Excel 2019. Starting Excel 2019 from the Windows 10 Start menu Windows 10 brings back the good old Start menu that many of you remember from much earlier Windows versions.
Office 2019 is the most touch-aware Office version to date, with features that can annotate Office files with comments and sketches, convert handwriting to text, and even convert freehand drawings to vector line art images. All these activities are collectively known as inking. Some of the inking features are available only if you have a touchscreen device such as a Microsoft Surface computer and an active stylus, but other features work with any touch-screen device (even if you are just using your finger to draw), and still others can be used on non-touch devices by "drawing" with an ordinary mouse or trackball.
To help you get your bearings, here’s a quick rundown on the different components of the Excel 2019 Worksheet window, from left to right and from top to bottom: The top row of the Excel window to the left of the centered filename contains the Quick Access toolbar with its default AutoSave, Save, Undo, and Redo command buttons.
You can add text comments to particular cells in an Excel 2019 worksheet. Comments act kind of like electronic pop-up versions of sticky notes. For example, you can add a comment to yourself in Excel to verify a particular figure before printing the worksheet or to remind yourself that a particular value is only an estimate (or even to remind yourself that it’s your anniversary and to pick up a little something special for your spouse on the way home!
If you’re looking for a quick rundown on what’s cool in Excel 2019, look no further! Just a cursory glance down the first few items in this list tells you that the thrust of the features is being able to be productive with Excel 2019 anytime, anywhere! Complete cloud file support: The Excel Save (File→Save) and Open (File→Open) screens make it a snap to add your OneDrive or company’s SharePoint team site as a place to store and edit your favorite workbooks.
Excel’s Filter feature makes it a breeze to hide everything in a data list except the records you want to see. To filter the data list to just those records that contain a particular value, you then click the appropriate field’s AutoFilter button to display a drop-down list containing all the entries made in that field and select the one you want to use as a filter.
You need to understand how to work with more than one Excel worksheet in a workbook, but it’s also important to understand why you’d want to do such a crazy thing in the first place. The most common situation is, of course, when you have a bunch of Excel sheets that are related to each other and, therefore, naturally belong together in the same workbook.
https://cdn.prod.website-files.com/6630d85d73068bc09c7c436c/69195ee32d5c606051d9f433_4.%20All%20For%20You.mp3

Frequently Asked Questions

No items found.