angelsnsa.blogg.se

1. #ARTICLESHIP COMPLETION FORM 108 HOW TO#
2. #ARTICLESHIP COMPLETION FORM 108 VERIFICATION#
3. #ARTICLESHIP COMPLETION FORM 108 TRIAL#

Make sure you have removed any blank cell in the left-most column because excel will ignore a row if the left most cell in the selected reference is blank.Ģ.

#ARTICLESHIP COMPLETION FORM 108 TRIAL#

Input data: 2 sets of Trial Balances (TB).

Today, we will try it with the Consolidate feature. Some of us have manually verified the balances and some of us have used the vlookup function.

#ARTICLESHIP COMPLETION FORM 108 VERIFICATION#

Using Consolidate Feature for Opening balance verification:ĭetermining whether the prior periods closing balances have been correctly brought forward to the current period is called Opening balance verification in the common parlance. Even though this is predominantly used at the managerial level (say, for aggregating various financial figures from multiple branches), it can come handy to the Chartered Accountants as well.Įxamples are better than precept and so, let us take an example to understand how it works. Put down from a CAs point of view, I believe, that this series of Excel with Excel‘ will make your life simpler.Įxcel’s Consolidate feature helps in consolidating data in worksheets (located in one workbook or multiple workbooks) into one worksheet. Starting this week, we will be going through some of the tips and tricks for effectively using Excel. One thing almost every Excel user has in common is – Not knowing enough. We have done so much in Excel, that, at the completion of articleship, while filling the details of training received in Form 108, we search for Excel in the Particulars column only to be disappointed, because ironically, Excel doesnt find a place in the list.

Many a times, after doing something that took us lesser time than it took others, we have felt as if we have ascended the Mount Everest.

#ARTICLESHIP COMPLETION FORM 108 HOW TO#

We have no choice, but to agree that excel is an incredibly powerful tool to find exactly what we need and get things done in a jiffy - only if we know how to use it, correctly.Īll of us have solved various practical problems using Excel. Thats when CA-Articleship happened to me! Where we meet people singing the praises of Excel all day. I would throw my hands up and tell myself that Excel just wasnt for me! 4 years ago, struggling to add the numbers in 4 cells, I belonged to the group of people who would rather be imprisoned than have to go cross-eyed, looking at the columns and rows in a spreadsheet.