Lisa A. Bucki
Excel Portable Genius
Lisa A. Bucki
Excel Portable Genius
- Broschiertes Buch
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…mehr
Andere Kunden interessierten sich auch für
- Paul McFedriesExcel Data Analysis for Dummies36,99 €
- Michael AlexanderMicrosoft Excel 365 Bible59,99 €
- Michael Alexander (TX McKinney)Excel 2019 Power Programming with VBA49,99 €
- Joseph SchmullerStatistical Analysis with Excel For Dummies33,99 €
- Michael Alexander (TX McKinney)Excel Power Pivot & Power Query For Dummies29,99 €
- Peter WeverkaOffice 365 All-In-One for Dummies30,99 €
- Thomas FragaleGetting Great Results with Excel Pivot Tables, Powerquery and Powerpivot41,99 €
-
-
-
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.
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
- 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
- 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
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.
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
&
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
&
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
&
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
&