Advertisement · 728 × 90
#
Hashtag
#EXCEL
Advertisement · 728 × 90
Post image

How to use pivot tables in Excel

#microsoft #excel #tech #tutorial #exceltips #exceltricks #microsoftexcel

0 0 0 0
Video

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

0 0 1 0
Video

How to use Table slicers with the GROUPBY function.

DOWNLOAD this example workbooks here:
📖 https://howtoexcel.com/downloads

Thanks for all your support!

#microsoft #excel #tech #tutorial #exceltips #exceltricks #microsoftexcel #excelfunctions #excelformulas

0 0 0 0
Post image

6 Excel habits I had to unlearn to get good at it The difference between struggling with Excel and working smoothly is often just a few habits. There are only a few people who learn Excel in an aca...

#Productivity #Microsoft #Excel #Spreadsheet #Tips

Origin | Interest | Match

0 0 0 0
Preview
Excel VBA | 【業務】データベース検索抽出(履歴管理) #データ抽出 #データ検索 #履歴管理 #標準モジュール YouTubeで開く「データベースのシートの内容を検

『簡易的な検索機能』を作ってみました✨

最大10件分の検索履歴がドロップダウンリストから選択できるようになっています!

👇作り方・実践ファイルはこちら
it-yobi.com/excel-p-no28...

#Excel

0 0 0 0

『ROUND関数』って分かりづらい…

・Excel:四捨五入
11.5 → 12
10.5 → 11

・VBA:銀行丸め(四捨五入、五は偶数へ丸める)
11.5 → 12
10.5 → 10

・Access:銀行丸め(四捨五入、五は偶数へ丸める)
11.5 → 12
10.5 → 10

同じ名前の関数でも、
環境によって機能が異なります💦

#Excel

0 0 0 0

Regla rápida para elegir función iteradora en Excel:

🔹 Celda a celda → MAP
🔹 Fila a fila → BYROW
🔹 Columna a columna → BYCOL

Las tres usan LAMBDA para definir qué hacer con cada elemento. La diferencia es el nivel de granularidad.

#Excel #ExcelTips #Influexcel

2 0 0 0
Preview
Excel VBA 快速上手:零基础构建高效自动化工具 <p><strong>你是否厌倦了每天在 Excel 中重复枯燥的复制、粘贴和格式设置?</strong> Excel VBA(Visual Basic for Applications)是释放 Office 潜力的终极钥匙。本课程旨在帮助完全没有编程经验的用户,通过最精炼的路径,从零开始掌握 Excel 自动化。</p><p>我们将跳过冗长的理论,直接进入实战。你将学习如何通过代码控制 Exce...

🚀 Excel 办公自动化:告别加班神器!

还在手动复制粘贴、处理成千上万行数据吗?这门 Excel VBA 快速入门 课程专为想提升效率的职场人设计。

核心内容:
✅ 零基础入门:从录制宏到编写首行代码。
✅ 核心语法:变量、循环与逻辑判断。
✅ 实战案例:自动生成报表、批量处理工作表。

无论你是财务、数据分析师还是运营,学会 VBA,让电脑为你工作!

🔗 立即开启自动化之路:
www.udemy.com/course/excel...

#Excel #VBA #办公自动化 #高效工作 #Udemy课程

0 0 0 0
Video

Set Excel desktop as the default in SharePoint

#microsoft #excel #tech #tutorial #exceltips #exceltricks #microsoftexcel

1 0 0 0
Preview
Excel | 【便利】VLOOKUP関数で複数件を抽出 #データ抽出 #VLOOKUP #FILTER #IF #ROW #SMALL #COLMUN #IFERRO

『VLOOKUP関数で複数件を抽出する方法』について紹介しました✨

FILTER関数を使いたいけど、会社が対応していない…
そんな時にも使えます!

👇解説&練習用ファイル配布
it-yobi.com/excel-p-no28...

#Excel

1 0 0 0
Video

Get text between two characters in Excel with TEXTBEFORE and TEXTAFTER

DOWNLOAD this example workbook here:
📖 https://howtoexcel.com/downloads

Thanks for all your support!

#microsoft #excel #tech #tutorial #exceltips #exceltricks #microsoftexcel

1 0 1 0
Post image

実は「クイックアクセスツールバー」はブック単位で設定できます✨

さらに、
ブック単位で設定した場合、
特定のパソコンだけでなく、
そのブックを開いたユーザーすべての環境で反映されます!

#Excel

