Microsoft Excel , Microsoft Excel (Windows). Microsoft Excel to use another file type, such as a PDF or Excel workbook. It's easy to. Commerce Manager Manual. Purpose and Overview. The purpose of this manual is to provide an overview of Microsoft Excel tools and functions which are most. Microsoft, ActiveX, Excel, InfoPath, Microsoft Press, MSDN, OneNote, . The Instructor's Guides are available from the Instructor's Book To work efficiently in Microsoft Excel, you need to become familiar with its primary user inter- Take Note Adobe PDF (Portable Documents Format) ensures that your.
|Language:||English, Spanish, Indonesian|
|Genre:||Business & Career|
|Distribution:||Free* [*Registration needed]|
There are even classes for new Excel users both online and on campuses. Unlock the This guide is available to download as a free PDF. Pivot Tables. User Guide .. This guide covers the analysis of data using formulae, functions & pivot tables, . There are two ways to filter a list in Microsoft Excel. You can find more Microsoft Office training (including Excel, Word and .. SUMIF and SUMIFS for Excel + users – Like the IF statement but for SUM. Excel.
Name a spreadsheet: Double-click the sheet tab and type the new name. By default, you will see them named Sheet 1, Sheet 2, and so on. Color a spreadsheet tab: Right-click the sheet tab and under Tab Color, just click to apply a new one. Protect a spreadsheet: Right-click the sheet tab and under Protect Sheet, add a password and select your options. Move or copy a spreadsheet: Right-click the sheet tab and select Move or Copy.
You can then move the sheet to another spot in the workbook, move it to a different workbook, and make a copy of it for either case. Delete a spreadsheet: Right-click the sheet tab and click Delete. You will need to confirm this action in the subsequent pop-up window. Working With Columns, Rows, and Cells in Excel There are some basics such as selecting, inserting, deleting the columns, rows, and cells in Excel.
These are handy actions to keep in mind as you work with your spreadsheets. Select an Entire Column or Row You will notice as you move your mouse over the letters for the columns or numbers for the rows that a small arrow will appear. If you click at that time, the entire column or row will be selected. You might use this action for applying a function, formatting, or sorting. Select a Group of Columns, Rows, or Cells There may be times when you want to select more than one column, row, or cell.
You can do this in a couple of different ways depending on if they are adjacent or scattered. Select Adjacent Columns, Rows, or Cells When you want to select columns, rows, or cells that are next to each other, begin by selecting the first one. Then, hold down your mouse button and drag through the rest.
You will see them highlight as they are selected. Release the mouse button when you finish.
Another way to do this is to select the first one, hold down your Shift key, and then select the last one. If you do this with cells, you can select an entire group across and down. Select Scattered Columns, Rows, or Cells If you would like to select columns, rows, or cells that are not adjacent, start by clicking the first one. Then, hold down the Ctrl key and continue clicking the ones you want. Release the Ctrl key when you finish.
Insert or Delete a Column, Row, or Cell You can easily add or get rid of a column or row that you no longer need. Again, put your mouse over the letter or number, but instead of left-clicking your mouse, right-click.
In the context menu that appears, select either Insert or Delete. You can also simply hide and unhide columns or rows How to Hide or Unhide Columns and Rows in Excel How to Hide or Unhide Columns and Rows in Excel If you're dealing with a data-heavy spreadsheet, sometimes it's helpful to hide or unhide rows and columns to better see the information you need to analyze.
Read More by selecting Hide or Unhide from the context menu. You can insert or delete a cell the same way as a column or row. However, with either option, you will receive a pop-up alert asking how you would like to shift the cells, row, or column. Just choose an option and click OK.
Move a Column, Row, or Cell If you decide to move a column, row, or cell to a different spot in your spreadsheet, you can do it but must be careful. First, select the column, row, or cell as described above. Put your mouse over one of the edges of it so that the four-sided arrow appears.
Then, drag it by holding down your mouse button to its new location and release.
What you must be cautious of is if you release the column, row, or cell over the top of one that already contains data. If this happens, a pop-up box will appear asking if you are sure you want to replace the data. So, if you do this in error, click Cancel and it will go back to its original spot. Adjusting the Size of a Column or Row You may want all or some of the columns or rows on your spreadsheet to be a specific size regardless of the data they hold.
Adjusting the width or height is simple and can be done in two different ways. First, you select and right-click the column or row.
In the context menu choose either Column Width or Row Height, depending on which one you want to change. In the pop-up window that appears, you will see the current width or height.
Replace it with the number you want and click OK. Another way to adjust the size of a column How to Manage Columns in Excel How to Manage Columns in Excel Do you need to add, move, hide, or change columns in a complex spreadsheet? Don't panic. We'll show you basic Excel column operations to organize your data. Read More or row is to first select it. Move your mouse to the border until you see a two-sided arrow appear. Then, hold down your mouse button and drag until you reach the size you want.
Adjusting the Size to Fit Your Data If you would rather have each column and row sized to accommodate your data, you can do this in a just a few clicks.
First, select the entire spreadsheet by clicking the triangle in the upper left corner between the A and the 1. Then, move your mouse between two columns until you see the two-sided arrow and double-click. Next, do the same for the rows. You will notice both columns and rows of the spreadsheet adjust to fit the data in your cells. It will automatically adjust for the cell with the longest amount of data. Basic Formatting Excel offers a variety of ways to format your spreadsheets, from basic to advanced.
Fonts, Shading, and Colors No matter what you decide to use Excel for, basic formatting of columns, rows, and cells can help you view your data easily.
For instance, you may use the first row of a spreadsheet to insert headers. Like in our example for a product sheet, you might use item number, product name, and price. To make that top row stand out better from a large amount of data beneath, you can format it easily. Select the row and then apply your formatting using options on the Home tab. Here, you may make the font bold, apply a fill shade, and color the font.
Select the top row. Click the arrow next to the Fill Color and pick a color. Click the arrow next to the Font Color and pick a color. Keep in mind that these instructions will apply to the entire first row. If you only have a few columns, you can follow the steps further above to only select certain cells in that row and apply the formatting to them alone. Dates, Currency, and Decimals If you are creating a tracking spreadsheet, automatic formatting for dates, currency, and decimals is convenient.
And you can apply each of these formatting rules in just a few clicks from the Home tab. Dates You may have a Date column on your spreadsheet for many reasons. When you enter the data, when you make a purchase, or when an item is due are all just examples.
Select the column, row, or cell where you will enter the date. Note that if you use the Long Date, which inserts words and numbers as shown below, you do not have to type it in manually. Method One Select the column, row, or cell where you will enter the currency. Under Number on your ribbon, click the arrow in the General Select Currency from the dropdown box. Method Two The second method allows you to choose the type of currency you would like. Select the column, row, or cell where you will enter the currency.
Under Number on your ribbon, click the arrow next to the Currency Select the type of currency you wish to apply. Whichever method you decide to use, any number that you enter into the applied columns, rows, or cells will automatically be formatted as that currency. Decimals You can use the decimal formatting to adjust your currency or simple numbers. You can apply this formatting with these two steps.
Select the column, row, or cell where you will enter the number. Under Number on your ribbon, click either the Increase Decimal or Decrease Decimal button depending on your current numbering format. Additional Number Formats You will also notice under Number on your Home tab, many additional ways to format your numbers.
As you progress with Excel, these may come in handy. These options include times, fractions, percentages, and others. Plus, you can click the More number formats link at the bottom to see options like ZIP code, phone number, and custom choices.
And if you are using Excel for a project like income and expenses or loan and debt management, you will appreciate the AutoSum feature. The cryptographic strength of this kind of protection depends strongly on the Microsoft Excel version that was used to create the document. In Microsoft Excel 95 and earlier versions, password to open is converted to a bit key that can be instantly cracked. As regards services which use rainbow tables e.
Password-Find , it takes up to several seconds to remove protection. In addition, password-cracking programs can brute-force attack passwords at a rate of hundreds of thousands of passwords a second, which not only lets them decrypt a document, but also find the original password. Due to the CSP, an Excel file can't be decrypted, and thus the password to open can't be removed, though the brute-force attack speed remains quite high.
The situation changed fundamentally in Excel , where the modern AES algorithm with a key of bits started being used for decryption, and a 50,fold use of the hash function SHA1 reduced the speed of brute-force attacks down to hundreds of passwords per second.
In Excel , the strength of the protection by the default was increased two times due to the use of a ,fold SHA1 to convert a password to a key. Microsoft Excel Viewer Microsoft Excel Viewer was a freeware program for viewing and printing spreadsheet documents created by Excel. Excel Viewer is similar to Microsoft Word Viewer in functionality. There is not a current version for the Mac.
Numeric precision Main article: Numeric precision in Microsoft Excel Excel maintains 15 figures in its numbers, but they are not always accurate: the bottom line should be the same as the top line. Despite the use of figure precision, Excel can display many more figures up to thirty upon user request. But the displayed figures are not those actually used in its computations, and so, for example, the difference of two numbers may differ from the difference of their displayed values.
Although such departures are usually beyond the 15th decimal, exceptions do occur, especially for very large or very small numbers. Serious errors can occur if decisions are made based upon automated comparisons of numbers for example, using the Excel If function , as equality of two numbers can be unpredictable. Although this number has a decimal representation that is an infinite string of ones, Excel displays only the leading 15 figures.
In the second line, the number one is added to the fraction, and again Excel displays only 15 figures. In the third line, one is subtracted from the sum using Excel. Because the sum in the second line has only eleven 1's after the decimal, the difference when 1 is subtracted from this displayed value is three 0's followed by a string of eleven 1's. However, the difference reported by Excel in the third line is three 0's followed by a string of thirteen 1's and two extra erroneous digits.
This is because Excel calculates with about half a digit more than it displays. Excel works with a modified version of the IEEE specification. See the main article for details. Besides accuracy in user computations, the question of accuracy in Excel-provided functions may be raised.
Particularly in the arena of statistical functions, Excel has been criticized for sacrificing accuracy for speed of calculation. Microsoft has announced some of these issues are addressed in Excel In the case of excessively large results, Excel will return the error warning NUM! Date range Excel supports dates with years in the range , except that December 31, can be entered as 0 and is displayed as 0-jan Converting a fraction of a day into hours, minutes and days by treating it as a moment on the day January 1, , does not work for a negative fraction.
A similar problem occurs when a text happens to be in the form of a floating point notation of a number. In these cases the original exact text cannot be recovered from the result.
This issue has caused a well known problem in the analysis of DNA , for example in bioinformatics. As first reported in ,  genetic scientists found that Excel automatically and incorrectly converts certain gene names into dates. A follow-up study in  found many peer reviewed scientific journal papers had been affected and that "Of the selected journals, the proportion of published articles with Excel files containing gene lists that are affected by gene name errors is IsText " in VBA , incorrectly returns "false".
You cannot open two documents with the same name, even if the documents are in different folders. To open the second document, either close the document that is currently open, or rename one of the documents. Microsoft released the first version of Excel for the Macintosh on September 30, , and the first Windows version was 2. This accomplishment solidified Microsoft as a valid competitor and showed its future of developing GUI software. Microsoft maintained its advantage with regular new releases, every two years or so.
Microsoft Windows Excel 2.
Versions prior to 2. Excel 2. This included a run-time version of Windows. The magazine stated that the port of the "extraordinary" Macintosh version "shines", with a user interface as good as or better than the original.