Power Query Finding Text in Another Column
If you need to find if text is in a column you can use the Text.PositionOf function to confirm it exists.
(more…)![Read more about the article Excel Power Query and Multiple Files [one hour video]](https://a4accounting.com.au/wp-content/uploads/2021/05/vimeo-548711986.jpg)
Excel Power Query and Multiple Files [one hour video]
Getting data into Excel and in the correct layout and format is the important starting point for any Excel project. Power Query can automate the importation process. It is now a vital skill to possess. This is a follow up session to the Introduction session which you can view here. This session focuses on importing multiple files from a folder. The session uses CSV and Excel files plus Excel tables. This is a video of a free live training session…
Filter Issue with Excel
When you have a filter in place in Excel you typically only affect the visible cells when you edit multiple cells. There is a case when you are affecting all cells not just the visible ones.
(more…)
Introduction To Excel Power Query [one hour video]
Getting data into Excel and in the correct layout and format is the important starting point for any Excel project. Power Query can automate the importation process. It is now a vital skill to possess. This is a video of a free live training session I ran in May 2021 - over 100 people attended - please share this resource with friends and colleagues. No editing has been done to the video. Use the button below to download the pdf…
Missing Chart Data in Excel
The default setting for charts in Excel is to hide the data on the chart if it is hidden on the sheet. I forgot that recently when I created a few charts using a workings area to hold the chart data. I later hid the workings with column grouping. Oops – when you hide the data in the charts go blank.
(more…)One Minute to Excel #13 – Create and Use a Check Box
A check box is an easy interface to create and use. See how to add one to a sheet and use it in a calculation. https://vimeo.com/529248845
Distinct Count Formula in Excel
It is now easier to create a distinct count formula in the subscription version of Excel. You can also use a criteria. A distinct count only counts each value once. Duplicate entries are ignored.
(more…)