Productivity Tools Flashcards
visualization or drawing that is in form of pictures, Clip Art, Shapes, SmartArt, charts or screen clippings. You can insert illustrations easily using the Illustrations group in the Insert tab.
Illustration
is a word processing feature that allows you to easily create multiple letters, labels, envelopes, nametags, or catalogue documents to a group of people as stored in a list in a database or spreadsheet.
Mail merge
Three components of mail merge
Main document
Data source
Merge document
the letter which contain the mail information for each of the merged
document that can be letter, stationary or template. It also contains the field names
which contain the instructions for carrying out the merge.
Main document
-it is also called data file which comprises the information to be merged into a document such as the list of names and addresses to be use in a mail merge. This must be connected to the data source before it can use the information in it.
Data source
this is also a word processing document that is the generated output after executing the merge process.
Merge document
In mail merge, you need to
- Create the main document
- Create data source
- Merge data with document
is the combination of more than two simple formulas One of the key features of excel is the ability to calculate complex formula.
Complex formula
is a predefined formula that performs calculations using specific values in a particular
order.
Functions
EXCEL FORMULAS
IF
VLOOKUP
EXCEL CONCATENATE FUNCTION
EXCEL COUNT AND COUNTIFS
= IF (logical_test, value_if_true, value_if_false)
If
= VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])
Vlookup with dropdown list
• = CONCATENATE (text1, [text2],..)
• = text1& “” & text2
Excel concatenate
• = COUNTIFS (range, criteria)
Excel Count and CountIfs
