Android Apps | Ballarat Fire Brigade | Blip.fm | Blackboard | Cool Stickers | Deviantart | EDAR308 | EDFD452 | email | Fractals | ghotit.com | Gimp 2 | Google | ICT leaders day - Nov 2010
| LTC Conference | Markbook | Movie Maker | Photography | Photoshop CS3 | Processing | RedBubble | Smartpen | Tutorials | WebQuests | mview | Weather
Home > Tutorials
> Excel Notes
| Formulas | Examples | Use |
=CHAR(RAND()*(121-97)+97) =CONCATENATE(A3,B3,C3,D3,E3,F3) |
|
Generate Random Passwords
|
|
=VLOOKUP(F3,$U$17:$V$23,2,TRUE)
|
 |
Uses a Lookup table to convert a numeric mark to a grade. See: Markbook Tutorial
|
| =AND((TODAY()-A2)>=30,ISBLANK(C2)) |
|
Format a cell if it's over 30 days old and has not been actioned.
|
APA citation:
Russell, R. (2011, June 09, 06:03 am). Excel Notes
Retrieved February 08, 2012, from
http://www.rupert.id.au/tutorials/excel/index.php
Last refreshed: February 08 2012. 09:15.22 am
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 2.5 License.
