MAPS

Some Impressive New Excel 2007 Features

As a PC user for over twenty years now, I started with a monochrome screen, DOS, and Lotus 123 as the major spreadsheet program of the day. Some of you go that far back too. As good as Lotus 123 was, I was very impressed the first time I used Excel in 1989. I remember the main advantage at that time was its’ WYSIWYG interface and more flexible charting. Later on in version 5, I discovered multiple worksheets (now taken for granted), over 16,000 rows and some nice analysis tools such as three-level sorting, auto-filter and the very capable pivot table.

This latest version of Excel is still very impressive, building on many of these same features. One of the first things you notice is that Excel 2007 now offers 1,048,576 rows and 16,384 columns and 2GB memory management (vs. 65,536 rows, 256 columns and 1GB). Because of this, cell addresses can have three letters representing the column (up to XFD instead of IV). The old worksheet had 16,777,216 cells. An Excel 2007 worksheet has 17,179,869,184 cells (1,024 times as many). Along with this greater capacity is a new file format (*.xlsx) using XML, which allows for reduced file size. On one workbook I use, the size was reduced from 463K (saved as xls) to 267K (saved as xlsx), over a 40% reduction by switching to the new format.

Formatting is much improved in Excel 2007. Excel always had styles, which is a feature more commonly used in Word or PowerPoint. It allows for a conglomeration of format settings to be saved and re-used under a unique name. For instance, in this Word document, the main paragraphs use the ‘normal’ style. The heading at the top uses the ‘Heading 1′ style which has a larger font and is bold. In Excel, I rarely used styles, due to the extra effort to find and use the styles in prior versions, and the relatively limited amount of formatting usually done in a worksheet. In Excel 2007, a style gallery in the ribbon under the home tab conveniently displays several styles, allowing for quick formatting choices for background color, font, font color, number format, and borders. Simply highlight the cells you want to change and pick your style. One last detail to mention is that there are now themes in Microsoft Office 2007, which are like styles, but more global in their result, changing an entire file’s, fonts, colors, line and fill effects. Once a theme is defined in any Microsoft Office 2007 application, it is available in the others too.

Conditional formatting has been a part of Excel’s feature set for years. It is commonly used for highlighting cells that meet certain criteria, such as changing a cell color to red if the entry was less than a specific amount. This is still part of Excel 2007, but it has now been enhanced to format an entire range of cells at once, changing the cell background by color and shade, in order to differentiate the values visually for easier analysis. Much like a weather map showing severe weather gradations, you can set choose a conditional format color scale to shade the smaller numbers in blue and the larger ones deep orange. Not only can you do this differentiation with color scales, but also shading of a portion of the cell with the data bars feature, the larger the portion shaded, the larger the number relative to the others in the selection, much like applying a bar chart directly in the cell. Finally, for a little fun, there are a large assortment of icons that can be used to quickly show the relative size of entries in a range, including stop lights, flags, arrows and even cell-phone-like reception strength bars.

About the Author

William Gee is an Excel power user and trainer for Training Connection. For more information on Excel training please visit our website.

http://www.trainingconnection.com

Breakthrough Learning in a Digital Age – Session III. New Learning Designs

Map Skills, Grade 3 (Basic Skills) $1.99 This book teaches students how to use maps as tools. Its pages provide students with enjoyable yet challenging practice with a wide variety of map skills. Author: Jan KennedyGrade: 3Pages: 48, PaperbackPublisher: School Speciality PublishingISBN: 1-56822-638-1…

Wugeo, Maps $68.51 High Quality Content by WIKIPEDIA articles WuGeo is a Python library used to draw points on geographical maps, starting from latitude and longitude. It borns from the desire to track site visitors, then becomes an abstract library, being a scientific generic tool. In particular, WuGeo has to be used with world maps created with the Miller cylindrical projection, that is a modified Mercator projection. The Mercator projection is a cylindrical map projection presented by the Flemish geographer and cartographer Gerardus Mercator, in 1569. It became the standard map projection for nautical purposes because of its ability to represent lines of constant course, known as rhumb lines or loxodromes, as straight segments. While the linear scale is constant in all directions around any point, thus preserving the angles and the shapes of small objects (which makes the projection conformal), the Mercator projection distorts the size and shape of large objects, as the scale increases from the Equator to the poles, where it becomes infinite. Author: Surhone, Lambert M./ Timpledon, Miriam T./ Marseken, Susan F. Binding Type: Paperback Number of Pages: 88 Publication Date: 2010/07/05 Language: English Dimensions: 5.98 x 9.01 x 0.21 inches

Scale (Map) $58.94 High Quality Content by WIKIPEDIA articles The scale of a map is defined as the ratio of a distance on the map to the corresponding distance on the ground. If the region of the map is small enough for the curvature of the Earth to be neglected, then the scale may be taken as a constant ratio over the whole map. (A town plan would be an example). For maps covering larger areas, or the whole Earth, it is essential to use a map projection from the sphere (or ellipsoid) to the plane. Such projections inevitably involve distortion and the scale can no longer be considered as constant. It is then necessary to introduce the concept of a variable point scale (or particular scale) which is defined as the ratio of the length of a small line element emanating from a point on the map to the length of the corresponding line element on the surface of the Earth. In general the point scale will vary with the position of the point and also the direction of the line element. Author: Surhone, Lambert M./ Tennoe, Mariam T./ Henssonow, Susan F. Binding Type: Paperback Number of Pages: 70 Publication Date: 2010/09/15 Language: English Dimensions: 6.00 x 9.02 x 0.17 inches

