Microsoft Word 2007: Basics on Table Creation
(Michele McDonough) In the opening segment of this series, we’ll take a look at the basic options available in Microsoft Word 2007 for creating tables.
|
Article
|
3/18/2010
|
http://excel.tips.net/Pages/T002946_Relative_Worksheet_References_when_Copying.html
(Allen Wyatt) When you copy a formula that contains cell or range references, Excel adjusts the references relative to where you are pasting the formula. It does this for all parts of a formula except worksheet names. This tip provides some techniques you can use to get around this apparent shortcoming.
|
Article
|
3/18/2010
|
Recolor Picture Backgrounds in PowerPoint 2007 and 2010
(Geetesh Bajaj) One of the worst things that you can do to your PowerPoint presentation is to add a busy, multi-colored background to your slides. However, people do that all the time and in the process, they compromise the subtlety and contrast of any content on their slides.
|
Article
|
3/18/2010
|
Double Underline Text to Make it Stand Out
(Andrew Malek) One way to focus a reader's attention onto certain text in a Microsoft Visio 2007 document is to underline the text, something easy to do by pressing the underline button in the toolbar or pressing Ctrl + U. But what if you want to really draw focus to an important word or phrase? Underline it twice - here's how.
|
Article
|
3/18/2010
|
Hate the Ribbon in Microsoft Word 2010? Here's How to Customize It
(Dave Johnson) Many people are still angry at Microsoft for eliminating the traditional menus in Word 2007, but I think that objectively, the ribbon is superior. It doesn’t take long to find your away around, and you can effortlessly search for commands.
|
Article
|
3/18/2010
|
Why FIND when you can SEARCH
(Mike Alexander) Vinicius writes to ask:
"Dear Mr. Pig. I would like to know what the difference is between Excel's FIND and SEARCH. Which one should I use?"
|
Article
|
3/18/2010
|
18 Paths to Pathos: How to Connect with Your Audience
(Andrew Dlugan) The previous article of the Ethos, Pathos, and Logos series defined pathos and described why emotional connection is so important for your presentations.
|
Article
|
3/18/2010
|
Center Pictures and Other Objects in Office 2007 & 2010
(Matthew) Sometimes it can be difficult to center a picture in a document just by dragging it dragging it around. Today we show you how to center pictures, images, and other objects perfectly in Word and PowerPoint.
|
Article
|
3/18/2010
|
Access Database Security Alternative
Access Database Security Alternative: database security can be a challenging aspect to MS Access database creation. Working with the workgroup administration tool and setting the security levels can be confusing at times.
|
Article
|
3/18/2010
|
Print Full or Partial Sheet of Labels
Hi, I am trying to create a full sheet of the same label from my access file. I would like 30 of record 1, 30 of record 2, etc. Is there a way to do that so I get a full sheet of each record rather than just one label of each?
|
Article
|
3/18/2010
|
Quickly display all you need to know about Excel functions while entering a function
(Susan Harkins) Most of us need little to no help to enter a simple SUM() or AVERAGE() function. We use them often and their arguments are simple. When entering an unfamiliar function, we usually need a little more help. Fortunately, Excel goes a long way toward putting the information we need right at our fingertips—literally.
|
Article
|
3/19/2010
|
Visio – Creating Tapered Lines
(Saveen Reddy) Sometimes you may want to have a line with a tapered width. It’s another interesting choice in showing the relationships between shapes.
|
Article
|
3/19/2010
|
Develop Advanced Access 2010 Web Databases and Publish to SharePoint 2010
Ryan’s great talk from the SharePoint Developer conference is now online.
|
Article
|
3/19/2010
|
Google DocVerse
(Troy Chollar) DocVerse is a company Google purchased last week that aims at making it's online Google Apps more appealing to MS Office users. DocVerse is ironically a startup founded by two former Microsoft key employees.
|
Article
|
3/19/2010
|
Specifying Font Attributes In Microsoft Word
(George Alexander) To change the font anywhere in your document, you need to begin by making a selection. Next, click on the drop-down menu next to the currently displayed font. The list of fonts that appears is divided into three sections first we have the Theme fonts. Microsoft Word’s Theme feature allows you to quickly format a document to achieve a certain look. The second section shows the fonts that you’ve recently used and the third section contains a list of all fonts installed on your computer.
|
Article
|
3/19/2010
|
Change charts, represent +/-, and count the Mondays between 2 dates
(Sam Rad) Bill Jelen has been running the MrExcel podcast for years now. For those that haven’t heard of it, it’s a frequently updated video podcast that teaches you Excel, showing everything from the basics of the fill handle to advanced tips around charting, and everything in between … including some recent tricks with linked pictures.
|
Article
|
3/19/2010
|
Reset a slide in PowerPoint 2007
Don’t you hate it when you accidently click on a text box on your slide and move it? Before you know it, your heading one one slide, or the body text on another is completely out of whack with the rest of your presentation.
|
Article
|
3/19/2010
|
How to Sync Windows Live Calendar with Outlook and Solve Sync Issues
(Arun Kumar M) There are many things you can do with the Windows Live Calendar: adding appointments, reminders, and sharing events with others. This guide shows how to sync Windows Live Calendar with Outlook and discusses solutions to common problems while synchronizing Windows Live.
|
Article
|
3/20/2010
|
Using the Organizer to Manage Styles
(Allen Wyatt) One of the things that the Organizer is great at doing is managing styles. You can use it to move them between templates and documents, rename them, or delete them. This tip shows how.
|
Article
|
3/20/2010
|
Making a Dynamic Dashboard in Excel [Part 1 of 4]
(Myles Arnott) In this and next 3 posts, we will learn how to make a Dynamic Dashboard using Microsoft Excel.
|
Article
|
3/20/2010
|
A fast way to center a heading across Word columns
(Susan Harkins) One way to get a heading or title to span columns is to add the heading before you add the column text. That’s great if you remember to do so and if you know the title before you enter the actual column text.
|
Article
|
3/21/2010
|
Tips and Tricks for Project 2007: Show filtered tasks with other tasks
(Toney Sisk) Sometimes, when filtering tasks, wouldn’t it be great if you could see filtered tasks with all the tasks, at the same time? Maybe you want to view filtered tasks within the context of all tasks.
|
Article
|
3/21/2010
|
Data Macro Aliases and the Where Condition Demystified
(James K. Rivera) Whenever I debug a data macro, one of the most common mistakes I find is misusing aliases, especially in the Where Condition of a ForEachRecord or LookupRecord data block. This blog post is an attempt to demystify this area. Hopefully, by the time you are done reading this you will have a firm grasp of how to use aliases in data macros.
|
Article
|
3/21/2010
|
NewsMap for Presentation 'Statistic' Graphics
(Troy Chollar) I recently made use of NewsMap for some great visual images to visually show the trends being talked about by the presenter. NewsMap is actually an old web based application that has had some big improvements recently.
|
Article
|
3/21/2010
|
Add Field Codes to Footers in MS Word
(dkoltow) This article teaches readers how to add field codes to footers in MS Word documents. That task enables Word users to apply field codes to paginate their documents and enable other automatically created text.
|
Article
|
3/22/2010
|
Y-Axis Chart Titles are Truncated
(Allen Wyatt) When creating a chart, you may find that the titles that appear along your Y-axis are being cut off for some reason. Here's a way you can work around the problem.
|
Article
|
3/22/2010
|
Print multiple copies of individual pages in a Word document
(Susan Harkins) Printing multiple copies of a document is easy — the functionality is built right in. From the File menu, choose Print. Then, in the Copies section, select the number of copies you need from the Number Of Copies control and print them.
|
Article
|
3/23/2010
|
The Visio Services JavaScript Mashup API
Last week, we took a look at how to create interactive mashups with Visio diagrams without writing any code. If you need more flexibility in creating rich diagram mashups than offered out of the box by web part connections, you can use the Visio Services JavaScript Mashup API.
|
Article
|
3/23/2010
|
Accessing MS Word Fields in Visual Basic for Applications
(dkoltow) This article shows readers how to use VBA to insert, navigate to, and delete field codes in Word.
|
Article
|
3/24/2010
|
Adding Table Columns to Columns with Merged Cells
(Allen Wyatt) If you have a table that has merged cells in the first row, and you insert a column to the right of any column underneath that merged cell, Word adds a cell to the right of the merged one. This may seem odd, but it is the default behavior of Word, as explained in this tip.
|
Article
|
3/24/2010
|
|
