Blog

  1. Using conditional formatting to dynamically change cell formats

    You can use the Conditional Formatting functionality to dynamically change the format of a cell/cells based on one or more…

    Posted on: 10.03.16 Read post
  2. dynamic data validation/drop-down cell

    When creating a cell that contains a drop-down (data validation) list, the simplest way to create this is to reference…

    Posted on: 03.03.16 Read post
  3. Using the IFS functions

    You are probably aware of the various functions to SUM, COUNT, AVERAGE that utilise the IF function. For example =SUMIF(I5:I10,”Apples”,J5:J10)…

    Posted on: 01.03.16 Read post
  4. See range status (Min, Max, Average, Sum, Count) without formulas

    Sometimes it is useful to be able to see the SUM, AVERAGE, MIN, MAX or COUNT of a range of…

    Posted on: 26.02.16 Read post
  5. Transpose data from column to row layout

    When using data in Excel it is generally created or delivered by 3rd party applications in a columnar layout.  …

    Posted on: 25.02.16 Read post
  6. All the shortcut keys you will need!

    Excel allows the vast majority of its functionality to be accessed via ‘shortcut key’. These are a combination of keys…

    Posted on: 24.02.16 Read post
  7. Editing formulas made a bit easier

    If you have a formula in a cell that has returned an error you sometimes need to step through the…

    Posted on: 23.02.16 Read post
  8. Quickly sum values above a cell

    To SUM a range of cells, say C3 to C14, can be achieved by entering the formula ‘=SUM(C3:C14)’ in cell…

    Posted on: 22.02.16 Read post
  9. INDEX function to return a value from a specified position in a range/array

    You can return the value in a range/array or table by using the INDEX function. The function is built as…

    Posted on: 17.02.16 Read post
  10. MATCH function to return relative position of a value

    You can return the relative position of a value in a range/array by using the MATCH function. The example below…

    Posted on: 16.02.16 Read post
  11. return the row or column number

    There may be occasions when you need to know the number of a column or even the row number in…

    Posted on: 12.02.16 Read post
  12. return end of month and same date in future or past months

    If you need to know the end of month dates for a list of months you could simply type in…

    Posted on: 10.02.16 Read post
  13. rETURN THE NUMBER OF WORKDAYS IN A PERIOD

    You can return the number of workdays between two date and take into account any Bank Holidays within the same…

    Posted on: 09.02.16 Read post
  14. Return the number of months and/or years between two date

    You can use the simple function of taking one date value away from another to find out the number of…

    Posted on: 08.02.16 Read post
  15. return the month number of a date

    Using the MONTH function will return the month number of a referenced date   Enter =MONTH(A4) to get the month…

    Posted on: 01.02.16 Read post
  16. substitute/replace function – remove and/or replace text from a cell

    By using the SUBSTITUTE or REPLACE functions, you can easily remove or replace a character/s from within the contents of…

    Posted on: 01.01.16 Read post
  17. text function – convert numeric cell values to text

    The TEXT function enables values such as dates, time and values to be interpreted as text values. ┬áThis can be…

    Posted on: 01.01.16 Read post
  18. upper/lower/proper function – amend the case of cell text

    Use the UPPER and PROPER functions to make any text content in Excel look more presentable. The entered in the…

    Posted on: 23.12.15 Read post
  19. TRIM function – remove leading and trailing spaces from cells

    The TRIM function is useful and incredibly simple to use as invisible leading and/or trailing spaces in a cell can…

    Posted on: 29.11.15 Read post
  20. Easy Navigation Around Large Excel Sheets

    Navigating large Excel sheets can take an unnecessary amount of time if a worksheet consists of many hundreds of columns…

    Posted on: 29.11.15 Read post

Get more great content from Rousseau Associates

Start your project with us today

Call +44 (0)1757 269461

Discuss your requirements today