excel 2003 training manual
File Name:excel 2003 training manual.pdf
Size: 4677 KB
Type: PDF, ePub, eBook
Uploaded: 13 May 2019, 18:52 PM
Rating: 4.6/5 from 642 votes.
Last checked: 1 Minutes ago!
In order to read or download excel 2003 training manual ebook, you need to create a FREE account.
eBook includes PDF, ePub and Kindle version
excel 2003 training manualDiscover everything Scribd has to offer, including books and audiobooks from major publishers. Start Free Trial Cancel anytime. Report this Document Download Now Save Save Microsoft Excel 2003 Training Manual, Excel 2003 T. For Later 0 ratings 0 found this document useful (0 votes) 284 views 3 pages Microsoft Excel 2003 Training Manual, Excel 2003 Tutorial Uploaded by govindagarg Description: Full description Save Save Microsoft Excel 2003 Training Manual, Excel 2003 T. For Later 0 0 found this document useful, Mark this document as useful 0 0 found this document not useful, Mark this document as not useful Embed Share Print Download Now Jump to Page You are on page 1 of 3 Search inside document Browse Books Site Directory Site Language: English Change Language English Change Language. You do not have to register for expensive classes and travel from one part of town to another to take classes. All you need to do is download the course and open the PDF file. This specific program is classified in the Excel category where you can find some other similar courses.An introduction to Excel 2003.But also many other tutorials are accessibleYou should come see our Excel documents. You will find your happiness without trouble. The latest newsThe best course and tutorial, and how to learn and use An introduction to Excel 2003. Microsoft released the firstWindows two years later. By 1993, Excel had morphed into anExcel’s core features were completed six or sevenThe answer,In a typical usability test, MicrosoftThe best way to avoid potential headaches like these is to take aAlong the way, you’llIt’s where you’ll perform all yourNote Part of getting to know Excel is figuring out where to go when youFigure 1-2 shows this cell, which looks like aFor example, youNote There is definitely, absolutely no way around the 256 column andYou can recognize the current (or active) cell based on its heavy black border.http://flatfeecanada.com/userfiles/ecler-pam-2000-manual.xml
- excel 2003 training manual, excel 2013 training manual pdf, excel 2003 training manual pdf, excel 2003 training manual transmission, excel 2003 training manual training, excel 2003 training manual template.
You’ll also notice that the corresponding column letter (C) and row number (6) are highlighted at the edges of the worksheet. Just above the worksheet, on the left side of the window, the formula bar tells you the active cell address. The best way to get a feel for Excel is to dive right in and startThe following sections cover each stepThis one tracksIf you’ve already got Excel open and you want toTo finish the job, you needThe New. Workbook task gives you a few other options that allow you to createYou’ll learn about using (and making) templates inAdding the Column Titles The most straightforward way to create aIt’s important to remember that even for theFor example, in a worksheet that stores a mailing list, youBut if you create more than two columns, yourFigure 1-3 shows the difference. Figure 1-3. And if you clump the addresses and Zip Codes together, you give Excel no way to count how many people live in a certain town or neighborhood because Excel can’t extract the Zip Codes on its own. Bottom: The benefit of a six-column table is significant: it lets you sort (reorganize) your list according to people’s last names or where they live. It also allows you to filter out individual bits of information when you start using functions later in this book. You can, of course, always add or remove columns later. But you canThe first step in creating your worksheet is to add yourTechnically, you don’t needRight away, you face your first glitch: awkwardly crowded text. Figure 1-4 shows how you can adjustTo solve this problem, 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.http://www.expert-geo.pl/userfiles/ecler-pam-4100-manual.xml Both of these pieces of information play the same role—they tell you how wide the column is—only the unit of measurement changes. Bottom: When you release the mouse, the entire column of cells is resized to the new size. Note A column’s character width doesn’tFor example the letter W is typically muchExcel shows you isn’t a real indication of how manyAdding Data You can now begin adding your data: simply fill in the rows under theSo what version is ExcelExcel Version 11. But even this version number doesn’t mean what you might expect. Excel 11 isWindows platform. The first version of Excel was a Macintosh-onlyWindows 95 was so great that they were entitled to jump up twoKeep in mind that Excel doesn’t impose any rules onPrice column. But if you don’t keep a consistentThe alignment of each column reflects the data type (by default, numbers and dates are right-aligned, while text is left-aligned), confirming that Excel understands your date and price information. That’s it. You’ve created a living,Enter to commit your change or Esc to cancel your edit and leave theAlternatively, you can turn off edit modeAs long as you stay in edit mode, Excel won’t letTip If you start typing new information into a cell, and you decide youThe cell box still looksYou can press F2 again to return to theAs you enter data, you may discover the Bigtime Excel Display ProblemChapter 2 tacklesChapter 4 shows you how to wrap multiple lines ofFor example, if you type a large amount of text into A1, and then you type some text into B1, you’ll only see part of the data in A1 on your worksheet (as shown here). The rest is truncated. But if, say, A3 contains a large amount of text and B3 is empty, the content in A3 is displayed over both columns, and you don’t have a problem. Navigating in Excel Learning how to move around the Excel grid quickly andTo move fromAs you move from cell to cell, you’ll see the blackIn some cases, you might want to cover ground a little more quickly.http://www.raumboerse-luzern.ch/mieten/d90-camera-manual You can use any of the shortcut keys listed in Table 1-1. The most useful shortcut keys include the. Home key combinations, which bring you back to the beginning of a rowOther key combinations work in sequence. For example, the keyEnd, and then press Home. POWER USERS’ CLINIC: Using R1C1 Reference Style Most people like to identify columns with letters and rows withThat means the cell address A10 becomes. R10C1 (read this as Row 10, Column 1). The letters R and C tell youThe order is reversed from conventional cell addressing. R1C1 addressing isn’t all that common. But itThis approach can becomeR1C50, gives you a clearer idea of where to find the cell.Fortunately, you can change cell addressing at any time using the. Options window. Table 1-1. Shortcut Keys for Moving Around a Worksheet Thus, if the grid shows 10 cells at a time, this key moves to a cellThis cell is at theEdge If there aren’tFor example, imagine you haveTip You can also scroll off into the nether regions of the spreadsheetExcel shows you automatically. The idea behind the simplified menu isTo its credit, Excel goes one stepExcel calls this aThis innovation is often more trouble than it’s worth, however, because it’s hard to remember how a menu is organized when it’s constantly changing. Right: This version lists all available options. If you can’t find an item you’reSimply click the expand icon at theExcel’s personalized menus can send you right overOptions tab. Turn on “Always show fullOffice programs. Thus, you’re turning them off inOutlook. GEM IN THE ROUGH: Getting Somewhere in a Hurry If you’re fortunate enough to know exactly where youIt comes in useful inThat’s because the Go To window maintains a list ofIn addition, every time you open the Go To window, ExcelThis feature makesYou’ll notice that in the list, cell addresses areExcel uses for fixed cell references. (You’ll learnIt provides information and controls to let you accomplish a specificThe task pane is a genuine improvementInstead of forcingIt also allows youUnfortunately, the Task Pane only lets you perform a limited numberExcel’s menus and toolbars. Still,Figure 1-8 shows the list of possible tasks. Tip The Task Pane window often usesTo find out if aYou can switch to any of 10 other tasks by clicking the drop-down arrow in the window title and choosing the task from the list. The current task is identified with a checkmark. You can close the Task Pane window at any time by clicking theIn Excel 2003, you can use the followingStarted. Microsoft’s Office Web siteExcel” to open up your Internet browser with a listYou can alsoExcel help files. If your computer is connected to the Internet, thisExcel documentation, where it retrieves the latest relevantResults. Both of theseOnce Excel hasEXCEL 2002 CORNER: The Changing Face of the Task Pane The Task Pane is one of the more changeable ingredients in Excel. IfWorkbook. It’s similarClipboard task and allows you to store several scraps of informationOddly enough, Excel 2003Clip Art task and allows you to hunt for useful images on yourSo what about the missing tasks. A few of them—includingSource—correspond to features that Excel 2002For example, ExcelFor example, if youAfter a short delay, a series of thumbnails appears. You can thenThis search canBest of all, you perform the searchYou can examine these piecesFor more information,You’ll learn more about creating and saving newTemplates are covered inWindows 2003 Server). Chapter 21 covers ExcelYou’ll learn all about XML and the future of OfficeNote Occasionally, you’ll come across tasks youFor example, why not use a task for printing a document andOr how about a task for formatting cellMicrosoft has decided to use the Task Pane to focus on new features. Though the company admits the Task Pane is a great time-saver, theyThe Toolbars Excel, like any self-respecting Windows program, is filled withYou can think of toolbars as a lighter version of the Task PaneAlso like the Task Pane, toolbars stay out ofBut unlike the Task Pane, toolbarsYou can hover over aUnfortunately, this text probably won’t tell you what you need to know if you’re trying to learn about a feature you’ve never used before. To see a menu that lists all the available ExcelThe toolbars that have a checkmark next to their name are the onesYou can use this list to show newTip Resist the urge to display all the toolbars at the same time, orExcel provides a grand total of 19 toolbars (not including the Task. Pane, which is really a completely different type of window). InExcel toolbars to your computer. For example, if you install the fullExcel alwaysNote To make life a little easier, Excel opens some toolbars automaticallyBoth of these toolbars use a standard arrangement of buttons that isToolbars and select them by clicking on their name in the menu. Excel provides a wealth of toolbars. In this picture, only two toolbars are currently displayed: the all-important Standard and Formatting toolbars. Or, just right-click anywhere on one of the currently displayed toolbars, as shown here. Moving toolbars You can dragTo move a toolbar, follow these three steps: For example, you can drag toolbars above the menu or to the left or right side of the window, in which case they change from a horizontal row of buttons to a vertical column of buttons. You can even drag a toolbar away from the window’s edge so that it becomes a standalone floating window, like this Picture toolbar. You can resize floating windows in the same way you resize any other window. Toolbars remember their last position. Thus, if you move a toolbarToolbars with missing buttons Depending on the width of your window and the arrangement of yourYou can tellFigure 1-12 shows the tell-tale sign and the trick forToolbar tricks When you click the arrow on the right edge of aExcel shows you not only any hidden buttons, but a couple of toolbarOne Row” to put all the buttons from the StandardYou can reach these missing buttons by clicking the right side of the toolbar, which opens a menu with the rest of the buttons. Note If you’ve chosen “Show Buttons on. One Row,” the menu item changes toThis approach is particularlyJust as with in-cell edits, formula barFormula Bar. But it’s such a basic part of ExcelInstead, keep it aroundFigure 1-13. The Formula bar (just above the grid) shows information about the active cell. In this example, the Formula bar shows that the current cell is B4 and that it contains the number 592. Instead of editing this value in the worksheet, you can click in the Formula bar and make your changes there. The Status Bar Though people often overlook it, the Status bar ( Figure 1-14 ) is a good way to keep on top of. Excel’s current state. For example, if you save orBut if you’re performing a time-consumingAs discussed in Quick Ways to Add Data, you can place a cell in edit mode or take itIn addition, the compartments at the rightmost side of the Status barFigure 1-14. The Status bar is an always available (but often overlooked) part of the Excel window. In it, you can see the basic status text (which just says “Ready” in this example) and several compartments on the right that display various indicators when they’re active (like “CAPS” and “SCRL” in this example). Table 1-2. Status Bar Indicators To turn this feature on or off, hit the. Caps Lock key. When this sign is off, theTo turn this featureFor example, hit. End and then Home to move to the bottom right cell in your worksheet. See Table 1-1 for a list of key combinations, someExtended mode is a useful keyboardYou’ll learnFor example, if you set. Excel to use two You’ll learn more about how to format numeric cellsExcel is no exception. YouYou can use Save As theThe Save As dialog box lets you jump to common folders, or you can browse a folder tree using the drop-down “Save in” menu.Save As: Excel prompts you to choose a folder and file name. To useAirlineSilverware.xls). As hard-core Excel programming gurus know,Binary Interchange File Format). This is the format used by ExcelThe codename is useful toFor example, Excel 95 uses the incompatible BIFF7 file format, whichExcel 97 can still open Excel 2000 workbooks that contain pivotThe good news is that if you need to exchange spreadsheet files withExcel allowsFigure 1-16 Tip When you save your Excel spreadsheet in another format, make sure youAirlines), or if you’re about to expose systematicIt allows you toYou’ll learn more about these features in Chapter 24 and Chapter 23, respectively. Excel actually has two layers of password protection that you canThis level ofYou can let others read a spreadsheet, but you can prevent them fromApplying them is easy. Just follow these steps: Then click OK. Passwords are case-sensitive (which means that PanAm is different from panam), and they are masked (which means that all that appears in the window as you type is a series of asterisks). POWER USERS’ CLINIC: Is Your Encryption Strong Enough. With Excel’s normal level ofExcel earlier than Excel XP. And if you lose your password, your dataThe payoff, however, is near-bulletproofMicrosoft Base Cryptographic Provider v1.0.” You canFor best results, combine strongIf you use a password to restrict people from modifying theBottom: If you assign a “password to modify,” you’ll see the choices in this window. If you use both passwords, you’ll see both windows, one after the other. Disaster Recovery The corollary to the edict “Save your data early andMake sure thatExcel to save backup files (the standard folder works fine for mostUnfortunately,You can also adjust theThere’s really no danger in being too frequent. 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 the document every five minutes with no appreciable slowdown. If your computer does crash, when you get it running again, you canIn fact, once youIf you attempt to open a backup file that’s somehowExcel automatically attempts to repair it. You can choose Show Repairs to display a list of anyThe only difference is that. Excel gives you two different ways to get to the standard Open dialog. Use the Task Pane ( Section 1.3.2 ). In Excel 2003,Excel 2002, look under the “Open aNote If the Task Pane is not currently visible, you can always choose View. Both of these methods bring up the Open dialog box. Using this dialogExcel can open many file types other than its native.xls format. ToFigure 1-20. If it finds a backup, that means a document was not properly saved the last time you exited from Excel. In this situation, you don’t need to worry since you haven’t lost any data.) Bottom: You can save or open an AutoRecover backup like an ordinary Excel file; simply click the item in the list. Once you’ve dealt with all of the backup files, close the Document Recovery window by clicking the Close button. Note Depending on your computer settings, Windows might hide fileWindows recognizes that the file is an Excel spreadsheet. If you seeWhen you open a file or save a file for the first time, Excel startsThis is a Windows-specific folderTo do so, select Tools. You can modify the “Default fileFiles ). Sadly, you can’t browse and pickTo see these hidden secrets, firstOpen button. A menu with several additional options appears, as shownRead-Only If your file is named Book1.xls,However, youOpen as Copy. (Of course, this technique only works when you haveOnce you save theBrowser HTML file. This option allows you to open a spreadsheet for viewingExplorer), which is something you’ll only want toRepair Of course, if you decide to useOnce As you open multipleIf you’re using Windows XP, you’llFor example, shortly after you open three. Excel files, you might find them in one task bar button (see Figure 1-21, bottom). Figure 1-21. Bottom: In Windows XP, similar taskbar buttons sometimes get bunched into groups. You can tell that a button contains a group of files when a drop-down arrow appears on the right side of the button, and a number appears on the left side. The number indicates how many buttons Windows has grouped together. Automatic taskbar bunching does save screen space, but it also makesYou now need two mouse clicks instead of one—the first to clickIn the Taskbar and Start Menu Properties dialog box that appears,The taskbar, though convenient, isn’t perfect. OneAnd the struggle to find an open file becomes dire if your taskbar isExcel’s Window menu, which lists the full file nameFigure 1-22. When you have multiple spreadsheets open at the same time, you can easily move from one to the other using the Window menu in Excel. The Window menu has the advantage of always showing the full file name. When you have multiple spreadsheets open at the same time, you needHere are your choices: To do so, you need to close the Excel window. Select FileTo do so, right-click the spreadsheet on the taskbar, and click. Close. Or, switch to the spreadsheet you want to close (by clickingNo matter what steps you take,Sadly, the only solution isWindows includes tools for searching your hard drive, but theyUsing it, you can huntFile Search. In Excel 2002, click the drop-down arrow in the Task. Pane, and choose the Search task. For example, you couldBear in mind that theIn addition, you can use theFor example, a searchFor example,For example, if you tryExpand the appropriateIn general, a good place to search is the My. Documents folder (under My Computer), which is a standard place toLost. Figure 1-23. In this example, the file search will examine the root directory of drive C: (note the ordinary checkmark), but it won’t look in any subdirectories. On the other hand, it will search the My Document folder (note the checkmark with multiple boxes) and all contained subdirectories. Right: The file type list is more straightforward. This search will only find Excel files. Excel gives you two ways to select a folder. Click once to place aThis sign indicates that the searchClick twice to place a checkmark withThis icon indicates that the searchIf you expand the folder, you can see thatUsually, Excel automatically includes Web pages and common OfficeIn most cases, however,If Excel finds no results, theFound.” Figure 1-24. Right: When you click Go, the Search Results pane appears. In this example, Excel has found two documents so far, and the search is still in progress. Note You can click Stop at any time to abort the current search. To changeSimply click the file once. If yourFor example, if you click a WordIf your search turns up a large number of results, ExcelInstead, it includesResults task window, just hover over it with the mouse. A tooltipPOWER USERS’ CLINIC: Advanced Searching Excel provides an To use it, open the Basic Files Search task window (choose FileTo specify detailed search conditions, choose a Property (the pieceFor example, to findValue. Finally, click Add to include your condition in the list ofAn index is a catalog of all the files on yourWhen you searchThis speeds up the wholeThis service can be set to runTo turn on the. Indexing Service, open the Basic File Search task window, click the. Search Options link, and then choose “Yes, enable. Indexing Service”. Of course, all good things comeInstead of opening the file, you can choose to copy the file path toTo open a menu with these. If you are using Excel 2007, click here for our Excel 2007 tutorial. You can use it to organize your data into rows and columns. You can also use it to perform mathematical calculations quickly. This tutorial teaches Microsoft Excel basics. Although knowledge ofThis lesson will introduce you to the Excel window. You use the window to interact with Excel. A major strength of Excel is that you can perform mathematical calculations and format your data. In this lesson, you learn how to performMicrosoft Excel has many functions you can use. T his lesson teaches you how to use functions and how to print. This lesson teaches you how to create a chart in Excel. Microsoft Excel is a spreadsheet program that is used to record and analyse numerical data. Think of a spreadsheet as a collection of columns and rows that form a table. Alphabetical letters are usually assigned to columns and numbers are usually assigned to rows. The point where a column and a row meet is called a cell. The address of a cell is given by the letter representing the column and the number representing a row. Let's illustrate this using the following image. Why Should I Learn Microsoft Excel. We all deal with numbers in one way or the other. We all have daily expenses which we pay for from the monthly income that we earn. For one to spend wisely, they will need to know their income vs.Where can I get Microsoft Excel. There are number of ways in which you can get Microsoft Excel. You can buy it from a hardware computer shop that also sells software. Microsoft Excel is part of the Microsoft Office suite of programs. Alternatively, you can download it from the Microsoft website but you will have to buy the license key. In this tutorial, we are going to cover the following topics. How to Open Microsoft Excel. Understanding the Ribbon Understanding the worksheet Customization Microsoft Excel Environment Important Excel shortcuts How to Open Microsoft Excel. Running Excel is not different from running any other Windows program. If you are running Windows with a GUI like (Windows XP, Vista, and 7) follow the following steps. Click on start menu Point to all programs Point to Microsoft Excel Click on Microsoft Excel Alternatively, you can also open it from the start menu if it has been added there. You can also open it from the desktop shortcut if you have created one. For this tutorial, we will be working with Windows 8.1 and Microsoft Excel 2013. Follow the following steps to run Excel on Windows 8.1 Click on start menu Search for Excel N.B. even before you even typing, all programs starting with what you have typed will be listed. Click on Microsoft Excel The following image shows you how to do this Understanding the Ribbon The ribbon provides shortcuts to commands in Excel. A command is an action that the user performs. An example of a command is creating a new document, printing a documenting, etc. The image below shows the ribbon used in Excel 2013. Ribbon components explained Ribbon start button - it is used to access commands i.e. creating new documents, saving existing work, printing, accessing the options for customizing Excel, etc. The home tab is used for basic commands such as formatting the data to make it more presentable, sorting and finding specific data within the spreadsheet. As an example, the Alignment ribbon bar is used to group all the commands that are used to align data together. Understanding the worksheet (Rows and Columns, Sheets, Workbooks) A worksheet is a collection of rows and columns. When a row and a column meet, they form a cell. Cells are used to record data. Each cell is uniquely identified using a cell address. Columns are usually labelled with letters while rows are usually numbers. A workbook is a collection of worksheets. By default, a workbook has three cells in Excel. You can delete or add more sheets to suit your requirements. By default, the sheets are named Sheet1, Sheet2 and so on and so forth. You can rename the sheet names to more meaningful names i.e. Daily Expenses, Monthly Budget, etc. Customization Microsoft Excel Environment Personally I like the black colour, so my excel theme looks blackish. Your favourite colour could be blue, and you too can make your theme colour look blue-like. If you are not a programmer, you may not want to include ribbon tabs i.e. developer. All this is made possible via customizations. In this sub-section, we are going to look at; Customization the ribbon Setting the colour theme Settings for formulas Proofing settings Save settings Customization of ribbon The above image shows the default ribbon in Excel 2013. Let's start with customization the ribbon, suppose you do not wish to see some of the tabs on the ribbon, or you would like to add some tabs that are missing such as the developer tab. You can use the options window to achieve this. Click on the ribbon start button Select options from the drop down menu. You should be able to see an Excel Options dialog window Select the customize ribbon option from the left-hand side panel as shown below On your right-hand side, remove the check marks from the tabs that you do not wish to see on the ribbon. For this example, we have removed Page Layout, Review, and View tab. Your ribbon will look as follows Adding custom tabs to the ribbon You can also add your own tab, give it a custom name and assign commands to it. Let's add a tab to the ribbon with the text Guru99 Right click on the ribbon and select Customize the Ribbon. The dialogue window shown above will appear Click on new tab button as illustrated in the animated image below Select the newly created tab Click on Rename button Give it a name of Guru99 Select the New Group (Custom) under Guru99 tab as shown in the image below Click on Rename button and give it a name of My Commands Let's now add commands to my ribbon bar The commands are listed on the middle panel Select All chart types command and click on Add button Click on OK Your ribbon will look as follows Setting the colour theme To set the color-theme for your Excel sheet you have to go to Excel ribbon, and click on a File aOption command. It will open a window where you have to follow the following steps. The general tab on the left-hand panel will be selected by default. Look for colour scheme under General options for working with Excel Click on the colour scheme drop-down list and select the desired colour Click on OK button Settings for formulas This option allows you to define how Excel behaves when you are working with formulas. You can use it to set options i.e. autocomplete when entering formulas, change the cell referencing style and use numbers for both columns and rows and other options. If you want to activate an option, click on its check box. If you want to deactivate an option, remove the mark from the checkbox. You can this option from the Options dialogue window under formulas tab from the left-hand side panel Proofing settings This option manipulates the entered text entered into excel. It allows setting options such as the dictionary language that should be used when checking for wrong spellings, suggestions from the dictionary, etc. You can this option from the options dialogue window under the proofing tab from the left-hand side panel Save settings This option allows you to define the default file format when saving files, enable auto recovery in case your computer goes off before you could save your work, etc.