Finance professional who loves teaching others to be amazing with Excel. Site: https://xitter.cf/t.co/vuu5jEDMPI YouTube: https://xitter.cf/t.co/xWx9OV2luz
England, United Kingdom
Joined January 2017
- Tweets1.1K
- Following221
- Followers5.5K
- Likes533
Excel Off The Grid retweeted
A lovely comment by Mark at @exceloffthegrid for chapter 1 of my #advancedexcelformulas book. Get your copy - amzn.to/3R0JInY #excel
ALT Advanced Excel formulas book testimonial by Mark Proctor at Excel Off the Grid.
Excel Off The Grid retweeted
In this special FP&A Today episode, Paul is joined by three Excel experts whom Microsoft has recognized as ⭐Most Valuable Professionals (MVPs)⭐
Catch the full episode at bit.ly/3EFQD2H
#fpna #excel #exceltips #microsoftexcel
Power Query problem:
How to get data from an Excel workbook when the sheet or Table names change.
Find the solution here:
youtu.be/7xIeBf4wwIE
One button to rule them. 🪄
How to run any macro from one button.
🤯
youtu.be/I2zdhAHD_Ck
Power Query: Get data from SharePoint lists | Excel Off The Grid
youtu.be/ZPe7wn91J9w
We're running a free webinar to help more people start saving time with Power Query.
Title: Getting started with Power Query
When: Tuesday 28th February 5pm GMT
Register here: exceloffthegrid.mykajabi.com…
We can't use wildcards directly inside the FILTER function... so what can we do?
Say hello to the FILTER / ISNUMBER / SEARCH combination.
youtu.be/tB-f7BuSZfI
Group By in Power Query is a simple yet powerful transformation.
Learn how to use it here:
youtu.be/XVQLBksQXag
Absolute and relative references for Tables in Excel | Excel Off The Grid
youtu.be/CdAdaApvFcM
Excel formulas not calculating correctly?
See if one of the solutions in this video help:
youtu.be/OCyiHRy9wfs
No matter what date format your source data has, Power Query gives us many options for converting it into a date we can use.
Find out more here:
youtu.be/K3MQBjgy_sY
Excel Off The Grid retweeted
It promises to be a fascinating debate!
To view our full agenda, go to globalexcelsummit.com/agenda.
#excel #microsoftexcel #globalexcelsummit
Power Query doesn't have any lookup functions. But this doesn't mean we can't get values from another table; the Power Query alternative is the merge transformation.
Find out more here: youtu.be/9d2bICnGap8
Today is the one-year anniversary of setting out on my own.
I had a plan and the ‘confidence of ignorance’… what could possibly go wrong?!?
Well… the plans quickly went out the window, leaving just confidence (or just ignorance, depending on how you look at it).
1/3
Everything that I thought would happen didn’t. But things I couldn’t possibly have imagined did.
I still remain committed to the original goal: Setting finance people free to do the jobs they were hired to do by automating the work they don’t need to do.
2/3