|
* 1 - EXCEL | Do you master the basics of the formulas synthax (absolute refs, impact for brackets...) and the basic functions use (condition, concatenation, restrict or condition the display of results…)? |
| |
|
|
|
* 2 - EXCEL | Can you manage very big spreedsheets to get a nice layout, a confortable for reading print out (e.g. optimizing fonts and color codes use, repeat headers and 1st column on all pages...) and being a team-friendly workbook? |
| |
|
|
|
* 3 - EXCEL | Can you create easily codes (refs), then search and display automatically the info linked to codes? |
| |
|
|
|
* 4 - EXCEL | Can you find the number of occurrences, one or more occurrences of an item (e.g. count how many time is a ref in a list or find the info linked to its 2nd or 3rd occurrence)? |
| |
|
|
|
* 5 - EXCEL | Do you know how to display automatically alerts based on the content of a cell (especially usefull for deadlines)? |
| |
|
|
|
* 6 - EXCEL | Do you know how to display automatically the progress of your projects, how to make a calculation on a date range (e.g. invoices between date A and date B), how to make time calculations (time x money, time % etc)? |
| |
|
|
|
* 7 - WORD | Do you use Word in a typographical way (meaning using stylesheets, tabulations and vertical spacing instead of spaces and returns, paragraph auto numbering, columns, text wraping, auto table of content…) and do you manage to clean your doc (add unbreakable spaces, remove double spaces, use efficiently search/replace)? |
| |
|
|
|
* 8 - IMAGES | Do you understand the "images language": files format (jpg, tif…), resolution (72 dpi, 300 dpi…), color modes (RGB, CMYK…), color profiles (sRVB…), why the needs are different depending on the media (print, web…)? |
| |
|
|
|
* 9 - PDFs | Are you aware of the traps of every media, do you know the traps and advantages when using pdfs and how to create the best pdfs for which use? |
| |
|
|
|
* 10 - WEB | Do you know the web encoding, how to update a website, validate it and upload the updated pages? (this is the last question, thanks for your participation) |
| |
|
|
|