Microsoft excel 2013 basics unit 1 free.Browse code samples

A career with bright prospects await you with the completion of this course. According to www. Entry Requirements. Who Should Attend. Method of Assessment. Other Information. I want to stay updated on the latest courses and offers. This field is for validation purposes and should be left unchanged.

Buy Now. Course Description: Microsoft Excel is the most commonly used spreadsheet application. What skills will I gain? Learn about other ways to create a chart. Select a range of data, such as A1:L5 multiple rows and columns or C1:C80 a single column.

The range can include titles that you created to identify columns or rows. Click to perform an ascending sort A to Z or smallest number to largest. Click to perform a descending sort Z to A or largest number to smallest.

In the Order list, select the order that you want to apply to the sort operation — alphabetically or numerically ascending or descending that is, A to Z or Z to A for text or lower to higher or higher to lower for numbers. For more information about how to sort data, see Sort data in a range or table.

Click the arrow in the column header to display a list in which you can make filter choices. To select by values, in the list, clear the Select All check box. This removes the check marks from all the check boxes. Then, select only the values you want to see, and click OK to see the results. For more information about how to filter data, see Filter data in a range or table. Under Save As , pick where to save your workbook, and then browse to a folder.

Preview the pages by clicking the Next Page and Previous Page arrows. The preview window displays the pages in black and white or in color, depending on your printer settings. On the File tab, choose Options , and then choose the Add-Ins category. Near the bottom of the Excel Options dialog box, make sure that Excel Add-ins is selected in the Manage box, and then click Go. In the Add-Ins dialog box, select the check boxes the add-ins that you want to use, and then click OK.

If Excel displays a message that states it can’t run this add-in and prompts you to install it, click Yes to install the add-ins. For more information about how to use add-ins, see Add or remove add-ins. Excel allows you to apply built-in templates, to apply your own custom templates, and to search from a variety of templates on Office. For more information about how to find and apply templates, see Download free, pre-built templates. Get started. Click File , and then click New. Under New , click the Blank workbook.

Click an empty cell. Type text or a number in the cell. Press Enter or Tab to move to the next cell. Select the cell or range of cells that you want to add a border to.

Select the cell or range of cells that you want to apply cell shading to. Select the cell to the right or below the numbers you want to add. AutoSum adds up the numbers and shows the result in the cell you selected. That tells Excel that this cell will contain a formula. Press Enter. This runs the calculation.

Select the cells that have numbers you want to format. Pick a number format. Select your data by clicking the first cell and dragging to the last cell in your data. To get back to the worksheet with your data, click the Sheet1 tab at the bottom of the window. Chapter 4 has more about how to use and manage multiple worksheets. That means you can still open a spreadsheet that uses newer, unsupported features in an old version of Excel.

Optionally, you can set the Compatibility Checker to run automatically for this workbook. Now, the Compatibility Checker runs each time you save your spreadsheet, just before Excel updates the file.

But if you want to share your spreadsheet with Excel , follow the instructions in the next section. Sharing your workbook with someone using Excel presents an additional consideration: Excel uses the older.

Save your spreadsheet in the old format. You can save a copy of your spreadsheet in the traditional. If you keep your spreadsheet in Excel and share it with an Excel user, the sheet might look a little different when your recipient opens it. Use a free add-in for older versions of Excel.

People stuck with Excel , Excel , or Excel can read your Excel files—they just need a free add-in from Microsoft. People with past-its-prime versions of Excel can find the add-in by surfing to www. If you save your Excel spreadsheet in the Excel format, make sure to keep a copy in the standard.

As you already know, each version of Excel introduces a small set of new features. The differences between Excel and Excel are small, but the differences between Excel and Excel are more significant.

Excel tries to help you out in two ways. First, whenever you save a file in. Second, whenever you open a spreadsheet in the old. While the Compatibility Checker points out potential problems after the fact, compatibility mode is designed to prevent you from using unsupported features in the first place. In fact, compatibility mode is so seamless that you might not even notice its limitations.

