You can also create constant values to use in a worksheet by referring to it by name. To do this, choose Insert > Name > Define.In the Refers to: area, type a value such as 55 percent for a markup ...

Whether you've landed a job interview for a role that requires fundamental Microsoft Excel skills or you're looking to solve a real-world problem, take the How-To Geek Beginner Excel Test to ...

Then in cell B2 enter the formula =INDEX(SheetNames,A2), and then copy and paste the formula down 25 rows. These formulas will return a list of the names of your worksheet tabs in the same order as ...

Open a new Excel spreadsheet. Enter "Account" in cell A1. Input "Debits" in cell B1 and "Credits" in cell C1. Input each account name into a separate cell of column A.

Microsoft is testing a free version of Office apps for Windows, offering Word, PowerPoint and Excel at no charge, but it comes with ad-support and limited features.