ejemplos checklist en excel 2010

How to Compare Worksheets in Excel 2010 Know-how | 27306 Views We often use Excel to deal with large data and they may be quite similar in MS Excel documents. So sometimes, we need to compare them in order to deal data better. Well, there are several freewares to do this job. However, if you are Excel 2010 users, you can get a free add-in to do so not to download those softwares. The method is quite quick and

How to Add Error Bars for a Chart in Excel 2010 Know-how | 44190 Views Error bar is a useful and flexible tool that helps add detail to an Excel chart. A typical use for error bars is to show variability in the measures which are plotted in the chart. There are other ways to use error bars too. For Microsoft Excel 2010, the newest version, I tell about how to add error bars for a chart.

How to Create a PivotTable from Worksheet Data in Excel 2010 Know-how | 3526 Views A pivot table creates an interactive summary from many records. And in new Microsoft Excel 2010, the PivotTable has been replaced with "PivotTable" command on the "Insert" tab in the "Tables" group. It is a little different. Next, I will introduce how to create a PivotTable from Worksheet data in Excel 2010.

How to Insert Page Numbers on a Single or Multiple Worksheets in Excel 2010 Know-how | 29708 Views Do you know you can get page numbers in Microsoft Excel as in Microsoft Word? Especially, when you print a worksheet , you may want number pages . You can insert page numbers in the headers or footers of the worksheet pages. Take Microsoft Excel 2010 for example. Then I will introduce how to insert page numbers on a single or multiple worksheets.

How to Correct Common Formula Errors in Excel 2010 Know-how | 4786 Views When we use Microsoft Excel to deal with data, it is necessary for us to insert all kinds of formulas. So it is possible that we may make some errors with formulas. And Microsoft Excel provides a good and useful tool for error checking. Here, I will take Excel 2010 for example to introduce how to correct common formula errors .

How to Change the Scale of the Axis in a Chart in Excel 2010 Know-how | 13956 Views By default, Microsoft Office Excel determines the minimum and maximum scale values of the axis when we create a chart. However, we can customize the scale to better meet your needs. This feature is also added in Microsoft Excel 2010 beta. Next, I will tell you how to change the scale of the axis in a chart.

How to Remove or Allow a Circular Reference in Excel 2010 Know-how | 12951 Views I have just installed Microsoft Excel 2010 and yesterday I used it to calculate my own budget. During that time and I was warned by some errors about circular reference. However, I have never used this feature in Excel. Is the new function of MS Excel 2010? How could I solve this problem?

How to Open an OpenDocument Spreadsheet in Excel 2010 Know-how | 4220 Views Maybe you have to install OpenOffice.org to open OpenDocuments before or use Google Docs. However, after you install the Microsoft Excel 2010, you can open and save files in the OpenDocument Spreadsheet (.ods) file format.

How to Make an Organization Chart in Excel 2010 Know-how | 23274 Views An organization chart shows the hierarchy of a company or a project. Each level in the hierarchy is represented by a row of boxes. We need to use this type of chart frequently. Microsoft Excel can create organizational charts through the use of SmartArt hierarchy diagrams in versions of Excel 2010 and earlier versions. Here I will take Microsoft

How to Apply an Artistic Effect to a Picture in Excel 2010 Know-how | 2259 Views I always insert pictures in Microsoft Word, PowerPoint and so on. But I have never embedded pictures into Microsoft Excel. Now I need to insert one picture in my Excel workbook. Then I find that the style of picture is not suitable with the whole sheet. I want to change the effect. Could I do this in Microsoft Excel directly not in other special t

How to Freeze Panes to Lock Specific Rows or Columns in Excel 2010 Know-how | 95185 Views To keep an area of a worksheet visible while you scroll to another area of the worksheet, you can lock specific rows or columns in one area by freezing panes .When you freeze panes, you keep specific rows or columns visible when you scroll in the worksheet. You will benefit a lot from this function in Microsoft Excel 2010. And I am glad to tell you

How to Restrict Changes in Excel 2010 Know-how | 5127 Views I have just put our boss's secret data in Microsoft Excel 2010. And I don't want content reviewers to accidentally change it in a Excel 2010 spreadsheet, I have no idea about how to make this function true in Microsoft Excel 2010. Could I only make formatting and editing restrictions but not protect it from opening?

How to Print Row and Column Headings on Printed Page in Excel 2010 Know-how | 9314 Views We are familiar with Microsoft Excel and always see row and column headings in Microsoft Excel document. But by default, Excel does not print the column and row headings that you see on screen. For some users, they need or want to print the row and column headings. Could they manage it ? Yes, Microsoft Excel application provides this feature. I wi

How to Insert a Page Break in Excel 2010 Know-how | 52015 Views Page beaks are dividers that break a worksheet into separate pages for printing. Microsoft Excel inserts automatic page breaks . But sometimes, we need to use our own page breaks with customized paper size, margin settings, scale options, etc. At this time, we can insert manual page breaks. Then I will tell you how to do this in Microsoft Excel 201

How to Change the Color of Gridlines in a Excel 2010 Worksheet Know-how | 8316 Views Gridlines in Microsoft Excel 2010 are displayed in worksheet using the color that is assigned to Automatic, usually black color by default. If you don't like this color and want to change the color of gridlines, you can use the following procedure. It is pretty simple.

How to Change the Default Font in Excel 2010 Know-how | 29452 Views When I use Microsoft Excel 2010 in my computer, it always provide "Arial Unicode MS" font with the size 11. This default font brings me a lot of trouble. Each time I need to change the font manually. So could I change the default settings and set my own default? If so, how should I do?