In reply to Craig M. Thanks for sharing, Craig! I often forget this tip because I don't use it, but it'...
https://www.myonlinetraininghub.com/excel-paste-special-tricks#comment-112848
Hi Mynda. Good tips. Another way to paste values or formats is to select a range, right-click a border, drag away and drag back. This opens a menu which includes 'Copy Here as Values Only' and 'C...
https://www.myonlinetraininghub.com/excel-paste-special-tricks#comment-112847
In reply to salh. That sounds laborious. If you'd like to find a more efficient way, you're we...
https://www.myonlinetraininghub.com/excel-if-and-or-functions-explained#comment-112818
I have a question about paying salaries according to an Excel list. I pay salaries by hand. It is very difficult to inventory my accounts at the same time as the fund with the list of employees. ...
https://www.myonlinetraininghub.com/excel-if-and-or-functions-explained#comment-112817
In reply to Matthew. Hi Matthew, Please post your question on our https://www.myonlinetraininghub.com/iferror-in-power-query-using-try-otherwise#comment-112593
In reply to Matt B. Hi Matt, AFAIK you can't extract information from...
Awesome tutorial! I've been curious about the Excel tasks that can be assigned using the @mention in cell comments. I'm curious if you have any content available in tutorials or your courses that...
In reply to Roy. Sorry folks, the Comment has a bit missing in the middle. For the first part, >4...
https://www.myonlinetraininghub.com/excel-custom-number-format-guide#comment-112582
Thank you for this write-up. I have tried some ideas to my problem below, but nothing is working. I have an issue where sometimes a system outputs a date that is wrapped, i.e. 10/22/202 4 Most of...
https://www.myonlinetraininghub.com/iferror-in-power-query-using-try-otherwise#comment-112576
In reply to Eric-Jan Venema. Hi Eric-Jan, When sorting by numeric/value fields, you can only s...
https://www.myonlinetraininghub.com/excel-groupby-and-pivotby-functions#comment-112568