Recent Posts
The World of Office Tips and Tricks.
Return To Blog Listing
Your Unofficial site for Tips and Tricks, Tutorials, Tweaks and Hotfixes for Microsoft Office.
Recent Posts Tagged With 'excel tutorials'
Formula for Combining Different Values into One Date Column.
It is time for the fourth and final Excel tutorial of this Excel week. The tutorials that we’ve covered this week are some pretty cool ones. The first was the tutorial with a formula for checking future dates followed by the Excel tutorial for ...
Use the Same Formatting for Multiple Cells, the Easy Way. – Part 2
This next Excel Tip and Trick is a follow-up of the article that I wrote last week about using the same formatting for multiple excel cells. I’m now using also using the Format Painter Tool. In the first article I explained how to copy the fo...
Work Faster With a Drop Down List For Auto Filling Your Cells.
In the last couple of months we’ve covered some really cool Excel Tips and Tricks. But more important some of these Excel Tips and Tricks were really useful and will save you lots of time. Some of my personal favorite Excel Tips and Tricks ar...
Microsoft Excel Formula to Count all the Cells with Text.
A while back I showed you how to create Formula to Count all the Empty Cells. Not only can it be useful to have a little help counting all the empty cells but an Excel Formula to count all the cells that contain Text and numbers can be just as help...
Hiding the Grid Lines in Your Microsoft Excel Spreadsheet.
The gridlines are probably one of the most useful tools in Microsoft Excel, especially when you’re designing an nice Excel worksheets. On the other hand it can be very useful sometimes to have no grid lines at all in your Excel Workbook...
Microsoft Excel Formula to Count all the Empty Cells.
It can be useful if you are working in a large Excel Spreadsheet to count the empty cells. This is a Microsoft Excel Tutorial to show you how to use this Excel Formula. I hope you’ll enjoy this quick Tip. How to use the “Countblan...
What To Look For In a P2P Download Software
by Terry Hunter There are many file sharing programs out there. Some that you might have heard of are Ares, Kazaa, Morpheus etc… These are great and useful programs for downloading all kinds of content with other users of the software. Contrar...
The World of Office Computer Support Forums are Live!!
You might have seen the forum link in the header of this blog but I can tell you now that after a lot of tweaking and getting things ready the forums are now live and accessible. We worked a lot of hours to get things ready but now that it...
5 Tips for Becoming a Faster, More Proficient Office User.
This next post is guest written by Kelly Kilpatrick who writes on the subject of Internet Service Provider Deals for Great ISP Deals.com. Using the Microsoft Office suite is an amazing tool that can increase your capabilities as a PC us...
Where Does Outlook Store All His Data?
A question I get asked a lot is “where does Outlook store all his data (email messages, contacts, your calendars, and more)”? Outlook stores his data in a "Personal Folder" (.pst) file. They are complex and complicated, an...
Are there any Bloggers here who are interested in a backlink??
As the title says; are there any bloggers around and preferably as my subscribers?? I already am talking to several bloggers via the webmaster forums but it seems only fair to ask here too. If you are a subscriber you might know that ...
This is unbelievable… We are disconnected.
Hi guys, I just wanted to let you know why things have been so silent around here. Things are pretty messed up here in the Netherlands. I run my blogs from home in a really great home office; I broke a several walls down and combined ...
Formula for Combining Different Values into One Date Column.
It is time for the fourth and final Excel tutorial of this Excel week. The tutorials that we’ve covered this week are some pretty cool ones. The first was the tutorial with a formula for checking future dates followed by the Excel tutorial for ...
An Excel Tutorial with a Formula for Checking Future Dates.
Hi folks, I hope you all had a great weekend!! It’s Monday again and it’s the last week of the month and we are having another Microsoft Excel Tutorial week. And I got some great Excel Tutorials lined up for you this week. We covered in ...
Maintenance and New Payment System.
Hi All!! I just want to let you know that we are working today on the blog for maintenance and implementing a new payment system. It can happen that the lay-out of the blog seems “strange” or that the blog is down for a couple of minutes...
How To Use Alt Keyboard Shortcut Combinations.
Today’s Word and Excel Tip and Trick doesn’t need an intro. It’s a nice printable list with all the Alt keyboard shortcut combinations. I hope you’ll enjoy it. Do you want to see more? This is related......
Give Some Color to Your Spreadsheet.
Earlier this week we talked about changing the background picture of your Excel Spreadsheet. This isn’t an Excel Tip & Trick that you can’t live without and this Tip & Tricks isn’t going to simplify your life but hé, it...
Change the Background Picture of Your Spreadsheet.
I hope you’ve liked yesterday’s Add Copy To and Move To to your right click menu trick. I don’t have a trick for you today but a very cool excel tip for making your spreadsheet look a lot better than the normal boring white ...
Formula for Calculating the End Date of a Project.
We covered some pretty cool Excel formula’s this week and I hope you’re ready for the last one. I used this one a lot when I still had a day job as a sales- and project manager. This excel formula can be used for determining the end date ...
Calculate your Gains and Losses of your Stocks in Excel.
And today were continuing with another Excel Tip & Trick. And it’s another Cool Excel Trick. I showed you on Monday a Formula to Calculate the Price Reduction or Discount. On Tuesday I showed you a Formula for Converting the Currency Dollar...
Formula for Converting the Currency Dollars to Euros
Yesterday we talked about a formula to calculate the price reduction or discount and today were sticking with the dollar formulas. If you are considering advertising on one of my blogs or requesting a product or blog review, this might be an i...
Create a Formula to Calculate the Price Reduction or Discount.
Hi folks, I hope you all had a great weekend and that you are ready for some cool Tricks. Well, I don’t have any cool tricks lined up for you this week. As I’ve told you last Friday I had planned for this week some very useful Excel formu...
Some Excel Tips and Tricks for Using Comments.
Today’s Tip and Trick is a pretty cool one for Microsoft Excel. Working in MS Excel can be a hard job especially when you are working with complicated formulas and lots of entries to fill in. If you are working in a complex spreadsheet it might...
