Solitary Office Search Results

How To: Hide scroll bars, sheet tabs & charts in Excel

This video is a tutorial on how to remove scroll bars, sheet tabs and objects in Excel. To remove scroll bars and sheet tabs, go to the Office button, then Excel Options. On the screen that comes up go to the Advanced tab and scroll down to “Display options for this workbook”, where you will see some check boxes. Uncheck the boxes for horizontal scroll bar, vertical scroll bar and sheet tabs. This will remove them from the current workbook. This feature only works with the current workbook.

How To: Perform the backaround pen spinning trick

Pen spinning is a fun pastime for the school or office environment. Hell, they even have multinational tournaments these days! Improve your pen spinning (pen mawashi) skills with this video tutorial. Learn how to perform the backaround pen spinning trick. The back around trick can be hard to do if you're new to pen spinning, but all it takes is practice.

How To: Save a 2007 Word docx. file as a 2003 Word doc. file

In Word 2007 a lot of things have been changed since word 2003. For instance the file menu is no longer present, it has been replaced by a glowing yellow button which is the office button. If you click on this button, a menu will pop up. In this menu click the save button. It'll give you the option to save your document with a docx extension. The problem with this is that a file with this kind of extension does not open in anything but Word 2007. Instead go into save as and save it as a word ...

How To: Apply for Arizona food stamps

In this video, we learn how to apply for Arizona food stamps. First, you will need to go online and print out the application to receive food stamps from the state. You will also need to print out the information that you will need to bring with you as well as look for an office that is closest to your location. Fill out all of the sections of the application until it's complete. Make sure to use the correct colored pen and don't leave out any information. If you do leave something out, this ...

How To: Create a free website with Office Live

In this video, we learn how to create a free website with Office Live. First, go to the website OfficeLive and sign up for an account. After this, you can get started designing your site. In this window, you will see an editor and a site designer. Through here, you can change the different information that is listed on your site and also change the layout. You can add images, music, videos, and more. You can also create tables and change the text that is written. Have fun with creating your w...

How To: Setup email in Microsoft Office Outlook 2007

In this Software video tutorial you will learn how to setup email in Microsoft Office Outlook 2007. Suppose you have a Yahoo email id and you want it in Outlook, go to tools > account settings > email > new and fill out the details. Then check the box next to ‘manually configure server settings’ and click ‘next’. In the next box, choose the 1st option and click ‘next’. To get the information for filling up in the next box, go to the Yahoo page shown in the video and copy and paste...

How To: Change Excel options directly in the Registry

This video shows us the method to block the formula bar, scroll bars and the status bars in Excel. Click on 'Start' and type 'regedit'. Click on 'regedit' and go to 'HKEY_CURRENT_USER'. Open it and go to 'Software' and 'Microsoft'. Expand it and go to 'Office' and open the version of Office on your computer. Expand it and go to Excel. Choose the options folder. Go to the 'Options' item and right click on it. Go to 'Modify' and type 150 in the text box. Click on 'OK'. Now restart the Excel and...

How To: Copyright a book

You've written the great American novel, and you want to make sure that your story stays yours. Register your copyright and preserve your intellectual rights. In this video, learn how to copyright produced material.

How To: Feng Shui your workspace

Lure luck your way at your workplace by arranging things according to the ancient Chinese design philosophy known as feng shui. De-clutter your desk and workspace, which is the most important thing you can do to balance the _chi_—or energy—in your office. Repair or get rid of anything that’s broken—like a pen that’s out of ink or a flickering desk lamp. They block your chi. The placement of your desk and chair should allow you to see who’s coming into the room. Business and opportunity symbol...

How To: Clear up office clutter

It's easy to find yourself drowning in a pile of papers and nick-nacks if you're not armed with a good organization system. By taking the time to set up a system where everything is condensed and has a place you'll find it much easier to keep it that way.

How To: View email messages by conversation in Microsoft Outlook 2010

Looking for an easy way to consolidate and view your email messages conversations into easy-to-ready threads? This clip will teach you everything you'll need to know. Whether you're new to Microsoft's popular email and scheduling application or a seasoned MS Office professional just looking to better acquaint yourself with the Outlook 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started organizing your own inbox, watch this free video g...

