Welcome to Excel Jet Consult blog post. In this blog, we will learn how to get daily and weekly historical stocks data of IBM and Microsoft from Alpha Vantage API. Lets get started Alpha Vantage API The first thing we need to do is go to www.alphavantage.co to register and generate API key. Next, we are going to flip to […]

Welcome to Excel Jet consult blog post. In this post, we are going to learn how to write Excel formula to generate weekdays and Month. Let’s get started Generate Weekdays Starting on Sunday The first demo we want to cover is how to write the Excel formula to generate weekdays with Sunday is the first day of the week. To […]

Introduction Excel Power Query is a powerful tool that allows transformation and manipulation of data for more effective analysis and reporting. One valuable technique to transform data is the creation of a calendar table, which typically helps to manage and visualize time-related data. In this article, we will go through the process of creating a calendar table using Power Query and explore the many […]

INTRODUCTION Welcome to Excel Jet Consult blog post. Microsoft Fabric Data Warehouse is a cloud-based data platform that enables you to store, analyze, and share large volumes of structured and semi-structured data. SQL Endpoint is a service that allows you to run SQL queries on your data warehouse using a web-based interface. CREATE TABLE & INSERT RECORDS One of the […]

Introduction Microsoft Fabric is an all-in-one toolbox for crunching numbers and making sense of data. It’s got a bunch of tools, like moving data around, storing it in lakes, doing engineering work on it, mixing it together, using it for science stuff, keeping an eye on it in real-time, and helping you make smart business decisions. And the best part […]

Introduction Welcome to Excel Jet Consult blog post. Power BI, Microsoft’s powerful business analytics service, empowers users to transform data into insightful reports and dashboards. After creating a compelling Power BI report on your desktop, the next step is to share it with stakeholders. This is where the Power BI Service comes into play. In this blog post, I will […]

Introduction Microsoft Excel is an amazing spreadsheet software that offers a wide range of functions to help users manipulate and analyze data efficiently. One such function that proves to be incredibly useful in financial and date-related calculations is the YEARFRAC function. In this article, we are going to delve into what the YEARFRAC function is, how it works, and various […]

Introduction Welcome to Excel Jet Consult blog post. In this blog, we will be focusing on Data Engineering and Data Engineer in the new Microsoft Fabric technology. Let’s get started. Data is the new oil, as the saying goes because data is the fuel that powers modern businesses, enabling them to gain insights, optimize processes, and create value. To harness […]

Excel to Excel Jet Consult blog post. Microsoft recently introduced a new feature called Stale Value Formatting in Excel that applies strikethrough formatting to any values that become “stale” when tinkered in manual calculation mode. Users can manage this feature through the Calculation Options area in the Formulas tab on the Ribbon Stale Value Formatting is an application setting that […]

Welcome to Excel Jet Consult blog post. In this blog post, I am going to wslk you through how to enable the Excel Labs add-in which is an editor that we can use to author Python code in Excel using the new PY function. Let’s get started. The Python Editor is a new addition to Excel Labs that allows users to write […]