Python in Excel
Python is now inside Microsoft Excel. Really? Python is only in Excel if you have Microsoft 365 on […]
Python is now inside Microsoft Excel. Really? Python is only in Excel if you have Microsoft 365 on […]
How would you convert an Excel column of strings or numbers to a string as a comma separated […]
Converting your Excel file to PDF can be a bit tricky when you have a large Excel file […]
What is the hash symbol that you see in some formulas? What does it do? If you have […]
The OFFSET function lets you create a reference to a range of cells that is a certain number […]
Linear regression analysis is used to predict the value of a variable based on the value of another […]
Do you want to work with a few small & sample data models in Excel to practice the […]
Let’s look at some Sales data in a simple example and use Pivot Table to summarize the data. […]
Let’s work with Kevin here on the fictitious Kevin Cookie Company’s data. Have a look at the YouTube […]
The AGGREGATE function allows you to summarize values and gives you the ability to ignore values such as […]
If you have Microsoft 365 (formerly Office 365) you can use Excel’s new data types to create Excel […]