Category Archives for "Excel Tips"

[Quick Tip] How to Copy a Worksheet in Excel

A lot of times we need to make a copy of a worksheet in Excel. Maybe you want to create a back-up worksheet, or you want to create a new worksheet but don’t want to redo the formatting.  The long (and inefficient) way is: Right-click on the worksheet tab for which you want to create […]

Continue reading >>

4 What is Intersect Operator in Excel and How to Use it

Watch Video – Using Intersect Operator in Excel Intersect Operator in Excel can be used to find the intersecting value(s) of two lists/ranges. This an unusual operator as it is represented by a space character (yes that’s right). If you use a space character in between two ranges, then it becomes the Intersect operator in Excel. […]

Continue reading >>