Excel

Excel

Spreadsheet tips and tutorials to boost your knowledge of the world’s favourite accounting tool.

Recent developments in Excel and Power BI

Excel
World map

ABC of Power BI: “C” is for CALCULATE

Excel
Calculate

New Excel functions: XLOOKUP and XMATCH

Excel
Woman working with spreadsheets

ABC of Power BI: “B” is for bar chart

Excel
Bar chart

How to solve common spreadsheet data issues

Excel
Spreadsheet

Excel-based templates for successful projects

Excel
Excel templates

Working with text in Excel

Excel
Spreadsheet table with text

How to detect errors in your spreadsheets

Excel
Number highlighted

The importance of cleaning up data

Excel
vacuum cleaner

Power BI: How to reduce your model footprint

Excel
Computer RAM

Three in spreadsheet equals Fife Council calamity

Excel
Spread sheet data show on tablet

Power BI basics: Two ways to remove old data

Excel
Bin

Dynamic Arrays: 15 months later

Excel
Excel
Newsletter updates

Join your peers and be in the know

Get all the latest tax, compliance, business and practice news from AccountingWEB.
Subscribe here

Trending

EasyJet problems grow as customer data hacked

EasyJet’s torrid May included an acrimonious AGM, a planned 30% cut in staff numbers and a potemtially expensive data breach.

Tech pulse
EasyJet experiences a torrid month in May 2020

Coronavirus: Flexible furloughing framework

Business tax
New quirks emerge for flexible coronavirus job scheme

Mini-Budget scheduled for early July

HMRC & policy
Chancellor Rishi Sunak hints at early July "fiscal event"

UK retail sector faces fight to recover from virus

Finance & strategy
Blurred shoppers and commuters in Glasgow

Key security questions you should keep in mind

Tech pulse
Username and password

Introducing DataDear to the world of data fluidity

Excel
DataDear: empowering finance teams to build better solutions

New views for Power Query

Excel
Business analysis

Dynamic Arrays vs legacy array formulae

Excel
Excel

Do not be scared of Power BI

Excel
Do not be scared of Power BI

Death of data tables and PivotTables?

Excel
Spreadsheet

Can you learn Power BI in a day?

Excel
power bi image 3

Dynamic Arrays and #SPILL! errors

Excel
Spreadsheet

Introduction to Dynamic Arrays

Excel
Excel on laptop

Resources

AML Compliance: Regulations and the five stages

Learn the basics of Anti-Money Laundering (AML) regulations, discover the five stages and check out some additional resources on AML compliance.

Guide
Sponsored
the_five_stages_of_aml_compliance_smartvault_aweb

The ultimate guide to VAT on Expenses

Guide
Sponsored
The Access Group Workspace

AccountingWEB's Buyer's Guide to Intuit QuickBooks

Guide
Sponsored
intuit buyers guide

Lead generation for accountants

Guide
Sponsored
lead_generation_ebook_cover pweb aweb.png

AccountingWEB's Buyer's Guide to Xero

Guide
Sponsored
Xero Buyers Guide Cover

Useful features of XLOOKUP

Excel
Excel

XLOOKUP and XMATCH: Two new X-Men for Excel

Excel
istock_andreypopov_ss

Modelling tips and tricks: Range names

Excel
Spreadsheet

Microsoft Teams emerges as rival to Slack

Excel
Microsoft Teams

How to avoid mistakes in cell referencing

Excel
Spreadsheet

Modelling tips and tricks: SUM things to consider

Excel
plus sign

Care with modifying numbers

Excel
istock_hh5800_no

Power BI: Why would you, when you have Excel?

Excel
Data

Microsoft adds picture capture to Excel 365 app

Excel
Android Excel composite

What’s new in Excel 2019: New charts and visuals

Excel
charts

What’s new in Excel 2019: PivotTable updates

Excel
spreadsheet

What’s new in Excel 2019: Functions

Excel
spreadsheet