# 10 Features in Sheets Excel Needs

## Microsoft’s rival fares better in several areas

Mar 16 · 11 min read

# 10. Images in Cells

`=IMAGE("https://upload.wikimedia.org/wikipedia/en/thumb/b/be/Flag_of_England.svg/1920px-Flag_of_England.svg.png",1)`

# 4. Non-Contiguous References

`=SUM({A2:A8,C2:C8,E2:E8})`
`=SUM((A2:A8,C2:C8,E2:E8))`

# 3. Arrays

`={SUM(A2:A8),AVERAGE(A2:A8),MAX(A2:A8),MIN(A2:A8)}`
`=CHOOSE({1,2,3,4},SUM(A2:A8),AVERAGE(A2:A8),MAX(A2:A8),MIN(A2:A8))`

# 2. QUERY function

`=QUERY(A2:K27,"SELECT A,DWHERE B='Goalkeeper'ORDER BY D")`
`=QUERY(A1:K27,"SELECT C, COUNT(C)GROUP BY CPIVOT D")`
`=QUERY(A1:K27,"SELECT C, COUNT(C)GROUP BY CORDER BY COUNT(C) DESCLABEL COUNT(C) 'Players'")`

# 1. Importing Data

## IMPORTHTML

`=IMPORTHTML("https://en.wikipedia.org/wiki/2020%E2%80%9321_Premier_League","table",5)`

## IMPORTXML

`=IMPORTXML("https://en.wikipedia.org/wiki/2020%E2%80%9321_Premier_League","//table[@class='wikitable'][1]/tbody/tr")`

# Final Thoughts

## CodeX

Everything connected with Tech & Code

Written by

## Andrew Moss

I mainly focus on Excel-related content in my articles, often providing example workbooks to download, too. https://www.linkedin.com/in/andrewcharlesmoss

## CodeX

Everything connected with Tech & Code

Written by

## Andrew Moss

I mainly focus on Excel-related content in my articles, often providing example workbooks to download, too. https://www.linkedin.com/in/andrewcharlesmoss

## CodeX

Everything connected with Tech & Code

## The One Thing I Wish I Studied More Before Starting My First Job as a Developer

Get the Medium app