Adding arrows to your variances

You are preparing a monthly report showing the variances between the
current month and the previous month. While the positive numbers and
negative numbers show up in the cells neatly, it is difficult to find
out whether there are more positive variances than negative variance. So
your boss asked you to add arrows next to the variances and coloured
them red if it is negative and blue if it is positive. If this is what
you are currently trying to do, you can refer to
...
more

Ask us an Excel question and get your question answered by our team of Excel experts

Upcoming Courses

For Individuals - If you are a Singaporean aged 25 and above, you are given $500 in your newly created Skills Future Credit Account. The credit
in the account is meant for you to pay for WDA approved courses for the purpose of upgrading yourself without company sponsors. You
can pay for our courses using your Skills Future Credit.

For Companies - If your company is a Singapore registered company with 3 or more Staff paying CPF, you are eligible to claim
for PIC (Productivity and Innovation Credit in short). PIC allows you to claim back 60% of the course fees in cash or offset
4 times of the course fees against your profit (i.e. pay less taxes). Your company is also eligible to claim SDF for most
of our courses. more details are available on the
PIC website.

For the details of the courses, please refer to our Excel courses page.

Subscribe to our newsletter

If you received this newsletter from a friend and would like to be included in our mailing list, please go to our Excel Today's page.

Follow us at Facebook, LinkedIn

If you have a facebook account, you can like us at facebook or linkedln. From facebook or LinkedIn, you will be notified on mini cases and ideas how we use Excel on a day to day basis. These tips may not be published in our newsletter.

Received this newsletter from a friend? You can request to be included in our mailing list by signing up at our Excel Today's page. If you have friends whom you think might be interested in this newsletter, feel free to send it to them.