Formatting and Editing from the Home tab: The Home tab of the Excel Ribbon literally brings home all the commonly used formatting and editing features. Gone are the days when you have to fish for the right button on some long, drawn-out toolbar or on some partially deployed pull-down menu. Now all you have to do is find the group that holds the command button you need and click it.
What could be easier! Simply select the data to chart, click the command button for the chart type on the Insert tab, and then select the style you want for that chart type. And with a little help from the many command buttons and galleries on the Design, Layout, and Format tabs on its Chart Tools contextual tab, you have a really professional-looking chart ready for printing!
Format As Table: This feature is a real keeper. Better yet, all new entries to the table are considered part of the table automatically when it comes to formatting, sorting, and filtering. Additionally, the program shows the margins for each page, including headers and footers defined for the report which you can both define and edit directly in the margin areas while the program is in this view.
As an extra nice touch, Excel throws in a pair of horizontal and vertical rulers to accompany the standard column and row headers.
- Use Excel as your calculator?
- Microsoft Excel Basics Tutorial – Learning How to Use Excel.
- Purple Heart.
- Excel 2010;
- How To Auto-Refresh Filtered Data In Excel When It Is Updated?
- Option 1: Change Known Excel 2010 Password.
Style Galleries: Excel is jammed full of style galleries that make it a snap to apply new sophisticated and, in many cases, very colorful formatting to the charts, tables and lists of data, and various and sundry graphics that you add to your worksheets. The Ribbon: The Ribbon is the heart of the new Excel user interface. It enables you to see how the data in the current cell selection would look with a particular formatting, font, or font size before you actually apply the formatting to the range.
All you have to do is mouse over the thumbnails in the drop-down menu or gallery to see how each of its styles will look on your actual data. Many of the larger style galleries sport spinner buttons that enable you to bring new rows of thumbnails in the gallery into view so that you can preview their styles without obscuring any part of the cell selection as would be the case if you actually open the gallery by clicking its More drop-down button.
When you finally do see the formatting that fits your data to a tee, all you have to do is click its thumbnail to apply it to the selected cell range.
Moving and resizing charts in Excel 2010
Cheat Sheet. Excel For Dummies Cheat Sheet. Moving the Cell Cursor in Excel Spreadsheets Excel offers a wide variety of keystrokes for moving the cell cursor to a new cell. Up arrow Cell up one row. Down arrow Cell down one row. Home Cell in Column A of the current row. Page Up Cell one full screen up in the same column.
How to Use Excel: 14 Simple Excel Tips, Tricks, and Shortcuts
Page Down Cell one full screen down in the same column. If no cell is occupied, the pointer goes to the cell at the very end of the row. If no cell is occupied, the pointer goes to the cell at the very beginning of the row. And to all the Harry Potter fans out there If you're just starting out with Excel, there are a few basic commands that we suggest you become familiar with.
These are things like:. For a deep dive on these basics, check out our comprehensive guide on How to Use Excel.
The Show Margins feature in Excel 2010 is revealed
Pivot Tables are used to reorganize data in a spreadsheet. They won't change the data that you have, but they can sum up values and compare different information in your spreadsheet, depending on what you'd like them to do. Let's take a look at an example. Let's say I want to take a look at how many people are in each house at Hogwarts. You may be thinking that I don't have too much data, but for longer data sets, this will come in handy. Excel will automatically populate your Pivot Table, but you can always change around the order of the data.
Then, you have four options to choose from. Since I want to count the number of students in each house, I'll go to the Pivot Table and drag the House column to both the Row Labels and the Values. This will sum up the number of students associated with each house. As you play around with your data, you might find you're constantly needing to add more rows and columns. Sometimes, you may even need to add hundreds of rows.
Doing this one-by-one would be super tedious.
Luckily, there's always an easier way. To add multiple rows or columns in a spreadsheet, highlight the same number of preexisting rows or columns that you want to add. Then, right-click and select "Insert. In the example below, I want to add an additional three rows. By highlighting three rows and then clicking insert, I'm able to add an additional three blank rows into my spreadsheet quickly and easily. When you're looking at very large data sets, you don't usually need to be looking at every single row at the same time.
- Subscribe to Online Tech Tips!
- How To Learn Ms Excel 2010.
- Kerala Christian Sainthood: Collisions of Culture and Worldview in South India!
- Excel Print Guide – Changing Important Print Settings in Excel 2010.
- Why Would My Nonprofit or Library Use These?;
Sometimes, you only want to look at data that fit into certain criteria. That's where filters come in. Filters allow you to pare down your data to only look at certain rows at one time. In Excel, a filter can be added to each column in your data -- and from there, you can then choose which cells you want to view at once. Let's take a look at the example below. Add a filter by clicking the Data tab and selecting "Filter. In my Harry Potter example, let's say I only want to see the students in Gryffindor. By selecting the Gryffindor filter, the other rows disappear.
Pro Tip: Copy and paste the values in the spreadsheet when a Filter is on to do additional analysis in another spreadsheet. Larger data sets tend to have duplicate content. You may have a list of multiple contacts in a company and only want to see the number of companies you have. In situations like this, removing the duplicates comes in quite handy. To remove your duplicates, highlight the row or column that you want to remove duplicates of. Then, go to the Data tab, and select "Remove Duplicates" under Tools. A pop-up will appear to confirm which data you want to work with.
Select "Remove Duplicates," and you're good to go. You can also use this feature to remove an entire row based on a duplicate column value. So if you have three rows with Harry Potter's information and you only need to see one, then you can select the whole dataset and then remove duplicates based on email. Your resulting list will have only unique names without any duplicates.
When you have low rows of data in your spreadsheet, you might decide you actually want to transform the items in one of those rows into columns or vice versa.
Welcome to Excel Easy
It would take a lot of time to copy and paste each individual header -- but what the transpose feature allows you to do is simply move your row data into columns, or the other way around. Start by highlighting the column that you want to transpose into rows. Right-click it, and then select "Copy. Right-click on the cell, and then select "Paste Special. Check that box and select OK. Your column will now be transferred to a row or vice-versa. What if you want to split out information that's in one cell into two different cells? For example, maybe you want to pull out someone's company name through their email address.
Or perhaps you want to separate someone's full name into a first and last name for your email marketing templates. Thanks to Excel, both are possible. First, highlight the column that you want to split up. Next, go to the Data tab and select "Text to Columns. In the example case below, let's select "Delimited" so we can separate the full name into first name and last name.