Tricks & Tips

Remove All Data After /

Question: I have list of domains in excel I would like to delete all the subfolders without going in one by one is there a way to do? example: www.domain.com/subfoldername www.domain2.com/subfoldername my list has about [Read More >>>]

Tricks & Tips

Highlight Duplicate Values

In this example I will show you how to highlight duplicate values in a column or row in less than 20 seconds. Here we have a list of names in Column A which contains some [Read More >>>]

Excel Topics

Hide / Show Worksheet Gridlines

The gridlines displayed in a worksheet can be very useful especially when you are designing your worksheets. There are times however when you may want to hide the gridlines. Step 1 Click the View tab. [Read More >>>]

Excel Topics

Quick Analysis Tool

The Quick Analysis Tool brings the most commonly used formatting, charting and summary tools into one convenient location. The tool allows you to quickly create an Excel table or Pivot Table, create a new chart, [Read More >>>]

Tricks & Tips

Enter Today’s Date

Probably the most common date you will enter in Excel is the current date. A quick and simple way to avoid having to type the same date again and again is to use the keyboard [Read More >>>]

Tricks & Tips

Display Day Name From A Date

If you need to get the day name (Monday, Tuesday, Wednesday etc.) from a date there are several options depending on your needs. In this article we will show you a few examples on how [Read More >>>]

Tricks & Tips

Delete Row if Cell is Blank

In this example we have a table of data listing each persons sales per quarter. What we want to do is delete the rows that no longer contain a name in column A without having [Read More >>>]