ELEGIRFILAS es "todo o nada": si un solo índice es inválido, toda la función da error.
La solución: envolverla con MAP + SI.ERROR para evaluar cada índice por separado.
=MAP(indices; LAMBDA(x; SI.ERROR(ELEGIRFILAS(datos; x); "")))
#Excel #ExcelTips #Influexcel
#Android #API #Integration #App #Development #Automation #C# #Programming #Data #Management #Excel
Origin | Interest | Match
Let's dive into a few rounding techniques that can make your reports cleaner and more professional. These work both in #Excel and #PowerBI.🔃
@excelguru.ca will start with ROUND(), explore some variations, and then take it further with MROUND(): youtu.be/uaMClt9jnwU
#DataAnalytics #DataModel
The AKA calls are where you bring puzzles like this and leave with real answers. If you want to build faster, smarter #BusinessIntelligence solutions, come join us at skw-t.com/aka, or get access included with my #Excel Fundamentals (skw-t.com/excelfun) and #SelfServiceBI (skw-t.com/ssbi) Academies.
(Image of a woman sitting at a long office desk looking intently at her computer monitors with her hand on the mouse.) (Skillwave Training logo) Why is my Power Query Solution So Slow??
A question came up in a recent AKA session that many #PowerQuery users will immediately recognize: "I built two versions of a file-combining solution, and one is ridiculously slow - why?" 😭
The student had a folder of #Excel files containing production data and needed to consolidate everything.🧵
Need a list of dates for the last 30 days?
Stop copying and pasting! 🛑
Generate a sequence of dates in Excel with one formula.
Clean, quick, and dynamic. 📅💡
DOWNLOAD this example workbook here
📖 https://link.howtoexcel.com/sp/0f8070f5522
#microsoft #excel #tech #tutorial #exceltips
列幅、ダブルクリックで揃えてませんか？💦
それだと、
列全体のセルが基準となって調整されてしまう…
実は、
特定のセルを除いた範囲で
"瞬時に"列幅を自動調整する方法があります！
👇手順はこちら
it-yobi.com/excel-b-noex...
#Excel
表を縦に繋ぐ✨
→トリム参照を使うと簡単に繋げられます！
=VSTACK(E.:.F, H.:.I)
・VSTACK：指定範囲を縦に繋げる関数
・E.:.F：E~Fの上下の空白行を除外した範囲
・H.:.I：H~Iの上下の空白行を除外した範囲
条件付き書式を組み合わせることで、書式も自動設定！
#Excel
BlueSky
Excel has no built-in "compare columns" button.
But some #Excel formulas will find matches, gaps, and differences in seconds
For #Microsoft365 #Office2024 #Office2021 it'll keep results live if the lists change.
office-watch.com/2026/how-to-compare-two-...
El separador de filas en constantes matriciales de Excel cambia según el idioma:
🇪🇸 Español: {1\2\3}
🇬🇧 Inglés: {1;2;3}
Si copias una fórmula entre versiones, los separadores chocan.
#Excel #ExcelTips #Influexcel
Kiolix Xel is now available on the App Store and Microsoft Store.
Built for Excel work: data profiling, summaries, and report generation in one workflow.
Launch offer: 60% off through the end of May. Details and store links: https://xel.kiolix.com #KiolixXel #Excel #MicrosoftStore #AppStore
OK so I can't make waterfall or scatter plot charts. Are those even useful?
#Excel #Upskilling
Was this from August 2025 PC Gamer ?
Yes
Is this still applicable and funny ?
Also Yes
#CoPilot
#excel
Join Our Upcoming Meetup with a Global Excel Champion!
We’re excited to invite you to a special session featuring Jean Philippe Christian Mbolanantenaina.
🔗 Register here: www.meetup.com/azerbaijanai...
#Excel #PowerBI #DataAnalytics #FinancialModeling #ExcelCompetition #FMWC #MicrosoftExcel
I can make charts now! 🎉
#Excel #Upskilling
👏 Huge thank you to Bernat for sharing his expertise and contributing to our growing data community.
🎥 Watch the full recording here:
www.youtube.com/live/PG5jzlM...
#Excel #PowerBI #MicrosoftFabric #DataAnalytics #AI #DataCommunity #Meetup #Learning #BusinessIntelligence
We had an awesome time learning about #Accessibility best practices in #PowerBI with Juliana Smith at last week's Vancouver Power BI and Modern #Excel meet-up! 👏 Learn how you can ensure #DataInsights are available to everyone, fostering inclusivity and compliance:
I’m taking this time to learn Excel and Power BI (Skillwave Training logo) (Microsoft Excel and Power BI icons) (Image of a woman sitting in front of a laptop, looking straight into the camera with her chin on her hand)
Are you ready to elevate your #DataAnalytics skills to new heights? 💫 Join today and unlock the full potential of #Excel and #PowerBI. Our courses are designed by leading #BusinessIntelligence experts, real professionals who’ve been in your shoes and conquered the data world. Go to skw-t.com/courses
📊Quarter info from dates?
Excel makes it effortless.
Stop entering them manually, start calculating! 📈⚡
DOWNLOAD this example workbook here
📖 https://link.howtoexcel.com/sp/0f8070f5522
#microsoft #excel #tech #tutorial #exceltips #exceltricks #microsoftexcel
『「セル結合を含む表」を一瞬で「集計可能な表」に変換する機能』を作ってみました✨
一度作れば、Excelの標準機能に追加することもできます！
👇作り方・実践ファイルはこちら
it-yobi.com/excel-p-no30...
※今回はメンバー限定公開です！
#Excel
Ditch the messy spreadsheets. 📊 Build a real-time Inventory Dashboard in Excel.
Guide: 📃 scriptdatainsights.blogspot.com/2026/04/exce...
Watch: 🎞️ youtube.com/shorts/TuTrb...
Tools: 🛒 scriptdatainsights.gumroad.com/l/april-skil...
What’s the one KPI you can’t live without? 📈
#Excel #Data #Business
Turn raw inventory data into executive insights. 📊🚀
Full Blog: 📃 scriptdatainsights.blogspot.com/2026/04/exce...
Video: 🎞️ youtube.com/shorts/TuTrb...
Assets: 🛒 scriptdatainsights.gumroad.com/l/april-skil...
Do you prefer Excel or PowerBI for your dashboards? 📈
#Excel #DataScience #Business
『条件付き書式』でサイコロを作れます✨
遊びに見えるけど、
実はロジック理解にめっちゃ効きます。
👇
#Excel
日付に文字をつけたら
「46133」みたいになったことありませんか？
Excelでは日付は数値で管理されています。
そんなときは
『TEXT関数』を使います✨
▼×
結果：【46133】日報
数式：="【"&B2&"】日報"
▼○
結果：【2026/4/21】日報
数式：="【"&TEXT(B2,"yyyy/m/d")&"】日報"
#Excel
Easily extract and transform text with FLASHFILL in Excel
DOWNLOAD this example workbooks here:
📖 https://howtoexcel.com/downloads?fsrc=shortform
Thanks for all your support!
#microsoft #excel #tech #tutorial #exceltips #exceltricks #microsoftexcel
⏰Adding days to dates manually in Excel?
That’s so 1999.
Use this simple formula in Excel and save hours! 🕒🔥
DOWNLOAD this example workbook here
📖 https://link.howtoexcel.com/sp/0f8070f5522
#microsoft #excel #tech #tutorial #exceltips #exceltricks #microsoftexcel
#Automation #Data #Analysis #Excel #Python #Regular #Expressions #Scripting #Software #Architecture #Web
Origin | Interest | Match
