14 Advanced Excel Tips and Tricks for Basic to Intermediate Users

Whether you’re an Excel power user or just reasonably experienced with spreadsheets, there are generally still things you can learn about Microsoft’s program, and points which can be refreshed in your memory. So, we’ve put together this compilation of 14 tips for those of you using Excel 2010, going over some important features – and making sure you’re making the most of them. Also, some of these tips cover essential Intermediate to Advanced-level skills that you should know no matter what version of Excel you use.

Read More

How to Highlight a Row in Excel Using Conditional Formatting

You can use conditional formatting to format or color the cells based on their contents. For example, you have a cell to turn red when it contains text ‘No’ or a value less than 90%. But how do you highlight an entire row? When a cell contain specified content.
This tutorial will help you learn how to highlight other cells based on a cell’s value? To see how this was done, read on.

Read More

How to Reduce Size of Excel Files? – Top 10 Tips

Did you ever wonder why your Excel File is so huge while it actually has very little information?
When you receive an excel file it was in KBs but when you make changes and save, file size surprisingly increased to MBs!! Fortunately there are several ways to overcome this problem, this article will help you learn the Top Ten Awesome Tips & Tricks to Reduce Excel File Size to a great extent without losing the actual content.

Read More

Conditional Formulas in Excel & Tricks Using the IF Function in Excel

If ever there was a single function in Excel that I use the most, it’d probably be the IF function. It is a workhorse as far as I’m concerned, as it can be used in combination with several other functions for a plethora of purposes. Along with other Logical Functions like AND, OR, NOT, TRUE, and FALSE, you’ve got all the ingredients you need to create some really cool formulas that will help you not only sort your data, but can even help improve the aesthetics of your spreadsheets and help to automate the analysis of your data. Here are some reasons why I have unconditional love for conditional formulas in Excel.

Read More