AE Newsletter: 2016 Dates and Prices, Date Axis in Chart, matching positive & negative numbers

2016 Dates and Prices, Date Axis in Chart, matching positive & negative numbers

In this issue:

If you want to get these tips and tricks as soon as they come out link to us via social media.

FSP LunchCourse dates and prices for 2016

The year is nearly over. For your planning and budgeting, you can request the course dates and prices for next year.

Next Excel Courses

Email us if you need more details or visit the calendar page

Date Axis on graph showing strange dates

When you use a Date on a graph, Excel sometimes recognizes it and then allows you to group into weeks, months and years. But you may not want this  Read more

Matching Positive and Negative Numbers in a list

If you perform recons, you sometimes need to match numbers. But what do you do if the matching number is the opposite sign.   Read more

Remove unwanted characters

In order to remove unwanted characters, or to extract portions of text you want, you should look at some of the TEXT functions.   Read more

Keeping the Format Painter on

The format painter allows you to copy a format from a cell and repeat it somewhere else. Sometimes you need to repeat it in many places.  Read More

How to use the new online courses

Instructions on how to use the new online Excel training course. We will be launching modules of the live courses over the next few months. Read More

Excel Skills Assessment

Did you know that our Excel Skills Assessment is now being used by overseas companies to assess their entire workforce? Read More

Cleaning up Data in Excel

Data AnalyticsWe have recently launched our new online course covering cleaning up data in Excel. Taking material out of the live 3 day course we have specifically targeted this course at people who regularly receive spreadsheets from different systems and need to rework it.

Areas covered in the course include