Instead of seeing something like CateringList. When you save an Excel workbook in. Instead, you need to close the workbook and reopen it. This saves an Excel version of your file with the same name but with the extension. One way to solve this problem is to save your spreadsheet as a PDF file. People use PDFs to pass around product manuals, brochures, and all sorts of electronic documents.

Unlike a document format like. The best part about PDFs is that you can view them on just about any computer using the free Adobe Reader. The Windows operating systems includes another electronic paper format called XPS, which works just as well as PDF for creating print-ready files. Excel opens a modified version of the Save As window that has a few additional options Figure You can save PDF files at different resolutions and quality settings which mostly affect graphics in your workbook, like pictures and charts.

Normally, you use higher-quality settings if you want to print your PDF file, because printers use higher resolutions than computers. That way, you can check the result. Finally, if you want to publish only a portion of your spreadsheet as a PDF file, click the Options button to open a window with even more settings. You can publish just a fixed number of pages, just selected cells, and so on. These options mirror the choices you see when you print a spreadsheet Printing.

Excel document properties are discussed in more detail on Document Properties. If your computer is on a network, the solution may be as simple as storing your file in the correct, protected location. It lets you password-protect your spreadsheets, which means that anyone who wants to open them has to know the password you set. You can prevent others from opening your spreadsheet unless they know the password. This level of security, which scrambles your data for anyone without the password a process known as encryption , is the strongest.

You can let others read but not modify the sheet unless they know the password. From the Tools drop-down menu, pick General Options. The Tools drop-down menu sits in the bottom-right corner of the Save As window, just to the left of the Save button. Type a password next to the security level you want to turn on as shown in Figure , and then click OK. Excel creates a backup with the file extension.

For example, if you save a workbook named SimpleExpenses. You can open the. When you do, you see that it is an exact copy of your work. With this option, Excel displays a message every time you or anyone else opens the file. You can use any sequence of letters and numbers as a password. Passwords are case-sensitive which means that PanAm is different from panam , and masked which means that, when you type in the password, Excel displays just a series of asterisks.

Click Save to store the file. Top: You can give a spreadsheet two layers of protection. AutoRecover periodically saves backup copies of your spreadsheet while you work. If you suffer a system crash, you can retrieve the last backup even if you never managed to save the file yourself. If your computer does crash, when you get it running again, you can easily retrieve your last AutoRecover backup. Click that link, and Excel adds a panel named Document Recovery to the left side of the Excel window Figure You can save or open an AutoRecover backup just as you would an ordinary Excel file; simply click the item in the list.

Once you deal with all the backup files, close the Document Recovery window by clicking the Close button. If your computer crashes mid-edit, the next time you open Excel you may see the same file listed twice in the Document Recovery window, as shown in Figure To open a file in the Document Recovery window, just click it.

You can also use a drop-down menu with additional options Figure If you find a file you want to keep permanently, make sure to save it. You can choose Show Repairs to display a list of any changes Excel made to recover the file. AutoRecover comes switched on when you install Excel, but you can tweak its settings.

You can adjust the backup frequency in minutes. See Figure for tips on timing. You can control whether Excel keeps a backup if you create a new spreadsheet, work on it for at least 10 minutes, and then close it without saving your work. Click it. You can configure how often AutoRecover backs up your files. Unless you work with extremely complex or large spreadsheets—which might suck up a lot of computing power and take a long time to save—you can set Excel to save a document every 5 minutes with no appreciable slowdown in performance.

You can choose where you want Excel to save backup files. The standard folder works fine for most people, but feel free to pick some other place. For example, this spreadsheet might hold records you pulled out of a central database so you can take a closer look. The left side of the page includes the Places list, which matches the list in the Save As page with one addition: Recent Workbooks.

If you find the file you want, click it to open it. When you open a file, Excel loads it into a new window. If you already have a workbook on the go, that workbook remains open in a separate Excel window. The best part about the Recent Documents list is the way you can pin a document so it stays there forever, as shown in Figure To keep a spreadsheet on the Recent Documents list, click the thumbtack on the right. Excel moves your workbook to the top of the list and pins it in place.

