In the corporate world, Excel is used to keep organized very different types of information, excel includes many...
Month: October 2015
How to check how many times a value appears in a range of cells in Excel
Sometimes in the business field it is necessary to know how many times a value repeats whithin a report. Depending on...
Calculating workdays between calendar dates
In the corporate world there are times when planning timelines for projects where we only have the start and end...
Extracting text into cells in Excel
Sometimes it is useful to be able to βsplitβ or extract text from a cell into various cells in Excel. Often times we...
Excel Lists-find largest/smallest values
Often times when we have a large list of data values we may need to extract specific data information from this list,...
Filtering data in a range in Excel
Sometimes there may be information that is contained in an excel worksheet which we might need to quickly sort to use...
How to combine data in a cell for Excel
Sometimes we would like to combine the text from different cells in Excel in order to better format the text in those...
Changing text case in excel
Sometimes at work, we download reports where when pasting text some programs do not take into account the formatting...
Removing Duplicate Entries in Excel
Sometimes at work, we may encounter large excel files that we have to work with, only to find out that the file has a...
How to Create graphs in Excel
Due to the fact that Excel is a very popular and heavily used application in the corporate world, it comes loaded with...









