Let's talk Excel (@LetstalkExcel) header
Let's talk Excel (@LetstalkExcel) profile picture

Let's talk Excel

@LetstalkExcel
Joined January 2015
  • Tweets24
  • Following1
  • Followers149
1Media
Photo by Let's talk Excel (@LetstalkExcel)
The Perennial Office Romance… 3 Reasons To Continue Loving Your Spreadsheets letstalkexcel.com/the-perenn…
Image from Let's talk Excel (@LetstalkExcel)
Get a random subset of data with Power Query excelunplugged.com/2017/02/1… via @excelunplugged
Get a random subset of data with Power Query

Get a random subset of data with Power Query

This post will take you through the process of creating a query that will return a random subset of a data table in Power Query.

excelunplugged.com
Search a Range for the closest value to a chosen number excelunplugged.com/2016/11/0… via @excelunplugged
Search a Range for the closest value to a chosen number

Search a Range for the closest value to a chosen number

How to find a closest value to a chosen number within an Excel range? Let's do it through a simple example!

excelunplugged.com
Dynamic Power Query excelunplugged.com/2016/11/0… via @excelunplugged
A great honor for Excel Unplugged excelunplugged.com/2016/06/0… via @excelunplugged
A great honor for Excel Unplugged

A great honor for Excel Unplugged

Yesterday I got an Email form the guys at spreadsheeto.com notifying me that Excel Unplugged will be featured on their “69 World’s Best Excel Blogs” site (the number might have changed till now J)....

excelunplugged.com
1
Amsterdam Excel Summit 2016 report excelunplugged.com/2016/05/3… via @excelunplugged
Amsterdam Excel Summit 2016 report

Amsterdam Excel Summit 2016 report

This post is a tribute to the event, that is one of a kind in Europe, and gives Excel professionals a rare opportunity to meet brilliant people, that have dedicated their lives to Excel and have a...

excelunplugged.com
USE POWER QUERY’S GET DATA FROM FOLDER TO GET DATA FROM MULTIPLE EXCEL FILES excelunplugged.com/2016/05/2… via @excelunplugged
USE POWER QUERY’S GET DATA FROM FOLDER TO GET DATA FROM MULTIPLE EXCEL FILES

USE POWER QUERY’S GET DATA FROM FOLDER TO GET DATA FROM MULTIPLE EXCEL FILES

I recently posted on how to make a process of getting data from a folder bulletproof. You can read it here. Whereas that post was about getting data from multiple TXT files within one folder, this...

excelunplugged.com
1
REMOVE, REPLACE OR SEPARATE BY LINE BREAKS (ALT + ENTER) INCLUDING VBA excelunplugged.com/2016/05/2… via @excelunplugged
1
1
Power BI publisher for Excel (The Times They Are A-Changin) excelunplugged.com/2016/04/0… via @excelunplugged
Custom Power Map to show Mick Jagger's stage presence during Gimme Shelter excelunplugged.com/2016/03/0… via @excelunplugged
Custom Power Map to show Mick Jagger’s stage presence during Gimme Shelter

Custom Power Map to show Mick Jagger’s stage presence during Gimme Shelter

This article will show you how you can use that nobody’s child called Power Map or 3D Map to solve a problem many of us wish to run into one day. We get tickets for the Rolling Stones and are unable...

excelunplugged.com
27 Microsoft Excel Experts Predict The Future Of Excel In Business Intelligence investintech.com/resources/b…
27 Excel Experts Predict The Future of Excel and BI

27 Excel Experts Predict The Future of Excel and BI

Get a head start on MS Excel 2016 and discover how leading experts see the future of Microsoft Excel in Business Intelligence.

investintech.com
New Charts in Excel 2016 excelunplugged.com/2015/05/2…
Image from Gašper Kamenšek (@ExcelUnplugged)
1
My three favorite things in Excel 2016 excelunplugged.com/2015/05/1… via @excelunplugged

My three favorite things in Excel 2016

First off, this post is written on basis of a public preview of Office 2016 which you can get here. The official version will contain a few more goodies like many new charts including Waterfall...

excelunplugged.com
Using Named Ranges in Excel excelunplugged.com/2015/05/0… via @excelunplugged
Amsterdam Excel Summit Report excelunplugged.com/2015/04/2… via @excelunplugged
Amsterdam Excel Summit Report

Amsterdam Excel Summit Report

Whereas this post does not contain any excel shortcuts or commands, it does contain plenty of information I wish I had when I was trying to expand my Excel horizons. It also mentions quite a few...

excelunplugged.com
test = zzyw = BBAb excelunplugged.com/2015/03/3… via @excelunplugged

test = zzyw = BBAb

The title might make you think that I lost my mind, but this is actually one of the best tricks to show your colleagues and also a transparent demonstration that all versions of Excel before Excel...

excelunplugged.com
Learn a foreign language with Excel excelunplugged.com/2015/02/2… via @excelunplugged

Learn a foreign language with Excel

Surprisingly, this is not a post about the Translate feature in Excel. Rather we will take an in depth look into Cell Format and a great feature of Excel that allows you to change the names of days...

excelunplugged.com
Get data from Folder in Power Query excelunplugged.com/2015/02/1… via @excelunplugged
Get data from Folder in Power Query

Get data from Folder in Power Query

If you get data periodically in any form (txt, csv, xlsx…) then Get data from folder command in Power Query is here to make your life easier.

excelunplugged.com
VBA Code to list files from a folder containing a string letstalkexcel.com/vba-code-t… via @LetsTalkExcel
VBA Code to list files from a folder containing a string

VBA Code to list files from a folder containing a string

The code bellow asks for a folder location, and then for a string. Then it searches through the files in that folder and returns a list of those, that contain the given string. At this point, it do…

letstalkexcel.com
Save Each Excel Sheet To A Separate File letstalkexcel.com/sheet-tose… via @LetsTalkExcel
Save Each Excel Sheet To A Separate File

Save Each Excel Sheet To A Separate File

This VBA code saves each Worksheet in the active Excel Workbook to a separate file and even lets you decide whether to keep the formulas on the sheets or change them to values. When you run the cod…

letstalkexcel.com
Load more