Excel: Lookup Functions, VLookup, HLookup, XLookup and Lookup (Tutorial)

Home

Recent Tutorials All Tutorials All Topics Youtube Facebook Forums

Spreadsheets

MS Excel

MS Excel: Pivot Tables, Pivot Charts Filters and Slicers (Tutorial)Excel: Lookup Functions, VLookup, HLookup, XLookup and Lookup (Tutorial)Excel: Using the Fill Features MS Excel: Pivot... Pivot... Pivot...Excel: Mapping, Grouping and Summarizing data in MS Excel (Tutorial)MS Excel: Conditional Formatting Explained MS Excel: Creating a Bell Curve in Microsoft Excel: A Step-by-Step Tutorial MS Excel: Predicting Sales with Linear and Non-Linear Demand Curve Models (Tutorial)MS Excel: Using the Break-Even Decision Model to Determine the Optimal Production Method MS Excel/Power BI: Unpivoting and Properly Pivoting Data in MS Excel and Power BI MS Excel: What lies beneath an Excel file?MS Excel: How to add serial numbers to identical items without sorting the data.MS Excel: Creating 3D Maps and Tours in Microsoft Excel with Picture Backgrounds MS Excel: Creating an Animated GPS Route on a 3D Map Using MS Excel MS Excel: Using What If Analysis to Forecast Profits Based on Sales Values in Excel (File in Link)MS Excel: Using Excel Slicers to Filter Data Quickly and Easily Power BI: Realtime Sales Simulation using SQL Server and Direct Query (Portfolio Project)MS Excel: How to Create Relational Data Models, and use them in Pivot Tables and Charts Power BI: Creating Pareto Charts in MS Excel and Power BI to analyze reasons by percentages MS Excel: Create a Smart, Dynamic, Personal Accounts Manager using Pivot Tables and Charts MS Excel:Â How to Use Calculated Fields and Items in Pivot Tables - A Tutorial for Excel Users MS Excel: Simplifying Complex Nested Conditional Formulas using Easy and Understandable Method MS Excel:Â Calculating, Comparing, and Visualizing Simple Returns and Log Returns MS Excel:Â Using Formulas like a Boss, By Using Actual Names instead of Cell References MS Excel:Â Data Modeling and Reporting in MS Excel using Power Pivot and Pivot Tables MS Excel: Mastering Excel Dashboards and Visualization using a Restaurant Sales Dataset.MS Excel: Best Way to Create Dashboard using a Grid - Stocks Performance Analysis and Visualization.

Visualizations

Power BI

AI/ML

Python

Python: Easiest way to download, install/setup and use python (WinPython Tutorial)Python: How to use World Bank API (WBGAPI) and Pandas to import data, and draw charts (Tutorial)Python: Data Scraping from web using Selenium, WebDriver and XPath (Tutorial)Python: How to work with SQL server database and queries in Python using pyodbc (Tutorial)Python: How to work with pandas, create, manage and visualize dataframes (Tutorial)Python: How to create and train a neural network machine learning model using sklearn/scikit-learn Python: How to perform loops (for/while/nested) in python (Tutorial)Python: Support Vector Machine for Classification (Tutorial)Python: Web Scraping using Pandas, How to import HTML table from Wikipedia (Tutorial)Python: Machine Learning, Classification using Nearest Centroid Classifier (Tutorial)Python: How to classify data using K Nearest Neighbors, Neighborhood Components Analysis and Pipline Python: How to save, reload and reuse a machine learning model in Python (Tutorial)Python: Why you should not trust a stocks prediction model.Python: Expected Returns (Finance/Risk Management) using PyPortfolioOpt Python: Creating a GUI based application (calculator) in Python using tkinter (Tutorial)Python: Predicting absenteeism at work, using simplest model (Tutorial)Python: Unleashing the Power of Statistics in Python: A Hands-On Guide Power BI: Displaying Live System Performance using Power BI, SQL and Python Power BI: Realtime Call Center Performance Simulation using Python, SQL and Power BI Power BI: Creating your first Python Visual in Power BI Desktop Power BI: Using SQL Query Instead Of Power Query To Get Data From Any Data Source Power BI: Displaying SQL Database Usage Information retrieved through Python Script from SQL Server.Python: Performing basic Statistical Analysis in Google Colab using Excel file in Google Drive Python: Mastering Data Visualization with PyPlot Library in 12 Minutes Python: Creating Polynomial Regression Line, using sklearn Library in Google Colab Python: Uploading Files Directly From Your PC into Google Colab, and Creating Charts.Python: Mastering NumPy Library, by Performing Sales Analysis

HTML/JS/CSS

Database

MS Access

MS Access: How to Create Relational Databases, Forms, Reports & Queries & Import Data from Excel.

SQL

SQL: How to create databases and tables. Use select, insert, delete, update commands etc. (Tutorial)Power BI:Â Displaying Realtime information in Power BI Dashboard using SQL Server Power BI: Realtime Sales Simulation using SQL Server and Direct Query (Portfolio Project)Power BI: Displaying Live System Performance using Power BI, SQL and Python Power BI: Realtime Call Center Performance Simulation using Python, SQL and Power BI Power BI: Creating a Key Performance Indicator (KPI) using SQL Server Database in BI Report Server Power BI: Creating Data Source and Data Set in Power BI Report Server Using Microsoft Report Builder Power BI: Creating Paginated Reports in Power BI Report Server, using SQL Server Database Power BI: Realtime Plant Simulation using SQL Server and Power BI Dashboard Power BI: Using SQL Query Instead Of Power Query To Get Data From Any Data Source Power BI: Displaying SQL Database Usage Information retrieved through Python Script from SQL Server.Power BI: Realtime Simulation of Coin Flip Probability using SQL and Power BI Power BI: Crafting Dynamic Animated Charts using Power BI and SQL Queries Power BI: Displaying Realtime Boiler Plant Information in Power BI Dashboard using SQL Server Power BI: Automating Data Loading from Online Analyzer flat files to SQL Database & BI Dashboard SQL: SQL Server Reporting Services, Installing, Configuring, and Creating Reports, for Beginners SQL: Creating Realtime Live Reports in SQL Server Reporting Services Power BI: Real-time Data Refreshing using Auto Refresh, Power Automate and Browser Extension Looker Studio: Setting up Public mySQL Server on your PC, and connecting it to Looker Reports Power BI:The Clock - Episode 2 | Displaying a Clock in Power BI with Current Time using SQL & XAMPP

Graphics

Unity 3D

Unity3d: How to create terrain, add trees & water, rotate camera, & create day night (Tutorial)

Adobe Animate

Animate: Classic Tween in Adobe Animate, parachuting from c130 (Animation Tutorial)

Others

Datasets

Adventure Works (SQL Server) Star Corp (SQL Server) Other SQL Datasets (SQL Server) Star Bakery (mySQL Server)

Excel: Lookup Functions, VLookup, HLookup, XLookup and Lookup (Tutorial)

Description

Tags

Watch on Youtube

Home

MS Excel

Power BI

Tableau

Looker Studio

R Language

Python

HTML/JS/CSS

MS Access

SQL

Unity 3D

Adobe Animate

Other Tutorials

Datasets

Excel: Lookup Functions, VLookup, HLookup, XLookup and Lookup (Tutorial)

Description

Tags

Watch on Youtube