CNAR Services Pty Ltd

02/08/2021

For those who want to connect to a web page table that gets updated daily and you want to automatically update you excel report with new updated figure, this is for you.

Enjoy

02/04/2021

Day 2 of

Today I am looking at Sumif formula where we are summing only data that meets a given criteria.

Below is the link to the video:

How to make use of the sumif formula and what is it?

01/04/2021

DAY 1 OF

Today I look at how you can convert names Typed as "clyve mishi" or "cLYve MISHI" etc to proper Case "Clyve Mishi" using excel

Watch how to here:

In this short video you will lean how to convert randomly upper and lower cased text into properly capitalized text strings.

19/03/2021

As a business owner you need to understand what's happening in your business and as part of doing that you need easy to understand, accurate reports.

An excel pivot table can do just that. And the good news is that its FREE!!!

Understand how to pivot data in less than 30minutes. For more videos on excel please check our YouTube Channel. Clyve's Excel Corner.

In this Video you will learn:What is a pivot tableWhy pivot dataHow to Pivot Data Adjusting Pivot properties and particularly focusing on the following aspec...

17/08/2018

Your accounting needs may be too many, CNAR Services is your total solution!!!

13/02/2018

Tired of using emails like [email protected]?

From R30 per month you can get an email like [email protected].

whats app me for more on: 0735422576

27/11/2017

For all your Accounting, Tax and Advisory needs, kindly contact us for an affodable quote.

visit www.cnarservices.co.za to browse more on our product range.

Find an accountant

25/10/2017

Did you know that the tax act has a provision that allows you to deduct tithe and offering from you taxable income?

Contact CNAR Today for tax advise.

CNAR Services, benefitiation through value addition.

www.cnarservices.co.za

09/10/2017

For all your financial reporting, tax and VAT returns, bookkeeping and business plans need please contact us.

Find an accountant