Steve Scott Articles

Get End of Year Date in Excel (Formula)

Click here to Read More »

How to Insert an Image in a Cell in Excel

Click here to Read More »

Bulk Find and Replace in Excel

Click here to Read More »

Get a List of All Sheet Names in Excel

Click here to Read More »

How to Open Multiple Instances in Excel

Click here to Read More »

Generate All Possible Combinations from Two Lists

Click here to Read More »

Convert Fraction to Decimal in Excel

Click here to Read More »

Make Pivot Table from Multiple Sheets

Click here to Read More »

Reorder Rows in Pivot Table in Excel

Click here to Read More »

Count Distinct Values in Excel Pivot Table

Click here to Read More »

Count Colored Cells in Excel

Click here to Read More »

Change a Pivot Table to Tabular Form

Click here to Read More »