Excel

11th Oct 2018
7
looking for something

Lookout for VLOOKUP and HLOOKUP

12th Sep 2018
1
Spreadsheet
Modelling tips and tricks

New data types and the FIELDVALUE function

29th Aug 2018
spreadsheet
Modelling tips and tricks

Modelling tips and tricks: Flagging IF

22nd Aug 2018
4
Abstract financial background
Power Query techniques

Power Query techniques: Grouping

14th Aug 2018
1
spreadsheet
Modelling tips and tricks

Modelling tips and tricks: Phantom links

1st Aug 2018
2
istock_savushkin_sh
Modelling tips and tricks

Using OFFSET for depreciation

Trending

18th Jul 2018
Messenger delivering information

Power BI and cash flow: Delivering information

Popular resources

12th Jul 2018

Power Query techniques: Conditional columns

Simon Hurst looks at conditional columns and the Power Query equivalent of the well-known IF() function. IF() is one of the most frequently...
11th Jul 2018

Using OFFSET for scenario analysis

Welcome to a new series of applied tips and tricks in Excel for accountants and financial analysts wherever you may be. As a professional...
2nd Jul 2018
1

Formulae referencing current worksheet

Welcome to a new series of applied tips and tricks in Excel for accountants and financial analysts. Excel MVP and FCA/FCMA Liam Bastick...
25th Jun 2018
35

Spreadsheets: Professional competence and due care

When it comes to spreadsheets, most accountants are either self-taught or taught by the self-taught. But in a profession that features...
13th Jun 2018
6
Evan Goldberg at SuiteWorld 2018

Will the native pivot function change Excel use?

7th Jun 2018
Excel formatting
Modelling tips and tricks

Modelling tips and tricks: Number formatting

5th Jun 2018
6
Old wooden bridge

How to deal with unstable Excel workbooks

29th May 2018
forecast
Modelling tips and tricks

Modelling tips and tricks: Revising forecasts

10th May 2018
Blue data mining structure

The EZ guide to IF(): Part two

10th May 2018
1
Rearview mirror with modern building

ICAEW Excel tips: Looking back

30th Apr 2018
3
excel

An accountant's guide to Excel PivotTables

12th Apr 2018
Tin can phone robots

ICAEW Excel tips: Talking shop with 'Excel geeks'

12th Apr 2018
9
Business man calculate about cost and doing finance at office

The EZ guide to IF() and other logical functions

3rd Apr 2018
5
Cash flow projection spreadsheet

How to build an Excel cash flow forecast

27th Mar 2018
1
Abstract numeric data
Power Query techniques

Power Query: Merging tables of data part two

14th Mar 2018
1
Excel

ICAEW Excel tips: Excel is some product