Microsoft Excel 2007
22 Stories
Use Excel 2007's Date feature to stay on top of deadlines
Techguide Excel will highlight any dates that fall within the parameters you set.
Tags: Microsoft Office, Microsoft Corp., Renewal, C, Borders Books & Music, Database, Microsoft Excel 2007, Microsoft Excel, Microsoft Word 2007, Microsoft Access
Print a graphic in an Excel header--sort of
Techguide Excel doesn't make it easy to use graphics in the header/footer section, but don't let that stop you. Use Excel's Print Titles feature to create a pseudo header.
Tags: Microsoft Office, Graphic, Microsoft Corp., Tool, Microsoft Excel 2007, File Menu, page layout, Microsoft Excel, Microsoft Access, Microsoft Office
Print selected pages from different sections of a Word document
Techguide Choosing which pages to print is a straightforward process, thanks to Word's Page Range options. But if those pages belong to different document sections, you'll need to give Word a little extra guidance.
Tags: Microsoft Office, Microsoft Corp., Section, Chapter, Parameter Query, data entry, Microsoft Excel 2007, Figure, Microsoft Excel, Microsoft Access
A quick method for counting Access records in a form
Techguide There are several ways to count the records in a form's recordset. In fact, Access forms display the record count by default.
Tags: Microsoft Office, Method, File, Tool, Tools Menu, Microsoft Excel 2007, File Menu, Microsoft Excel, Microsoft Access, dialog box
Display hidden data in an Excel chart
Techguide By default, Excel displays only visible data in a chart. Consequently, if you hide worksheet data, Excel won't display that data in a chart.
Tags: Microsoft Office, Database, Option, Chart, Microsoft Corp., Tools Menu, Figure B, Microsoft Excel, Microsoft Word, technique
How to display pictures that appear to be partially hidden
Techguide Sometimes, an in-line text picture doesn't display completely--you can see just the bottom of the image. Find out what you can do to correct the problem.
Tags: Microsoft Office, Slide, Cell, Training, Microsoft Excel 2007, Microsoft PowerPoint, Microsoft Office 2007, Microsoft Excel, Microsoft Office, Microsoft Word
Clear an Access combo box for entering the next record
Techguide Have Access clear the selection from a combo box in a data entry form so that you start fresh with each new record. See how to make this user-friendly tweak.
Tags: Microsoft Office, C, keyboard shortcut, Clear, Microsoft Excel 2007, e-mail, keyboard, Microsoft Excel, Microsoft Access, Microsoft Office
The 10 most useful Word shortcuts
Techguide How many Word shortcuts do you remember and use on a regular basis? Fifty? Twenty? How about just 10 solid go-to shortcuts?
Tags: Microsoft Office, Positioning, Tool, Mouse, Microsoft Excel 2007, Ctrl, keyboard, Microsoft Excel, Microsoft Access, camera
Prevent duplicates when entering data into Excel
Techguide Duplicate values, when not valid entries, return erroneous summaries and totals. Here's what to do to prevent duplicates in a specific range using Excel's Validation feature.
Tags: Microsoft Office, MsgBox, Entry, Microsoft Excel 2007, Microsoft Excel, job, Microsoft Access, Microsoft Office, Microsoft Word, HTML
Use SUM in an array function to count values that match multiple criteria
Techguide When you need to count values based on more than one criterion, the CountIF function won't do the job. The solution: build an array formula with SUM.
Tags: Microsoft Office, Microsoft Corp., C, Cell, Sales, Tools Menu, Microsoft Excel 2007, Microsoft Excel, Microsoft Access, Microsoft Office
Quick sort for Word lists
Techguide Sorting lists with text, numbers or dates in Word isn't exactly intuitive, but here's what you need to know to get it done quickly.
Tags: Microsoft Office, Tools Menu, Microsoft Excel 2007, e-mail, Microsoft Excel, dialog box, window, Microsoft Outlook, Microsoft Office, Microsoft Word
Hide the Ribbon programmatically in Access and Excel 2007
Techguide All of the Office 2007 applications sport the infamous Ribbon. Unfortunately for developers, the Ribbon object isn't as easy to control as its earlier counterpart, the command bar object.
Tags: Microsoft Office, Microsoft Corp., Mouse, Microsoft VBA, Microsoft Excel 2007, software, Microsoft Excel, Microsoft Word 2007, Microsoft Access, spreadsheet
Control where Word hyphenates a word
Techguide Follow this tip to determine where Word hyphenates your content.
Tags: Microsoft Office, Microsoft Corp., MsgBox, C, vbOKOnly, command button, Tools Menu, Microsoft Excel 2007, Microsoft Excel, Microsoft Access
Use an Excel command to quickly separate first and last names
Techguide If you need to split a list of names into two columns, you don't have to do it manually. See how this Excel wizard can quickly knock out the task for you.
Tags: Microsoft Office, Microsoft Corp., Column, Dirty Property, check box, Microsoft VBA, Microsoft Excel 2007, Figure F, Microsoft Excel, Microsoft Word 2007
Add a looping introduction to a PowerPoint presentation
Techguide You can set up your slide shows to include a little preview presentation that will help prime your audience for the main event. Susan Harkins shows this simple but highly effective technique.
Tags: Microsoft Office, Presentation, Slide, Template, Button, Invoice, PowerPoint Presentation, Microsoft Excel 2007, sales tax, Figure
Jump to
1 2
