Excel 2019 for Dummies 1st Edition by Greg Harvey ISBN 9781119513346 1119513340

Excel 2019 for Dummies 1st Edition by Greg Harvey – Ebook PDF Instant Download/Delivery: 9781119513346 ,1119513340
Full download Excel 2019 for Dummies 1st Edition after payment

Product details:
ISBN 10: 1119513340
ISBN 13: 9781119513346
Author: Greg Harvey

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.

Excel 2019 for Dummies 1st Edition Table of contents:

Part 1: Getting Started with Excel 2019

Chapter 1: The Excel 2019 User Experience

Excel’s Ribbon User Interface

Launching and Quitting Excel

Help Is on the Way

Chapter 2: Creating a Spreadsheet from Scratch

So What Ya Gonna Put in That New Workbook of Yours?

Doing the Data-Entry Thing

It Takes All Types

Fixing Those Data Entry Flub-Ups

Taking the Drudgery Out of Data Entry

How to Make Your Formulas Function Even Better

Making Sure That the Data Is Safe and Sound

Saving the Workbook as a PDF File

Document Recovery to the Rescue

Part 2: Editing Without Tears

Chapter 3: Making It All Look Pretty

Choosing a Select Group of Cells

Using the Format as Table Gallery

Cell Formatting from the Home Tab

Formatting Cells Close to the Source with the Mini-bar

Using the Format Cells Dialog Box

Calibrating Columns

Futzing with the Fonts

Altering the Alignment

Doing It in Styles

Fooling Around with the Format Painter

Conditional Formatting

Chapter 4: Going Through Changes

Opening Your Workbooks for Editing

Much Ado about Undo

Doing the Old Drag-and-Drop Thing

Copying Formulas with AutoFill

Cut and Paste, Digital Style

Let’s Be Clear About Deleting Stuff

Staying in Step with Insert

Stamping Out Your Spelling Errors

Eliminating Errors with Text to Speech

Chapter 5: Printing the Masterpiece

Previewing Pages in Page Layout View

Using the Backstage Print Screen

Printing the Current Worksheet

My Page Was Set Up!

From Header to Footer

Solving Page Break Problems

Letting Your Formulas All Hang Out

Part 3: Getting Organized and Staying That Way

Chapter 6: Maintaining the Work sheet

Zooming In and Out

Splitting the Worksheet into Window Panes

Fixed Headings with Freeze Panes

Electronic Sticky Notes

The Range Name Game

Seek and Ye Shall Find …

Replacing Cell Entries

Doing Your Research with Smart Lookup

Controlling Recalculation

Putting on the Protection

Chapter 7: Maintaining Multiple Worksheets

Juggling Multiple Worksheets

Don’t Short-Sheet Me!

Opening Windows on Your Worksheets

Comparing Worksheets Side by Side

Shifting Sheets to Other Workbooks

Summing Stuff on Different Worksheets

Part 4: Digging Data Analysis

Chapter 8: Doing What-If Analysis

Playing What-If with Data Tables

Playing What-If with Goal Seeking

Making the Case with Scenario Manager

Chapter 9: Playing with Pivot Tables

Data Analysis with Pivot Tables

Formatting Pivot Tables

Sorting and Filtering Pivot Table Data

Modifying Pivot Tables

Creating Pivot Charts

Part 5: Life Beyond the Spreadsheet

Chapter 10: Charming Charts and Gorgeous Graphics

Making Professional-Looking Charts

Adding Great-Looking Graphics

Controlling How Graphic Objects Overlap

Printing Just the Charts

Chapter 11: Getting on the Data List

Creating Data Lists

Sorting Data Lists

Filtering Data Lists

Importing External Data

Chapter 12: Linking, Automating, and Sharing Spreadsheets

Using Office Add-ins

Using Excel Add-Ins

Adding Hyperlinks to a Worksheet

Automating Commands with Macros

Sharing Your Worksheets

Editing Worksheets in Excel Online

Part 6: The Part of Tens

Chapter 13: Top Ten Beginner Basics

Chapter 14: The Ten Commandments of Excel 2019

Chapter 15: Top Ten Ways to Manage Your Data

Chapter 16: Top Ten Ways to Analyze Your Data

Index

People also search for Excel 2019 for Dummies 1st Edition:

how to get the 0 to stay in excel
    
excel 2019 for mac
    
excel 2019 for mac free download
    
excel 2019 for mac download
    
how to do basic excel formulas

Tags: Greg Harvey, Excel 2019, Dummies