Sometimes at work we need to calculate specific metrics, KPIs or just simple percentages, with this principles you can create virtually any calculation you need for work. Having these calculations as ...

Custom functions enable you to add new functions to Excel by defining those functions in JavaScript as part of an add-in. Users within Excel can access custom functions just as they would any native ...

Microsoft's spreadsheet program can do way more than you might realize. These are the hacks and tricks you need to know.

Calculate the difference between two values in your Microsoft Excel worksheet. Excel provides one general formula that finds the difference between numbers, dates and times. It also provides some ...

Microsoft is still finding ways to inject drama into spreadsheets. The Verge points out that Microsoft is giving Excel support for custom live data types, expanding the content you can include well ...

That all changed when I discovered two features in Excel most people don't know about: Watch Window and Custom Views. Together, they provided me with a way to track the numbers that matter without ...

Have you ever stared at an Excel spreadsheet, overwhelmed by its complexity, and thought, “There must be a better way to do this”? You’re not alone. Despite being one of the most widely used tools for ...