EMPOWERMENT FINALS

• Microsoft Excel


  Spreadsheet application
• SUM() Function


  Allows to sum numerical data
• SUM() Function


  1. Used to summate the values

  2. Format: =SUM(sum_range)
• Range


  Group or array of cells that contain values
• Criteria


  Value which will define which cells will be summed up
• Sum_range


  Range of cells to be summed up
• AVERAGE() Function


  Allows user to get the average of all the numbers in the chosen cells
• AVERAGE() Function


  Format: =AVERAGE(range to be averaged)
• COUNT() Function


  Used to count the number of chosen cells that have a number value in them
• COUNT() Function


  Format: =COUNT(range to be counted)
• IF() Function


  Allows user to achieve a particular value if the condition has been satisfied, TRUE or not satisfied, FALSE
• IF() Function


  Format: =IF(condition, result if true, result if false)
• VLOOKUP() Function


  To find something on the leftmost column
• VLOOKUP() Function


  1. Format: =VLOOKUP(lookup_value, table_range, column index number, range lookup)

  2. Lookup_value - found in the leftmost column

  3. Table_range - table from which data is retrieved

  4. Column_index_num - column in table array from which number is to be retrieved

  5. Range_lookup - logical value that can be true or false
• CONCATENATE() Function


  Combines 2 or more strings
• CONCATENATE() Function


  Format: =CONCATENATE(text1, text2, text3)
• MAX Function


  Used to search for the highest value
• MAX Function


  Format: =MAX(range)
• MIN Function


  Used to search for the lowest value
• MIN Function


  Format: =MIN(range)
• Conditional Formatting


  To emphasize certain cells with any format they want
• Text to Column


  Opposite of concatenate function
• Data Validation


  Limits what particular value can be entered in a certain cell
• Graphs


  Graphical representation
• Insert Pictures


  Adding pictures in a report
• Wrap Text


  Image & other objects can be surrounded by text
• Text Wrapping Options


  • In line with text
  • Square
  • Tight
  • Through
  • Top and Bottom
  • Behind Text
  • In front if text
• Shapes


  Use in creating flowcharts, diagram, illustration
• Minimalism


  • Do not put too many slides
• Clarity


  • Slides in presentation must be clear
• Insert Shape


  Shape can be added
• Simplicity


  • Do not put entire paragraph
• Visual-orientedness


  • Use relevant graphic design
• Tables


  Useful in organizing informations using rows and columns
• Consistency


  • Slide should be uniform
• Insert Tables


  Tables can be inserted
• Contrast


  • Make the slide presentable
• Slide Master


  Enables the user to apply predesigned slide
• Balance


  Evenly arranged elements throughout the screen
• Tables


  • Useful in organizing infos
  • Easiest way to read and compare datas