how to find median in Excel

How to Find the Median in Excel for Office 365

Microsoft Excel is much more than just a simple table in which you can sort and display data. It can also be used to perform formulas or mathematical operations on sets of data. This means that you can find all sorts of useful values. You can even learn how to find the median in Excel … Read more

what is compatibility mode in Microsoft Excel

What is Excel Compatibility Mode?

Older versions of Microsoft Excel used to create files with a file type that ended in .xls. However, newer versions now use a file format that ends with .xlsx. Newer versions of Excel can open these older Excel file versions, but some older versions of Excel have trouble with the newer file format. Excel is … Read more

How to Title an Excel Spreadsheet

Giving a title to an Excel spreadsheet makes it much easier to identify the spreadsheet in the future if you need to view it or edit it. Use these steps to title an Excel spreadsheet. Open the file in Excel. Click the Page Layout tab at the top of the window. Click the small Page … Read more

How to Create a Comma Delimited File from Excel

While default files that you create in Microsoft Excel are going to be in the .xls or .xlsx file format, you have some other options. Use these steps to create a comma delimited file from Excel. Open Excel and create a new workbook. Enter the data into your cells. Click the File tab at the … Read more

Excel UPC number formatting

How to Show Excel UPC Numbers in Full

The steps in this article are going to show you how to display Excel UPC numbers in full, as opposed to the scientific notation that it displays by default. This setting will only apply to each worksheet for which you make this formatting change. It doesn’t carry over to other spreadsheets or new spreadsheets that … Read more