By Joe Habraken
This 10 Minute consultant specializes in the main frequently used gains, overlaying them in classes designed to take 10 mins or much less to accomplish. furthermore, this advisor teaches the consumer easy methods to use Excel with out counting on technical jargon. It presents common, easy-to-follow motives and lists of numbered steps that inform the person which strategies to pick.
Read Online or Download 10 Minute Guide to Microsoft Excel 2002 PDF
Best microsoft books
Written for business-minded and skilled workplace clients, this task-oriented consultant is going on to the base line, revealing optimum how one can practice serious, not easy projects. After fifteen years of educating humans how one can be extra effective with place of work, Courter and Marquis understand clients' FAQs and comprehend how you use Office-as an built-in suite instead of as a suite of separate functions.
The outdated "80/20" rule for software program - that eighty percentage of clients use purely 20 percentage of a program's gains - does not observe to Microsoft Excel. in its place, this software operates lower than what might be referred to as the "95/5" rule: ninety five percentage of Excel clients use a trifling five percentage of the program's good points. so much of these clients be aware of that they can be getting extra out of Excel through the use of extra of its instructions and suggestions, yet are usually not yes the place to begin.
This entire ebook prepares you for Microsoft's new certification, MCTS: Microsoft alternate Server 2007. examination 70-236 serves as either the one examination requirement for reaching the MCTS designation in addition to the access examination for the MCITP certification for alternate Server 2007. inside of, you can find the sensible and in-depth guideline you wish, together with complete insurance of all examination goals, functional hands-on routines, real-world situations, tough assessment questions, and extra.
Additional resources for 10 Minute Guide to Microsoft Excel 2002
Excel converts the date into a number that reflects the number of days that have elapsed since January 1, 1900. Even though you won't see this number (Excel displays your entry as a normal date), the number is used whenever you use this date in a calculation. Times also are considered values. m. Page 27 Follow these steps to enter a date or time: 1. Click in the cell where you want to enter a date or a time. 2. To enter a date, use the format MM/DD/YY or the format MM-DD-YY, as in 5/9/01 or 5-9-01.
Page 30 ENTERING A CUSTOM SERIES If you want to create a series such as 10, 20, 30, where the series uses a custom increment between the values, you need to create a custom series. Excel provides two ways to create a custom series. To create a custom series using Fill, follow these steps: 1. Enter the first value of the series into a cell. 2. Enter the second value in the series into the next cell. For example, you might enter 10 into the first cell and then 20 into the second cell. This lets Excel know that the increment for the series is 10.
2. Click the Spreadsheet Solutions tab on the Templates dialog box. 3). 3 The Spreadsheet Solutions tab provides the different Excel templates. 3. Select a template by clicking its icon, and then click OK or press Enter. A new workbook opens onscreen with a default name based on the template you chose. 4. 4 A new workbook based on a template provides a basic layout for a particular business form. SAVING AND NAMING A WORKBOOK Whether you build your workbook from a blank template or use one of the Excel templates, after you enter some data into the workbook, you should save the file (you learn about data entry in Lesson 3, ''Entering Data into the Worksheet").