Link to specific slides in other PowerPoint presentations
Posted on May 7, 2008 - Filed Under MS Office Tips | Leave a Comment
Have you ever wanted to link your power point presentation to another one? What if you could link it to a specific slide in the other presentation? What if you could link it to a Word or Excel document as well (and specify exactly which part of the document you want to open)? Well, it can be done – and I’m here to tell you how.
To start with, you will need to have your power point presentation as well as the other file that you want to link to. In this example, we will be linking two power point presentations together and jumping immediately to Slide 2 on the second presentation.
If you enjoyed this post, make sure you subscribe to my RSS feed!
Read More..>>Master Excel Tables with AutoFilter and Subtotal
Posted on April 9, 2008 - Filed Under MS Office Tips | Leave a Comment
How much of Microsoft Excel are you using? I thought so. Get ready because we’re stepping it up another notch. Excel is a powerful but often underutilized tool. Many of us use it every day to plan and track budgets, analyze marketing data, and occasionally to do more important things such as manage the office March Madness pool. Several Online Tech Tips posts have already covered clever but unfamiliar functions like VLOOKUP and SUMIF. Now it’s time for another round of Outrageous Excel Tips!
If you enjoyed this post, make sure you subscribe to my RSS feed!
Read More..>>How to add comments to an Excel Worksheet cell
Posted on April 6, 2008 - Filed Under MS Office Tips | Leave a Comment
I’m a big user of Excel and it always amazes me how few people add comments to their Excel spreadsheets! Adding and using comments in Excel is a great way to explain formulas, cells, and other data in the spreadsheet itself, thus saving you the time spent on the phone with colleagues! It’s really easy to add comments to cells in Excel and I’ll explain how you can do so in Excel XP/2003 and Excel 2007.
Comments are basically notes that can be inserted into any cell in Excel. It’s useful for reminders, notes for others, and for cross-referencing other workbooks.
If you enjoyed this post, make sure you subscribe to my RSS feed!
Read More..>>How to fix slow Outlook 2003-2007 loading dataset problem
Posted on April 4, 2008 - Filed Under MS Office Tips | 4 Comments
Microsoft Outlook 2007 running super slow? Still loading dataset for you? I just love it when Microsoft tries to make their software better by adding a crapload of useless features to them! I have no idea why it would take 8 hours to load a single dataset! I don’t even know what the heck the dataset is supposed to be! We’re just talking email here right?
Unfortunately, making sense and talking about Micorsoft products at the same time is usually not possible, so you’ll just have to live with the fact that each newer version of Windows and Office is only going to slow your computer down eve more!
If you enjoyed this post, make sure you subscribe to my RSS feed!
Read More..>>MS Excel Tips and Tricks – How to count things in Excel
Posted on February 8, 2008 - Filed Under MS Office Tips | 2 Comments
There’s an old wives’ tale that says most of us only use about ten percent of our brains. Well, that’s poppycock. But what is true is that most of us use far less than 10 percent of the power in our expensive Microsoft Office applications. Take Excel for example. I love Excel. If you could take the most horrible job in the world and figure out a way to use Excel to do it, I think I would find it fun.
If you enjoyed this post, make sure you subscribe to my RSS feed!
Read More..>>Amazing Ways To Format Cells in Excel 2007
Posted on January 31, 2008 - Filed Under MS Office Tips | 5 Comments
If you are used to using older versions of Excel, the conditional formatting options in Excel 2007 will amaze you. Now, you can use conditional formatting to format every cell in a range based on your own criteria (and there are a lot more formatting options to choose from). For example, if you have a profit sheet that you want to color code all profits greater than $200 as green and all profits less than $200 as yellow and all losses as red, then it could take a while to do manually – especially if you have thousands of entries. Instead, use conditional formatting to do the work for you.
If you enjoyed this post, make sure you subscribe to my RSS feed!
Read More..>>
