It might seem complicated and have an impenetrable interface, but Excel isn’t difficult to use. Once you know the basics, you’ll be summing your totals, creating graphs and maybe even the legendary PivotTables. Our step-by-step Excel guides are easy to follow and will work with any version. See also: How to get Office 2016 (including Excel) for free Excel isn’t only available on your PC or laptop these days: you can also get Microsoft Office on your tablet, an iPad and an Android tablet. You can even use Excel in a web browser now, thanks to ‘cloud’ versions of the main Office apps. See also: How to use Microsoft OneNote – the best app for getting organised
How to use Excel | Excel How To guides:
Use basic formulae Use Excel to budget your money Make a graph or chart Add (SUM) and subtract cells Calculate standard deviation Freeze rows and columns Delete duplicate data Add, delete, lock, merge and split cells Calculate percentages Set print areas on multiple sheets Make PivotTables
How to use Excel | Import and export data from Excel
Import and export comma separated (CSV) files Export Excel to Google Sheets and vice versa
Jim has been testing and reviewing products for over 20 years. His main beats include VPN services and antivirus. He also covers smart home tech, mesh Wi-Fi and electric bikes.
