MS Excel: How to add serial numbers to identical items without sorting the data.

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)

MS Excel: How to add serial numbers to identical items without sorting the data.

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

MS Excel: How to add serial numbers to identical items without sorting the data.

Description

Tags

Watch on Youtube