shoegal68
LIF Toddler
Member since 6/08 422 total posts
Name:
Sandy
|
Microsoft Office
most jobs require that you be Proficient in MS Office. i am currently employed but don't use ALL the applications on a regular basis. i use outlook & word on a regular basis & excel once in awhile. i would't consider myself proficient.
i have signed up for training classes in the past but feel because i don't use on a regular basis that i couldn't really apply what i learned.
my question is are there any training material/study guides that will bring me up to me snuff & possibly give my confidence to apply to these jobs 
any advice would be appreciated
thanks!
|
karabara
LIF Adult
Member since 8/07 1153 total posts
Name:
|
Re: Microsoft Office
yes, i agree. i think unless you are going to be in a data oriented role, access is not used by too many companies. But, if you have time, you might want to at least have a familiarity with it. I know DH's company uses access a tiny bit so he has to know how to get data out of it.
I use(d) excel a lot in my job, so from my experience, here are a few things that are pretty commonly used in excel. Some may be more intermediate/advanced, but pick out what ever you think will be useful to you. The later versions of excel have great "help" functions. I think some formulas, like vlookup, actually have a pop up that tells you what to do. Or, you can always use the wizard function for most things. I highly recommend wizard 
Basic Functions:
-adding/deleting rows, columns, tabs
-labeling tabs
-creating charts & graphs
-formatting page (page set up)
-formatting text
-copy/paste
-understand what a formula "data range" is and how to locate it
Intermediate/Advanced Functions:
-Formulas (know how to build them, know how to do multiplication, division, addition, subtraction)
-Pivot tables
-Vlookup
-Anchoring cells in formula
-Basic statistics/formulas: Avg, countif, sum,
-filtering data
-sorting data
I hope this helps! And, if you have any Q's feel free to FM me and I'll help you if I can.
Message edited 1/8/2010 8:36:22 AM.
|
tourist
Member since 5/05 10425 total posts
Name:
|
Re: Microsoft Office
Posted by queensgal
I would focus on excel and powerpoint - most places don't use access or the other office applications.
Good Luck!
We use Access, but don't expect people to know how to.
I know how you feel-I work in the only marketing department that doesn't use use Powerpoint. I know I can, I did for 1 project in college, but I haven't used it in years & I'm sure it has been updated, so I feel like if I were applying for a job, I'd have to make up powerpoint presentations for no reason just to practice.
|
