L3 | MAILMERGE

• WORD PROCESSOR

  • computer program or device that provides for input, editing, formatting and output of text often with some additional features.
  • EARLY WP: stand-alone devices often on its function
  • CURRENT WP: word processors programs running on general purpose computers.
• MAIL MERGE

  • used to create multiple documents at once.
  • documents have identical layout, formatting, text, and graphics.
  • Only specific sections of each document varies and is personalized.
• COMPONENTS OF MAIL MERGE

  1. LIST OR DATA FILE (MS EXCEL)
  2. FORM DOCUMENT (MS WORD)
• LIST OR DATA FILE (MS EXCEL)

  • Individual information or data that needs to be plugged in (merged) to our form document is placed and maintained.
• FORM DOCUMENT (MS WORD)

  • Document that contains the main body of the message we want to convey or send.
• COMPLEX FORMULA

  • Combination of more than 2 simple formulas.
• FUNCTIONS

  • Predefined formula that performs calculations using specific values in particular order.
• PARTS:

  • equal sign
  • function name
  • argument

  
• BASIC FUNCTIONS

  • Excel formulas all start with an = sign, followed by the function name and a section in parentheses to provide ranges or arguments.
• BASIC FUNCTIONS:

  • SUM
  • AVERAGE
  • MAX
  • MIN
  • COUNT
• SUM

  • Adds all cells together and gives you the total sum.
• SUM SYNTAX:

  • =SUM(range reference)
• AVERAGE

  • Gives you the average of the selection you provide.
• MAX

  • Returns the largest value from the selection you provide
• MIN

  • Returns the smallest value from the selection you provide
• COUNT

  • Counts how many cells have values in them
• COUNTIF FUNCTIONS

  • COUNTIF
  • COUNTIFS
  • SUMIF
  • SUMIFS
  • IF
• COUNTIF

  • function to count cells that meet a single criteria.
• COUNTIFS

  • function to count cells that meet multiple criteria.
• COUNTIF SYNTAX:

  • =COUNTIF(range, criteria)
• COUNTIFS SYNTAX:

  • =COUNTIFS(range1, criteria1, [range2], [criteria2], ...)
• SUMIF

  • returns the sum of cells that meet a single criteria.
• SUMIFS

  • returns the sum of cells that meet multiple criteria.
• SUMIF SYNTAX:

  • SUMIF=(range, criteria, sum_range)
• SUMIFS SYNTAX:

  • =SUMIFS(sum_range, range1, criteria1, [range2], [criteria2], ..)
• IF

  • Performs a logical test and return one value for a TRUE result, and another for a FALSE result