Excel workbook with pivot table is a common way to analyze data. But sometimes the workbook size will get too big especially when you have
Tag: Excel
Get Excel Data from another Excel workbook using Power Query, a better method compared to using Filter formula.
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
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
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.
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
Using Excel and Power Query to get dynamic and refreshable web data (including cleaning and transforming)
Hi all, below is my YouTube video for using Excel and Power Query to fetch refreshable web data. This is useful for dashboarding and data
Welcome...enjoy coding, Electronics, IOT or data mining? Thank you for visiting my blog. 