Excel Formulas and Formatting tools | Audit Tickmark Toolbar Add-In

Introduction:
Excel has wealth of options to perform Trend Analysis. Trend Analysis is a very useful tool for business decision making and is a widely adopted procedure in Sales, Marketing, Finance, Operations and Inventory control. In today’s post, we will learn...

Introduction
Excel user are familiar with drop down lists from the time Microsoft used it in their Office Program. The drop down lists were helpful as they are we able to a lot of options, were cascade-able. The value of these dropdowns was multiplied as the options...

Introduction:
We often came across the requirement of joining texts or concatenation in spreadsheets. This requirement might arise due to need to creating a key for lookup operations or might be to create full name, with first, second and third name present in various...

Introduction:
Just like other spreadsheet users, accountants do use a lot of formulas. It is not necessary that all the formulas that are used by accountant relate to their accounting functions. In order to make their sheets works and analyze data intelligently they...