Search Results

Excel’s Flash Fill feature can save you a ton of time! Check out how you can automatically split names, get the initials, email addresses and more with Excel’s amazing Flash Fill feature. No more writing complex formulas.

With this Excel Hyperlink formula you’ll be able to create customized emails from Excel. You can use cell references for mailto recipient, body text and even Cc. It’s a big headache to do it manually for each person. Specially if your list is long. This Excel formula will do it for you.

Get a list of all your external links in your Excel file with a trick that combines the past with the future. This way you can make sure all your links are pointing to the right files.

These are the Do’s and Don’ts for Excel Spreadsheet design. Implement these tips for organized, clear and beautiful Excel reports. There are two aspects of workbook design: Workbook Structure and Visual Design of each Excel Worksheet.

Make sure you know the answers to these Excel Interview questions before you go to your next interview. These are asked specially if you’re applying for data analyst jobs.

You can use Excel VBA GetOpenFileName method to copy data from another Excel file by browsing for and selecting the file from the Open File Dialog Box.

Here is the easiest way you can switch data from columns to rows in Excel. It involves NO formulas, NO Transpose – just simply UNPIVOT with Get & Transform. After-all tabular data sets are easier to work with.

Discover what Excel’s NEW XLOOKUP Function can do for you and how it can help you with your Excel lookup problem. In this example we use XLOOKUP to lookup values on another sheet (Yes – No more VLOOKUP for these tasks!)

Interested to create a progress circle chart infographic in Excel like never seen before? This progress chart has rounded edges. I show you two solutions – you’ll love the second one!

Justify text – or Fill Justify – is a useful and hidden Excel feature when it comes to managing text, rearranging or aligning text in Excel. Learn it quickly right here.

Is there an Excel MAX IF or MIN IF function? Yes. There is MAXIFS and MINIFS functions that allow you to get the MAX or MIN value based on criteria. IF you don’t have these functions you have alternate ways of getting this done. One option is to use AGGREGATE function

Hyperlinks provide a better user experience. You can also insert Hyperlinks to create a table of contents in your Excel Reports.