technology center

Microsoft Excel 2010 Retail Full Version:

Starting at:£49.00

Mini map is EXCEL2010 adding a new charting tool for the drawing area to the cell, simple and convenient for us to draw a simple little chart data, the data in a convenient form of a small map showing the reader before it is present in a small cell chart.

I: the basic application of mini-map:

Mini-map as a mapping of data visualization gadget show, very simple to use, generating mini-map, please pay special attention to only use EXCEL2010 create data tables to create a mini-map, the low version of the EXCEL document to open even with EXCEL2010 can not create the data must be copied to EXCEL2010 document to use this feature.

1 mini-map created:

By clicking “Insert” ribbon – any type of mini-map example (this example uses mini-Line) to create pop-up dialog box mini figure

“Data Range” Select B2: F5 cells (see Figure 1) that the source data area “position range” refers to the mini-map to generate a range of cells, such as figure one of the “range of positions” for the H2: H5, click OK, the mini-map is created successful.

2 mini-map changes:

When we click on the mini map there will form a “mini-map design” functional areas:

Editing data: modified Mini Figure set of source data area or a single mini-map of the source data area

Type: mini-map to change the type of line chart, bar chart, profit and loss graph

Show: In the mini-map to identify what specific data

Style: the mini-map directly apply a predefined chart style format

Mini colors: Mini Figure line or column change the color

Edit Color: Mini map display in a special focus on the color data

Axes: the scope of control mini-map coordinates

Combination and Ungroup: As in this case created when mini-map “position range” selected range of cells, four cell picture shows a group of mini-mini-map, this feature can be set by using the split or multiple combination of different groups of mini-map as a set of

II. Mini-map and chart

OFFICE products always give the impression that: each new release, each adding new features, most features of interest are not new per se, but to use this new feature in the expanded use of derived methods, including combination with other features will have what effect.

Mini-map exists in the cell, and cell and is usually the most frequent target operation, we are often in the charts, text boxes, pictures and more features in a large number of references, which can not help but appeals to the imagination, but unfortunately , mini-maps are not really present in the cell of the “content”, it can be seen as covering the top layer in the cell, we can not directly reference the way to reference it, if you want other functions such as charts reference needs to be converted to mini-map picture.

Specific steps are as follows:

(1) to generate a mini-map in the cell right-click – select “Copy” button, right-click in any cell – select Paste – linked picture. In this way, the mini-map can be converted to pictures.

(2) Right-click the resulting image – Click “Copy” button in the bar chart corresponding to the two left-click on the radio a bar, then press CTRL + V key combination. This will paste the picture into the strip of four.

Microsoft Excel 2010 Retail Full Version Download:

Special Price:$59.99

Microsoft Office 2010 products as an important component, Excel 2010 is also compared with the previous version has many improvements, but overall changed little, almost does not affect all the current Office 2007 product platform based on the application, but Office 2010 is upward compatible, that is, it supports most of the functionality provided in earlier versions, but the new version does not necessarily support the functionality in earlier versions. In fact, in Excel 2010 and Excel 2007 on the basis of no major changes, following a brief introduction.

In front of the same version as the Microsoft Office 2010 product is an important component, Excel 2010 is also compared with the previous version has many improvements, but overall changed little, almost does not affect all current product platform based on the Office 2007 applications But Office 2010 is upward compatible, that is, it supports most of the functionality provided in earlier versions, but the new version does not necessarily support the functionality in earlier versions. In fact, in Excel 2010 and Excel 2007 on the basis of no major changes

1 Enhanced Ribbon toolbar

What is the Ribbon toolbar? Fact that I do not know how to translate, contact Excel 2007 users should be familiar. Microsoft Office products from 2003 to 2007 upgrade process to do a lot of improvement, involving almost the whole product framework, experience of the user interface part of a new bright spot is Ribbon toolbar introduction, here is a screenshot of Excel 2010.

Just from the interface point of view with Excel 2007 and no major changes in the interface change theme colors and styles. In Excel 2010, Ribbon is more enhanced features, users can set something more, and easier to use. Moreover, to create a SpreadSheet more convenient.

2. Xlsx file format compatibility

xlsx format along with Excel 2007 was introduced into the Office products, it is a compressed format. By default, Excel files are saved as xlsx format files (of course, can also be saved into a format compatible with previous versions of 2007, with a vba macro code files can be saved into xlsm format), you can change the suffix into the rar, and then use Winrar open it, you can see a lot of xml file which contains this xml based file formats and programming interfaces in the network to provide a great convenience.Compared to Excel 2007, Excel 2010 has improved on the previous version of file format compatibility, and more secure than previous versions.

3. Excel 2010 for Web support

Terms over the previous version, Excel 2010 one of the most important improvement is the support for Web-enabled, users can direct the browser to create, edit and save Excel files, and share these files through a browser. Excel 2010 Web Edition is free, users need only have a Windows Live account online via the Internet will be able to use Excel spreadsheet, Excel functions in addition to some outside, Microsoft claimed to Web version of Excel will work with the desktop version of Excel as well. In addition, Excel2010 also provides the application with the Sharepoint interface, users can even save directly to a local Excel file to Sharepoint document center.