Connect your Bank Accounts to Microsoft Excel for mac, windows & online
There would be nothing easier than managing your personal finance in Excel & Exciting part is to connect your Bank accounts securely with Money In Excel
Category: Excel
Today Date Function in Power Query (Power BI & Excel)
Simple technique to extract the today date in Power Query for Excel & Power BI.
Simple Trick to Create A Data Entry Table In Excel Power Query
Simple Trick to Create Data Entry Table In Excel Power Query
Webinar London Excel Meetup – Dynamic Reports With Power Query
On May 26, 2020, it was my pleasure to present Dynamic Reports with Power Query at London Excel Meetup webinar, we talk about best practices to use the modern Power Query tool and simplify our daily routine task. The webinar was organized by Alan Murray, Founder of Computergaga.com along with Tea Kuseva, Co-Founder of DATEL…
Extract Username From Email Address In Excel
This formula in Excel will allow you to extract the username from the email address from a cell.
Get Data From PDF In Excel with Power Query PDF Connector
Amazing New PDF connector for Excel in Power Query get the data from PDF into Excel
Get Sheet Names using Power Query Excel for mac and windows
One Click Refresh Dynamic Solution to Get Sheet Names using Power Query Excel for mac and windows
WEBINAR – POWER QUERY and POWER AUTOMATE – Faraz Shaikh
On May 09, 2020, it was my pleasure to present about Power Query & Power Automate to the Pakistani Excel Community, we talk about best practices to use the modern tools and simplify our daily routine task. The webinar was organized by Rahim Zulfiqar Ali, Founder & CEO of Excel Basement during the COVID-19 lockdown…
Get Workbook Location-Name-Sheet Name With Formulas
This simple Excel formula for mac and windows allows us to get the file path/location, name & sheet name of active workbook. Simply copy the formula and paste into your workbook.
Unhide Active workbook sheets with VBA Excel for Mac & Windows
With this VBA code, we can easily unhide all the sheet which are hidden in the active workbook.