Excel 2007 | How To Protect Selected Cells

Protecting selected cells is a great feature to use if users need access to your spreadsheets. This gives people the option to modify your spreadsheet with the exception of the few cells that you’ve protected. Use this tip if you’re creating forms, schedules or applications! As always, let us know if there are things you [...]

How To Play Sound Across Multiple Slides

This is a great tip for playing sounds (music or narration) across many slides. Whether it’s music or narration, having sound play across your presentation will not only save you time but give your presentation an edge above your competitors. As always, let us what you need help with. You can receive updates automatically via email [...]

Word 2007 | How To Insert Track Changes

    Track changes are used in a document if it’s going to be altered many times. This feature allows you to “track the changes” and go back to the original if you need to. It’s a great tool for contracts, memos, announcements etc. Hope you find this tip useful!   As always, let us know if [...]

Excel 2007 | How To Minimize The Ribbon

   Great tip for creating more space in your spreadsheet is to minimize your ribbon. As you add more data to your spreadsheet, all the space saved is valuable. Try this tip to free up some space! DOWNLOAD THE STEP-BY-STEP INSTRUCTIONS HERE: Excel 2007 | Minimize The Ribbon (PDF)   HOW TO MINIMIZE THE RIBBON [...]

Excel 2007 | Split Information Across Multiple Cells

  This excel tip is useful for common tasks as an administrative assistant. Learn to easily split information across multiple cells in excel. The most common use for this is splitting first and last names, phone numbers, titles etc. Follow the simple steps below and you’ll find how easy it is. The PDF  instructions is a great [...]

Powerpoint 2007 | How To Add A Footer To A Slide

   This is a really cool trick to help kick your presentation up a knotch. Put a footer in all your slides to give it that edge or send the same message throughout your presentation. As always, let us know if there are things you need help with. You can receive these updates automatically through [...]

Excel 2007 | How To Insert A Pop-Up Picture In A Cell

Pop-ups in your Excel spreadsheet make your document look more alive. Use this quick tip to help spice up your presentation! As always, let us know if there are things you need help with. You can receive these updates automatically through email by clicking below: Subscribe to admins4admins.com by Email HOW TO INSERT A POP-UP [...]

PowerPoint 2007 | 2 Steps To Hide The Movie Frame

Two easy steps to hide the movie frame on your PowerPoint presentation: 1. In Normal view, click the movie frame on the slide. 2. Under Movie Tools, on the Options tab, in the Movie Options group, select the Hide During Show check box Click on the link below to download a printable step-by-step pdf. How [...]

PowerPoint 2007 | How To Hide The Sound Icon

   Get rid of the sound icon in your PowerPoint presentations. Here’s how:  Click on the Insert tab of the ribbon. Click the drop down arrow under the Sound icon on the right side of the ribbon. Select Sound from Clip Organizer. Keywords are search terms you would use to narrow the search for a [...]

Excel 2007 | How To Insert Drop-Down List

 Create professional looking spreadsheets by including drop-down lists. Here’s how:    HOW TO FIND THE PASSWORD OPTION IN EXCEL 2007 1. To create a list of valid entries for the drop‐down list, type the entries in a single column or row without blank cells 2. Select the “cell” where you want the drop‐down list. 3. [...]

« Previous Page — Next Page »