Excel

11th Aug 2017
0
Pen on histogram graph
ExcelZone guide

The EZ guide to the EZ guide

10th Aug 2017
1
Hammer and nail

ICAEW Excel tips: Hammer and nails

8th Aug 2017
0
Mobile devices emitting data in a crowd of people
Cutting Big Data down to size

Cutting Big Data down to size: Power BI

4th Aug 2017
0
How to collate Net Promoter Scores in Excel

Net promoters: How to manage feedback in Excel

9th Jun 2017
3
Excel examination

VLOOKUP for beginners

30th May 2017
0
House for sale
EZ guide to PivotTables

EZ guide to PivotTables – grouping

Trending

14th Jul 2017
3
Worker sharpening his lawn mower

EZ guide to rounding

Popular resources

14th Jul 2017
0

ExcelZone: EuSpRIG 2017 round up

David Lyford Smith reports back from the EuSpRIG spreadsheet conference held at the Imperial College. It was my pleasure this month to...
21st Jun 2017
0

Cutting Big Data down to size: Broadband speeds

In the first part of this series we discussed possible definitions of Big Data and considered whether some of the technology and techniques...
21st Jun 2017
0

EZ guide to PivotTables: Grouping values areas

Simon Hurst delves further into his analysis of specific techniques used when working with PivotTables. Now that we have explored grouping...
14th Jun 2017
5

The real costs of spreadsheet risks

The ICAEW’s David Lyford-Smith discusses the issue of spreadsheet risk and how it can be identified and tackled. This past month has been...
23rd May 2017
13
deadline

Never miss a client filing deadline

8th May 2017
1
Data analytics

Analytics doesn’t have to be out of reach

3rd May 2017
0
Dashboard
EZ guide to PivotTables

EZ guide to PivotTables – an interactive dashboard

19th Apr 2017
5
Using a sliding compound mitre saw
Supercharge Excel

Power tools: Automate management accounting part 2

12th Apr 2017
19
image of a spreadsheet

Excel is dead - Long live Excel?

11th Apr 2017
1
Factory manufacturing
Supercharge Excel

Supercharge Excel: Automate management accounting

11th Apr 2017
0
Pushed to the limits

ICAEW Excel tips: Pushing your limits

9th Mar 2017
5
Slice and dice
EZ guide to PivotTables

EZ guide to PivotTables – slice and dice data

8th Mar 2017
0
On the road

ICAEW Excel tip: Back on the road again

2nd Mar 2017
2
Power tool
Supercharge Excel

VLOOKUP() v merging tables – approximate lookup

9th Feb 2017
74
Hanging on to a cliff

Spreadsheets survive MTD cull

8th Feb 2017
2
Spreadsheet
EZ guide to PivotTables

EZ guide to PivotTables part 2 – From why to how