Everyone tells you that Excel is NOT a Database, but they don't offer you options or tell you how to handle your data.

I WILL tell you HOW TO DO IT: We are going to combine Excel + SQL Server + Power Query and Pivot Tables.


✅ Get certified in Excel | https://www.exceleinfo.com'>https://www.exceleinfo.com/certificac...

⭐ Tutorials and free files | https://www.exceleinfo.com'>https://www.exceleinfo.com

Download EXCELeINFO addin | https://addin.exceleinfo.com

Subscribe to my news list | https://www.exceleinfo.com'>https://www.exceleinfo.com/newsletter



⏱ CHAPTERS ⏱
0:00 Intro
01:06 Save Excel file to CSV
03:54 Create Database and SALES Table in SQL Server
07:51 Insert the CSV data to the SALES database Table
09:38 Create query in Power Query
11:16 Create Pivot Table
12:11 Create new CSV and insert it to Table


FOLLOW ME ON ALL NETWORKS
Website | https://www.exceleinfo.com'>https://www.exceleinfo.com
Facebook |   / exceleinfo  
Instagram |   / sergioacamposh  
LinkedIn |   / sergioacamposh  
Telegram | https://t.me/EXCELeINFO
TikTok |   / sergioacamposh  
Twitter |   / sergioacamposh  

#MsExcel