Microsoft Excel is a spreadsheet application that you can use to record data, make calculations and create charts. In this article I’ll introduce you to the basics of working in Excel. We’ll look at ...

If you're a spreadsheet jockey but you're not keen on Excel's default settings, reader Curare details how to set up a custom Excel template so the data-wrangling app always uses the workspace you ...

Have you ever found yourself endlessly scrolling through a sprawling Excel workbook, struggling to locate the exact worksheet you need? For those managing complex datasets or collaborative projects, ...

Number formats in Microsoft Excel define how data is displayed in your spreadsheet without changing the underlying values. As well as using number formats to present data as dates, times, percentages, ...

Here's how to create your own animated Christmas tree in Excel: Open up a new spreadsheet. Click the triangle button in the ...

Microsoft Office Excel helps small-business owners analyze price trends, collect demographic data to improve your marketing efforts and produce customized reports for your bank or investors. The ...

Sometimes when I’m working with an Excel worksheet and I want a cell to look a certain way, I run into what appears to be a limitation in the program. It might be trying to enter product numbers with ...

Data validation in Excel lets you restrict what can be entered into a cell, whether whole numbers, decimals, dates, or a certain number of characters. However, one of the most powerful capabilities of ...

Create a CRM using Excel with dropdown customer selection and FILTER plus XLOOKUP, saving time while keeping leads and deals ...

Computer programs frustrate users when something that worked before stops working, especially when there is no clear indication as to why. With Excel 2007, Excel 2010 and Excel 2013, the "Custom Views ...