header

 

More links

AutoHotkey | Android | Arduino | COMM140Fractals | Grammar Checkers | Knots | A Million Dots Activity |  Processing | Processing for Scratch Users | Redbubble | Tutorials | Weather | World Time Meeting Planner | Favicon Generator.


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 December 23, 2024, from
     http://www.rupert.id.au/tutorials/excel/index.php

Last refreshed: December 23 2024. 04:23.03 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.


1011 Visits since June 29, 2007