A4accounting.com.au Website Review

I recently found a useful keyboard shortcut for the VBA code window. I tried an Excel shortcut that helped in the VBA window. In December 2018 I reviewed four of my articles from the INTHEBLACK magazine from 2018. Do*nload the materials using the bu*ton below and As always there will be a few more tips and tricks shared in the session. If you have filters turned on and you are in the heading row of the table you can press Alt + down arrow to open the filter drop down. Excel has a few counting functions. But when it comes to counting entries in a cell it can be difficult if you are using formulas that return a blank cell. This is where the SUMPRODUCT function can come to the rescue. Counting is the poor cousin to summing in Excel. Not many people count things, but everyone adds up things. There is a special sort of count that can be useful. A distinct count counts unique entries and is hard to do with a formula. If you have Excel 2013 or a later version you can use a PivotTable to perform a distinct count. Click here to read the full article » The most difficult thing is the decision to act, the rest is merely tenacity. Following on from my last two VBA posts here is how you can identify the cell addresses of the first and last cells in a range. When I ran some face to face training sessions recently I was reminded how much people LOVE shortcuts. I did a keyboard shortcut webinar In November 2018 I shared lots of mouse shortcuts. Do*nload the materials using the bu*ton below and watch the video. This session will demonstrate lots of techniques using the mouse and also using the mouse with the keyboard. Even if you prefer using the keyboard you might learn a few useful new techniques. post lets us find the row and column extremities of a specific range. Click here to read the full article » Life is 10% what happens to me and 90% of how I react to it. Apparently this is not widely known, but you should always bold the headings in your tables. Then when you use Format as Table (Ctrl + t) on the Home ribbon tab the header row will be correctly identified.