If you decide to stop working with the file later on, just click the thumbtack again to release it. Pinning is a great way to keep your most important files at your fingertips. Do you want to hide your recent editing work?

Choose Computer to see a list of locations on your hard drive. As with recently opened workbooks, you can pin your favorite locations so they remain on this list permanently. To open a file in one of these locations, click the folder or click the Browse button underneath to look somewhere else. Either way, Excel opens the familiar Open window, where you can pick the file you want. To use this trick, hold down the Ctrl key and click to select each file.

Excel can open many file types other than its native. Depending on your computer settings, Windows might hide file extensions. In this case, you can still tell what type of file it is by looking at the icon.

If you see a small Excel icon next to the file name, that means Windows recognizes the file as an Excel spreadsheet. If you see something else like a tiny paint palette, for example , you need to make a logical guess as to what type of file it is. Protected view is an Excel security feature that aims to keep you safe.

It opens potentially risky Excel files in a specially limited Excel window. Excel automatically uses protected view when you download a spreadsheet from the Web or open it from your email inbox. Currently, this file is in protected view.

The most obvious danger is macro code : miniature programs stored in a spreadsheet file that perform Excel tasks. Poorly written or malicious macro code can tamper with your Excel settings, lock up the program, and even scramble your data. But before you panic, consider this: Excel macro viruses are very rare, and the. Instead, macro-containing files must be saved as.

The more subtle danger here is that crafty hackers could create corrupted Excel files that might exploit tiny security holes in the program. Once again, this sort of attack is extremely rare. It might not even be possible with the up-to-date. But protected view completely removes any chance of an attack, which helps corporate bigwigs sleep at night. The Open window harbors a few tricks.

To see these hidden secrets, first select the file you want to use by clicking it once, not twice , and then click the drop-down arrow on the right-side of the Open button. A menu with several options appears, as shown in Figure Why settle for the plain-vanilla Open command when you have all these choices? Open as Copy creates a copy of the spreadsheet in the same folder. If you named your file Book1. Open in Protected View prevents a potentially dangerous file from running any code.

If you try to open a corrupted file by just clicking Open, Excel warns you that the file has problems and refuses to open it. Depending on the type of problem, you might not lose any information at all.

As you open multiple spreadsheets, Excel creates a new window for each one. Although this helps keep your work separated, it can cause a bit of clutter and make it harder to track down the window you really want. Fortunately, Excel provides a few shortcuts that are indispensable when dealing with several spreadsheets at a time:. When you have multiple spreadsheets open at the same time, you can easily move from one to the other using the Switch Windows list.

One of the weirdest limitations in Excel occurs if you try to open more than one file with the same name. Sadly, the only solution is to open the files one at a time, or rename one of them. Adjust your starting point. When you open a file or save it for the first time, Excel starts you off in your personal documents folder. This is a Windows-specific folder that many programs assume you use for all your files. Keep track of more recent documents.

Why stick with 25 recent documents when you can show scores? Change the standard file type. Most Excel fans prefer the new. But if you decide that something else suits you better, like the binary. Get started with a bang. You can tell Excel to automatically open a whole group of spreadsheet files every time it starts up.

To find this setting, choose the Advanced section, and then scroll to the General group of settings. Then, the next time you start Excel, it automatically opens in separate windows every Excel file it finds.

Skip to main content. Start your free trial. Chapter 1. Creating Your First Spreadsheet. Starting a Workbook. Adding Information to a Worksheet. Note Obviously, once you go beyond 26 columns, you run out of letters. Adding Column Titles. Adding Data. Editing Data. Move to the cell you want to edit.

Use the mouse or the arrow keys to get to the correct cell. Complete your edit. Tip If you start typing new information into a cell and you decide you want to move to an earlier position in your entry to make an alteration, for instance , just press F2.

