Microsoft Office Archives

Microsoft Excel – Convert Answers to Values FAST!

If you are new to Excel, you no doubt have already discovered the need to take a series of numbers created by formulas and convert them to fixed values. In other words, replace the questions with the answers. With no idea how to accomplish this, beginners usually spend great stretches of time retyping the numbers into the answer cells to make them “permanent”.

Eventually, someone who feels your pain turns you on to the technique of highlighting all of your formula cells, clicking Copy, then in the same cells clicking Paste Special…, Paste Link.

You could now not be more ecstatic. “This is going to save me sooooo much time”, you say to yourself.

Well, guess what. There’s an even FASTER way to accomplish this task. Try this out:

Selecting Objects in Word with the Selection Pane

If you have ever inserted an object (like a picture, shape, or clipart) into a Word document and then made the unfortunate move where you pushed it behind your text… …and now it seems forever trapped behind a sea of impenetrable words. No matter how …

Excel Comma Style Keyboard Shortcut

If you are an Excel user who LOVES working from the keyboard as much as possible (i.e. data entry, navigation, feature activation, etc…) then you simply MUST know of this little gem of a keyboard shortcut. Although we have no scientific data to back up …

Missing Resources when Using Microsoft Project Resource Pools

If you work with Microsoft Project and have ever leveraged the power of Resource Pools across multiple projects, you may have encountered a strange behavior when assigning those resources.

When you share resources between a Resource Pool file (a dummy project file that typically has no tasks but is merely a container for holding resources) and another project file, sometimes the resources don’t show up when it comes time to make the resource assignments.

Microsoft Excel Keyboard Shortcuts

Keyboard shortcuts may seem like a throwback to the olden days, but they can seriously ramp up your productivity once you start using them. Especially for tasks you do on a repeated basis. Here are some of the most common Microsoft Excel keyboard shortcuts. F7 …

How to Use VBA in Microsoft Access Tutorial

In this Microsoft Access Tutorial, you’ll see how to begin using VBA in Microsoft Access 2007. The basic concepts of objects, properties methods and events are explained and then you will see how to attach VBA code to the load event of a Microsoft Access …

Learn Microsoft Access

SkillForge is proud to announce the most comprehensive Microsoft Access Training schedules available anywhere! Offering Introduction to Advanced courses in Visual Basic for Applications (VBA) – SkillForge offers training for students wanting to learn more about the Microsoft Access application no matter what level of …

Install Xcelsius with Office 2010

Xcelsius (now renamed SAP Crystal Presentation Design) is supported for use with Microsoft Office 2007. Many users though, not knowing this, try installing Xcelsius on a machine that has Microsoft Office 2010 installed and are presented with an error message stating something like “Microsoft Office XP and later applications: Excel, Word, Outlook or PowerPoint must be pre-installed.”

MS Access Resources

Microsoft has recently published a very thorough set of MS Access 2010 resources to the TechNet site. Access has always been the part of the Office Suite that straddles the end-user/IT Professional fence. The resources on TechNet are definitely geared toward Access Developers rather than folks that might be using MS Access more casually.

What’s New in Microsoft Office 2010 – Part 2 of 6 – Outlook

In Part 1 of this series, we took a look at some of the new features that are common to all of the Office 2010 applications. In this post, we’ll take a closer look at some of the new features specific to Outlook 2010.

The Ribbon

Of all the Office 2010 applications, none has changed more visually than Outlook. The main reason for this is that Outlook now (finally) shares the same Ribbon interface that the rest of Microsoft Office received in the 2007 version.