Recover Unsaved Documents in Microsoft Office 2010

Have you ever forgotten to save a document or closed a document and hit "don’t save" on accident? Well you can recover it to the last auto save by following these simple steps.

• Click the File tab
• Click on Recent
• On the bottom right click Recover Unsaved Documents
• A window will open with a list of your recent unsaved documents

So the next time you accidently hit “don’t save” you don’t have to get frustrated trying to recreate your document.

Excel 2013 Essential Training with: Dennis Taylor- Lynda.com

Whether you’re a novice or an expert wanting to refresh your skillset with Microsoft Excel, this course covers all the basics you need to start entering your data and building organized workbooks. Author Dennis Taylor teaches you how to enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data, and build charts and PivotTables. Other lessons cover the powerful IF, VLOOKUP, and COUNTIF family of functions; the Goal Seek, Solver, and other data analysis tools; and how to automate many of these tasks with macros.



Watch Trailer

Using the Windows SkyDrive in Office 2010

Here is a neat tool that can especially help when you are working on team projects.  Using windows SkyDrive you can save your documents on a SkyDrive account and access them from anywhere you have internet access.  Also, this allows you to give permission for others to edit your documents as well, all without the hassles that come with emailing your documents.

Here are some quick steps on how to save your documents in your SkyDrive.

• Open the file you want to save
• Click the File tab on the ribbon
• Click Save and Send in the left pane
• Click Save to Web
• Click Sign In enter your Windows Live ID and password (if you do not have a Live ID you can get one here.) 
• Click OK

And now you are done! No need to go to another site and upload your documents.  Also, if you have an older version of Office you can still use this feature, it just requires you to download an Add-in.

Facebook Likes

Here is an interesting article I found in Spirit  Magazine’s January 2013 Edition.

“Facebook processes 2.7 billion ‘Likes’ each day. The social media site’s users—who total one billion, or 1/7 of the earth’s population—are giving this feature a big thumbs up.  But the ‘Like’ button wasn’t always so well-liked—or even called ‘Like.’  In a post on the Q-and -A site Quora, Facebook engineering director Andrew Bosworth explains that ‘like was deemed more universal than the company’s first choice, ‘awesome,’ even though initial employee response was lukewarm. ‘We [had] become attached to ‘awesome’ and, comparatively, ‘like’ seem[ed] bland,’ he says. The digital sentiment as we know it today made its official debut in February 2009. Since then, 1.3 trillion ‘likes’ have been recorded. A quite positive development, indeed.”

Microsoft PowerPoint 2010- Speed Keys

There are some easy ways to speed up your presentation and make it easier to maneuver. Rather than having to go through the slideshow tab to view your show you can just press F5.

Once you are in the presentation mode there are several keys that will make it more simple to show exactly what you want seen.  If there is some reason you need to pause your presentation and do not want a slide shown on the screen you can press B on your keyboard and then a black screen will appear. Also you can press W on the keyboard and a white screen will appear.  Once you are ready to resume your presentation press the Esc key to return to the show.

Word 2013 Essential Training with: David Rivers- Lynda.com

Start building better documents with Microsoft Word. In this course, author David Rivers teaches you the basics of creating, editing, and formatting documents in Word 2013. Discover how to leverage templates and building blocks to create a stylish document with instant purpose; collaborate with other writers and editors; create numbered and bulleted lists; and work with tables. Plus, learn to automate these tasks with macros, and use the proofing tools in Word to check spelling, grammar, and more.





Watch Trailer

Microsoft PowerPoint 2010- Slide Master

Slide Master helps make your formatting (background, font, etc.) the same throughout your presentation, without having to change it on every slide. Having consistent formatting throughout your presentation gives it a more professional appearance.   Also, when you have a lot of slides in a presentation, using the Slide Master will save you LOTS of time. So, with that said, here is how you can use it.

• Click on the View Tab on the Ribbon
• Then click Slide Master
• There you can make all your formatting changes and it will apply these changes to all your slides and to any new slides you create 
• To return to your Normal view, look on the far right side of the ribbon and click Close Master View

Electric Slide App

Here is a neat article I found in Spirit magazine’s January 2013 edition, featuring the App of the Month.

“Electric Slide will simultaneously simplify and revolutionize your presentation setup. Upload PowerPoint decks, Word docs, PDFs, photos and videos to this cloud-based service.  Then, swipe a finger across your iOS device’s screen to navigate wirelessly through your content as it is ‘broadcast’ in real time to colleagues or clients on a Web browser- anywhere in the world.”

For more information on this app click here.

Microsoft Excel 2010- Displaying Formulas instead of the Results

Working with formulas in Excel can be a real headache.  This is especially true when checking to make sure you have the right cells selected in your formula.

An easy way to check the accuracy of the content in your formulas is to press Ctrl+tilde (tilde is this key: ~) and repeat the process to return the view back to the results of your formula.

Up and Running with LinkedIn Video from Lynda.com

Join author Richard Colback as he shows you how to get started with the world’s largest professional networking site, LinkedIn. The course demonstrates how to build a profile that will get the attention of employers, recruiters, fellow professionals, and potential clients. Richard walks you through creating an account, adding pertinent information such as skills and work experience, making connections and joining groups, accessing LinkedIn from apps, and monitoring your stats to continuously build a better profile. Along the way, learn to grow your personal brand and become a more visible community member by participating in group discussions, asking and answering questions, and engaging in other ways that add to your profile’s integrity.



Watch Trailer

Microsoft Excel 2010- Adding a Watermark

How many times have you wanted to add a watermark in Excel only to find you can’t?  Well, here is a little trick around that limitation.

In your worksheet, click the Insert tab and in the Text group click Header & Footer.  Now you will look in the Header & Footer Elements group and click Picture.  Select the picture that you would like to use as a watermark and voila! If you need more information about re-sizing and re-positioning your water mark, you can find that listed on point 7 here.

Microsoft Word 2010- Using Smart Art

We all use lists in many different documents well here is a way to make them look more exciting.

1. First, use CTRL+X to cut your list.
2. Then go to the Insert tab where you will find the Smart Art icon to click and then click lists.  There you can pick the style of list that you would like to use.
3. Once selected a type of text box will pop up on your document where you can use CTRL+V to paste you list and it will show up looking nice in the new format and color you selected.

Windows 7 - Snipping Tool

Windows 7 comes with a Snipping Tool to capture a screen shot or snip any object on your screen and then save or share the image.

Go to your Windows icon and type "snipping tool" into the search field.

• Free-form Snip.  Draw an irregular line, such as a circle or a triangle, around an object.
• Rectangular Snip.  Draw a precise line by dragging the cursor around an object to form a rectangle.
• Window Snip.  Select a window, such as a browser window or dialog box, that you want to capture.
• Full-screen Snip.  Capture the entire screen when you select this type of snip.

After you capture a snip, you can then save or share the snip. 

It's a FUN tool.  Try it!

Microsoft Word 2010- Hiding the Ribbon

Do you ever find yourself wanting to view more of your document but the ribbon is in the way?

Well, there is an easy way to hide it.   

• You can press CTRL+ F1 or double click on the title of any tab, except the file tab.
• You can still use the ribbon when it’s hidden just click on the tab you need and it will pop down temporarily.
• To un hide it just repeat the process of CTRL +F1 or double clicking any tab except the file tab.