@ExcelUnplugged

Microsoft Excel MVP, Excel Trainer, BI Consultant, Power BI Enthusiast, Fender Stratocaster Player...

 Slovenia
excelunplugged.com
Joined August 2012
  • Tweets221
  • Following259
  • Followers1K
71Media
Join Types in Power Query – Part 2: Lookup Dashboard excelunplugged.com/2022/03/1…

Join Types in Power Query – Part 2: Lookup Dashboard

We'll use the different join types create a LOOKUP Dashboard in Power Query, which will be a single table, but also a concept you can develop onwards.

excelunplugged.com
4
Join Types in Power Query – Part 1: Join Types excelunplugged.com/2022/03/0…

Join Types in Power Query – Part 1: Join Types

I use Join all the time in Power Query for merging tables one way or the other. Let's look at all the different Join types in Power Query.

excelunplugged.com
2
Why You Should Know Power Query – Part 3: Merge excelunplugged.com/2022/02/2…

Why You Should Know Power Query – Part 3: Merge

Power Query is a great tool for data transformation. I often use as an upgrade to Excel. We already covered two great functionalities .

excelunplugged.com
5
Gašper Kamenšek retweeted
Power BI Summit@PowerBISummit16 Feb 2022
📣 Gasper is speaking at #Power BI Summit 2022! @ExcelUnplugged See you there! globalpowerbisummit.com/ #RADACAD #Inforiver #PowerBISummit #PowerBI
1
2
4
Why You Should Know Power Query – Part 2: Split excelunplugged.com/2022/02/1…

Why You Should Know Power Query – Part 2: Split

Splitting is a common task in Excel that works well for simple cases. But for more complex data you would need to use split in Power Query.

excelunplugged.com
Sorry, @ExcelAnalytics :). No surprises. I think you said it best. Neither is perfect. Best to know them both and use them per taste :).
Remove Blank Rows in Excel excelunplugged.com/2022/01/1…

Remove Blank Rows in Excel

How to remove blank rows in Excel? Let's look at some examples for simple and complicated tables.

excelunplugged.com
1
4
Sure, now let me see you do that in Power Query editor 😀
AI in Excel – Part 3 – Analyze Data, the Future of Data Analysis? excelunplugged.com/2022/01/0…

AI in Excel – Part 3 – Analyze Data, the Future of Data Analysis?

Analyze Data is a powerful feature that provides high-level summaries, visuals in the form of different charts that show trends and patterns.

excelunplugged.com
Here is the biggest boost to my Excel game in 2021. Start using it, and I promise you 2022 will be more productive. And the best thing... It's not an Excel - only trick. You can use it everywhere (except on mac 😇 ) youtu.be/Hty-923bQAc

Biggest Boost to My Excel Game in 2021

This video and the two tricks I describe are my gifts to the viewer...

youtube.com
1
1
6
AI in Excel – Part 2 – Column From Examples excelunplugged.com/2021/11/3…

AI in Excel – Part 2 – Column From Examples

Let's look at Power Query’s Column From Examples command. It’s similar to Flash Fill: it fills in the rows based on the input we provide.

excelunplugged.com
1
2
Data Saturday Slovenia 2021 speakers will be delivering Azure & SQL & BI sessions. Join us! @ikdonev @Kjonge @dbanuggets @marco_parenzan @sqldbawithbeard @DerFredo @MilosSQL @janizajc @HalkjaerM @Aschenbrenner @ExcelUnplugged #Alpa_Buddhabhatti
1
13
15
AI in Excel – Part 1 – Flash Fill excelunplugged.com/2021/11/2…

AI in Excel – Part 1 – Flash Fill

Flash Fill acts as your friend that listens and tries to respond with the answer you want. It can hit or miss, depending on data complexity.

excelunplugged.com
2
Global Excel Summit 2022 excelunplugged.com/2021/11/1…

Global Excel Summit 2022

Markthe Global Excel Summit in your calendar for February 2022. Hope to see you there when I will be delivering a New Data Types MasterClass.

excelunplugged.com
Gašper Kamenšek retweeted
Global Excel Summit@ExcelSummit11 Nov 2021
6 NEW #GES2022 MASTERCLASSES JUST DROPPED 💥 Learn from the very best with @r1c1 @dsteinfairhurst @OzExcel @ExcelUnplugged @JLOOKUP_ & Leigh Thompson 🙌 See what Masterclasses could excel your career 👇 buff.ly/2YDr1Sn #Excel
2
4
How to Highlight Weekend Dates in Excel Table excelunplugged.com/2021/11/0…

How to Highlight Weekend Dates in Excel Table

You will learn to highlight weekend Dates (same techniques can also do holidays) using three different methods in Excel including LAMBDA.

excelunplugged.com
2
1
5

No more items