Data Types Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/data-types/ Bestselling Excel and Power BI Courses Mon, 18 Dec 2023 17:39:31 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Data Types Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/data-types/ 32 32 How to Use Organizational Data Types In Excel https://www.xelplus.com/excel-organizational-data-types/ Fri, 03 Jun 2022 12:16:00 +0000 https://www.xelplus.com/?p=9149 Organizational data types allow you to create your own rich custom data types in the Excel Ribbon. Technically you‘d create them in Power BI and have them show up in the Excel Menu of your team members. This tutorial shows you what organizational data types are and you can set them up from scratch.

The post How to Use Organizational Data Types In Excel appeared first on Xelplus - Leila Gharani.

]]> How to Use Excel’s STOCKHISTORY Function https://www.xelplus.com/excel-stockhistory-function/ Thu, 28 Jan 2021 10:00:00 +0000 https://www.xelplus.com/?p=8967 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.

]]> Excel Stock Data Type to Get Real-Time Stock Metrics https://www.xelplus.com/excel-stock-data/ Thu, 31 Dec 2020 10:38:00 +0000 https://www.xelplus.com/?p=10387 Get the latest stock data in Excel with Excel Data Types. You don't have to worry about the right formula. Everything gets written for you automatically. In this tutorial I show you how to set up your own stock portfolio in Excel from scratch.

The post Excel Stock Data Type to Get Real-Time Stock Metrics appeared first on Xelplus - Leila Gharani.

]]> Excel VBA Data types, DIM & SET (Learn to use them correctly) https://www.xelplus.com/excel-vba-data-types-dim-set/ Sun, 20 Jan 2019 02:21:00 +0000 https://www.xelplus.com/?p=13017 If you like to create efficient Excel macros, it's important to assign the correct data type to each variable. In this tutorial find out why you need to use the DIM statement and when you should use SET instead.

The post Excel VBA Data types, DIM & SET (Learn to use them correctly) appeared first on Xelplus - Leila Gharani.

]]> Free Excel Tutorials (Power Query Hack Included) https://www.xelplus.com/free-excel-tutorials/ Thu, 20 Dec 2018 07:15:00 +0000 https://www.xelplus.com/?p=13808 Find the links to helpful and free Excel tutorials all in one place. These include videos, articles and downloadable Excel files. Whenever you get stuck, refer to this list.

The post Free Excel Tutorials (Power Query Hack Included) appeared first on Xelplus - Leila Gharani.

]]>