Teacher Created Materials 10899 Looking at Maps $23.4 Maps show us where things are in the world with abstract pictures of what is in view. Many maps have grid coordinates that make it easier to locate where something is. A vertical grid line is known as longitude and a horizontal line is known as latitude. Symbols and keys are important parts of maps. A scale helps us know how far apart things are from each other in real life. Compasses also help us know the direction on a map. There are many different types of maps such as street maps tourist maps population maps and landuse maps. Author: Moira Anderson. Format: Paperback. Pages: 32. Publish Date: October 10 2008. Publisher: Shell Educational Publishing. Language: English.

National Geographic Maps DC00622058 Tunis $21.45 In addition to the easytoread map on the front the back includes: Regional map Points of interest Metro map Inset maps of the coastal towns of Bizerte and Sousse Floor plan of the Bardo Museum Multilanguage legend. Approximately 4 1/4 x 8 3/4 folded; 17 3/4 x 24 3/4 fully opened. Scale = 1:4 000.

Looking at Maps and Globes By Bredeson, Carmen $11.06 This introductory book describes maps and globes, including the map legend, map scale, directions, equator, and North and South Poles. Author: Bredeson, Carmen Series Title: Rookie ReadAbout Geography Publication Date: 2002/01/01 Number of Pages: 31 Binding Type: Paperbound Grade Level: 12 Language: English Depth: 0.25 Width: 6.00 Height: 7.00

National Geographic Maps NGMRE01020557 Beginners World Map $37.47 Educators Resource offers products for preK8 learning materials and educational toys used by schools teachers parents and children. This is a very exciting year for National Geographic Maps as we are launching our new series of maps designed specifically for the kids. Our new gradedseries of maps are the first to address the unique needs of K12 students as they advance their understanding of our World.Unlike other classroom poster maps ours utilize the WinkelTriple projection which provides the best combination of size shape and distance giving the student the best visual representation of the Earth s surface. This solves the effect seen on other maps where Greenland appears larger than South America.Our new maps start early elementary kids off right. Our Beginner Series grades K3 contains an easy to read maps of the World and United States. Scale = 1:30 000 000

010-11316-00 – Dvd, Maps Of Montana, Idaho, Wyoming $112.52 outdoor Enthusiasts: Your Adventure is Waiting – in Vivid Detail. Topo U.s. 24k North Central Dvd Brings You The Highest Level of Topographic Detail Available, With Maps Comparable to 1:24,000 Scale Usgs Maps. [0101131600] UPC: 753759093518 UNSPC: 55111508 10.3L x 6.8W x 0.4H 0.29 LB 1 Cubes

Designing Better Maps By Brewer, Cynthia A. $37.21 A guide to map design covers such topics as resolution and viewing distance, fonts and symbols, colors, scale bars, and export options. Author: Brewer, Cynthia A. Subtitle: A Guide for GIS Users Publication Date: 2005/08/22 Number of Pages: 203 Binding Type: Paperback Language: English Depth: 0.75 Width: 8.75 Height: 7.25

National Geographic Maps AD00003106 Belize $24.15 National Geographic s Belize AdventureMap details the country s numerous protected areas including its National Parks preserves wildlife sanctuaries archeological reserves marine reserves spawning grounds and private reserves. UNESCO World Heritage sites and the locations of archeological ruins are highlighted along with locations of popular places for diving surfing fishing and more. A detailed road network plus inset maps of Belize City and San Pedro including the location of key infrastructure and pointsofinterest make the Belize AdventureMap ideal for touring both urban and remote destinations. The reverse of the Belize AdventureMap contains detailed interpretive information to Belize s Blue Hole the ruins of Tikal in Guatemala The Barrier Reef System plus information on the many cultures history and districts of Belize. Like all National Geographic AdventureMaps Belize is printed on durable waterproof tearresistant and environmentally friendly media capable of withstanding the rigors of international travel. Protected Area Boundaries to include: National Parks Nature Reserves Wildlife Sanctuaries Mangrove Reserves National and Public Reserves Bird Sanctuaries Forest Reserves Archeological Reserves Marine Reserves Spawning Aggregation Grounds and Private Reserves. Archeological Sites and Ruins locations. UNESCO World Heritage Sites. Belize City and San Pedro Insets. Popular Diving and fishing locations. Travel information. Approximately 4 1/4 x 9 1/4 folded; 25 1/2 x 37 3/4 fully opened. Scale = 1:400 000.

National Geographic Maps NGMRE01020560 Beginners United States Map $37.47 Educators Resource offers products for preK8 learning materials and educational toys used by schools teachers parents and children. This is a very exciting year for National Geographic Maps as we are launching our new series of maps designed specifically for the kids. Our new gradedseries of maps are the first to address the unique needs of K12 students as they advance their understanding of our World.Unlike other classroom poster maps ours utilize the WinkelTriple projection which provides the best combination of size shape and distance giving the student the best visual representation of the Earth s surface. This solves the effect seen on other maps where Greenland appears larger than South America.Our new maps start early elementary kids off right. Our Beginner Series grades K3 contains an easy to read maps of the World and United States. Scale = 1:30 000 000

Maps $10.19 No Synopsis Available