عنوان

Excel 2019 Bible /

1119514762

1119514770

111954937X

9781119514763

9781119514770

9781119549376

1119514789

9781119514787

Excel 2019 Bible /

[Book]

Michael Alexander, Dick Kusleika ; previously by John Walkenbach.

Indianapolis, IN :

Wiley,

[2018]

1 online resource

Includes index.

Cover; Title Page; Copyright; About the Authors; About the Technical Editors; Credits; Acknowledgments; Contents; Introduction; Is This Book for You?; Software Versions; Conventions Used in This Book; Excel commands; Typographical conventions; Mouse conventions; How This Book Is Organized; How to Use This Book; What's on the Website; Part I: Getting Started with Excel; Chapter 1: Introducing Excel; Understanding What Excel Is Used For; Looking at What's New in Excel 2019; Understanding Workbooks and Worksheets; Moving around a Worksheet; Navigating with your keyboard.

Chapter 2: Entering and Editing Worksheet DataExploring Data Types; Numeric values; Text entries; Formulas; Entering Text and Values into Your Worksheets; Entering numbers; Entering text; Using Enter mode; Entering Dates and Times into Your Worksheets; Entering date values; Entering time values; Modifying Cell Contents; Deleting the contents of a cell; Replacing the contents of a cell; Editing the contents of a cell; Learning some handy data-entry techniques; Automatically moving the selection after entering data; Selecting a range of input cells before entering data.

Formatting numbers by using the Format Cells dialog boxAdding your own custom number formats; Chapter 3: Performing Basic Worksheet Operations; Learning the Fundamentals of Excel Worksheets; Working with Excel windows; Moving and resizing windows; Switching among windows; Closing windows; Activating a worksheet; Adding a new worksheet to your workbook; Deleting a worksheet you no longer need; Changing the name of a worksheet; Changing a sheet tab color; Rearranging your worksheets; Hiding and unhiding a worksheet; Controlling the Worksheet View; Zooming in or out for a better view.

Navigating with your mouseUsing the Ribbon; Ribbon tabs; Contextual tabs; Types of commands on the Ribbon; Accessing the Ribbon by using your keyboard; Using Shortcut Menus; Customizing Your Quick Access Toolbar; Working with Dialog Boxes; Navigating dialog boxes; Using tabbed dialog boxes; Using Task Panes; Creating Your First Excel Workbook; Getting started on your worksheet; Filling in the month names; Entering the sales data; Formatting the numbers; Making your worksheet look a bit fancier; Summing the values; Creating a chart; Printing your worksheet; Saving your workbook.

Using Ctrl+Enter to place information into multiple cells simultaneouslyChanging modes; Entering decimal points automatically; Using AutoFill to enter a series of values; Using AutoComplete to automate data entry; Forcing text to appear on a new line within a cell; Using AutoCorrect for shorthand data entry; Entering numbers with fractions; Using a form for data entry; Entering the current date or time into a cell; Applying Number Formatting; Using automatic number formatting; Formatting numbers by using the Ribbon; Using shortcut keys to format numbers.

0

8

8

8

8

The complete guide to Excel 2019 Whether you are just starting out or an Excel novice, the Excel 2019 Bible is your comprehensive, go-to guide for all your Excel 2019 needs. Whether you use Excel at work or at home, you will be guided through the powerful new features and capabilities to take full advantage of what the updated version offers. Learn to incorporate templates, implement formulas, create pivot tables, analyze data, and much more. Navigate this powerful tool for business, home management, technical work, and much more with the only resource you need, Excel 2019 Bible.-Create functional spreadsheets that work -Master formulas, formatting, pivot tables, and more -Get acquainted with Excel 2019's new features and tools Whether you need a walkthrough tutorial or an easy-to-navigate desk reference, the Excel 2019 Bible has you covered with complete coverage and clear expert guidance.

OverDrive, Inc.

265827FE-D422-4A91-929C-0D3B277593C1

9781119514787

Microsoft Excel 2019 Bible

Microsoft Excel (Computer file)

Microsoft Excel (Computer file)

Business-- Computer programs.

Electronic spreadsheets.

Business-- Computer programs.

COMPUTERS-- Desktop Applications-- Spreadsheets.

Electronic spreadsheets.

COM-- 054000

Alexander, Michael,1972-

Kusleika, Dick

Walkenbach, John.

20200822154438.0

pn

[Book]

Y