Excel Spreadsheet

Excel Spreadsheet

1. Home

   • Font
     • basic typing
     • type in numbers and letters
     • change the layout of cells
     • edit text
   • alignment
     • edit the position of text or unmbers in cell
   • number
     • change the format of numbers
       • currency
       • general
       • percentage
   • Editing
     • edit the cells format
       • use a function to change the cells properties
       • Fill- continue with a set pattern for multiple cells
       • find and search
       • clear- delete everything in that cell

2. Insert

   • Tables
     • add tables to make work look professional and to add clarity to work as it will be easier to use
   • illistartions
     • charts
       • are used to add a clear final presentation of the data used in spreadsheet
       • bar charts, line charts, pie charts , scatter charts.
     • add pictures and logos to spreadsheet
   • Links
     • use hyper links to link your spreadsheets to other attachments which make it easier than searching up the website or finding the attachment
     • saves space on your spreadsheet

3. Page Layout

   • Pre defined Themes and formatting tool bars
     • can add different effects
       • looks prettier
     • use different fonts
     • different colours
   • page setup
     • different size margins to fit your size of spreadhsheet whilst keeping it clean
     • change the options for your spreadsheet
       • change the background
     • Print
       • have different options on how to print your work such as in different sections

4. Formulas

   • =AVERAGE
   • =SUM
   • =HIGHEST
   • =LOWEST
   • IF STATEMENT
   • Autosum
   • use suitable formulas for different purposes
   • data with functions in automatically update when data is chanhed

5. Data

   • import
     • import data to create specific spreadsheets by using different functions
   • export
     • use data from spreadsheet and other sources and create new spreadsheets from this
     • use web to search up sources

6. Operating systems providers

   • microsoft excel
   • numbers (apple)