Now as I’ve only been working with excel excessively for the past 2 years, I honestly am just beginning to learn all of what Excel is capable of. 

One thing for sure is it can’t be learned all in one day! There are so many things you can do with this program!

I was just looking over a couple of websites and thought I’d share them with you.

10 Basic Useful Tips: Link

More Useful tips for Beginners: Link

A Brief intro to Excel: Link

Word 2007:

Change Case
To toggle between upper, lower and initial caps. Highlight word and press Shift F3.

Change measurement for margins to inches (or centimeters if you prefer)
Click on the Office button, bottom middle there is a button called Word Options, click on it. Choose Advanced. Scroll down to Display Section,
Across from Show Measurements in Units of, there is drop down to change from centimeters to inches

Simple Shortcuts

• CTRL + C = Copy
• CTRL + X = Cut
• CTRL + V = Paste

Line Spacing
Highlight section you want to change spacing on. Choose Ctrl 1 for Single, Ctrl 2 for Double, Ctrl 5 for 1.5 spacing

To insert a document i.d. or a filename path to your document
Insert Footer, Edit Footer
On Insert Tab, click on drop down menu for Quick Parts. Choose Field.
In the Categories Drop Down Menu (top left hand corner), drop down and choose Document Information
Under Field Names (right below Categories drop down menu), click on FileName
In top right-hand corner under Field Options – Click on Add path to filename Press OK

Turn off check Grammar with Spelling
I like to check my spelling, but not the grammar at the same time. I find it really slows down the process and I have the Check Grammar While You Type on so feel that is enough. If you want to turn off the Check Grammar with Spelling and only enable the Check Spelling, here is how to do it. Click on Office Button, Word Options, Proofing, Scroll down to When Correcting Spelling and Grammar in Word.Unclick Check Grammar with Spelling. Press OK

PrintScreen
To print the active window only, in PrintScreen hold down the Alt key and press Print Screen. Then open a new document and paste (Ctrl v).
To print the entire screen, press the PrintScreen key and then paste it into a blank document.

To continue paragraph numbering
Right click and choose either restart number or continue numbering

Source: Link

Outlook 2007:

To recall a message in Outlook 2007
Go in the Sent message you want to Recall. In the Message tab under Actions, you will see Other Actions in the Toolbar. Click on the arrow down and you will see the option to either Delete Unread copies of this message or Delete unread copies and replace with a new message. You should also click the box Tell me if Recall succeeds or fails for each recipient.

To set a recurring 9-5 meeting (as opposed to clicking all-day meeting)
I don’t like the all-day meeting settings as they are out of sight at the top of the calendar and easily missed. If my boss is going to be away from Monday to Wednesday, I block off the day and set a recurrence for the three days. His calendar then shows blocked time and nobody misses seeing that he is away. To do this Open a New Meeting. At this stage the start and end date should be the same, but the time should be set for how many hours for that day i.e. 9 a.m. to 5 p.m. Set a recurrence. Recurrence should be set to Daily, Every 1 day. Range of occurrence should be set. Put in Start date and click on End by and put in End date. Click OK. Your bosses calendar will now show Monday to Wednesday blocked from 9-5. There is little chance that someone will miss that and double book them.

Send a Meeting Request, without getting replies
You know how it is when you send a meeting request to the whole organization and then get 40 replies in your Inbox. If it is not necessary to see the Replies then just turn off your Request Responses button. To do so choose Invite Attendees. Under Attendees tab, choose the bottom icon called Responses. Arrow down and unclick the Request Responses button.
Turn off automatic email memoryTools, Options, Preferences, E-mail Options, Advanced E-mail OptionsUnclick “Suggest names while completing To, cc and bcc…”

Turn off items being marked as read when your cursor sits on it
On the Tools menu, click Options, and then click the Other tab. Click Reading Pane button. Make sure there is no check mark in the Mark items as read when viewed in the reading pane and the Mark items as read when selection changes check box

To set your default reminder to 15 mins (or whatever you choose)Tools, Options, for Calendar Options, choose the time you want i.e. 15 mins, 30 mins. Etc. Click Apply and OK

To set your email to view b.c.c. in Send bar
Open a new message. Under the Options Tab, click on Fields and choose Show b.c.c.

How to set Out-of-Office Assistant
Tools, Out-of-Office Assistant. Click on I am currently in the office/or I am currently out of the office. Type in message (when you will be away, who to contact in your absence, when you will return). Press OK

Source: Link

Unless your job requires you to wear a uniform, choosing clothing for work can be difficult. Of course there are industry standards, such as the navy blue suit for accountants and bankers. What do you wear, however, if you work in an industry where there really isn’t a typical style of dress? Complicating the matter further are companies that allow more casual attire. How do you keep from crossing over the line from casual to sloppy? What about the job interview? You want to look your professional best, but you also want to appear as if you “fit in”. Here are some pointers for dressing for any type of work situation: 

• First and foremost, no matter what you wear, your clothes should be neat and clean.
• Keep your shoes in good condition.
• Your hair should be neatly styled.
• For women: makeup should be subtle.
• Nails should be clean and neat and of reasonable length.
• Dress for the job you want. If you aspire to be a manager, dress like managers in your company do.

Rules for Casual Dress at Work

Although in theory most people love the idea of not having to wear a suit to work, they are often confused by the casual dress policies some employers have instituted over the last few years. Here are some simple rules:

• Casual doesn’t mean sloppy. Your clothing should still be neat and clean.
• You can’t go wrong with khakis and a sport shirt or a nice sweater.
• If you are going to a meeting or making a presentation, professional attire may be in order.

Dressing for a Job Interview

In addition to following the general rules for dressing for work, heed this advice when you go on a job interview:

• Adhere to the employer’s dress code: find out whether it’s formal (suit and tie) or casual by asking around or by observing employees arriving for work.
• Dress slightly better than you would if you were an employee. For example, if the dress code is very casual, you should take it up a notch.
• Cover up tattoos and remove body jewelry until you know whether they are acceptable at that particular workplace.

Source: Link

Without a doubt, I’ve never heard anyone say they receive way too much appreciation! On the contrary, employees usually complain about NOT receiving the recognition they think they deserve. There are several reasons why people are hesitant to compliment someone on a job well done. Instead of focusing on this, however, let’s take a look at why people should compliment those around them. First, everyone craves appreciation.

These top tips will help you organize your time, improve your communication, and learn new ways to get ahead in your career. These tips will help you make the most of out of your first year and jump start your second.

Here are some tips to help you get started in your new career.
read all »