Exceed expectations 2002… More Nuts and bolts.

Uploaded on:
Category: General / Misc
Exceed expectations 2002… More Essentials Make a Basic Exercise manual This lesson will cover: What is an Exercise manual? Instructions to… Open an Exercise manual Select a Worksheet Move around the Worksheet Store Information in a Cell Utilize the Fix and Re-try Charges Make Straightforward Computations Use AutoFill
Slide 1

Exceed expectations 2002…More Basics Introduction to Excel 2002

Slide 2

Create a Simple Workbook This lesson will cover: What is a Workbook? How to… Open a Workbook Select a Worksheet Move around the Worksheet Store Data in a Cell Use the Undo and Redo Commands Create Simple Calculations Use AutoFill Use the Office Clipboard Use Smart Tags Save and Close a Workbook These subjects are from Chapter 2 of the content... Prologue to Excel 2002

Slide 3

What will be what? Exceed expectations stores information in documents which are called “Workbooks”: Workbooks are comprised of Worksheets are comprised of Columns and Rows The fundamental unit of a Workbook (or spreadsheet) is a Cell Excel exercise manual records have the augmentation .xls The most extreme number of worksheets an exercise manual can have is just limited by the measure of accessible memory The greatest worksheet size is 65,536 lines by 256 sections Objects ,, for example, outlines, pictures or drawings exist on top of the phones, not in them. These ideas are fundamental to understanding and utilizing Excel… Introduction to Excel 2002

Slide 4

Many components of Excel can be tweaked to suit your needs. To change the system choices select Tools > Options For instance, you can change the default number of worksheets that are naturally made here…among other things… Introduction to Excel 2002

Slide 5

Opening a Workbook As is common with most Windows based projects, there are a few approaches to do things with Excel… To open a current exercise manual: Open the File menu Select Open Select the document from the “Open” window’s posting, or search to discover the one you need …or Use the easy route keys… Ctrl+O to show the Open window Select the record from the rundown Introduction to Excel 2002

Slide 6

First select Open from the File menu…or utilize the Crtl+O alternate way. You could likewise choose from the “Most Recently Used” (MRU) list, if the document you need to open is recorded there... Prologue to Excel 2002

Slide 7

Clicking the Open charge will show the “Open” dialog box…from the rundown select a worksheet document. Exceed expectations worksheet records end with the XLS expansion. You can likewise scan to discover a record. These records are situated on a floppy circle. Prologue to Excel 2002

Slide 8

Many times when you select to open a record there will be a notice like this one. It just implies that there is a touch of programming code appended to the record, and cautions you about it. In the event that the document originated from a “trusted” source, select Enable Macros . On the off chance that it didn’t originate from a trusted source, tap the Disable Macros catch and the document will open without running any code. Prologue to Excel 2002

Slide 9

Once you navigate the Macro cautioning, the record will be displayed… recall that, you won\'t generally see the notice indicated on the past slide . Numerous exercise manuals will open right from the Open dialog box . Prologue to Excel 2002

Slide 10

Excel can likewise open numerous different sorts of documents and believer them to the Excel exercise manual format…file sorts, for example, HTML , XML , TXT and CSV are all bolstered, and Excel will even open numerous records made by other spreadsheet programming or databases, similar to Lotus 1-2-3 , Quattro Pro, Microsoft Access and dBase . Prologue to Excel 2002

Slide 11

Selecting a Worksheet To choose a worksheet basically tap on the sheet’s tab situated on the Sheet Bar . The Sheet Bar is situated at the window\'s base over the Status Bar . When you tap on a tab it moves to the bunch\'s front of tabs. The tab looking over catches permit looking through tabs not noticeable on the bar, or from a pop-up menu. Prologue to Excel 2002

Slide 12

You can travel through the worksheets in the open exercise manual by utilizing the sheet tabs , or the tab looking over catches.. . tab looking over catches sheet tabs Introduction to Excel 2002

Slide 13

Right-tapping on the tab looking over catches will show a pop-up menu demonstrating all the accessible tabs. Notice the “Wellcome” tab is chosen, it is the “active” sheet. It is spelled wrong on purpose… Introduction to Excel 2002

Slide 14

Moving Around a Worksheet Moving about the lines and segments in Excel should be possible with both a mouse and a console. Standard Windows alternate way keys, for example, Ctrl+X for Cut or Ctrl+C for Copy work with Excel. Route keys you can utilize are: Arrows keys move up , down , left and right one cell Tab move left one cell Shift+Tab move right one cell Page Up or Page Down move up or down one window Home move to the start of a line Ctrl+Home move to cell A1 Ctrl+ End move to the last cell in a worksheet Introduction to Excel 2002

