SQL Server to Excel (Copy Paste)
You can transfer data out of SQL Server to Excel with Copy Paste. This works very well for […]
excel
Pandas DataFrame to Excel
How do you export a Pandas DataFrame to an Excel file? It’s very easy to do. This exercise […]
Excel into Python (pandas)
Do you have some data in Excel that you would like to import into Python? You can do […]
From CSV to Excel
How do you convert a comma separated values (text file) into a Microsoft Excel file? If you have […]
From Excel to CSV File
How would you convert an Excel sheet to a CSV (comma separated values) file? You could open the […]
Cleaning Mixed Data Types
Exploratory Data Analysis (EDA) has six main practices. The six main practices of EDA are discovering, structuring, cleaning, […]
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’s Hash Reference
What is the hash symbol that you see in some formulas? What does it do? If you have […]
Excel OFFSET function
The OFFSET function lets you create a reference to a range of cells that is a certain number […]
Simple Linear Regression in Excel
Linear regression analysis is used to predict the value of a variable based on the value of another […]