Excel

12th Apr 2018
0
Tin can phone robots

ICAEW Excel tips: Talking shop with 'Excel geeks'

12th Apr 2018
8
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: Merging tables of data part two

11th Jan 2018
0
Business graph and keyboard

The EZ guide to Excel views

11th Jan 2018
0
New Year resolution

What's your Excel New Year’s resolution?

Trending

14th Mar 2018
1
Excel

ICAEW Excel tips: Excel is some product

Popular resources

6th Mar 2018
4

The EZ guide to VLOOKUP(): Part two

Simon Hurst explores a range of Excel problems that can be solved using Excel's lookup functions and reveals how to reduce the number of...
8th Feb 2018
1

ICAEW Excel tips: You can’t beat the classics

This week I have been in Wales, presenting training courses for local ICAEW members. This has become something of a tradition (it’s now my...
8th Feb 2018
0

The EZ guide to VLOOKUP

Objective: To extend the range of Excel problems that can be solved using Excel's lookup functions and to reduce the number of VLOOKUP()...
31st Jan 2018
0

The EZ guide to printing

Objective: to make it easier to get the right content in the right place on the printed page. Introduction Many Excel workbooks are...
19th Dec 2017
2
Christmas tree

Use Power BI to create an interactive Xmas card

14th Dec 2017
1
Kuala Lumpur

ICAEW Excel tips: Excel around the world

4th Dec 2017
0
Histogram

Excel tips as wallpaper: The Power BI alternative

30th Nov 2017
2
What we've been reading

Spreadsheets, Starship Troopers, B.S. and startups

21st Nov 2017
2
world

Using Power BI to save the world

8th Nov 2017
0
Typing on laptop

The EZ guide to conditional formatting: Part 2

8th Nov 2017
0
Hand point to the screen with histogram

Forecast employee payroll and bonuses

7th Nov 2017
1
microsoft

What would you want to ask Microsoft?

25th Oct 2017
0
Analytics
Unleash the Power BI

Power BI: set analysis periods for Sage 50 data

25th Oct 2017
2
helping hand

Spreadsheets: Victims of their own success?

18th Oct 2017
3
Financial chart
Unleash the Power BI

Power BI: How and why to create a date table

13th Oct 2017
0
Colourful earth globe

Cutting Big Data down to size: Animated map