header

 

More links

Adobe Connect | Adobe Conect Custom Pods | AutoHotkey | Android | Arduino | Blog | COMM140Fractals | Grammar Checkers | Knots | a Million Dots |  Processing | RedBubble | Tutorials | Weather | World Time Meeting Planner |


Home > Tutorials > Excel Notes

Excel Notes

 

Formulas Examples Use

=CHAR(RAND()*(121-97)+97)

=CONCATENATE(A3,B3,C3,D3,E3,F3)

Generate Random passwords

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))

 

Conditional Formatting

 

Format a cell if it's over 30 days old and has not been actioned.

 

 


 

APA citation:
Russell, R. (2016, July 04, 03:39 pm). Excel Notes
     Retrieved October 22, 2017, from
     http://www.rupert.id.au/tutorials/excel/index.php

Last refreshed: October 22 2017. 05:40.55 pm

rupert dot russell at acu dot edu dot au Support Wikipedia

Creative Commons License This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 2.5 License.


4346 Visits since June 29, 2007