Excel 2010 NL tips

Charts in Excel 2010

Charts in Excel make overviews more readable and visually appealing for the recipient. Creating charts in Excel is fairly straightforward. Here’s how to do it.

Excel formula: Convert text to date

Exported data from another system and no date formatting in Excel? Here’s the solution.

Calculating Age in Excel

How often do you need to know someone’s age? If you know the date of birth, Excel can calculate it for you.

Excel 2010 Function: COUNTIF

In Excel 2010, you can count how often a specific value appears using the Excel function COUNTIF.

Spell Check in Excel

In Microsoft Word, users are corrected live for any spelling errors. However, in Excel this feature is not enabled by default.

Excel: Freeze Panes

Freezing the top rows in Excel is called Freeze Panes, and here’s how you use it. With video instruction!