Editing Cells with the Formula Bar. Using the Ribbon. The Tabs of the Ribbon. Collapsing the Ribbon. Using the Ribbon with the Keyboard. Pick the ribbon tab you want. Choose a command in that tab. Tip You can go back one step in KeyTips mode by pressing Esc. The Quick Access Toolbar. Using the Status Bar. Table Signatures, Information Management Policy, and Permissions Displays information about the rights and restrictions of the current spreadsheet.

Caps Lock Indicates whether you have Caps Lock mode on. Num Lock Indicates whether Num Lock mode is on. Scroll Lock Indicates whether Scroll Lock mode is on.

Fixed Decimal Indicates when Fixed Decimal mode is on. Overtype Mode Indicates when you have Overwrite mode turned on. Macro Recording Macros are automated routines that perform some task in an Excel spreadsheet. Selection Mode Indicates the current Selection mode. Upload Status Does nothing that we know of.

Online Microsoft Excel Basic Course, Training and Certification – Recent articles

There’s also bascis online events, interactive content, certification prep materials, and more. Every Frwe grandmaster needs to start somewhere. Figure Excel fills most of the welcome page with templates, spreadsheet files preconfigured for a specific type of data. That happens later, when you save your frse Saving Files.

A worksheet is a grid of cells where you type in information and formulas. This grid takes up most of the Excel window. The largest part of the Excel window is the worksheet microsoft excel 2013 basics unit 1 free, where you type in your information. The grid divides your worksheet into rows and columns. Excel names columns using letters A, B, C…and labels rows using numbers 1, 2, 3…. The smallest unit in your worksheet is the cell.

Excel uniquely identifies excfl cell by column letter and row number. For example, C6 is the address of a cell in column C the third column and row 6 the sixth row.

Figure shows this cell, which looks like a rectangular box. Incidentally, an Excel cell can hold approximately 32, characters. A worksheet can span an eye-popping 16, columns and 1 million rows.

When you enter information, enter it one cell at a time. Init example, you can start by typing information into cell A40 without worrying about filling any data microsoft excel 2013 basics unit 1 free the cells that appear in the earlier rows. Obviously, once you go beyond 26 columns, microsoft excel 2013 basics unit 1 free run out of letters.

Excel handles ,icrosoft by doubling up and then tripling up letters. In uhit spreadsheet, the basiics cell is C6. You can recognize an active or current cell by its heavy black border. The best way to get a feel for Micrsooft is to dive right in and start putting together a worksheet. The following sections cover each step that goes microsoft excel 2013 basics unit 1 free excwl a simple worksheet. This one tracks household expenses, but you can use the same approach with baaics basic worksheet.

Excel /16148.txt you arrange information in whatever way you like. However, one of the most common and most useful ways to arrange information is in a table, with headings for each column. For example, in a worksheet that stores a mailing list, you could have two columns: one for names and another for addresses. But if you create more than two columns, your dxcel will probably be easier because you can separate first names from street addresses from ZIP codes, and microsoft excel 2013 basics unit 1 free on.

Figure shows the difference. Top: If you enter both first and last names in a single column, you can sort the column only by first name. And if you clump the addresses and ZIP codes together, you have no way to count the number of people in a certain town or microsoft excel 2013 basics unit 1 free. This arrangement also lets you filter out individual bits of information when you start using functions later in this book.

You can, of course, always add or remove columns. The first step in creating a worksheet is to add your headings in the row adobe photoshop extended dll free cells at the top of the sheet row 1.

Adding information is easy—just click the cell you want and start typing. Подробнее на этой странице you finish, hit Tab to complete your entry and move to the cell to microsodt right, or click Enter to head to the cell just underneath. Nothing stops you from microsoft excel 2013 basics unit 1 free numbers and text in random cells. For a simple expense worksheet designed to keep a record of your most prudent and extravagant purchases, try the following three headings:.

Date Basicss. Stores the date when you spent the money. Stores the name of the product that you bought. Records how much it cost. Right away, you face your first glitch: awkwardly crowded text. Figure shows how to adjust the column width for proper breathing room.

