Creating New Macros in Microsoft PowerPoint 2007
(Michele McDonough) One of the things I really miss from previous versions of Microsoft PowerPoint is the ability to simply record a macro. You can still create macros in PowerPoint 2007, but it requires a little more work.
|
Article
|
3/12/2010
|
Redoing an Object Browse
(Allen Wyatt) The Object Browser is a great way to search for and navigate through all sorts of objects in your document. Once you use the Object Brower, you can use a handy shortcut to jump to the next (or previous) object you are searching.
|
Article
|
3/12/2010
|
Power Tip: Estimate the complexity of an Access development project
(Brandon) As we all know, it's never easy to estimate how much work will be involved when creating a new Access database. To help with that, OpenGate Software has produced a white paper designed to help Access users (particularly newer users) figure out how complex their prospective Access database may be, and what skills they may need to get the job done.
|
Article
|
3/12/2010
|
Get the most out of Windows XP Mode with these tips
(Greg Shultz) While Windows 7 has several built-in compatibility features that are designed to allow you to run most Windows XP applications right from within Windows 7, there are other older Windows XP applications that will not run in Windows 7 even with those built-in compatibility features. For these types of applications, Microsoft designed Windows XP Mode for Windows 7.
|
Article
|
3/12/2010
|
Color Swatch Add-In (for Templates)
(Troy Chollar) If you develop PowerPoint templates, this new add-in from OfficeTips (PowerPoint MVP Shyam Pillai) is a MUST HAVE. Adding a custom color scheme is a tedious process that is now super easy, just fill in the swatches with the colors needed for the template, click apply, done!
|
Article
|
3/12/2010
|
Convert a Row to a Column in Excel the Easy Way
(Matthew) Sometimes we’ve entered data in a column in Excel, only to realize later that it would be better to have this data in a row, or vise-versa. Here’s a simple trick to convert any row or set of rows into a column, or vise-versa, in Excel.
|
Article
|
3/12/2010
|
Combine Documents in MS Word
(Carol Bratt) A reader recently wrote:
"I have several Word files that I must combine for a book. The largest file has headers and footers. When I combine files, the footer and header spreads throughout the combined document. How can I combine and isolate headers and footers to one section? Thank you for your assistance!"
|
Article
|
3/12/2010
|
Status Bar stats in Excel
If you only need some basic details about a list of numbers, there's no need to use Excel formulas or the Descriptive Statistics feature.
|
Article
|
3/12/2010
|
View the reminders window in Outlook 2007
You know how that box always pops up whenever you have a reminder in Outlook 2007?
|
Article
|
3/12/2010
|
At Long Last - An Access Post!
(Nate Oliver) Okay, maybe not quite. I wrote and tested this in Access, but it really has more to do with moving very large Recordsets to Excel, from any DB given the correct Connection String, in a hurry, via Automation.
|
Article
|
3/12/2010
|
Build a simple timesheet in Excel
(Susan Harkins) Excel makes it easy to set up a system for tracking time. Follow these steps to create your own or download our sample timesheet template and customize it to fit your needs.
|
Article
|
3/13/2010
|
InfoPath 2007: Creating a no-code unique identity value
(Will Feaser) On a recent project, I had the need to have InfoPath 2007 create a unique integer value (auto-incrementing) for each entry in my repeating sections. I researched possible solutions (came across this post from Yaniv that has some good options), but couldn't find a solution that completely satisfied my requirements. I wanted a solution similar to Yaniv's second option. However, I had to be able to handle the situation where a user deleted a section. Adding a new field to my schema to track the count was not going to work because I had a non-InfoPath controlled (external) schema and I did not want to add InfoPath-specific fields to it. So, building on Yaniv's options, I came up with the following option that has worked well for me.
|
Article
|
3/13/2010
|
Exploring Office 2007: Making Multimedia Magic with Producer for PowerPoint 2007
(Helen Bradley) One of the best kept secrets related to PowerPoint 2007 is Producer for PowerPoint 2007. Producer allows you to compile a multimedia screen presentation combining your slide deck with objects such as still images, movies, and text. In this article, I'll show you how to get your hands on Producer for PowerPoint 2007 and how to get started using it.
|
Article
|
3/13/2010
|
How to restore default file block settings in Word 2010
(singh1985) A user is allowed to create and save a file using the Word 2010 application. Various sets of settings related to the customization and formatting functions are included in to provide a custom feel and increased user interaction. Word 2010 application also allows blocking files of certain type in concern with opening and saving of those files.
|
Article
|
3/13/2010
|
Access Naming Oddity
(Glenn Lloyd) As a design principle, I apply a naming convention when creating new database objects. For example, field names begin with a lowercase letter.
|
Article
|
3/13/2010
|
Understanding the Purpose and Uses of Primary Keys in an Access 2007 Database
(John Garger) Every good database makes use of primary keys to uniquely identify each record. Learn the uses and benefits of using primary keys in your Access 2007 database.
|
Article
|
3/14/2010
|
Counting Records Matching Multiple Criteria
(Allen Wyatt) Excel provides worksheet functions that make it easy to count things. What if you want to count records that match more than one criterion, though? Here are five easy ways you can count those records.
|
Article
|
3/14/2010
|
Use Word's Find feature to highlight all occurrences of a word or phrase
(Susan Harkins) Most of us use Word’s Find feature to locate specific text, often so we can change it. You might not know that you can use this feature to highlight all the occurrences of a specific word for phrase for the entire document at the same time. For instance, I often use this feature when creating an index. I don’t want to change anything, I just want to know the location of each indexed word or phrase.
|
Article
|
3/15/2010
|
Project 2010: Introducing Millions of Colors
(Heather O'Cull) While Shakespeare said “Truth needs no colour”, we decided this wasn’t true for Project 2010. With Project 2010, no longer are you limited to 16 colors. We now support 32-bit color which simply put means you have millions of colors to choose between. How many million you ask – 16,777,216 colors. The human eye can only distinguish roughly 7-10 million colors so you’ll have to trust us on that number. Just know that orange, citrine, ultramarine blue, hot pink, etc. are all possible now.
|
Article
|
3/15/2010
|
The Access Show: How the Microsoft Legal Department uses Access 2010 web databases
(Clint Covington) Meet Malori! Malori is a paralegal in Microsoft's legal department. She manages patent applications and assigns them out to attorneys and portfolio managers as well as other paralegals.
|
Article
|
3/15/2010
|
The Case for Access
(Mike Alaexander) Amazon says it's official. My new book will be out on April 5th.
|
Article
|
3/15/2010
|
An Introduction to Relationship Types in Access 2007
(John Garger) Unlike flat databases, relationship databases split data into two or more tables. The power of Access 2007 lies in its ability to create relationships among tables. Learn about the theory and practice of relationship types.
|
Article
|
3/16/2010
|
Quickly Adjusting Paragraph Spacing
(Allen Wyatt) Word allows you to easily adjust the amount of white space before and after a paragraph. Rather than continually displaying the Paragraph dialog box, you may want to use the macros in this tip to make short work of adding the desired space.
|
Article
|
3/16/2010
|
Eliminate mostly blank pages from the end of an Excel report
(Susan Harkins) No matter what kind of formatting you apply to an Excel sheet, you can’t easily control the number of rows on each page, when printing. Occasionally, you might end up with just a few rows printing on the last page. That’s not exactly a problem, but those two or three additional rows printed on the last sheet can look unprofessional. In addition, it seems wasteful in today’s greener environments.
|
Article
|
3/17/2010
|
Add a Dynamic Map to a Contact Form using REST Web Services
Hi, Phil Newman here from the InfoPath team. In this post, I’ll explain how to use the new REST Web service data connection in InfoPath 2010 to add a dynamic map to a contacts form. The form connects to two Web services. The first is a REST Web service that returns the coordinates of a given address from Bing Maps, the second returns an image of a map for a given coordinate set. When users enter address information in the form, the map will update to display the specified address.
|
Article
|
3/17/2010
|
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
|
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
|
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
|
|
