Beginner Excel Lessons
CTRL + Shift Selections
Regionrepitem eastjonespencil1/23/2014centralkillbinder2/9/2014centralsardinepencil2/26/2014centralgillpen3/15/2014westservingpencilall your data has beenselected.selected. thisthis will highlight allyour data.data. select aa cellanywhere,...
editing excel fillable template
Learn about editing cells of locked pages in excel. read how you can lock and edit certain cells in microsoft office
excel dollar function
Excel dollar() functionemploymailhamilton mortonneque.sed@atvelitpellentesque.comchaney barloweu.dui@convalliserat.netlyle harringtonmalesuada.ut@congueelit.netdenton harperfelis.adipiscing@eratnonummy.eduforrest morrisfeugiat@elit.netjordan...
excel left function
Excel left functionmichael heathahmed craneblaze sheppardfletcher chandlerplan bryangarth steinazeem mcleodcolt reenterenter the following inb3.b3.the left()left() functionallows you to return aacertain number ofcharacters from thebeginning of aa...
format social security number
Format social security number new employee listing employee namessnjoseph wright503246990maria reynolds400393687nicole nelson520521bruce oliver502541751mark cook473025442joan medina640924561harry webb230138379503246990 then select d6 and drag the...
name printable form
Full name kimberly cooper rose butler jonathan ramirez bobby weaver james knight kelly burke louise spencer sara hunt dante hicks jean day phillip fosterfirst namefor one reason oranother,another, you may fndit is useful to retrieve thefrst name...
get initials from names
Get initials from namescontact telephone number melissa gardnerjeremy adam andersonharry steven barnesevelyn stevensbilly foxarthur thomas andrews()3168167(546)7376512(922)8142556(080)2955682(618)8153189(637)9096987jane cookevelyn burkejason
Largest Number in Range
The largest number rangeemployeematt jeffersonjessica buckwaltermonthly sales$$16,9,500kim cooper$17,650don mcallen$18,225erica wander sloot$12,675olivia rojo$14,900large(c7:c1large(c7:c12,1)2,1)finding the largestnumber in aa range cancanbe done,...
Smallest Number in Range
The smallest number rangeemployeejerry mcnamaracharles del bruckmonthly sales$$19,8758,400karen cooper$14,445barbara romero$17,995nathan oliviera$17,500jack ruby$16,752thethe small()small() formulacaptures the smallestnumber within aadepicted