MCS

In past version it was easy to adjust margins so you could fit more data on a page, by going into print preview and dragging those margins. Now, in Excel 2010, Print Preview is accessed in the Print area and doesn’t allow for this easy margin dragging. The older method is still available. The easiest [...]

Make repetitive steps easier by automating them with a macro.

Select the cell in which you want to record the macro.
Click on the Developer Tab.
Click on Record New Macro.
Enter the name of the macro in the Macro name box. The name must be a single word with no spaces, and the first character must be a [...]

Learn how to create a formula that applies specific formatting on a number, only if it meets specific conditions. Have all numbers that fall below a certain value format as red, and any that fall above a certain value format as green.

 
Conditional Formatting in Excel covered in Excel Training Classes
Learn more about conditional formatting in [...]

When your data has been entered into Excel, you can use the built-in Filter tool on the Data Tab to narrow down what you are viewing based on criteria you set:
Enter your data.

On the Data tab, click the Filter button.
(It’s a toggle button meaning: "one click on, one click off")

Click the arrow next to the [...]

When you update a PivotTable, Excel can often change some of the column width formatting you previously set. Here’s how you can protect the column widths you want for the PivotTable. After your PivotTable is created and columns formatted…

Select any cell in your PivotTable.
Display the Options tab from the PivotTable ribbon.
Click the Options tool at [...]

You can create a drop-down list in Excel, so that others can select from a list of options to populate a cell, using a feature called a Data Validation.

Select cells you want the drop-down list to appear in
On the Data tab, in the Data Tools group, click the Data Validation button, then select the Data [...]

We can create dates within Excel, but sometimes we want to know what day of the week they actually fall on. Watch this video to see how to use a formula to calculate the day of the week.

You can show trending by using a secondary axis. This also allows you to combine 2 different types of charts, such as a line and column chart, to more visually represent your data.

Create a 2-D chart type — such as a column chart
Right-click on one of the columns for the series you want to change [...]

Excel: Creating a chart using a single keystroke

Pick from a drop-down list if you enter the same entries in a column in Excel.