2016 Dates and Prices, Date Axis in Chart, matching positive & negative numbers
In this issue:
Course dates and prices for 2016
- Next Advanced Excel course dates 7-9 Dec
- Beginner Excel Course Dates- Next 16 Nov 2015 (NEW)
- In houses Courses
- Date Axis in a graph acting strangely?
- How to use our new online courses
- Matching Positive and Negative numbers
- Excel Skills Transfer
- Removing unwanted characters
- Keeping the format painter on
- Cleaning up Data using Excel
If you want to get these tips and tricks as soon as they come out link to us via social media.
Course 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.
Request info on training dates, prices and venue
Next Excel Courses
Advanced Excel course (7-9 Dec 2015)
- Excel Financial Modeling, Budgets and Forecasts (12-13 Nov 2015)
- In House course- whenever it is convenient for you
- Excel Fundamentals for beginners
- 16 Nov 2015 (NEW)
- 12 Feb 2016
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
We 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