Lisa A. Bucki

Excel Portable Genius

• Broschiertes Buch

Produktbeschreibung

Your genius-level guide to Excel excellence

Excel Portable Genius covers the key features of Microsoft Excel in a concise, fast-paced, portable format that provides the perfect quick and easy-to-follow reference for novices and experienced users alike. Written by seasoned tech expert and trainer Lisa A. Bucki, it answers the nine key questions Excel users are most likely to face in their work and adds some hot tips and advice on this incredibly useful--but sometimes difficult-to-learn--program's lesser-known features.
_ Build formulas to perform powerful calculations
_ Format data to make it easy to find interpret and to highlight key results
_ Sort and filter to organize or display specific information
_ Chart data to pinpoint changes and identify trends
_ Communicate results by printing and sharing

Complete with a comprehensive index and extensive illustrations complementing straightforward instructions, this is the ideal guide to mastery of the world's most popular spreadsheet program.

Produktdetails

• Portable Genius
• Verlag: Wiley / Wiley & Sons
• Artikelnr. des Verlages: 1W119763610
• 1. Auflage
• Seitenzahl: 240
• Erscheinungstermin: 10. Dezember 2020
• Englisch
• Abmessung: 216mm x 140mm x 13mm
• Gewicht: 80g
• ISBN-13: 9781119763611
• ISBN-10: 1119763614
• Artikelnr.: 60123180

Autorenporträt

Lisa A. Bucki is an author, trainer, and content creator who's been educating others about computers and software since 1990. She's written dozens of books, provided marketing and training services to her clients, and written online tutorials. She is the co-founder of 1x1 Media. Fun, hip, and straightforward, the Portable Genius series gives forward-thinking computer users useful information in handy, compact books that are easy to navigate and don't skimp on the essentials. Collect the whole series and make the most of your digital lifestyle.

Inhaltsangabe

Acknowledgments vii

Introduction xiv

Chapter 1 How Do I Start Using Excel? 2

Starting and Exiting Excel 4

Taking a Look Around 5

Reviewing key screen features 5

Workbooks versus worksheets 8

Changing views 8

Zooming 10

Working with Files 11

Creating a blank file 11

Exploring templates 12

Opening an existing file 13

Switching to another file 14

Making Your First Cell Entries 16

Moving around the sheet 16

Text and values 17

Dates and times 19

Number formatting on the fly 20

Making Selections 21

Understanding cells and ranges 22

Selecting a range 22

Selecting a row or column 23

Working with Sheets 24

Adding, renaming, and jumping to a sheet 25

Moving or copying a sheet 26

Saving and Closing a File 27

Chapter 2 How Do I Make Changes to My Sheet? 30

Cell Editing Basics 32

Making changes 32

Commenting when editing 33

Clearing cell contents 33

Using Undo and Redo 34

Spell-checking your work 35

Copying or Moving a Range 35

Using Paste Special 37

Using Auto Fill and Filling Series 38

Inserting and Deleting Rows, Columns, and Cells 41

Creating Range Names 44

Using the Name box 45

Using the New Name dialog box 46

Assigning multiple range names at once 47

Deleting a range name 48

Using Find and Replace 50

Freezing Rows and Columns On-Screen 51

Chapter 3 How Do I Add Up the Numbers with Formulas? 54

Entering a Basic Formula 56

Typing the formula 56

Cell and range references in formulas 57

Using the mouse to save time 58

Dealing with minor errors 60

Learning More About Operators 60

Understanding Order of Precedence 63

How order of precedence works 63

Using parentheses in formulas 64

Making a Cell or Range Reference Absolute Rather Than Relative 66

Changing the reference type in a formula 66

How referencing works when filling, copying, or moving a formula 67

Showing Formulas in Cells 69

Using Other Formula Review Techniques 70

Chapter 4 When Do I Need to Include a Function? 72

Understanding Functions 74

Using AutoSum on the Home or Formulas Tab 74

Typing a Function in a Formula 77

Using the Formulas Tab to Insert a Function 79

Choosing from the Function Library 79

Using Insert Function to find a function 82

Using Range Names in Formulas 83

Reviewing Some Essential Functions 84

Chapter 5 How Do I Use Formatting to Enhance My Worksheet? 90

Changing the Number or Date Format 92

Using number formats 94

Using date and time formats 96

Using special and custom formats 96

Changing Cell Formatting 99

Applying font formatting 100

Applying alignment formatting 103

Working with Borders and Shading 105

Using Styles 107

Clearing Formatting 109

Understanding Themes 109

Reviewing elements of a theme 109

Changing themes 110

Changing theme colors, fonts, and effects 111

Working with Column Width and Row Height 113

Using Conditional Formatting to Highlight Information 115

Chapter 6 How Do I Use Graphics in Excel? 118

Inserting Simple Graphics 120
&