Getting data from another Excel workbook using Excel formula requires the source data workbook to be open in order to perform a data refresh, but
Author: AnthonyC
Using Excel formula to transpose every N rows in Excel
This video uses a simple and power Excel index formula to assist in transposing data with a N rows pattern. Please see the video and
Hide unprotected Excel sheet without letting users know
Hi, in this post video, I will show how to hide an unprotected Excel sheet without letting users to unhide sheet by using the right
Dynamic data filtering and creating sub-tables using FILTER function in Excel
Using a simple and powerful Excel FILTER function to create a dynamic data filtering, displaying sub-tables base on the dropdown selection and conditions.
Download multiple stocks data with Python thru Yahoo finance and analyze with PivotTable
Hi, in the following Youtube video, I am using Python to download multiple stock prices from Yahoo Finance and using Excel PivotTable to analyze the
Using Excel Countif formula and Data Validation to prevent duplicate entry into a column
Hi, Below is my Youtube video on using Excel countif formula and data validation to prevent duplicate data entry into a column. This method can
Welcome...enjoy coding, Electronics, IOT or data mining? Thank you for visiting my blog. 