Steve Scott Articles

How to Ungroup Sparklines in Excel

Click here to Read More »

Standard Deviation in Pivot Tables in Excel

Click here to Read More »

How to Separate Excel Tabs Into Separate Files

Click here to Read More »

Find the Position of a Character in a String in Excel

Click here to Read More »

Can’t Push Objects Off the Sheet in Excel – How to Fix!

Click here to Read More »

Find Last Occurrence of a Value in a Column in Excel

Click here to Read More »

How to Lock a Pivot Table in Excel

Click here to Read More »

Count Days from a Date to Today in Excel (Formula)

Click here to Read More »

How to Convert Date to Quarter in Excel

Click here to Read More »

Convert Latitude Longitude to Decimal Degrees in Excel

Click here to Read More »

Change Count to Sum in Excel Pivot Table

Click here to Read More »

Check If Value is in List in Excel

Click here to Read More »