We have created sample data containing sales of 6 different companies in four consecutive months (from January to April). The Total Sales sheet represents the total number of sales in all four months ...

You can add a column in Excel by right-clicking or using the “Insert” option. These features are helpful for adding new data to a spreadsheet.

The ampersand symbol is a quick and easy way to combine data in Excel. To explain this method to you, I have created sample data in Excel with the names of some persons (refer to the above screenshot) ...

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions. One of the ...

You can easily hide and unhide columns in Excel by individually revealing hidden columns or using the "Format" option to ...

You’ll find three of them — Goal Seek, Scenario Manager, and Data Tables — under the Data tab, within the Forecast group, ...

Microsoft Excel is an incredibly powerful application that can tackle everything from simple tables to complex financial spreadsheets, and you can even password-protect an Excel file to keep your data ...

Here's how to build smarter checklists in Excel using checkboxes, conditional formatting and task dependencies to help with multi-step processes. In my previous article in this series, I walked you ...