When it comes to creating spreadsheets, the software that comes to most people’s minds is Microsoft Excel. Microsoft Office is a complete suite that lets users create documents, spreadsheets, slide ...

Create a report using charts: Select Insert > Recommended Charts, then choose the one you want to add to the report sheet. Create a report with pivot tables: Select Insert > PivotTable. Select the ...

What is a Custom Template? When you work with Excel, you often find yourself performing the same tasks repeatedly. This is where creating custom templates can be a catalyst. By learning how to create ...

Bad spreadsheet habits create hidden data problems that break calculations and make files harder to maintain.

Here’s a quick tip for creating a Microsoft Excel drop down list from another tab. The data you want to use in an Excel drop down list usually won’t be in the same sheet as the drop down. The good ...

Microsoft recently announced that they are adding a feature to Excel that will allow Python code to be embedded and used for advanced analytics. That made me wonder if it might be possible to create ...