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.

Microsoft Excel User Guide Pdf

Language:English, Japanese, Dutch
Genre:Personal Growth
Published (Last):24.09.2016
ePub File Size:27.48 MB
PDF File Size:20.86 MB
Distribution:Free* [*Registration Required]
Uploaded by: SAMELLA

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.

In the simplest of terms, Excel is a spreadsheet application. It uses grids of cells within columns and rows to manipulate, organize, and perform calculations with data. You can use pivot tables, charts, formulas, and functions in a variety of ways.

Popular Topics

General Uses for Excel Budgets for household or business finances Invoices and receipts Tracking for projects, client and customers, and health records Planners and calendars Financial, loan, debt, and mortgage calculations Inventory management The list goes on with the many uses for Excel. Getting familiar with them will help you to understand the guide and the steps you see. Workbook and Spreadsheet: A workbook is what you actually use when you open Excel.

The workbook contains the spreadsheets. We'll show you how to best work with Excel worksheet tabs. Read More on the bottom of the Excel workbook. Cell: Spreadsheets are made up of rectangular blocks called cells. A cell contains the data you enter; from numbers to words to images to formulas, cells hold that information. You can enter data either directly in the cell or in the formula bar text box for the cell right below your ribbon.

You will also notice the name box cell indicator to the left of the formula bar. By default, this displays the corresponding column and row for the cell. For instance, the cell in the top left corner of the spreadsheet is A1 for column A, row 1. Formulas and Functions: You can think of a formula as a calculation or equation. With Excel, you can create formulas or use built-in ones.

These formulas can automatically calculate numbers Doing Your Taxes? This is the time to leverage the power of Excel to get everything in order. Read More for you like addition or multiplication. In addition to calculations, you can use functions for things like counting the number of items in a column or displaying a minimum or maximum number for a group of cells. The Excel Tabs and Ribbon You should take a little time to familiarize yourself with the ribbon in Excel.

Just like with other Microsoft Office applications, the ribbon holds the buttons that you will use inside tabs. You can customize the ribbon to remove or add both tabs and buttons. But you will likely see the tabs below by default.

You might also like: EDEXCEL PHYSICS BOOK

Here is a brief explanation of what each one is for and which button sections you can see. File: Create a new workbook, open an existing one, save, print, and share books and sheets.

Home: Ctrl the clipboard, font, alignment, numbers, style, cells, and editing. Insert: Insert tables, charts, illustrations, filters, and links. Draw: Use drawing tools such as a lasso selection, eraser, pen, and highlighter. Page Layout: Adjust the spreadsheet theme, page setup, scale-to-fit, and sheet options.

Formulas: Pick a formula, function from the library, and perform formula auditing. Data: Get and transform data, view queries and connections, sort, filter, and use data tools.

Review: Use tools for proofreading, accessibility, language, and comments. View: Change the workbook view, items to show, zoom in or out, and work with windows. Also, note the Tell me what you want to do box. If you need help or want more information on a feature, just enter the keyword into the box and view your results. But if not, this is the toolbar at the very top left of the Excel window.

And it is important because it allows you to quickly undo or redo an action, plus save your file. If you make a mistake and want to undo it, just click the Undo button. If you click it once, it will undo the last action you took. If you keep clicking it, it will undo actions you took one-by-one moving backward. Alternatively, you can click the arrow next to the Undo button and highlight all actions you want to undo. If you undo an action with the button, the Redo button will then be clickable.

This lets you redo what you have just undone. Like the Undo button, you can redo your last action with one click or use the arrow next to the Redo button to redo multiple actions. The Save button lets you quickly save the file you are working on with the current file name. Spreadsheet Options Managing a large number of spreadsheets is no problem for Excel.

So, you can use more than one if your project calls for it. For example, you can use different spreadsheets for months or years, product warehouse locations, loan or credit card companies, and healthcare facilities. Along with multiple sheets, you can take advantage of these basic spreadsheet features. Add a spreadsheet: Click the plus button at the bottom next to your last sheet. Rearrange spreadsheets: Hold the sheet tab and drag to its new spot in the workbook.

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. OLE Object Linking and Embedding: allows a Windows application to control another to enable it to format or calculate data.

This may take on the form of "embedding" where an application uses another to handle a task that it is more suited to, for example a PowerPoint presentation may be embedded in an Excel spreadsheet or vice versa.

Excel can accept data in real time through several programming interfaces, which allow it to communicate with many data sources such as Bloomberg and Reuters through addins such as Power Plus Pro.

Although it is easy for users to create such links, programming such links reliably is so difficult that Microsoft, the creators of the system, officially refer to it as "the protocol from hell". Network DDE Extended the protocol to allow spreadsheets on different computers to exchange data. Starting with Windows Vista, Microsoft no longer supports the facility.

These include opening Excel documents on the web using either ActiveX controls, or plugins like the Adobe Flash Player. ExcelPackage is another open-source project that provides server-side generation of Microsoft Excel spreadsheets. Excel Services is a current.

NET developer tool that can enhance Excel's capabilities. Excel spreadsheets can be accessed from Python with xlrd and openpyxl. Password protection Microsoft Excel protection offers several types of passwords: Password to open a document [46] Password to modify a document [47] Password to unprotect worksheet Password to protect workbook Password to protect the sharing workbook [48] All passwords except password to open a document can be removed instantly regardless of Microsoft Excel version used to create the document.

300 Examples

These types of passwords are used primarily for shared work on a document. The only type of password that can prevent a trespasser from gaining access to a document is password to open a document. 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.To make that top row stand out better from a large amount of data beneath, you can format it easily. Internal rewrite to bits. Read More on the bottom of the Excel workbook. Read More for you like addition or multiplication. To select every cell in the worksheet, click in the upper right corner of the worksheet to the left of "A.

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.

In the context menu choose either Column Width or Row Height , depending on which one you want to change.

CRAIG from Ontario
Also read my other articles. I enjoy wheelstand competition. I love reading comics accidentally .