1. Bækur & afþreying
  2. Bækur og kort
  3. Rafbækur
  4. Fræði- og handbækur
  5. Tölvunarfræði

Microsoft Excel 2019 Step by Step

Rafræn bók. Uppl. sendar á netfangið þitt eftir kaup
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. Útgáfa: 1
Get the product now

Efnisyfirlit

  • Cover Page
  • Title Page
  • Copyright Page
  • Contents
  • Acknowledgments
  • About the Author
  • Introduction
    • Who this book is for
    • The Step by Step approach
    • Download the practice files
    • Ebook edition
    • Get support and give feedback
  • Part 1: Create and format workbooks
    • 1 Set up a workbook
      • Explore the editions of Excel 2019
      • Become familiar with new features in Excel 2019
      • Create workbooks
      • Modify workbooks
      • Modify worksheets
      • Merge and unmerge cells
      • Customize the Excel 2019 app window
      • Skills review
      • Practice tasks
    • 2 Work with data and Excel tables
      • Enter and revise data
      • Manage data by using Flash Fill
      • Move data within a workbook
      • Find and replace data
      • Correct and expand upon data
      • Define Excel tables
      • Skills review
      • Practice tasks
    • 3 Perform calculations on data
      • Name groups of data
      • Create formulas to calculate values
      • Summarize data that meets specific conditions
      • Set iterative calculation options and enable or disable automatic calculation
      • Use array formulas
      • Find and correct errors in calculations
      • Skills review
      • Practice tasks
    • 4 Change workbook appearance
      • Format cells
      • Define styles
      • Apply workbook themes and Excel table styles
      • Make numbers easier to read
      • Change the appearance of data based on its value
      • Add images to worksheets
      • Skills review
      • Practice tasks
  • Part 2: Analyze and present data
    • 5 Manage worksheet data
      • Limit data that appears on your screen
      • Manipulate worksheet data
      • Define valid sets of values for ranges of cells
      • Skills review
      • Practice tasks
    • 6 Reorder and summarize data
      • Sort worksheet data
      • Sort data by using custom lists
      • Organize data into levels
      • Look up information in a worksheet
      • Skills review
      • Practice tasks
    • 7 Combine data from multiple sources
      • Use workbooks as templates for other workbooks
      • Link to data in other workbooks and worksheets
      • Consolidate multiple sets of data into a single workbook
      • Skills review
      • Practice tasks
    • 8 Analyze alternative data sets
      • Examine data by using the Quick Analysis Lens
      • Define an alternative data set
      • Define multiple alternative data sets
      • Analyze data by using data tables
      • Vary your data to get a specific result by using Goal Seek
      • Find optimal solutions by using Solver
      • Analyze data by using descriptive statistics
      • Skills review
      • Practice tasks
    • 9 Create charts and graphics
      • Create charts
      • Perform business intelligence analysis using charts
      • Customize chart appearance
      • Find trends in your data
      • Create combo charts
      • Summarize your data by using sparklines
      • Create diagrams by using SmartArt
      • Create and manage shapes
      • Create and manage mathematical equations
      • Skills review
      • Practice tasks
    • 10 Use PivotTables and PivotCharts
      • Analyze data dynamically by using PivotTables
      • Filter, show, and hide PivotTable data
      • Edit PivotTables
      • Format PivotTables
      • Create PivotTables from external data
      • Create dynamic charts by using PivotCharts
      • Skills review
      • Practice tasks
  • Part 3: Collaborate and share in Excel
    • 11 Print worksheets and charts
      • Add headers and footers to printed pages
      • Prepare worksheets for printing
      • Print worksheets
      • Print parts of worksheets
      • Print charts
      • Skills review
      • Practice tasks
    • 12 Automate repetitive tasks by using macros
      • Enable and examine macros
      • Create and modify macros
      • Click a button to run a macro
      • Run a macro when you open a workbook
      • Insert form controls into a worksheet
      • Skills review
      • Practice tasks
    • 13 Work with other Microsoft Office apps
      • Include Office documents in workbooks and other files
      • Create hyperlinks
      • Paste charts into documents
      • Skills review
      • Practice tasks
    • 14 Collaborate with colleagues
      • Save workbooks for electronic distribution
      • Manage comments
      • Protect workbooks and worksheets
      • Finalize workbooks
      • Authenticate workbooks
      • Save workbooks for the web
      • Import and export XML data
      • Work with OneDrive and Excel Online
      • Skills review
      • Practice tasks
  • Part 4: Perform advanced analysis
    • 15 Perform business intelligence analysis
      • Define a Data Model
      • Define relationships between tables
      • Analyze data by using Power Pivot
      • View data by using timelines
      • Bring in external data by using Power Query
      • Skills review
      • Practice tasks
    • 16 Create forecasts and visualizations
      • Create forecast worksheets
      • Define and manage measures
      • Define and display key performance indicators
      • Create 3D maps
      • Skills review
      • Practice tasks
  • Keyboard Shortcuts
  • Glossary
  • Index
  • Code Snippets

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!

Þú 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
Eiginleikar
Vörumerki: Microsoft Press
Vörunúmer: 9781509306169
Taka af óskalista
Setja á óskalista

Umsagnir

Engar umsagnir
Lesa fleiri umsagnir

Microsoft Excel 2019 Step by Step

Vörumerki: Microsoft Press
Vörunúmer: 9781509306169
Rafræn bók. Uppl. sendar á netfangið þitt eftir kaup
3.790 kr.
Get the product now
3.790 kr.