Slide 15

Putting Data in its Place… Literal information is a particular arrangement of information like 255 or 01/01/2002 it doesn\'t change unless you do it physically. Exceed expectations stores such information by essentially entering it into an Active cell. To initiate a cell and enter information: Activate the cell by tapping on it or utilizing the console to move to it Type the information Press the Enter key or get off the cell…such as utilizing the Tab or Arrow keys Introduction to Excel 2002

Slide 16

Whether you “type” the information in the recipe bar or in the cell, it shows up in both, however is really put away in an area that Excel knows as the cell’s address… for this situation it would be C5. Prologue to Excel 2002

Slide 17

Some information sorts are organized a sure route by default…so entering something like “December 7, 1941” will change to… Introduction to Excel 2002

Slide 18

…“7-Dec-41” when you get off of the phone. This can be changed as you will learn later. Be that as it may, be mindful the worth is still the same, just the way Excel is showing the information is different…it could likewise be “12-7-1941”, or “12/7/1941” relying upon your decision of arrangement. Prologue to Excel 2002

Slide 19

Basic Data Types… Excel utilizes 3 fundamental sorts of information: Numeric qualities – Number sort information can incorporate any number blended with the accompanying characters + - ( ) ,/$ % . E . On the off chance that you attempt to enter a number that is to huge for a cell, Excel will show an arrangement of number signs ( ########## ) in the cell. Content – Excel utilizes message principally for marks. In any case, you can likewise utilize numbers as content. A cell characterized as holding printed information can have up to 32,767 characters in it (just 1024 are shown). Putting away numbers as content keeps them from being utilized as numbers as a part of calculations…they are viewed as alphanumeric content. Recipes – Formulas are directions to Excel to perform some kind of operation and return the outcome in the cell. Recipes are entered by first entering an equivalent sign ( = ) took after by the equation. Exceed expectations as a rule believes that anything went before by an equivalent sign is an equation. Prologue to Excel 2002

Slide 20

Everything put away in a cell is a number…here you perceive how changing the cell\'s organizing changes the qualities which are displayed…each cell on the left contains the numbers 1234. Prologue to Excel 2002

Slide 21

Right-tapping on a cell will show a pop-up menu. From that point you can choose the Format Cells order to open a dialog box giving you numerous approaches to change how your information is displayed… however this is another topic…for one more day. Prologue to Excel 2002

Slide 22

Undoing and Redoing… Excel stores the 16 latest operations in memory so it can recover and right your errors. These activities are known as the Undo and Redo charges. On the off chance that you choose you truly didn’t need to erase a quality in a cell, or a text style designing change to a mark you can choose the Undo summon from either the toolbar or the Edit menu. In the event that you then conclude that you loved it the way it was before select Redo. Utilizing these orders you can step you\'re path back to a given express that your worksheet was in, the length of you stay inside of the 16 latest activities. Anything past that is gone until the end of time. Prologue to Excel 2002

Slide 23

Undo and Redo as they show up on the Standard toolbar… Undo and Redo as they MIGHT show up on the Edit menu…the alternate way keys are to one side of the menu summons. Prologue to Excel 2002

Slide 24

Working with Formulas… Calculations set in a phone are called equations in Excel. Equations start with an equivalent sign ( = ) so Excel realizes that you aren’t entering basic information. Recipes are built of numbers, cell references (or cell names) and administrators ,, for example, < > + -/* A straightforward equation may resemble: = (B3*H6)- D6 More mind boggling recipes may incorporate capacities , which are predefined counts that Excel offers to spare time A more perplexing equation may resemble: = AVE(B3:B16) * H6 This equation utilizes the AVErage capacity, which gives back the normal of an arrangement of numbers. Prologue to Excel 2002

Slide 25

Working with Formulas… Calculation Operators: + addition A1 + B2 A1 in addition to B2 - subtraction A1 - B2 A1 less B2/ division A1/B2 A1 separated by B2 * multiplication A1 * B2 A1 times B2 % percent A1 * 10% A1 times 10 percent ^ Exponentiation A1 ^ 3 A1 to the 3 rd power Introduction to Excel 2002

Slide 26

Working with Formulas… Comparison Operators: = Equal to > Greater than < Less than >= Greater than or Equal to <= Less than or Equal to <> NOT Equal to Introduction to Excel 2002

Slide 27

Working with Formulas… Calculations

View more...