How to split worksheets into separate Excel workbooks
Easily Split your worksheets into separate workbooks and save them in the same location. This code works with Excel for mac & windows.
Blog
Extract Comments In Excel with VBA
There is currently there is no built-in function in excel which can allow us to extract the comment/notes of the cells into a cell. However, with the help of this User-Define Function (UDF) VBA code we can easily extract comments into the cell.
Convert Numbers to Words in Microsoft WORD [mac & windows]
![Convert Numbers to Words in Microsoft WORD [mac & windows]](https://i0.wp.com/excelexciting.com/wp-content/uploads/2020/05/Convert-Number-To-Text.jpg?resize=500%2C270&ssl=1)
We can convert numbers to words in Excel with UDF function SpellNumber, but we also have a method to convert the numbers to words in Microsoft WORD without any VBA code with two different methods for mac & windows
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
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