Excelypedia

The Excel Encyclopedia of The Internet

Add-ins in Excel

by

You may find yourself needing extra tools to really bring your data to life. Excel supports additional applications, here's how to use add-ins in Excel.

Hyperlinks in Excel

by

When you’re working in a spreadsheet, it’s often useful to include URLs and online links. Here's how to add hyperlinks in Microsoft Excel.

Add Color Scales in Excel

by

When you’re working with data in Microsoft Excel, it’s often useful to apply simple color codes. Here's how to add Color Scales in Microsoft Excel.

Chart in Excel

by

Pictures, it’s often said, are worth a thousand words. It follows that charts may be worth a thousand numbers! Here's how to build charts in Excel.

Lock a Row in Excel

by

When you’re working in a spreadsheet, it’s often useful to lock certain rows in view at all times. Let’s learn how to lock a row in Excel.

Trendline in Excel

by

Trendlines are chart features that help illustrate patterns in a set of data. Let’s learn how to add a trendline in Microsoft Excel.