Category Archives: Microsoft Excel Simplified

You can have Excel calculate subtotals for a portion of your worksheet data. Let me explain this with an exercise. With this exercise, let us assume we need to subtotal value of the journal entries processed each day of the … Continue reading →

As promised in my previous post, this time I will start by discussing the Vlookup Microsoft excel function. VLookup is one of the most commonly used excel functions in data analysis today.I would like to show you with examples when and where … Continue reading →

Jobs have been hard to come by these days for inexperienced accounting staff among others. The other day a friend of mine who is looking for a job told me that during interview for a junior accountant job he was … Continue reading →

Find and replace found in Microsoft applications is a powerful function that we can use to manipulate data in any Microsoft applications like word, excel, power point etc. This tool can be used to find and replace any kind of … Continue reading →

Most accountants and accounting students have some basic knowledge about excel. We even know by name various functions such as VLookup, HLookup, Match, if statements, creating subtotals, Pivot tables etc, but we have no clue of how to execute these … Continue reading →