Category Archives: Microsoft Excel Simplified

Subtotals Using Excel Subtotal Function

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

Share
Posted in Microsoft Excel Simplified | Leave a comment

How to Use VLookup Excel Function

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

Share
Posted in Microsoft Excel Simplified | 27 Comments

How to Copy and Paste Only Visible Cells in an Excel Worksheet

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

Share
Posted in Microsoft Excel Simplified | 32 Comments

Find and Replace Excel Function

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

Share
Posted in Microsoft Excel Simplified | 22 Comments

Excel Functions Simplified

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

Share
Posted in Microsoft Excel Simplified | 34 Comments