Have you ever wondered what all the different cursors do in Excel? Here is a short video to show what they all do and where to place your cursor to achieve your desired task.
Did you know that you can easily insert your pictures from Facebook into a Microsoft Office document? You can in any Microsoft Office program! Click on the Insert tab and in the Illustrations group click Online Pictures. Now when the dialog box opens click on the Facebook logo and once you have logged in you will see all the photos you have posted to Facebook and also ones you have been tagged in. Finally select your photo of choice and click insert.
Have you ever considered switching over and using Office 365? This video gives an overview and examples of how Office 365 could benefit you.
You make sure and back everything else on your computer but have you ever backed up your email? If you are using Microsoft Outlook it is really pretty simple and can save you a ton of hassle if anything should happen to you Outlook. Watch this video to learn how.
Here is a different way to organize your emails in Outlook. You can have the color of your incoming messages from a designated contact automatically set to a color of your choice. Here is how you can set it up.
- Click on the View tab
- On the far left in the Current View group click View Settings
- In the pop up window click Conditional Formatting
- In the next window click Add, now once you have highlighted the new rule (which is labeled Untitled) you can rename it by clicking on it, now click Condition.
- Now click the From button and you can choose a contact or multiple contacts from your address book, and then click OK.
- Lastly click the Font button and change the color and/or font for this rule.
So now when looking at your inbox, you can easily find messages you are looking for just by seeing what color it is.
Many times we are working on multiple documents and switching back and forth between documents. Here is a neat trick that will save you having to switch back and forth to save each one; there is a Save All button that will save all your open Word documents with just 1 click! To be able to use this neat feature we first have to make the button visible. To do that click the File tab, and go to Options. Once in Options, select the Quick Access Toolbar. Now in the drop down menu labeled “Choose Commands from” choose the selection Command Not in the Ribbon. Then scroll down until you see the command Save All with a small icon next to it. Once you have selected this command click the Add button, and finally Ok. Now right above your ribbon in your Quick Access tool bar you will see that same icon. So, next time you need to save multiple Word documents at the same time you can just click on that icon.
Many times when working with a large spread sheet you need to be able to view column headings at any point in your document. You can do this by freezing the panes. First go to the View tab, and in the Window group you will click Freeze Panes. From here you can Freeze you panes based on the cells you have highlighted, the first row, or first column. To unfreeze your panes simply follow these same steps, except when you click Freeze panes this time you will see an Unfreeze Panes option.
Do you ever need the same heading information and/ or formatting in multiple sheets? Instead of inserting the information multiple times into each spread sheets here is how you can enter it only once. Simply hold down the CTRL and click on each Sheet tabs that you would like to group. Typically, the tab for the sheet you are in is white while the others are grey, but now all the sheets that you have grouped will be white. Once you have entered the information and completed the formatting you would like to appear on all your sheets, remember to go back and select an individual Sheet tab to ungroup the sheets.
Excel can be a little tricky in getting exactly what you want to print. In Excel we usually need certain records and/or columns to print, and it isn’t always separated on different pages. Here is a way to have exactly what you need print. First, highlight the cells you would like to print, and then click on the “Page Layout” Tab. In the middle of the “Page Setup” group you will click Print Area. Lastly, in the small drop down list click “Set Print Area”. Now when you go to print your document the only thing that will print will be the cells that you highlighted. If you ever need to print your whole document or change the area you need printed, just follow these same steps but click “Clear Print Area” instead.
Many times we have these great power point presentations that can easily be used to promote your product and/or business, but are limited to showing these presentations in locations where PowerPoint is available. Here is a tip to show you how to save your presentation as a video, so you can show your presentation anywhere you can play a video. Simply open your presentation and click on the File tab, and then select Save and Send. Lastly, in the left hand column, select Create a Video and then select the specific options that you would like your video to have, click the Create Video button, and you can now save your newly created video.