TODAY Archives - Xelplus - Leila Gharani

How to Use Excel’s STOCKHISTORY Function

Leila Gharani — Thu, 28 Jan 2021 10:00:00 +0000

The StockHistory Function in Excel allows you to easily pull historical stock data in Excel with a single formula. You can get daily, weekly or monthly data. Find out how to use this together with sparklines to visualize the trend of different stocks in one view.

The post How to Use Excel’s STOCKHISTORY Function appeared first on Xelplus - Leila Gharani.

How to Create a Project Plan in Excel with Gantt Charts

Leila Gharani — Thu, 25 Jul 2019 09:00:00 +0000

With this complete Excel Gantt chart, you can professionally present your project timeline. It includes task completion, planned timeline versus actual view in one single chart.

The post How to Create a Project Plan in Excel with Gantt Charts appeared first on Xelplus - Leila Gharani.

Data Validation in Excel

Leila Gharani — Thu, 10 May 2018 16:46:00 +0000

Learn how to properly set up data validation in Excel. It's especially useful when you're preparing a data input form, where you require the entered data to meet certain criteria.

The post Data Validation in Excel appeared first on Xelplus - Leila Gharani.

Excel Conditional Formatting Symbols

Leila Gharani — Thu, 29 Jun 2017 09:47:00 +0000

If the conditional formatting icon selection doesn't meet your needs, you can customize your design and still make it dynamic with the help of the IF function and symbols. Explore the example of a project planning dashboard tracking overdue tasks.

The post Excel Conditional Formatting Symbols appeared first on Xelplus - Leila Gharani.