Wednesday, April 20, 2011

Some Fine Tuning Tips For Excel Experts

Microsoft excel is a powerful software that is used by excel consultants in making spreadsheets and maintaining data for business organization. The use of the software needs proper training that can be achieved through tutorials, that have regular class or through online course that can be tailor made according to your convenience. You can also use some excel tricks and tips that can minimize your effort and can make working with chart graphics and other objects faster. Here are few tips that can help you in the process of achieving expertise in excel.

Creating Charts

1.    Creating chart is the most common task that every expert needs to perform.  You can create and customize charts at the same time. This can be done by selecting the data that needs to be present in the chart and then click on the chart wizard option, on the toolbar whereas, chart can be created by selecting the data and pressing F11 key from the keyboard. Another alternative for creating chart is by pressing ALT+F1 key.
2.    Chart type can also be changed if the excel expert right clicks on the chart and selects the chart type. 
3.    Any one entry from the chart can also be changed to a different type, just by selecting the entry and clicking on the chart type from the chart menu. While changing the chart type you need to make sure that the Apply to selection check box is selected.

Display of charts

1.    Chart display is one of the very unique parts of your job which make you different from the others. As a excel expert you can move or resize the plot area of your chart by dragging the border. 
2.    You can also change the overlaps between columns by selecting data series option from the format menu. The percentage option in the overlap box will help you maintain the gap between columns.

Formatting charts

1.    You can format individual data marker by clicking the marker until only one is selected and then click on the standard data appoint option available in the format menu.  The same technique can be applied for formatting a series of data. 
2.    Excel consultant can also label the series of the data maintained by clicking on the selected data series option in the format menu and then again by selecting the label option on the data labels tab. 
3.    You can also reposition the data label by clicking selected data labels option on the format menu and select the desired option from the alignment tab.
4.    You can also add color to the chart by selecting data series on the format menu and then select vary color by point check box from the option tab. By adding color to you chart you will make it more attractive and data can also be easily located.

Last but not the least excel experts can check all the spellings present in the chart by clicking on the spelling button. This will also help you in checking all the text that is not linked to the worksheet.


No comments:

Post a Comment