0 0 0 0
多肉植物の照波(てるなみ)
午後3時頃に花が咲き始めるので三時草とも言われるようです。
黄色の可愛い花が一斉に咲き始めました💛

多肉植物の照波(てるなみ) 午後3時頃に花が咲き始めるので三時草とも言われるようです。 黄色の可愛い花が一斉に咲き始めました💛

最近の土日のどちらかは育て親宅にExcelの使い方を教えに行っています🚗³₃
多肉植物栽培の作業のものは既に作ってあるので大丈夫だと思います☺️
ただ今年から地域の事で色々書類を作成するのに必要となったようで急遽勉強したいとの事でした。
先月後半から2~3時間マンツーマンで教えています🍀*゜
普段Excelを使用しないのでPCが苦手な人には難しいと思い学習用にダイソーで購入したExcelの教本を渡してみました💦
厚い本だと開いて勉強する気持ちがおきなさそうなので薄くて要点がまとまっているものとして。
何歳になっても勉強しようと思う気持ちを持つ事は見習わなければ😊
#学ぶ #Excel

30 1 0 0

Caso completo con fichero Excel y todas las soluciones:
influexcel.com/

La tecnica ENCOL+AJUSTARFILAS para intercalar filas es oro puro 💎

#Excel #ExcelTips #Influexcel

0 0 0 0
Post image

How often does Excel crash for you? 🤔

#meme #excel #globalexcelsummit

1 0 0 0
Dynamic Expand Collapse Messages in Excel - Monkey Shorts Episode 020
Dynamic Expand Collapse Messages in Excel - Monkey Shorts Episode 020 In this episode of Monkey Shorts, Ken shows a quick reporting trick he likes to use in complex workbooks. It allows you to collapse a range, but provide a message which only shows up while the range…

Here's a quick reporting trick I like to use in complex #Excel workbooks. It allows you to collapse a range, but provide a message which only shows up while the range is collapsed, inviting the reader to open it and see the data. 🤓https://www.youtube.com/watch?v=m413vFZ2pEg

#ExcelTipsAndTricks

1 0 0 0
Vote Now!
Card #1:
3rd Edition Global Excel Awards
Finalist - Training Provider of the Year
Ken Puls (Skillwave Training)
Vote for Me

Card #2:
3rd Edition Global Excel Awards
Finalist - Best Microsoft Excel Add-in
Monkey Tools
Vote for Me

Voting closes April 30, 2026

Vote Now! Card #1: 3rd Edition Global Excel Awards Finalist - Training Provider of the Year Ken Puls (Skillwave Training) Vote for Me Card #2: 3rd Edition Global Excel Awards Finalist - Best Microsoft Excel Add-in Monkey Tools Vote for Me Voting closes April 30, 2026

As you may have heard, both @excelguru.ca and his Monkey Tools add-in are finalists in the 2026 Global #Excel Awards! 🙌
If you're a fan of Ken's training and/or #MonkeyTools, cast a vote in the following categories:
✅Training Provider of the Year
✅Best Excel Add-in
Vote now at

1 0 0 0
Video

Quick Excel Tip: Use the IMAGE Function with Animmated GIF's in Excel

#microsoft #excel #tech #tutorial #exceltips #exceltricks #microsoftexcel

3 0 0 0
Preview
F2 – Datumsangaben vor 1900 in Excel berechnen – Die ultimative Anleitung Kompatibilität: Die in diesem Artikel vorgestellten Methoden funktionieren in allen aktuellen Excel-Versionen (Excel 2010, 2016, 2019, Microsoft 365) sowie in Excel für das Web. Einzelne Funktionen wie TEXTTEILEN stehen nur in neueren Versionen (Excel 365) zur Verfügung. Arbeiten Sie mit historischen Daten, genealogischen Informationen oder langfristigen Zeitreihen? Dann stoßen Sie in Excel schnell an eine harte Grenze: Datumswerte vor dem Jahr 1900 lassen sich nicht direkt berechnen.

❌ Excel kann keine Datumswerte vor 1900 berechnen?
✅ Doch – mit einem einfachen Trick!

Mit dem 400-Jahre-Trick lösen Sie dieses Problem sauber und professionell.

👉 Schritt-für-Schritt erklärt inkl. Formeln

#Excel #Controlling #Datenanalyse #ExcelTipps #BusinessIntelligence

0 0 0 0
Post image

【ExcelVBA】
コードがぐちゃぐちゃになる人へ

長期運用する前提なら
処理は「機能単位」で分割
+同じ処理はまとめて定義

