How I use Excel as a Data Analyst
A better solution than Excel for SaaS team (ChartMogul) 👉🏼 https://lukeb.co/ChartMogul
Follow the Data 👸🏻 & 🤴🏻 @TinaHuang1 @KenJee_ds
📊 My recommended course for Excel 👉🏼 https://lukeb.co/ExcelBusinessAnalyst
Certificates & Courses
==================================
Coursera Courses:
📜 Google Data Analytics Certificate (START HERE) 👉🏼 https://lukeb.co/GoogleCert
💿 SQL for Data Science 👉🏼 https://lukeb.co/SQLdataScience
🧾 Excel Skills for Business 👉🏼 https://lukeb.co/ExcelBusinessAnalyst
🐍 Python for Everybody 👉🏼 https://lukeb.co/PythonForEverybody
📊 Data Visualization with Tableau 👉🏼 https://lukeb.co/Tableau_UCDavis
🏴☠️ Data Science: Foundations using R 👉🏼 https://lukeb.co/RforDataScienceJH
Coursera Plus Subscription (7-day free trial) 👉🏼 https://lukeb.co/CourseraPlus
DataCamp Courses:
🐍 Python 👉🏼 https://lukeb.co/PythonBasicsDataCamp
📈 Power BI 👉🏼 https://lukeb.co/PowerBIDataCamp
📊 Tableau 👉🏼 https://lukeb.co/TableauDataCamp
🏴☠️ R 👉🏼 https://lukeb.co/RDataCamp
🐍 Data Analyst w/ Python 👉🏼 https://lukeb.co/PythonAnalystDataCamp
DataCamp Subscription (Monthly $25USD) 👉🏼 https://lukeb.co/DataCampSub
👨🏼🏫 All courses 👉🏼 https://kit.co/lukebarousse/data-anal...
Build a Portfolio Online
==================================
👩🏻💻Build portfolio here 👉🏼 http://hostinger.com/luke
Rebate Code: "LUKE"
My Portfolio 👉🏼 https://lukebarousse.tech/
Books for Data Nerds
==================================
📚 Books I’ve read 👉🏼 https://kit.co/lukebarousse/book-reco...
📗 Data Science Must Read 👉🏼 https://geni.us/StorytellingWithData
📙 Tableau 👉🏼 https://geni.us/tableau
📘 Power BI👉🏼 https://geni.us/powerbi
📕 Python 👉🏼 https://geni.us/pythontricks
Tech for Data Nerds
==================================
⚙️ Tech I use 👉🏼 https://kit.co/lukebarousse/computer-...
🪟Windows on a Mac (Parallels VM) 👉🏼 https://lukeb.co/ParallelsFreeTrial
👨🏼💻 M1 Macbook Air (Mac of choice) 👉🏼 https://geni.us/M1macAir8GB
💻 Dell XPS 13 (PC of choice) 👉🏼 https://geni.us/DellNewXPS13
💻 Asus Vivo Book (Lowest Cost PC) 👉🏼 https://geni.us/AsusVivoBook15
💻Lenovo IdeaPad (Best Value PC)👉🏼 https://geni.us/LenovoIdeaPad15
Social Media / Contact Me
======================
🙋🏼♂️Newsletter: https://www.lukebarousse.com/
🌄 Instagram: / lukebarousse
⏰ TikTok: / lukebarousse
📘 Facebook: / datavizbyluke
📥 Business Inquiries: [email protected]
As a member of the Amazon, Coursera, Hostinger, Parallels, Interview Query, and Data Camp Affiliate Programs, I earn a commission from qualifying purchases on the links above. It costs you nothing but helps me with content creation.
00:00 Intro
01:46 Spreadsheets
03:39 VBA
06:04 PowerQuery
09:16 PowerPivot
#datanerd #dataanalyst #datascience
