Tutorials - Page 4 of 4 - Accounting On Excel

HOW TO RECONCILE BANK STATEMENT AND CASH BOOK IN EXCEL

October 31, 2020 / Excel Templates

If you are an accountant, cashier, bookkeeper or finance person in any capacity, you will agree with me that the task of reconciliation can be daunting when you don’t have the right tool at your disposal to make it easier. Microsoft Excel is a tool that is used by a wide range of individuals across …

HOW TO RECONCILE BANK STATEMENT AND CASH BOOK IN EXCEL Read More »

VLOOKUP & #N/A ERROR FIX

April 15, 2020 / Excel Formulas

The VLOOKUP function is used to look up values in a cell range and returns a value that is in the same row as the specified lookup value. Let’s examine the function syntax for better understanding: =VLOOKUP(Look_value, table_array, Col_index_num, [range_lookup]) The Look_value is the first argument in the VLOOKUP syntax above – this the value …

VLOOKUP & #N/A ERROR FIX Read More »