Archive for 'Tutorials'
Excel Bar Chart
Bar charts in Excel are good at displaying values for different groups for comparison. Let’s look at an example to illustrate how we might use a bar chart. Yesterday I sat on a bridge and counted how many cars of different colours I saw. Here are the results in a spreadsheet:
Full StoryExcel Area Chart
If your worksheet contains data that is arranged in columns or rows then using an area chart may be a good way to display that data. Area charts emphasize the magnitude of change over time, and can be used to draw attention to the total value across a trend. Area charts are good for emphasizing totals. They offer the time-tracking qualities of a line chart but also display relative proportions well. You can visualise area charts as being line charts with different colours in the areas below the lines.
Full StoryExcel Column Chart
Column charts in Excel are good for plotting data that is arranged in columns or rows of your worksheet. If you need to show how data changes over time, a column chart might be a good fit. Whereas scatter charts plot actual values along the x-axis, column charts use categories.
Full StoryExcel Scatter Chart
A scatter chart plots the values for two variables as a set of points on a graph. One variable controls the position on the x-axis of a point, whilst the other variable controls the position on the y-axis. If you’re familiar with graphs, you might already understand that these points are referred to as (x,y) where x is the position along the x-axis and y is the position along the y-axis of each point.
Full StoryConditional Formatting In Microsoft Excel 2010
Conditional formatting in Excel allows you to highlight cells whose data satisfies certain criteria. For example, you might want to highlight sales margins on products that are less than 5%. Or you might like to highlight sales people in your tean who have achieved more than their targets. Excel enables you to apply formatting to cells that meet certain criteria that you specify.
Full StoryExcel Hyperlink
An Excel hyperlink gives the reader quick access to related information in another file or on a Web page. In addition to being able to insert hyperlinks into cells, you can also insert them into specific chart elements. Links usually open web pages, but they can also lead to pictures, email addresses or programs. The hyperlink itself can be text or a picture.
Full StoryExcel Viewer
If you have an Excel workbook to open but you don’t have Excel, don’t worry. There is a freely downloadable utility provided by Microsoft that enables you to open Excel files, even without having Excel installed. Enter Excel Viewer.
Full StoryExcel Smart Tags
Smart tags in Excel 2010 recognise specific data and then offer action options based on the type of data recognised. The actions are made available with a button that appears near the cell that contains the recognised data. The button appears when the cell is activated or when you move the mouse pointer over the cell.
Full StoryExcel Function
A function in Excel calculates a result based on one or more input values. For example, the SUM function returns the sum of all the cells you specify as arguments. If you were to type into a cell the following:
Full StoryFormulas In Excel 2010
If you need to dynamically calculate values that are dependent on other values entered in your worksheets, then you need formulas. Formulas will calculate values for you so that you don’t have to spend time struggling with Maths and risk making mistakes. In Excel 2010, you can use formulas to calculate things like:
Full Story
