Efnisyfirlit

• Cover
• Introduction
  • About This Book
  • How to Use This Book
  • What You Can Safely Ignore
  • Foolish Assumptions
  • How This Book Is Organized
  • Conventions Used in This Book
  • Beyond the Book
  • Where to Go from Here
• 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
• About the Author
• Connect with Dummies
• End User License Agreement

UM RAFBÆKUR Á HEIMKAUP.IS

Bókahillan þín er þitt svæði og þar eru bækurnar þínar geymdar. Þú kemst í bókahilluna þína hvar og hvenær sem er í tölvu eða snjalltæki. Einfalt og þægilegt!

Rafbók til eignar
Rafbók til eignar þarf að hlaða niður á þau tæki sem þú vilt nota innan eins árs frá því bókin er keypt.

Þú kemst í bækurnar hvar sem er
Þú getur nálgast allar raf(skóla)bækurnar þínar á einu augabragði, hvar og hvenær sem er í bókahillunni þinni. Engin taska, enginn kyndill og ekkert vesen (hvað þá yfirvigt).

Auðvelt að fletta og leita
Þú getur flakkað milli síðna og kafla eins og þér hentar best og farið beint í ákveðna kafla úr efnisyfirlitinu. Í leitinni finnur þú orð, kafla eða síður í einum smelli.

Glósur og yfirstrikanir
Þú getur auðkennt textabrot með mismunandi litum og skrifað glósur að vild í rafbókina. Þú getur jafnvel séð glósur og yfirstrikanir hjá bekkjarsystkinum og kennara ef þeir leyfa það. Allt á einum stað.

Hvað viltu sjá? / Þú ræður hvernig síðan lítur út
Þú lagar síðuna að þínum þörfum. Stækkaðu eða minnkaðu myndir og texta með multi-level zoom til að sjá síðuna eins og þér hentar best í þínu námi.



Fleiri góðir kostir
- Þú getur prentað síður úr bókinni (innan þeirra marka sem útgefandinn setur)
- Möguleiki á tengingu við annað stafrænt og gagnvirkt efni, svo sem myndbönd eða spurningar úr efninu
- Auðvelt að afrita og líma efni/texta fyrir t.d. heimaverkefni eða ritgerðir
- Styður tækni sem hjálpar nemendum með sjón- eða heyrnarskerðingu