As an auditor, Excel is likely your go-to tool for daily work. Almost all Auditors I know admit to having dozens of Excel instances open every day. But are you using Excel to its full potential? Like any profession, mastering your tools will get you ahead and many auditors who waste hours on manual tasks that could easily be automated or simplified with the right … [Read more...]
How to Open Excel VBA Editor
Excel VBA is a powerful tool which enables the automation of tasks in Excel. It can be used to automate many repetitive tasks along with more complex applications. This quick tip guide shows you how to open the Excel Visual Basic Editor (aka Excel VBA Editor) and get started with VBA programming in Excel. Having access to the VBA editor lets you write your own VBA code or … [Read more...]
10 Must Have Excel Skills for Accountants
Introduction: One of the most widely used tool for accountants and managers is none other but MS Excel . Spreadsheets are around us for quite some time and they have been developed in to a handy tool. Some of them are propriety like Microsoft office and some can be used under creative commons license like open office. When it comes to collaboration or sharing data, google … [Read more...]
What are MS Excel Tables – Tips and Tricks
Introduction There are two ways of organizing your data in Excel, either it could be a list or it could be a excel table. Both has its advantages and disadvantages. In today’s post, we will try to learn about the later and see how to get most out of it – i.e. excel tables. Tables are identified by a header row and a column, where is for list, there is only a header row. … [Read more...]
Getting Most out of COUNTIF () function
Introduction COUNTIF () function constitutes a family of functions that is used for counting and specially for counting conditionally. We said that COUNTIF () is a family because there are few other similar function that are present in Excel that starts with COUNTIF. These functions include COUNTIFS() that is used for counting more than one criteria, COUNTA () that is used … [Read more...]