When you are a professional who need to use Microsoft Excel for his/her regular work, then be prepared to face errors in it. For all the errors in MIcrosfot product [ … ]
Tag: excel
August mailbag: The benefits of Excel helper columns
Complex problems require complex solutions, right? Not necessarily. I often hear from users struggling to produce a single-formula solution. Even long-time developers struggle to build complex formulas. My advice is [ … ]
Use Excel’s Data Validation to display data entry tips for users
Excel comments let you display information about the values in a cell. The notes might be for you or they can be information for users. Excel displays the comment when [ … ]
Use Excel’s conditional formatting to highlight weekends
If you’re like me, weekends are important to you so easily identifying them is important too. Fortunately, by combining a date function and a conditional formatting rule, you can dynamically [ … ]
Quick Tip: Fill in blank cells in Excel quick and easy
This tip was originally published in April 2010 but continues to be one of our most popular. One of the first things you should do when importing foreign data into [ … ]
Quick Tip: Excel 2013 offers flexible data labels
Excel 2013 offers more formatting and shape options for displaying data labels in a chart. It also supports a dynamic data label option. We’ll explore those options and then put [ … ]
20 Excel tips for creating stylish spreadsheets
By Carlo Pandian Most Excel users would probably agree that the program is a godsend when it comes to creating spreadsheets, yet the results can often be boring to look [ … ]
October Office tip mailbag: Outlook settings and Excel conditional formatting
This month, I help a reader find a familiar and friendly Word setting. In addition, I show a reader where to find a mail setting after upgrading to Outlook 2010. [ … ]