Apex Technology Blog

Microsoft Excel is an extremely capable spreadsheet creation and management tool, made all the more powerful through the inclusion of many handy shortcuts and features. We wanted to share one for a common enough function that you are effectively sure to find a use for it: quickly adding up the values in a single column.

If you have ever invested time and effort into an Excel spreadsheet, then you know how irritating it is to move all of that data to a different sheet. Thankfully, you can easily and accurately copy this data using a simple technique. Here’s how you can do it.

Modern spreadsheet programs, like Microsoft Excel or Google Sheets, carry a plethora of functions under the surface that—if used correctly—can take their utility to another level. For instance, the cells in your spreadsheets can be turned into dropdown menus. Let’s go over how to do so in both Excel and Sheets.

In what seems to be the final stage of a plan that Microsoft has been inching towards for years, Microsoft Office will apparently be phased fully into the Microsoft 365 brand. Let’s consider what we know so far about this change.

Microsoft Excel is a great tool that can provide loads of value to power users, but oftentimes users just don’t have the know-how to make the most of it. Thankfully, you have power users like us to guide you through some of the more intricate processes in the spreadsheet software. Let’s look at one such process: removing duplicate values in columns.