CODEX

10 Features in Sheets Excel Needs

Microsoft’s rival fares better in several areas

Andrew Moss
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)

9. In-Cell Dropdown Lists

8. SPLIT Function

7. Checkboxes

6. Automatic Pivot Tables

5. Ranges

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,D
WHERE B='Goalkeeper'
ORDER BY D"
)
=QUERY(A1:K27,
"SELECT C, COUNT(C)
GROUP BY C
PIVOT D"
)
=QUERY(A1:K27,
"SELECT C, COUNT(C)
GROUP BY C
ORDER BY COUNT(C) DESC
LABEL 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

Andrew Moss

Written by

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

CodeX

CodeX

Everything connected with Tech & Code

Andrew Moss

Written by

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

CodeX

CodeX

Everything connected with Tech & Code

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store