Essay on Tutorial: Microsoft Excel and Sample Excel Spreadsheets

Submitted By sst1qgd
Words: 1377
Pages: 6
Open Document
direction headings are in yellow, and these are followed by detailed directions in red. Additional comments about the directions appear in blue. Then there are “Try it!” exercises in green. These “Try it!” exercises are a key feature of this tutorial. I have embedded numerous sample Excel spreadsheets so that you can try out the directions right away—without switching into Excel. When you double-click on one of these spreadsheets, you launch Excel, and the spreadsheet “comes alive.” The menus and toolbars even change to those for Excel. By clicking outside one of these spreadsheets, you’re back in Word.
The easiest way to maneuver around this tutorial is to switch to outline view. To do so, select Word’s ViewOutline menu item, which gives you an extra Outlining menu. Select this menu and then click on the Show Level dropdown. This lets you choose the level of the outline. You’ll get good results by choosing Level 2. This lets you see all first-level and second-level headings. Put your cursor on a heading of interest and then switch back to normal view by selecting Word’s ViewPrint Layout menu item. (Try it right now. It’s easy!)
Finally, I suggest that you save this file–RIGHT NOW–as MyXLTutorial.docx (or some such name) and work with the copy. That way, if you mess anything up as you try the exercises, you can always go back and retrieve the original file (ExcelTutorial.docx).
Have fun!
Differences in Excel 2007
If Excel 2007 is your first exposure to Excel, you’ll love it. If you’re used to Excel 2003 or an earlier version, however, you’ll have some unlearning to do. There are two big changes in Excel 2007 and a host of smaller changes. The first big change is that worksheets are much bigger. You used to have about 65,000 rows and 256 columns. Now you have over a million rows and over 16,000 columns. You’ll hardly ever use this much space, but it’s available.
The second big change is the one you’ll notice right away: you no longer have the usual menus and toolbars. Microsoft has completely reorganized the user interface to provide menus and ribbons. Each menu (Home, Insert, Page Layout, etc.) has an associated ribbon that is similar to the old toolbars. For example, if you click on the Formula menu, you get a ribbon with buttons that are useful for working with formulas. Each ribbon has several groups of buttons. For example, the Formulas ribbon has one group called Defined Names with buttons for manipulating range names. There’s only one way to learn these ribbons: practice and experiment. If you’re used to the old Excel, you’ll undoubtedly curse at the new ones a few times when you can’t find something, but you can be assured that they are more logically organized than the old versions.
One particular menu item you’ll miss is ToolsOptions, for changing various options in Excel. It’s not gone; it’s just in a different place. To get to it, click on the new Office button (in the upper left corner of the screen) and then the Excel Options button. From there, you can experiment with the various options. While you’re at it, note the options along the left when you click on the Office button. For example, that’s where you find Save As and Print, two obvious favorites.
You can’t change the new ribbons; they are built in and fixed. However, you can customize the user interface to some extent. First, Excel gives you a quick access toolbar (QAT) at the top left of the screen. You can put your favorite buttons on this toolbar so that they’re always visible and available. The QAT comes with a few favorite buttons, but you can add more. Just click on the dropdown arrow to the right of the QAT and check any of your favorites (or click on More Commands to get more buttons). Second, if you don’t mind writing a bit of XML, you can create new ribbons that have your favorite Excel buttons or even new buttons attached to your own macros. (This is somewhat advanced, so it won’t be covered in this document.)
With the old menus
Show More

Related Documents: Essay on Tutorial: Microsoft Excel and Sample Excel Spreadsheets

Independent Study Guide

The Nottingham Bluecoat School and Technology College Post 16 Centre Independent study guide 2011-12 Help make the jump from GCSE to Post-16 study with these suggested study tasks from your teachers. Post-16 Independent study guide “What determines your success at GCSE is how hard you work in your lessons. What determines your success at A Level is how hard you work outside of lessons.” Across the country GCSE results have steadily been rising over the past few years. Some people put this…

Words 5145 - Pages 21

Osmosis: Experiment and Lab Essay examples

Each column should be labeled appropriately and contain the units in parentheses. DO NOT WRITE THE UNITS NEXT TO EACH PIECE OF DATA (NUMBER). UNITS GO IN PARENTHESES ONLY ONCE AT THE TOP OF THE COLUMN IN THE TABLE! ii. Graphs 1. You should use Excel (or some similar program) to produce the graphs. Graphs must have axes correctly labeled (with units of measurement). They must be titled. If the data suggest a function, there must be a curve fit with the statistics of the analysis or a best-fit…

Words 5942 - Pages 24

My Profile Essay

their building design. Those who did not consider daylighting blamed lack of information and unwillingness of clients to pay for this extra service. Among those participants who were considering daylighting 79% used computer simulations. This strong sample bias towards computer simulations reflects that many participants had been recruited through building simulation mailing lists. Participants named tools’ complexity and insufficient program documentation as weaknesses of existing programs. Selftraining…

Words 8561 - Pages 35

Managing Information Technology (7th Edition) Essay

from other sources and reproduced, with permission, in this textbook appear on appropriate page within the text. Microsoft® and Windows® are registered trademarks of the Microsoft Corporation in the U.S.A. and other countries. Screen shots and icons reprinted with permission from the Microsoft Corporation. This book is not sponsored or endorsed by or affiliated with the Microsoft Corporation. Copyright ©2012, 2009, 2005, 2002, 1999 Pearson Education, Inc., publishing as Prentice Hall, One Lake…

Words 239873 - Pages 960