Top: The standard width of an Excel column is 8. First, position your mouse on the right border of the column header you want to expand so that the mouse pointer changes to the resize icon it looks like a double-headed arrow. Now drag the column border to the right as far as you want. As you drag, a tooltip appears, telling you the character size and pixel width of the column. Both of these pieces of information play the same role—they tell excell how wide the column is. Only the unit of measurement changes.

Bottom: When you release the mouse, Excel resizes the entire column of cells to the new width. Excel uses proportional fonts, in which different letters take up different amounts of room.

For по этому сообщению, the letter W is typically much wider than the letter I. You can now begin adding your data: Simply fill in knit rows under the column titles. Each row in the expense worksheet represents a separate purchase.

As Figure shows, the first column is for dates, the second stores text, основываясь на этих данных the third holds numbers. This rudimentary expense list has three items in it in rows 2, 3, and 4.

Uniit default, Excel aligns the excwl in a column according to their data type. It aligns numbers and dates on the right, and text on microsfot left. The next section explains how you can edit the data you just entered.

Every time you start typing in mucrosoft cell, Excel erases any existing content in that cell. You can also quickly remove the contents of a cell by moving microsoft excel 2013 basics unit 1 free the cell and pressing Delete, which clears its contents. If you want to edit cell data instead of replacing it, you need to put the cell in edit mode midrosoft, like this:. Put the cell in edit mode by pressing F2 or by double-clicking inside it.

Once you modify the cell content, press Enter to confirm your changes or Esc to cancel your edit and microsoft excel 2013 basics unit 1 free the old value in microsoft excel 2013 basics unit 1 free cell. Alternatively, you can click on another cell to accept the current value and go somewhere else. If you start typing new information into a cell and microsott decide you want to move to an earlier position in your entry to make an alteration, for instancejust press F2.

Press F2 again to return to data entry mode, where you can use the arrow keys to move to other cells. Figure illustrates the problem. Another option is to turn on text microsoft excel 2013 basics unit 1 free so you can fit multiple lines of text in a single cell, as described on Alignment and Orientation. Overlapping cells can create big headaches. The rest is hidden from view. Just above the worksheet grid but under the ribbon is an indispensable editing tool called the formula bar Figure The formula bar just above the grid displays information about the active cell.

In this example, you can see that the current cell is B4 and it contains the number Instead of editing this value in the cell, you can click anywhere in the formula bar and make your changes there. You can use the formula bar to enter and edit data instead of editing directly in your worksheet. This is particularly useful when a cell contains a formula or a large amount of information.

Just microssoft with in-cell edits, you press Enter to confirm formula bar edits or Esc to cancel them. Ordinarily, the formula bar is a single line. To enlarge the formula bar, click the bottom edge and pull down. You can make it two, three, four, or many more lines large. Most people like to identify columns with letters and rows with numbers. This system makes it easy to tell the difference between the two, and it lets you use short cell addresses like A10, B4, and H When microsogt first install Excel, it uses this style of cell addressing.

However, Excel lets you use another cell addressing system called R1C1. In R1C1 style, Excel identifies both rows and columns with numbers. The letters R and C tell you mmicrosoft part of the address represents the row number and which part is the column number. The R1C1 format reverses the order of conventional cell addressing. With normal microsoft excel 2013 basics unit 1 free addressing, Excel runs out of letters after column 26, and it starts using two-letter column names as in Microosoft, AB, and увидеть больше on.

But this fee can get awkward. On the other hand, the R1C1 address for the same cell—R1C50—gives you a clearer idea of where to find the cell. This shows the Excel Options window, where you can change a wide array of settings. In the list on the left, choose Formulas to hone in microdoft the section you need. Fortunately, /47676.txt can change cell addressing at any time using the Excel Options window.

Basicss focal point of the Excel window hasics the worksheet grid. This is cle dactivation parallels desktop 10 gratuit free ribbonand it ensures that even the geekiest Excel features are only a click or two away.

To accommodate all these buttons without becoming an over-stuffed turkey, the ribbon uses tabs.