1 / 17

Excel Basics: Data Entry, Formulas, and Charts

Learn how to effectively enter and manipulate data, use formulas for calculations, and create visual representations with charts in Excel. Explore functions like Goal Seek and Pivot Table to enhance data analysis skills.

pierce
Télécharger la présentation

Excel Basics: Data Entry, Formulas, and Charts

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. C6/ 7.11.2013 Birotica Excel_2 • Prezentaregenerală • Ferestra Excel • Divizarea unei foi de calcul • Blocarea capetelor de tabel • Ascunderea registrelor, foilor de calcul, rânduri, coloane • Tipuri de date • Completarea datelor • Comentariile • Formule (Calcule) • Denumireacelulelor • Copiereaformulelor – adreseabsolute • Inserareafuncţiilor • Insert ~ Chart • Insert ~ Diagram • Insert ~ Picture • Tools ~ Goal Seek • List (Filtru) • Pivot (Table si Chart Report) • Scenarii. … Curs7. Microsoft Power Point

  2. 13. Insert - Chart • Diagrama Column

  3. … 13. Insert - Chart • XY Scater

  4. … 13. Insert - Chart • XY Pie

  5. 14. Insert Diagram

  6. 15. Insert - Picture ~ ClipArt …

  7. 16. Tools ~ Goal Seek • Cat trebuie sa iau la Op. Computer : media sa fie 9? =AVERAGE(C12:C16) Tools ~ Goal Seek

  8. 17. List Orar

  9. … 17. List … Filtru

  10. … 17. List … Filtru

  11. 18. Pivot TabelandChart Report

  12. … 18. Pivot Chart Report Tabel

  13. … 18. Pivot Tabel Chart Report

  14. 19. Scenarii

  15. … 19. Scenarii

  16. … 19. Scenarii

  17. Tema Realizati un tabelutilizandurmatoareleelemente: • Divizareauneifoi de calculsiBlocareacapetelor de tabel, • Ascunderea de rândurisicoloane, • Diverse tipuri de date sicompletarealor, • Comentariile, • Formule (Calcule) cu Denumireacelulelor, • Copiereaformulelor – adrese absolute ~ $, • Inserareafuncţiilor, • Inserarehistograme, grafice, diagrame, imagini • Calculinvers (Goal Seek), • List (Filtru), • Pivot (Tabelsi Chart Report), • Scenarii . . . C6 /7.11.2013

More Related