Do you need a list that’s based on spreadsheet data? Excel is your friend! An Excel list makes it easier to enter and track your data. Today we’ll cover three different types of lists you can add to your Excel worksheets: custom lists, dropdown lists, and checklists. 1. Custom Lists If you frequently use the […]
Continue Reading
Every Excel workbook contains at least one worksheet. You can create multiple worksheets to help organize your data, and each worksheet is shown as a tab at the bottom of the Excel window. These tabs make it easier to manage your worksheets. Currently, the Excel worksheet row limit is over 1 million, and the column […]
Continue Reading
Despite not being as powerful as software specifically for statistics, Excel is actually quite adept at running basic calculations, even without add-ins (though there are some add-ins that make it even better). You probably know that it can do arithmetic, but did you know that it can also quickly get percentage change, averages, standard deviation […]
Continue Reading
If you have a data-heavy chart, it can often be helpful to have a visual representation of that data. Unsurprisingly, Excel has robust visualization features, making it easy to create powerful graphs and charts in Excel. You can even use Excel to create self-updating graphs! If you want to play around with it but don’t have […]
Continue Reading
An Excel dashboard is a great way to show off the most pertinent pieces of data from a big, unwieldy spreadsheet. Whether it’s for your own reference, or to pass on information to others, it’s a great way of separating the wheat from the chaff. In this guide, I’m going to produce a dashboard that […]
Continue Reading
Microsoft Excel has an array of useful features for creating powerful spreadsheets with charts and tables. But, when you want to take your spreadsheet to the next level, beyond fancy text or themes, you may need the help of an add-in. With these handy tools, you can create more visually stimulating representations of your data. […]
Continue Reading