your favourite ms office process or tool

[StealthPolarBear]

I expect this thread to run to thousands of posts :)

Access compact and repair. Lovely.

Mine's simple. I like flagging things in outlook. I love it when everything has ticks next to it (It doesn't happen often) and hiding columns in excel if something looks too horrible I can just hide it

I like putting stupid/odd bits of clip art onto customers emails, relating to what I think they look like, I don't send them though, so far I've never hit send before removing the pictures.

I don't like the flags, they bother me.

F4 is the best shortcut in office ever, it basically just repeats the last thing you did, so if you formatted a cell [excel] or text [word] then you want to do the same format somewhere else in the document, click on it, press F4 and heypresto - it will change your life

I'm a big fan of the undo button!

Off to try f4, preparing for my life to change.
Format painter is also brilliant

Just tried F4 Scarlett! Amazing!

Wow!!!

Kelly, I don't like the flags, I hate that they're red, it scares me seeing hundreds of red flags in my inbox but I like to go on on my laptop once a week and not connect to internet and do them all, they sit in outbox till I connect and that's the only time that I ever have a nice neat line of ticks, until I turn internet on anyways

I like to concatenate columns.

That sounds painful exexe

Not MS Office, but the Snipping Tool in Accessories (Windows) have changed my life. It's brilliant! You can use it to save absolutely anything in JPeg format. I use it almost every single day in my job.

I am concatenating columns as we speak and using it to run access queries. It's painful though as something keeps corrupting my dh :(

Ouch, feel your pain Stealth, I'm currently trying to make a template spreadsheet for our budgets with formula's and everything

It's his own fault he keeps telling me he can't find my database but won't tell me which one it is. Can anyone blame me for getting the CONCATENATOR out? Thatkl learn him

OneNote in general. It's so useful I've even bought my own copy at home!
It's a dumping ground and notes organiser in one, so easy to use.

V lookup in excel - I use that all the time, so useful.

Concatenate function. Just for the word concatenate, really.

Pivot tables.

I really like Excel. I hate Word and think it is the spawn of the devil.

x posts everyone re concatenate

Do you think we are a bunch of geeks on the quiet?

I have only fairly recently learnt the joys of concatenating and have been pushing the boundaries on vlookup, makes my job sooooo much quicker why why why did no one tell me they were so useful and, actually, fairly simple to use.

Pivot tables .... I love and can any one else share my joy in discovering the beautifu and satisfyingl Spark Lines??

Now if I could just master Macros I'd be unstoppable.

I hate word with a passion, it's useless, I use publisher instead

conditional formatting in excel 2010 (previous versions not nearly as good). best. thing. ever.

One of the things I'm most looking forward to doing when I'm back at work is using excel for vlookup, hlookup, pivot tables and lots of other excel functions. Currently looking for pt finance job and run out of 'home admin' spreadsheets to mess around with. Sad geek!

Has everyone discovered the joys of ctrl shift enter in excel? Haven't fully looked into exactly how it does what it does but it means you can apply formulas to ranges and has saved me loads of time!

Ooh ca what's so good about it in 2010?

at gladyoucame

Oh and if you like vlookup, are you aware of sumif and countif? Think they were new in 2007 and are fantastic - can use with wildcards