How To: Use the Ribbon interface in Microsoft Access 2010

Before you can work in MS Access 2010, you'll need to learn how to work with it. See how to navigate the Ribbon interface when working in Microsoft Access 2010 with this guide. Whether you're new to Microsoft's popular database management application or a seasoned MS Office professional just looking to better acquaint yourself with the Access 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started using the Backstage view in your own Acces...

How To: Adjust font settings within Microsoft Office Word 2010

Before you can work in Word 2010, you'll need to learn how to work with it. See how to change and style fonts within the Microsoft Word 2010 user interface with this free video software tutorial. Whether you're new to Microsoft's popular word processor or just wish to get to know Word 2010 a little better, you're sure to find much of value in this video lesson. For more and better information, and to get started using custom font settings in Word 2010 yourself, take a look.

How To: Undo and redo actions in Microsoft Office Word 2010

Before you can work in Word 2010, you'll need to learn how to work with it. See how to undo and redo actions the Microsoft Word 2010 user interface with this free video software tutorial. Whether you're new to Microsoft's popular word processor or just wish to get to know Word 2010 a little better, you're sure to find much of value in this video lesson. For more and better information, and to get started undoing and redoing actions with ease in Word 2010 UI, take a look.

How To: Use the Ribbon interface in Microsoft Office Word 2010

Before you can work in Word 2010, you'll need to learn how to work with it. See how to use the Microsoft Word 2010 Ribbon interface with this free video software tutorial. Whether you're new to Microsoft's popular word processor or just wish to get to know Word 2010 a little better, you're sure to find much of value in this video lesson. For more and better information, and to get started navigating the Word 2010 Ribbon UI yourself, take a look.

How To: Export an Adobe Illustrator CS5 image for use in Microsoft Office

Want to use an Illustrator CS5 illustration in a Microsoft PowerPoint presentation or Word document? This video clip will show you how it's done. Whether you're new to Adobe's popular vector graphics editor or a seasoned graphic arts professional interested in better acquainting yourself with the new features and functions of Illustrator CS5, you're sure to benefit from this free software tutorial. For more information, and to get started using this trick in your own Illustrator projects, wat...

How To: Create & work with pivot tables (PivotTables) in Excel

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the nth installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create and work with pivot tables (PivotTables) in Microsoft Office Excel. Specifically, this video covers the following topics and examples:

How To: Count unique values greater than a hurdle in MS Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 56th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use an array formula and the COUNTIF function to count unique records that are greater than a given hurdle (in this case, $30). Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Add a workbook reference to an Excel VLOOKUP formula

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 52nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to have one workbook look into another workbook using a workbook reference. See also how to update workbook references. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Record macros in Excel 2007

In this Microsoft Excel 2007 for Dummies video the instructor shows how to record a Macro. Macros let you create a shortcut to perform a sequence of commands all at once. For example you can create a macro to quickly build a sales report template that you frequently use. When ever you run that macro the Word will automatically build the template for you based on the recorded commands. To write macros you need to have the developer tab enabled. To enable it click on the office button and at th...

How To: Create navigation forms in Microsoft Access 2010

David Rivers shows us how to create navigation forms in Microsoft Office 2010 without writing codes or using logic. A navigation form is kind of like a homepage that will give you a list of reports. There are pre-designed layouts you can choose from to make your navigation form. You will just need to customize your form by adding reports to the navigation pane. What this means for business owners is that you can see customer orders and store reports just by looking at one page. Simple to make...

How To: Create a Post-it note in Photoshop

Now, instead of leaving Post-It notes on a monitor screen, you can create virtual Post-It notes in Adobe Photoshop! This is a quick tutorial for the intermediate to advanced user of Photoshop, showing you how to create a square, yellow graphic that looks strikingly like the Post-It notes you can find at office supply stores! Add to your website, incorporate in PowerPoint presentations, or use wherever you see a need for a virtual sticky note!

How To: Craft an inexpensive skinny notepad

Got a case of the wintertime blues? Then use a snow day or just a boring Sunday afternoon to put together this simple and inexpensive skinny notepad. Yeah, we realize you can purchase notepads at just about any office supply store, but these pretty, beribboned notes will cheer up your day every time you write on them.