Home // Blog & Excel Tips // Replace */?, compare year on year, new charts in Excel 2016

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. 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!

2. How do you take all the formatting from chart (see 1 below) and PASTE it onto another chart (2)? Guess and then see how it can be done with 'See Answer'

 

 

Replace */?, compare year on year, new charts in Excel 2016

Comments Closed
Uncategorised

Replace */?, compare year on year, new charts in Excel 2016

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

Please follow us on Facebook, Twitter , Google + or LinkedIn

In this issue:

Next Excel Courses

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

Finding and Replacing * and ? in Excel

* and ? are wildcard characters in Excel and as such you cannot easily find and replace them. In order to do this…  Read more

In Houses Courses

We are frequently asked if we can offer courses to clients at their premises. The answer is yes and the major benefits are:

  • Cheaper on a per person basis
  • Can be customised to suit your exact needs
  • Can be flexible with period over which it is presented.

For more information give us you group size and we can provide an estimate. Email us

Compare years in a pivot chart

Pivot tables and charts tend to show dates consecutively. In order to see year on year information so that the years are on top of each other… . 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

Data Tables have the formula replaced with values

Data tables can sometimes lose their formula and be replaced with values. This occurs when … Read More

Excel Skills Transfer

We have developed a new Excel Skills Transfer Product to enable a more thorough transfer of our Excel skills. The product is for corporates who want to ensure that their training budget is used in the best possible way.  Read more

New Charts Available in Excel 2016

Charts have been neglected by Excel for years, but in the upcoming version there are a number of new charts including waterfall, treemap … 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

VLOOKUP Explained

Do you need to join databases, age debtors or reconcile account?   Read more