Steve Scott 
Microsoft Excel and Google Sheets are currently the two giants in the spreadsheet space. While there are some smaller players as well (such as Airtable, Libre Office, or Open office), …
While Excel is amazing when it comes to analyzing a large amount of data, navigating through this data could be a challenge. For example, if you have daily sales data …
When you copy and paste text from one place to another in Excel, the formatting of that text is often copied along with it. This can be a pain when …
By default, whenever you’re in a cell in Excel and hit the Enter/Return key, the cursor would go down one cell. In most cases, this is what you want (especially …
Pivot tables in Excel provide a powerful tool to group and summarize large datasets, helping you get a bird’s eye view of your data. They come equipped with a variety …
A drop-down list provides a great way to let your user choose from a list of options. It makes data entry quick and easy, which is why it is often …
If you’ve been following our Excel tutorials for a while, you would have come across a reference to the ‘Developer tab’ quite a lot of times. You might also have …
You sometimes need to represent text data as bullet points in Excel. For example, you might need to display bulletin boards, to-do lists, etc. However, Excel was primarily designed for …
We know that a picture is worth a thousand words, and a chart is to data as a picture is to words. They provide a great way to represent data …
Circular references in Excel can be quite a source of annoyance. If you’ve come across this error, you’re not alone. Numerous Excel users face this problem every day, but the …
When you have a lot of data in a spreadsheet it becomes quite difficult to compare the contents of two cells without just staring closely into the screen. Moreover, if …
Imagine you bring home your test scores and you’re really happy with how you’ve scored…up until one of your parents asks you ‘what percentile is it?’ or ‘what’s the cumulative …