microsoft excel

• Excel


  A spreadsheet program that allows you to store, organize, and analyze information
• Spreadsheets


  Developed to store, analyse and manipulate data. They are now commonly used for working with sets of data containing both text and numbers.
• Microsoft Excel


  A computer application program written by Microsoft. It mainly comprises tabs, groups of commands and worksheet. It is mainly used to store tabular data.
• Microsoft Excel


  • It is one of the most suitable spreadsheet functions that help us manage data, create optically logical charts, and thought-provoking graphs. It is supported by both Mac and PC platforms and can also be used to balance a checkbook, create an expense document, build formulas, and edit them.
• Worksheet


  Made of rows and columns that intersect each other to form cells where data is entered. It is capable of performing multiple tasks like calculations, data analysis, and integrating data.
• Main features of Excel

  Microsoft Office button

  Ribbon

  Quick access toolbar
• SUM


  Function to calculate the sum of values
• AVERAGE


  Function to calculate the average of values
• MAX


  Function to find the maximum value
• MIN


  Function to find the minimum value
• Relative cell address


  Excel automatically adjusts part of cell reference as formula is moved or copied
• Absolute cell address


  Using $ to lock cell address so it doesn't change when formula is moved or copied
• Sorting


  Placing records in order alphabetically or numerically
• Sorting data


  Use Sort A to Z or Sort Z to A buttons
• AutoSum


  Helps us to add the contents of a cluster of adjacent cells
• List AutoFill

  Automatically develops cell formatting when a new component is added to the end of a list
• AutoFill


  1. Quickly fill cells with a repetitive or sequential record such as chronological dates or numbers, and repeated document

  2. Copy function

  3. Alter text and numbers
• AutoShapes


  • Toolbar will allow us to draw some geometrical shapes, arrows, flowchart items, stars, and more
  • Can be used to draw graphs
• Wizard


  Guides us to work effectively while we work by displaying several helpful tips and techniques based on what we are doing
• Charts


  Features will help us in presenting a graphical representation of our data in the form of Pie, Bar, Line charts, and more
• PivotTable


  • Flips and sums data in seconds and allows us to execute data analysis and generating documents like periodic financial statements, statistical documents, etc
  • Can also analyze complex data relationships graphically
• AutoFormat - lets us choose many preset table formatting options.
• Shortcut Menus

  These commands that are appropriate to the function that we are doing occur by clicking the right mouse button.