For training call +44(0)1273 6222 72

Your basket is empty View Cart shopping cart

theBLOG

Blog Main Categories

You are viewing posts from the . excel formulas

Click to view all posts

Excel Tips & Tricks - 3 Hidden Gems You May Have Missed

Written by Andy Trainer – Fri 19 Oct 2012

There is more to Excel than you realise

In this post I share three of my favourite Excel tips that - once you know how - become very useful. Most people who use Excel have only just scratched the surface, if you take the time to learn more about Excel, you could really achieve a lot more at work and at home. Learning Excel is time consuming, and a near impossible task to do on your own. We provide regular Excel resources and tips on the blog, but nothing beats hands-on, classroom based Excel training.

excel-hidden-gems

Here are three Excel tips that come in handy once you know what you're doing:

How to Shade Every Other Row

When you have a long list of data that stretches across the page it can sometime be difficult to read each line precisely across. One way to help you, and your eyes, is to make every other row a different colour.

excel-shade-every-other-row

  • Highlight all the rows you want to make easier to read
  • Click Conditional Formatting in the 'Styles' section of the ribbon
  • Select New Rule > Use a formula to determine which cells to format
  • In the box marked 'Format values where this formula is true enter the formula =MOD(ROW(),2)=0
  • Click on the 'Format' box to apply your desired styling to every other line.
  • For simple shading, click on the 'Fill' tab and click on the lightest grey.
  • Apply the conditional formatting and your spreadsheet should now be nice and stripy, and more importantly - easy to read:

excel-shaded-cells

Read More

Looking for Online Training?

AgilePM, PRINCE2® & MSP® eLearning

A flexible, cost-effective way to gain your AgilePM, PRINCE2 & MSP qualifications online with our APMG accredited AgilePM eLearning, PRINCE2 eLearning & MSP eLearning packages.

ITIL®, PRINCE2®, PRINCE2 Agile®, MSP®, M_o_R®, P3O®, MoP®, MoV® courses on this website are offered by The Knowledge Academy, ATO of AXELOS Limited. ITIL®, PRINCE2®, PRINCE2 Agile®, MSP®, M_o_R®, P3O®, MoP®, MoV® are registered trade marks of AXELOS Limited. All rights reserved.