-
Similar Topics
Are You an Excel Expert?
Do you also have a desire to share your knowledge with others?
If so, we'd love to hear from you! Join our team of talented professionals today!
Excel Tips and Tricks
Microsoft Excel Tips and Tricks – Moving a Chart to Another Worksheet
Creating a chart can be extremely useful for Excel users, especially users who need to communicate complicated or difficult information in an engaging and user-friendly way. When you first create a chart, the chart wizard gives you the option of saving the chart as an object in the existing worksheet or creating a new sheet to hold the graph. The decision you make at that point is not irrevocable. You can go back later and move the chart to another worksheet. This can be a big help, especially if you are preparing a new presentation and need to present the chart on its own, without the accompanying spreadsheet cells. To Move a Chart to a New Location or a New Worksheet Select the chart by clicking on it. You … Continue reading
Microsoft Excel Tips and Tricks – How to Change the Default Size of the Worksheet Tab
The ability to create multiple worksheets within a single workbook is a hallmark of Microsoft Excel. It is easy enough to change the name, color and formatting of the various worksheet tabs within Excel, but you can also change the default size of those tabs. The exact procedure for changing the default size of the worksheet tabs within Microsoft Excel depends on the operating system you are using to run the program, but no matter which OS you are using the process is relatively straightforward. To Change the Default Worksheet Tab Size in Windows XP Click the Start menu Choose Control Panel from the list Double-click the Display icon Click the Appearance tab Click the Advanced button Choose the Scrollbar option and choose a larger size Click Apply to … Continue reading
How to Use Microsoft Excel to Calculate Your Tax Withholding
If you have ever taken a close look at your pay stub, you have no doubt noticed quite a large difference between the gross pay from your employer and the net pay that actually lands in your bank account or paycheck Calculating the percentages you pay in all the different categories of taxation can be quite instructive, and you can build an Excel spreadsheet to calculate those tax percentages. If you want to get an idea of just where all that tax money is going, just use these step by step instructions to create your own tax withholding spreadsheet. Open Microsoft Excel and start a new spreadsheet. Give the spreadsheet a descriptive name like "Payroll Taxes" and save it to your hard drive. Create columns for each of … Continue reading
How to Create an Excel Table
In Excel 2010, you can change an existing cell range to a table. Tables have additional functionality that normal cell ranges do not have by default – such as filters, formatting and total rows. The table can also be published to a SharePoint server, if available. Open the worksheet that contains the data you would like to convert to a table. Alternatively, if the data is not present, select the blank cells you would like to convert to a table. On the Insert tab, click Table in the Insert group. Ensure that the correct cell range is displayed. If your table has a header row, select the My table has headers checkbox. Click OK. Your data range will now be formatted as a table. NOTE: If at any time you … Continue reading
How To Save Your Excel Spreadsheet as a CSV File
There are many situations in which you'll need to save your spreadsheet as a CSV file. CSV stands for comma-separated value(s). This is a popular and standardized import format for a wide variety of applications. To save your excel spreadsheet as a CSV file, follow these steps: Open the worksheet that contains the data you would like to save as a CSV file. NOTE: Only one worksheet can be saved in a CSV file. If multiple worksheets need to be saved, select each one and save them individually. Click the File tab and click Save As. Enter a name for the file in the File name field. Click the drop-down arrow next to the Save as type field to select the file type. Scroll down and select CSV (comma delimited) … Continue reading
How To Import Data Into an Excel Worksheet
If you have data from an alternative source, you may be able to import it into Excel 2010 instead of having to re-enter all the information again. Depending on the type of data you would like to import, you can select from a number of options. We’ll look at one of the most common import types – a text file. Open the worksheet you would like to import the data to and select the cell where you would like to data import to start. Click the Data tab and choose from the options in the Get External Data group. NOTE: For this example, we will import a text file. Click From Text. This will allow text file types such as prn, txt and csv to be imported Browse to find … Continue reading
How To Convert Text to Columns in Excel
If you have a cell in Excel 2010 that contains a lot of text, you may wish to separate it into several columns. This can only be done if there is a logical character that separates the text, such as a comma, semi-colon or full stop. For example, you may wish to take cells that contain Last Name, First Name and separate it into two different columns. Open the worksheet that contains the text you would like to convert to columns. Select the cells that you would like to convert. On the Data tab, click Text to Columns in the Data Tools group. Choose the format of your current data. Select Delimited if the text contains a character such as a comma, tab, space or semi-colon to separate the various … Continue reading
How To Import Data Into an Excel Spreadsheet
If you have data from an alternative source, you may be able to import it into Excel 2010 instead of having to re-enter all the information again. Depending on the type of data you would like to import, you can select from a number of options. We’ll look at one of the most common import types – a text file. Open the worksheet you would like to import the data to and select the cell where you would like to data import to start. Click the Data tab and choose from the options in the Get External Data group. NOTE: For this example, we will import a text file. Click From Text. This will allow text file types such as prn, txt and csv to be imported. Browse to find … Continue reading
How To Apply Emphasis in Your Excel Table
Your Excel 2010 table can be formatted in a number of ways to put emphasis on particular data sets. These are often specific columns or the headers of your table. Open the worksheet that contains the table you would like to amend. Click once in the table and the Design tab under Table Tools will appear in the Ribbon. On the Design tab, you can select from a number of checkboxes in the Table Style Options group. Header Row: the first row appears emphasised with Header Row formatting Total Row: the last row appears emphasised with Total Row formatting First Column: the first column appears emphasised with First Column formatting Last Column: the last column appears emphasised with Last Column formatting Banded Rows: each row alternates in colour to … Continue reading
How To Display Formulas in an Excel Cell
By default, your formulas in Excel 2010 are hidden from view in the worksheet and only displayed in the Formula Bar. However, at times you may want to show the formulas in your worksheet, rather than the results of the formula. Open the workbook that contains the formulas you would like to display. On the Formulas tab, click Show Formulas in the Formula Auditing group to display the formulas in your worksheet. Instead of the results or calculations, the actual formulas, functions and arguments are displayed. This may make it easier for you to identify any errors or inconsistencies in your formulas. To switch the view back to normal, on the Formulas tab, click Show Formulas in the Formatting Auditing group. That’s it for displaying formulas in your worksheet. Hope … Continue reading
