Images loading below. While you wait, can you answer this Excel related tip? Guess the answer then click SEE ANSWER to see how it can be done.

1. What is the shortcut to ONLY select the visible cells? Guess, then click 'See Answer' as it can be done.
2. How do you copy from Excel (see 1 below) and paste into Word (2) WITHOUT seeing the filter button, gridlines, comment notes and more?

Guess and then view answer to see how it can be done!


AE News: Alumni Reward, spider charts, extract text from the last #-/, look for current month and year, training budgets

Alumni Reward, spider charts, extract text from the last #-/, look for current month and year, training budgets

In this issue:20151112_142335

Online Course Available

Below the online courses we currently offer. Use these to top up your CPD points!


Next Excel Courses

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

Alumni Reward

If you have previously attended one of our live courses you qualify for a reward on the online training. We will send it out shortly to the people we have listed but if you have attended, reply to this mail and we will send the details.

Extracting text after the last #\-

An easy method to determine how many delimiters there are and extracting only after the last one (or any other number)  Read more

IF the Month and Year match …

How to check if the month and year of a date match the current month and year…   Read more

Comparing data with a spider graph

A good way to compare multiple aspects of a project or any data is the spider chart…   Read more

radar chart for comparison charts

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

Example of filling in the gaps