@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
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
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
SEQUENCE function – Add it to your toolbelt today excelunplugged.com/2021/09/1…

SEQUENCE function – Add it to your toolbelt today

SEQUENCE function sits in top 10 helper functions of modern Excel. The scenarios of combining it with other Excel function just seems endles.

excelunplugged.com
2
1
12
Consolidate Multiple Excel Sheets From Multiple Excel Files with the use of Custom Functions in Power Query excelunplugged.com/2021/07/1…

Consolidate Multiple Excel Sheets From Multiple Excel Files

We often have our data spread out in different Excel files and sheets. How do we combine all of them into one table?

excelunplugged.com
Gašper Kamenšek retweeted
Ken Puls, FCPA, FCMA@kpuls30 Jun 2021
Only 1 day left to save $200 on my #SelfServiceBI Boot Camp on our @skillwave_ platform. Join me starting July 12 to learn how to use #Excel, #PowerQuery, and #PowerBI together to build robust solutions. Don't miss out, register today at skillwave.training/shop/self…
1
2
4
Turning Product Descriptions into list of attributes with Power Query excelunplugged.com/2021/06/2…

Turning Product Descriptions into a list of attributes with Power Query

This post shows you how to modify the Power Query Filter step to simulate Fuzzy matching and turn product descriptions into attributes.

excelunplugged.com
1
Gašper Kamenšek retweeted
Ken Puls, FCPA, FCMA@kpuls26 Apr 2021
Check it out tomorrow!
Raw Data With Rob Collie@RawDataWithRob26 Apr 2021
***NEW EPISODE TOMORROW*** Our guest is the #Excel #Guru himself-Ken Puls @kpuls! He's been helping and guiding people for years with Excel and #PowerBI issues, and wait until you hear about Monkey Tools! Ken's website is excelguru.ca, tune in tomorrow for his story!🐵
5
17
Gašper Kamenšek retweeted
Global Excel Summit@ExcelSummit12 Jul 2020
Are you ready to get ahead of the competition?🔥Start your journey today: datelproductions.com/summer-… @OzExcel @olafusimichael @ExcelUnplugged @celia_excel @TonyDeJonker @keyskillset @brshristov @Computergaga1
5
1
10
Load more