Excel Tutorial

Best Way to Create Dashboard using a Grid – Stocks Performance Analysis and Visualization

Shahid Latif3 years ago2 years ago02 mins

Welcome to our MS Excel dashboard tutorial where we’ll guide you through creating an insightful stock performance dashboard using power pivot, pivot tables, slicer, and timeline. In this tutorial, we’ll show you how to: #ExcelTutorial #DataAnalysis #DashboardDesign #StockPerformance #TechCompanies #PowerPivot #PivotTables #Slicer #Timeline #DataModel #MicrosoftExcel #FinancialAnalysis #DataVisualization #StockMarket #Meta #Google #Microsoft #Apple #DataVisualization #Tutorial #SubscribeNow…

Data Modeling and Reporting in MS Excel using Power Pivot and Pivot Tables

Shahid Latif3 years ago2 years ago02 mins

Welcome to our MS Excel data modeling tutorial! In this session, we will guide you through the process of connecting various CSV files to your Microsoft Excel file and creating a comprehensive data model using Power Pivot. To get started, make sure to download the dataset from the link provided in the comments section below…

Comparing Various Projected Data Scenarios with Actual Data, Using Data Modeling Technique

Shahid Latif3 years ago2 years ago01 mins

In this tutorial, we’re delving into the world of data analysis using Excel and Power BI. We have an Excel file containing both projected and actual sales data, and we’ll guide you through the process of creating an informative dashboard to compare different sales scenarios with the actual data. We’ll cover everything from importing data…

Using Formulas like a Boss, By Using Actual Names instead of Cell References

Shahid Latif3 years ago2 years ago03 mins

Are you tired of using meaningless cell references in your formulas? Do you want to use proper names in your formulas, which are more meaningful, self-explanatory, and understandable? Do you want to make your formulas look more professional and unique? Then welcome to our tutorial on named references. In this tutorial, we’ll show you how…

Dealing with Error in DAX Find/Search formulas, with Practical Product Analysis Example

Shahid Latif3 years ago2 years ago03 mins

In this tutorial, we’ll walk you through the process of creating an insightful dashboard to compare the price, cost, and profit of various products. We’ll use Excel and Power BI to extract and visualize the data. Follow along to learn how to transform raw information into valuable insights. To begin, open the Excel file in…

Calculating, Comparing, and Visualizing Simple Returns and Log Returns

Shahid Latif3 years ago2 years ago03 mins

Hey there, welcome to my MS Excel tutorial! In today’s video, we’re diving into the world of investment simulations using Microsoft Excel. I’ll walk you through the process of comparing simple returns with log returns, helping you gain a better understanding of these concepts. First off, log returns might sound a bit complex, but they’re…

Simplifying Complex Nested Conditional Formulas using Easy and Understandable Method

Shahid Latif3 years ago2 years ago02 mins

In this tutorial, we’ll show you how to write a large, complex, nested conditional formula in Microsoft Excel, but in a simple and understandable manner. We’ll guide you through the process of adding multiple conditions using a straightforward technique that minimizes the risk of errors and confusion. Using a practical example with a credit dataset,…

Creating an Animated GPS Route on a 3D Map Using MS Excel

Shahid Latif4 years ago2 years ago02 mins

The video is a tutorial that guides the viewer through the process of creating an animated GPS route on a 3D map using Microsoft Excel. The presenter explains that to design this visualization, three columns are required: GPS coordinates in latitude and longitude, and a time column. To begin, the presenter suggests downloading GPS data…

Creating 3D Maps and Tours in Microsoft Excel with Picture Backgrounds

Shahid Latif4 years ago2 years ago03 mins

This video is a tutorial on how to create a 3D map using Microsoft Excel. The presenter begins by stating that the information will be presented using Microsoft Excel 3D maps, and a picture background map will be used to display sensor data. The video provides step-by-step instructions for creating the 3D map. First, the…

Power Query vs DAX for Beginners: When to Use Which in Power BI?

How to Peform YoY Comparison in Power BI – For Begginers

Complete Power BI Tutorial with Custom Graphics, Animated Background, Dynamic Values and Much More – Global E-Commerce Supply Chain

North American Company

How to Fix Mapping Errors in Power BI (Accurate Location Data Tutorial)

Power BI: Build a Dynamic Risk Matrix Simulation in Power BI Using DAX & Parameters

Excel: How to Correct Wrong Date Formats in Seonds without using Complex Forumulas and Methods.

Power BI Desktop: Creating Dashboard with 60,000 Plus Photos and Generating Dataset from file names

Learn By Example: Python File Organizer – Learn Windows Automation using os, shutil, and pathlib

Data Analysis with R: Tutorial for Beginners – Want to Learn Data Analysis with R, Start Here

Data Modeling and Reporting in MS Excel using Power Pivot and Pivot Tables

Comparing Various Projected Data Scenarios with Actual Data, Using Data Modeling Technique

Using Formulas like a Boss, By Using Actual Names instead of Cell References

Dealing with Error in DAX Find/Search formulas, with Practical Product Analysis Example

Calculating, Comparing, and Visualizing Simple Returns and Log Returns

Simplifying Complex Nested Conditional Formulas using Easy and Understandable Method

Creating an Animated GPS Route on a 3D Map Using MS Excel

Creating 3D Maps and Tours in Microsoft Excel with Picture Backgrounds