Frank Hänel
@excelwithfrank.bsky.social
📊 Data Diva by day, Excel Enthusiast by night
💡 Simplifying Data One Cell at a Time
🚀 Follow to level up your Excel game!
https://www.instagram.com/excelwithfrank/
💡 Simplifying Data One Cell at a Time
🚀 Follow to level up your Excel game!
https://www.instagram.com/excelwithfrank/
May your holiday season be merry and bright, and the New Year bring you happiness and success. #christmas #excel
December 24, 2024 at 6:21 PM
May your holiday season be merry and bright, and the New Year bring you happiness and success. #christmas #excel
🔡 Excel Hack: Master the LEFT Function!
Need to extract specific parts of your text in Excel? The LEFT function makes it easy to grab characters from the beginning of any text string. 🎯
Ready to take control of your text? 🔥 Try it out and simplify your workflow!
#ExcelTips #Excel #ExcelHacks
Need to extract specific parts of your text in Excel? The LEFT function makes it easy to grab characters from the beginning of any text string. 🎯
Ready to take control of your text? 🔥 Try it out and simplify your workflow!
#ExcelTips #Excel #ExcelHacks
December 23, 2024 at 2:21 PM
🔡 Excel Hack: Master the LEFT Function!
Need to extract specific parts of your text in Excel? The LEFT function makes it easy to grab characters from the beginning of any text string. 🎯
Ready to take control of your text? 🔥 Try it out and simplify your workflow!
#ExcelTips #Excel #ExcelHacks
Need to extract specific parts of your text in Excel? The LEFT function makes it easy to grab characters from the beginning of any text string. 🎯
Ready to take control of your text? 🔥 Try it out and simplify your workflow!
#ExcelTips #Excel #ExcelHacks
🎥 Top 5 YouTube Videos on Filtering in Excel! 🎥
Ready to master the art of filtering in Excel? These incredible tutorials will take you from beginner to pro in no time! 🚀
#Excel #dataanalytics #datascience #datascientist #dataanalyst #spreadsheets
👉 www.instagram.com/p/DD4g15Vum5...
Ready to master the art of filtering in Excel? These incredible tutorials will take you from beginner to pro in no time! 🚀
#Excel #dataanalytics #datascience #datascientist #dataanalyst #spreadsheets
👉 www.instagram.com/p/DD4g15Vum5...
Login • Instagram
Welcome back to Instagram. Sign in to check out what your friends, family & interests have been capturing & sharing around the world.
www.instagram.com
December 22, 2024 at 7:28 PM
🎥 Top 5 YouTube Videos on Filtering in Excel! 🎥
Ready to master the art of filtering in Excel? These incredible tutorials will take you from beginner to pro in no time! 🚀
#Excel #dataanalytics #datascience #datascientist #dataanalyst #spreadsheets
👉 www.instagram.com/p/DD4g15Vum5...
Ready to master the art of filtering in Excel? These incredible tutorials will take you from beginner to pro in no time! 🚀
#Excel #dataanalytics #datascience #datascientist #dataanalyst #spreadsheets
👉 www.instagram.com/p/DD4g15Vum5...
Reposted by Frank Hänel
I’d be interested to know if there’s a simpler way
How to Identify Rows with Missing Values using Power Query
youtu.be/TAGn9hJ93AA
#PowerQuery #PowerBI #Excel
How to Identify Rows with Missing Values using Power Query
youtu.be/TAGn9hJ93AA
#PowerQuery #PowerBI #Excel
December 21, 2024 at 10:06 AM
I’d be interested to know if there’s a simpler way
How to Identify Rows with Missing Values using Power Query
youtu.be/TAGn9hJ93AA
#PowerQuery #PowerBI #Excel
How to Identify Rows with Missing Values using Power Query
youtu.be/TAGn9hJ93AA
#PowerQuery #PowerBI #Excel
Reposted by Frank Hänel
When you need to write 484 UPDATE statements for your SQL database, but that number might change, and you really want to do it with just one formula. #Excel
December 19, 2024 at 8:50 PM
When you need to write 484 UPDATE statements for your SQL database, but that number might change, and you really want to do it with just one formula. #Excel
1/ COUNTIF and SUMIF are great, but… If you're working with simple criteria, they work perfectly. But when you need to analyze data with multiple conditions, their counterparts COUNTIFS, SUMIFS, etc., are far more powerful and flexible. 🚀 Let’s break it down.
#Excel #ExcelTips #ProTip
#Excel #ExcelTips #ProTip
December 20, 2024 at 9:29 AM
1/ COUNTIF and SUMIF are great, but… If you're working with simple criteria, they work perfectly. But when you need to analyze data with multiple conditions, their counterparts COUNTIFS, SUMIFS, etc., are far more powerful and flexible. 🚀 Let’s break it down.
#Excel #ExcelTips #ProTip
#Excel #ExcelTips #ProTip
🚀 Master Stocks with Excel! 💹💡
Unlock the full potential of Excel with these essential functions for stock analysis, portfolio management, and data import.
#StockAnalysis #ExcelTips #Investing #FinanceTools #DataDriven #PortfolioManagement #Excel #Exceltips #Finance #Stocks
Unlock the full potential of Excel with these essential functions for stock analysis, portfolio management, and data import.
#StockAnalysis #ExcelTips #Investing #FinanceTools #DataDriven #PortfolioManagement #Excel #Exceltips #Finance #Stocks
December 19, 2024 at 2:21 PM
🚀 Master Stocks with Excel! 💹💡
Unlock the full potential of Excel with these essential functions for stock analysis, portfolio management, and data import.
#StockAnalysis #ExcelTips #Investing #FinanceTools #DataDriven #PortfolioManagement #Excel #Exceltips #Finance #Stocks
Unlock the full potential of Excel with these essential functions for stock analysis, portfolio management, and data import.
#StockAnalysis #ExcelTips #Investing #FinanceTools #DataDriven #PortfolioManagement #Excel #Exceltips #Finance #Stocks
🔢 Make Counting Effortless with the COUNTIF Function!
Need to quickly count how often something appears in your data? COUNTIF has you covered! 🎯
#ExcelTips #ExcelFunctions #ExcelHacks #DataAnalysis #ExcelSkills #exceltutorial #Excel #excelforbeginners #DataScience #datacleaning #DataAnalytics
Need to quickly count how often something appears in your data? COUNTIF has you covered! 🎯
#ExcelTips #ExcelFunctions #ExcelHacks #DataAnalysis #ExcelSkills #exceltutorial #Excel #excelforbeginners #DataScience #datacleaning #DataAnalytics
December 19, 2024 at 9:29 AM
🔢 Make Counting Effortless with the COUNTIF Function!
Need to quickly count how often something appears in your data? COUNTIF has you covered! 🎯
#ExcelTips #ExcelFunctions #ExcelHacks #DataAnalysis #ExcelSkills #exceltutorial #Excel #excelforbeginners #DataScience #datacleaning #DataAnalytics
Need to quickly count how often something appears in your data? COUNTIF has you covered! 🎯
#ExcelTips #ExcelFunctions #ExcelHacks #DataAnalysis #ExcelSkills #exceltutorial #Excel #excelforbeginners #DataScience #datacleaning #DataAnalytics
🔗 Excel Collaboration Made Easy! 🔗
Did you know you can share a specific range in your Excel workbook? With the ‘Link to this range’ feature, you can direct your team to exactly the right spot—no more hunting through endless rows and columns! 🎯
#Excel #Exceltips #Teamwork #Collaboration
Did you know you can share a specific range in your Excel workbook? With the ‘Link to this range’ feature, you can direct your team to exactly the right spot—no more hunting through endless rows and columns! 🎯
#Excel #Exceltips #Teamwork #Collaboration
December 18, 2024 at 6:08 PM
🔗 Excel Collaboration Made Easy! 🔗
Did you know you can share a specific range in your Excel workbook? With the ‘Link to this range’ feature, you can direct your team to exactly the right spot—no more hunting through endless rows and columns! 🎯
#Excel #Exceltips #Teamwork #Collaboration
Did you know you can share a specific range in your Excel workbook? With the ‘Link to this range’ feature, you can direct your team to exactly the right spot—no more hunting through endless rows and columns! 🎯
#Excel #Exceltips #Teamwork #Collaboration
💡 Say goodbye to duplicates and hello to cleaner data with Excel's UNIQUE function! 🎉
#ExcelTips #ExcelFunctions #ExcelHacks #DataAnalysis #ExcelSkills #exceltutorial #Excel #ExcelForBeginners #datamanagement #DataScience
#ExcelTips #ExcelFunctions #ExcelHacks #DataAnalysis #ExcelSkills #exceltutorial #Excel #ExcelForBeginners #datamanagement #DataScience
December 18, 2024 at 2:21 PM
💡 Say goodbye to duplicates and hello to cleaner data with Excel's UNIQUE function! 🎉
#ExcelTips #ExcelFunctions #ExcelHacks #DataAnalysis #ExcelSkills #exceltutorial #Excel #ExcelForBeginners #datamanagement #DataScience
#ExcelTips #ExcelFunctions #ExcelHacks #DataAnalysis #ExcelSkills #exceltutorial #Excel #ExcelForBeginners #datamanagement #DataScience
🔢 Excel Tip: Sum a Column with Errors Like a Pro! 🔢
Frustrated when errors stop your formulas from working? 🤯 The AGGREGATE function in Excel is your solution!
👉 https://buff.ly/4gwsJHs
#ExcelTips #DataVisualization #DataAnalysis #ExcelHacks #accounting
#Excel #dataanalytics #dataanalysis
Frustrated when errors stop your formulas from working? 🤯 The AGGREGATE function in Excel is your solution!
👉 https://buff.ly/4gwsJHs
#ExcelTips #DataVisualization #DataAnalysis #ExcelHacks #accounting
#Excel #dataanalytics #dataanalysis
December 18, 2024 at 1:32 AM
🔢 Excel Tip: Sum a Column with Errors Like a Pro! 🔢
Frustrated when errors stop your formulas from working? 🤯 The AGGREGATE function in Excel is your solution!
👉 https://buff.ly/4gwsJHs
#ExcelTips #DataVisualization #DataAnalysis #ExcelHacks #accounting
#Excel #dataanalytics #dataanalysis
Frustrated when errors stop your formulas from working? 🤯 The AGGREGATE function in Excel is your solution!
👉 https://buff.ly/4gwsJHs
#ExcelTips #DataVisualization #DataAnalysis #ExcelHacks #accounting
#Excel #dataanalytics #dataanalysis
Reposted by Frank Hänel
🔄 Power Query Challenge 42: Advanced Conditional Splitting!
🎥 Learn how to split text dynamically based without helper columns.
✔ Split IDs into 2 or 3 parts
✔ Master List.Transform & conditional logic
📺 Watch here: www.youtube.com/watch?v=_ILr...
#PowerQuery #ExcelTips #HowToLearnExcel
🎥 Learn how to split text dynamically based without helper columns.
✔ Split IDs into 2 or 3 parts
✔ Master List.Transform & conditional logic
📺 Watch here: www.youtube.com/watch?v=_ILr...
#PowerQuery #ExcelTips #HowToLearnExcel
Advanced Conditional Splitting - Power Query Challenge 42
YouTube video by How to Learn Excel
www.youtube.com
December 17, 2024 at 10:24 PM
🔄 Power Query Challenge 42: Advanced Conditional Splitting!
🎥 Learn how to split text dynamically based without helper columns.
✔ Split IDs into 2 or 3 parts
✔ Master List.Transform & conditional logic
📺 Watch here: www.youtube.com/watch?v=_ILr...
#PowerQuery #ExcelTips #HowToLearnExcel
🎥 Learn how to split text dynamically based without helper columns.
✔ Split IDs into 2 or 3 parts
✔ Master List.Transform & conditional logic
📺 Watch here: www.youtube.com/watch?v=_ILr...
#PowerQuery #ExcelTips #HowToLearnExcel
Want to evaluate your investments like a pro? The NPV function is your go-to tool for calculating the present value of future cash flows based on a discount rate.
#ExcelTips #accounting #DataAnalysis #Excel #dataanalytics #dataanalysis #datascience #Projektmanagement #datascientist #exceltutorials
#ExcelTips #accounting #DataAnalysis #Excel #dataanalytics #dataanalysis #datascience #Projektmanagement #datascientist #exceltutorials
December 17, 2024 at 11:19 PM
Want to evaluate your investments like a pro? The NPV function is your go-to tool for calculating the present value of future cash flows based on a discount rate.
#ExcelTips #accounting #DataAnalysis #Excel #dataanalytics #dataanalysis #datascience #Projektmanagement #datascientist #exceltutorials
#ExcelTips #accounting #DataAnalysis #Excel #dataanalytics #dataanalysis #datascience #Projektmanagement #datascientist #exceltutorials