これだけで保守性が激変します。

修正箇所が一瞬で分かる

#Excel

0 0 0 0
Preview
Export Outlook Mailbox to Excel via Power Query  - Select Distinct Learn how to use Power Query to export and clean Outlook mailbox data in Excel for faster reporting and better email insights.

Export Outlook Mailbox to #excel via #PowerQuery by Elle Harrison #PowerBI www.selectdistinct.co.uk/2026/03/31/e...

0 0 0 0

SI.CONJUNTO: el orden de las condiciones importa MAS de lo que crees.

Excel trata celdas vacías como 0. Si tu primera condición es >=0, las vacías la cumplen y devuelve ese resultado.

Pon siempre la condición más restrictiva primero.

influexcel.com

#Excel #ExcelTips #Influexcel

0 0 0 0
Solve Tough Data Problems Beyond Star Schema
Solve Tough Data Problems Beyond Star Schema Download the Practice Kit ⬇ - https://goodly.co.in/how-to-structure-multiple-fact-tables-in-power-biLearn more about my DAX & Data Modeling Course - https://...

Solve Tough #Data Problems Beyond Star Schema by Chandeep Chhabra #PowerQuery #excel #PowerBI www.youtube.com/watch?v=6X3r...

0 0 0 0
Video

Launch Excel with secret shortcut.

By @andrewmoss.bsky.social

#exceleration #globalexcelsummit #excel

2 1 1 0
Post image Post image

i begun doing a diet CALC spreadsheet! cuz it could be nice to start, as im underweight, it could be nice to see foods i can eat, cuz i eat kinda badly and stuff, so

I got help by #gemini to make this by the way!

#excel #food #life #health
#underweight #linux #libreoffice #calc #spreadhseet

2 1 1 0
Vote Now!
Card #1:
3rd Edition Global Excel Awards
Finalist - Training Provider of the Year
Ken Puls (Skillwave Training)
Vote for Me

Card #2:
3rd Edition Global Excel Awards
Finalist - Best Microsoft Excel Add-in
Monkey Tools
Vote for Me

Voting closes April 30, 2026

Vote Now! Card #1: 3rd Edition Global Excel Awards Finalist - Training Provider of the Year Ken Puls (Skillwave Training) Vote for Me Card #2: 3rd Edition Global Excel Awards Finalist - Best Microsoft Excel Add-in Monkey Tools Vote for Me Voting closes April 30, 2026

As you may have heard, both myself and Monkey Tools are finalists in the 2026 Global #Excel Awards! 🥳
If you're a fan of my training and/or our add-in, cast a vote to help us out in the Training Provider of the Year and Best Add-in categories. 🗳Voting is open until April 30 - go to mkyt.ca/vote2026

1 0 0 0
Dynamic Expand Collapse Messages in Excel - Monkey Shorts Episode 020
Dynamic Expand Collapse Messages in Excel - Monkey Shorts Episode 020 In this episode of Monkey Shorts, Ken shows a quick reporting trick he likes to use in complex workbooks. It allows you to collapse a range, but provide a message which only shows up while the range…

In this video, @excelguru.ca shows a quick reporting trick he likes to use in complex #Excel workbooks. It allows you to collapse a range, but provide a message which only shows up while the range is collapsed, inviting the reader to open it and see the data. 🤓

1 0 0 0
Preview
Vibe Coding an Office-js Add-in | Jan Karel Pieterse, Thu, Apr 2, 2026, 10:00 AM | Meetup **SESSION TRACK:** Excel **SESSION OUTLINE:** There’s a lot of talk about so-called vibe coding. As Microsoft MVP Jan Karel Pieterse understands it, this is letting an AI

An hour to go until today's Vancouver #PowerBI and Modern #Excel meet-up begins! As Jan Karel Pieterse understands it, #VibeCoding is letting an AI do the programming based off descriptions you give it. See how he “programmed” his new Rule Manager for Excel add-in. 👉RSVP here:

0 0 0 0
Post image

🚀 Excel Lovers, Don’t Miss This!
👉 Register here:
www.meetup.com/azerbaijanpo...
#Excel #ExcelCompetition #DataAnalytics #SpreadsheetSkills #LearnExcel #ExcelTips #MicrosoftExcel #DataCommunity #Meetup #PowerBI #DataSkills #ExcelTraining #AnalyticsCommunity

0 0 0 0
Post image

If you’re seeing this error on your #PowerQuery refresh when loading to Table it’s not just you

Token Refresh Timed Out

#Excel

3 0 1 1