Make a Table of Contents in a Workbook - Excel tutorial

Category: Excel tutorials > Basics - Difficulty:

One feature that we don’t use often is separating just one slice from the pie chart to highlight that specific piece of data. I'll show you step by step, how to do this.

Calculate the Net Present Value of a series of cash flows.

The Data Autofilter allows you to investigate large quantities of information and filter out unnecessary rows. Extremely useful if you work with large quantities of data.

This video tutorial shows how to use the logarithm function in Excel.

Let's say you are making an Excel table where you shall input how many hours did you work for everyday. And you would like to make designation with colors. Red number for less than 8, blue for 8 and green color for more than 8. You can make that process automatic in MS Excel and here's how.