News

The new user interface in the latest version of Microsoft Excel changes all the rules. Here's how to find your way around and get the most out of Excel 2007.
This cheat sheet gets you up to speed on the features that were introduced in Excel 2016 and Excel 2019, the perpetual-license versions of Excel included with Office 2016 and Office 2019 ...
You can have Excel make a spreadsheet in read only format for others, so that people can read its contents but not edit them, or you can enforce other content restrictions.
Google Sheets offers seamless compatibility with Microsoft Excel, allowing users to export their spreadsheets, complete with graphs, into Excel's format. Click File in the toolbar. Select Download.
Drop-down lists in an Excel sheet can greatly facilitate data entry. Here's a look at how to use Microsoft Excel's data validation feature to create handy lists within your worksheets.
A pivot table is a useful tool in data analysis that can give you an overview of your data. We'll show you how to create one in Excel and Google Sheets.
How to Make a Two Column Spread Sheet on Microsoft Excel. Unless someone's calculator needs an upgrade, one plus one usually adds up to two. With Microsoft Excel, you can put that math to work ...
So, you want to know how to create a scatter plot in Excel. Chances are, you probably already know what the term means, but given Microsoft Excel’s arsenal of options packed into each tab ...
Figure B How to use the UNIQUE () function in Excel If you’re using Microsoft 365 or one of the 2019 standalone versions of Excel, you can quickly create a dynamic list using the UNIQUE () function.
Excel macros are like mini-programs that perform repetitive tasks, saving you a lot of time and typing. Here's everything you need to know to start programming macros yourself.
If you’re new to using Microsoft Excel, or an experienced user looking for a good visual reference, this handy cheat sheet covers eight helpful tricks for becoming a spreadsheet pro.