Andrew Potter | search
Click here to view Andrew Potter news from 60+ newspapers.
Bookmark or Share- Insert a check mark symbol - Microsoft SupportYou can easily insert a check mark (also known as a "tick mark") in Word, Outlook, Excel, or PowerPoint. These marks are static symbols. If you're looking for an interactive check box that you can click to check or uncheck, see: Add a check box or option button (Excel) or Make a checklist in Word.
- VLOOKUP function - Microsoft SupportUse VLOOKUP when you need to find things in a table or a range by row. For example, look up a price of an automotive part by the part number, or find an employee name based on their employee ID. In its simplest form, the VLOOKUP function says:
- About the shared workbook feature - Microsoft SupportShared Workbooks have limitations, and one in particular is the inability to edit using Excel for the web. Therefore we highly recommend co-authoring, which is the replacement for Shared Workbooks. Create a new workbook or open an existing workbook. Then place it on a network location.
- Combine first and last names - Microsoft SupportLet's say you want to create a single Full Name column by combining two other columns, First Name and Last Name. To combine first and last names, use the CONCATENATE function or the ampersand (&) operator. Important: In Excel 2016, Excel Mobile, and Excel for the web, this function has been replaced with the CONCAT function.
- Add a pie chart - Microsoft SupportPie charts can convert one column or row of spreadsheet data into a pie chart. Each slice of pie (data point) shows the size or percentage of that slice relative to the whole pie. Pie charts work best when: You have only one data series. None of the data values are zero or less than zero.
More
