From CSV to Excel
How do you convert a comma separated values (text file) into a Microsoft Excel file? If you have […]
Excel
From CSV to SQLite
How do you get your CSV data into a SQLite database? Here is an article from Towards data […]
Python in Excel
Python is now inside Microsoft Excel. Really? Python is only in Excel if you have Microsoft 365 on […]
Excel Column to CSV
How would you convert an Excel column of strings or numbers to a string as a comma separated […]
Export Excel to PDF
Converting your Excel file to PDF can be a bit tricky when you have a large Excel file […]
Excel Filtering
This post is about filtering in Excel. For information on the FILTER function have a look at our […]
Excel Sort Function
The new Excel SORT function is one of the new dynamic arrays that are available in Microsoft 365. […]
Excel Dynamic Arrays
What are dynamic arrays in Excel? Dynamic arrays are new to Excel and are available in Microsoft 365 […]
Excel’s Hash Reference
What is the hash symbol that you see in some formulas? What does it do? If you have […]
Sorted Data Validation List
In Excel, in Microsoft 365, how do you sort your dropdown data validation list? You have a cell […]
Excel OFFSET function
The OFFSET function lets you create a reference to a range of cells that is a certain number […]
Excel Recursive Lambda Function
LAMBDA functions in Excel are recursive! This means they can call themselves. One classic example of recursion is […]