Excel
PDF Print E-mail
Using Excel's conditional formatting to colorize the weekends

 

In this period of the year most of us are starting to make plans for next year, Excel is an incedibly powerfull tool that can help you visualize your plans. Using Excel's conditional formatting you can colorize the weekends and make them standout more than the other days of the week or vice versa. This article is an How to colorize the weekends in Excel using conditional formatting.

Read more...
 
PDF Print E-mail
Prevent RSI and automate mouse clicks by using excel

 

Sometimes one has to do a lot of mouse clicking... By repetitive clicking and small movements of your hands and other joints you could end up with some nasty RSI (Repetitive Strain Injury) and that ain't worth it!!! So beat RSI by using VBA and Excel to automate some excessive mouse clicks!

Read more...
 
PDF Print E-mail
Improving readability of worksheet data in Excel

 

It can be a big help if your data in Excel is easy to read (avoiding errors in calculations and or data analysis). I know there are more ways than one to achieve that goal, in this article I'll show you some code that handles the solution without using conditional formatting. It's a rough and simple solution...

Read more...
 
PDF Print E-mail
Rearrange columns in Excel using VBA

 

Did you ever need to rearrange or reorganize columns across multiple sheets in a certain order based on column headers? In this article I’ll try to explain how to rearrange columns in Excel based on column header information by using Visual Basic for Applications (VBA) .

Read more...
 
PDF Print E-mail
Convert MAC address in MS Excel or OO Spreadsheet

 

As I'm currently working a lot with Excel, I get a lot of questions like "How do I do this?" or "How do I do that?". Yesterday someone asked me how to convert a data string to a MAC address. The standard format for printing MAC addresses in human-friendly form is six groups of two hexadecimal digits, separated by hyphens (-) or colons (:), in transmission order, e.g. 01-23-45-67-89-ab, 01:23:45:67:89:ab. In this article I'll give you examples of how to add, remove or change the separator for MAC addresses in MS Excel or OO Spreadsheet.

Read more...
 


Sponsored Links