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