1. Microsoft ExcelSummarizing business performance using sparklines| 00:00 | Petal Jones keeps a close eye on how the
company's mail order and web sales have progressed.
| | 00:05 | The company first started accepting
mail and web orders from outside the Los
| | 00:08 | Angeles area two years ago.
| | 00:11 | When she started tracking sales in Excel,
she created the Summary Worksheet or
| | 00:15 | Dashboard that included the actual
numbers and the conditional format that
| | 00:18 | indicated how sales performance
measured up against the monthly targets.
| | 00:23 | The Conditional Format measures how
Revenue compared to the Goal for a given month.
| | 00:28 | In this case, the Conditional Format
uses an icon set to indicate whether the
| | 00:34 | Value is above the Goal, which is $14,600,
whether it fell between $14,600 and
| | 00:41 | $13,510, or weather it was below $13,510.
| | 00:44 | $14,600 was the sales goal for the
month. $13,510 is the amount that is 15%
| | 00:54 | less or 85% of the Goal, and then any amount
that was below 85% of the Goal is marked in red.
| | 01:01 | So as you can see, there were only
two months out of the year, March and
| | 01:06 | October, where sales were in the red.
| | 01:09 | But on the other hand, there were 1, 2, 3, 4
other months where sales were in the yellow.
| | 01:15 | The good news, of course, is that the
company did meet its goals six of the 12
| | 01:19 | months and those months
are all indicated in green.
| | 01:22 | Conditional Formats provide a useful
summary of how a business performs in
| | 01:25 | relation to its goals, but
they don't provide any context.
| | 01:29 | In other words, Petal could discover
whether sales for the current month met the
| | 01:33 | target amount, but she couldn't see
how sales had trended for the past year
| | 01:37 | without creating a separate chart.
| | 01:39 | Excel 2010 introduced Sparklines, a set
of small, compact charts Petal can use
| | 01:43 | to add context to her summary workbooks.
| | 01:47 | The first Sparkline, a line chart,
indicates how sales have increased and
| | 01:51 | decreased from month-to-
month over the past year.
| | 01:54 | So she moves to the Sparklines
group and then selects the data she wants.
| | 01:59 | The data she wants on another sheet, so
she goes to that another sheet, copies
| | 02:04 | the revenue and clicks OK.
| | 02:09 | The Sparkline just created provides the
context that the Conditional Format doesn't.
| | 02:13 | The Conditional Format in the other
table provides an instantaneous measure, but
| | 02:18 | this Sparkline indicates how sales
have trended over the past 12 months.
| | 02:21 | If we want to indicate whether the
sales team met their goals for each of the
| | 02:25 | past 12 months, we can create
what's called a Win/Loss Sparkline.
| | 02:29 | To do that, on the Insert tab,
click Win/Loss and select the data.
| | 02:37 | The date that you use for a Win/Loss
Sparkline needs to have either positive
| | 02:42 | or negative values.
| | 02:43 | Positive values are considered a win,
which means that they are placed on the
| | 02:46 | upper part of the Sparkline.
| | 02:49 | Negative values are considered losses and
are placed in the bottom part of the Sparkline.
| | 02:53 | You'll see what that looks like in a moment.
| | 02:55 | The data in the Difference column
here is perfect for a Win/Loss Sparkline,
| | 02:59 | because we have positive values, such
as for January and February, and negative
| | 03:03 | values such as the one in March.
| | 03:05 | We're ready to create the Sparkline, so
we can just click OK, and there you have
| | 03:08 | the 12-month Performance.
| | 03:10 | As you can see the company met its
sales goal six months out of the year but
| | 03:14 | fell short during the other six.
| | 03:16 | Now that Petal has Sparklines at her
disposal, she can summarize her data using
| | 03:20 | the three complementary methods.
| | 03:22 | The raw numbers present the results literally.
| | 03:24 | Second, Conditional Formats indicate
how the result compares to the goal.
| | 03:28 | And finally, Sparklines allow her
to see the last 12 months to put her
| | 03:32 | present results in context.
| | 03:34 | Taken as a group, the Numbers,
Conditional Formats, and Sparklines give Petal a
| | 03:38 | perspective that business
owners require to be successful.
| | Collapse this transcript |
| Customizing the Excel 2010 user interface| 00:00 | Kirk Hansel, one of the cofounders
of Hansel & Petal, asks his assistant
| | 00:04 | Timothy to manage the
company's Excel workbooks.
| | 00:06 | Timothy wants to customize the Excel
2010 user interface to suit his workflow.
| | 00:11 | To do that, Timothy will go into backstage view.
| | 00:14 | To move into backstage view, he clicks
the File button, which is new in Excel
| | 00:17 | 2010, and then clicks Options.
| | 00:21 | From within the Excel Options dialog
box, he can click Customize Ribbon to
| | 00:25 | display the Customize Ribbon page.
| | 00:27 | The first thing Timothy wants to do
is create a custom tab named 'document
| | 00:31 | prep' to bring all the controls he uses in
document preparation into the same workspace.
| | 00:36 | To do that, he clicks to the tab within
the list and then clicks Rename so that
| | 00:40 | he can change its name.
| | 00:42 | In this case, he'll change it to DocPrep.
| | 00:46 | Now that he's created his custom group,
he can start adding controls to it.
| | 00:50 | If he wants to add controls from an
existing Ribbon tab, he can do that by
| | 00:54 | clicking the Choose commands from
down arrow and selecting All Tabs.
| | 00:59 | If he wants to add the clipboard item
from the Home tab, he can display the
| | 01:02 | items on the Home tab, click
Clipboard and then click the Add button.
| | 01:06 | When he does, the clipboard
appears on his Custom tab document prep.
| | 01:10 | He can add other elements as well.
| | 01:11 | For example, he can add the Styles
group and from the Page Layout tab, he can
| | 01:18 | add Page Setup and Scale to Fit.
| | 01:21 | If he wants to add any items from the
File tab, such as printing, he needs to
| | 01:25 | display the File tab separately.
| | 01:27 | To do that, he clicks the
list again and clicks File tab.
| | 01:31 | Now he can go down, click Print
and he'll add it to his Custom group.
| | 01:38 | When Excel creates a Custom tab, it adds
a single custom group to it as well, so
| | 01:42 | that you can add any commands that you need.
| | 01:44 | So he clicks New Group, clicks Print,
clicks Add and the print controls will
| | 01:50 | appear in his new group.
| | 01:51 | If he wants to change the name of
that group, he can click New Group, click
| | 01:56 | Rename and then in the
Display name box, type a new name.
| | 01:59 | In this case, we'll just call it
Printing and Excel changes the name.
| | 02:04 | Now let's suppose that Timothy
wants to run Macros from the Ribbon.
| | 02:08 | He can do that, but he needs
to add the control separately.
| | 02:11 | First, he'll add the new group and
he'll change that group to the name of
| | 02:16 | 'Charting' and then display the Macros
that are available within this workbook.
| | 02:23 | The macro he wants to use is the only
one available, ApplyLineStyle, and the
| | 02:27 | Charting group is still available.
| | 02:30 | Clicks Add and the macro
appears where it's supposed to.
| | 02:33 | If he wants to give the ApplyLineStyle
macro a new icon on the Ribbon, he can.
| | 02:38 | All he needs to do is click it, click Rename
and select a new button from the Rename box.
| | 02:43 | He is done changing the ribbon for now,
so he can click OK, and the new tab
| | 02:50 | appears here on the Ribbon.
| | 02:51 | When you click it, you see all
of the controls that he added.
| | 02:54 | If he wants to run the ApplyLineStyle
macro, all he needs to do is click a Chart
| | 02:59 | and then click the ApplyLineStyle
button and Excel runs the Macro, applying the
| | 03:04 | style that he selected.
| | 03:05 | The ability to record chart-related
macros wasn't present in Excel 2007, but
| | 03:10 | in Excel 2010, you can record any chart
macro that you like and run it from the ribbon.
| | 03:15 | Now let's say that Timothy wants to
change the order of the items that he has on
| | 03:19 | his document prep custom tab.
| | 03:21 | For example, he uses the ApplyLineStyle
macro a lot less than he uses the other
| | 03:26 | controls, so he can move
that to the far right side.
| | 03:29 | To do that, he goes back into
backstage view, clicking File>Options>Customize
| | 03:34 | Ribbon and then in the list of tabs and
groups that are present on the Ribbon,
| | 03:38 | he can click the group he wants to move.
| | 03:39 | In this case, it is Charting.
| | 03:42 | Click the down arrow to move it to the
bottom of the group, and Excel makes the change.
| | 03:48 | If he wants to hide this Ribbon
entirely, he can, once again, customize the
| | 03:52 | Ribbon and clear the check
box next to his custom tab.
| | 03:57 | He can also hide any other
tabs that are on the Ribbon.
| | 04:00 | So let's say that he hasn't been using
the Add-Ins or Background Removal tabs.
| | 04:05 | If he clears the checkboxes next
to them and clicks OK, they go away.
| | 04:09 | Although Timothy would love to have
Excel 2010 provide the almost complete
| | 04:12 | control over the user interface he
had in Excel 2003, he can work with the
| | 04:16 | improved Ribbon
customization capabilities in Excel 2010.
| | 04:20 | The custom DocPrep Ribbon tab he
created makes it easier for him to find the
| | 04:24 | controls he needs when he is
preparing a document for distribution.
| | Collapse this transcript |
| Analyzing data with improved PivotTable capabilities| 00:00 | Petal Jones, one of the founders of
Hansel and Petal, uses PivotTables to
| | 00:04 | analyze her company's sales data.
| | 00:06 | She's collected all of her sales data,
which is spread out over several Excel
| | 00:10 | tables into a single Excel table,
from which she can discover insights that
| | 00:14 | help her analyze her business's performance.
| | 00:16 | Petal has used PivotTables since Excel
2002, but even the numerous advances in
| | 00:21 | Excel 2007 left out a few
capabilities she wish she had at her disposal.
| | 00:25 | One of the most common notes that she
received after her presentations was that
| | 00:29 | the onlookers could never remember which
items were included in or excluded from
| | 00:33 | a filter, because only the values
present in the PivotTable, usually displayed
| | 00:37 | in very small type, provided any
visual evidence of what was in or out.
| | 00:41 | In Excel 2010, Petal uses slicers to
create filters and indicate which values are
| | 00:46 | included in, or excluded from, a PivotTable.
| | 00:49 | To create a slicer, we select any
cell in the PivotTable, click Options and
| | 00:55 | then click Insert Slicer and select the
field on which you want to filter using a slicer.
| | 01:02 | In this case, we want to filter by region.
| | 01:04 | So I will click Customer Region and click OK.
| | 01:09 | When I do, a slicer with all of
the available regions appears.
| | 01:13 | If I only want to see sales from Region no.
| | 01:14 | 1, I can click number 1 and when I do,
Excel limits the items displayed in the
| | 01:20 | PivotTable to just that region.
| | 01:22 | If I want to change to Region
6, I click 6 and there it is.
| | 01:25 | If you want to select multiple regions or
multiple items at the same time, you can.
| | 01:30 | You can do so using a
combination of the Ctrl and Shift keys.
| | 01:33 | For example, if I wanted to select
Region 6 and Region 2, I can select Region 6,
| | 01:40 | as I have here, hold down the
Ctrl key and then click Region 2.
| | 01:45 | When I release the Ctrl key, Excel displays
all the sales for Region 2 and for Region 6.
| | 01:51 | If I want to select only Regions 1
through 3, I can click Region 1 and then
| | 01:57 | holding down the Shift key, click Region 3.
| | 02:01 | When I do, Excel adds Region 1 and
Region 3, which I clicked, and also Region 2,
| | 02:06 | which was between Regions 1 and 3 in the slicer.
| | 02:09 | If I want to get rid of the filter
entirely, I can click the Clear Filter button
| | 02:13 | here at the top-right corner of the
slicer and if I want to get rid of the
| | 02:16 | slicer, I can right-click it and click Cut.
| | 02:20 | If you want to change the
formatting of the slicer, you can do so.
| | 02:24 | Let's say, for example, that I want to filter
using a slicer that is based on the OrderMonth.
| | 02:33 | If I wanted to change the formatting of
my slicer, I can select a slicer style.
| | 02:37 | To do that, you click the slicer and
then, in the Styles gallery here, you'll
| | 02:42 | select the style that want.
| | 02:44 | I'll go for something a little bit
darker and something that contrasts to the
| | 02:47 | colors in the PivotTable, such
as the style here with orange.
| | 02:51 | Now my slicer is definitely visible.
| | 02:53 | If I wanted to see sales that occurred
during January, I can click January and
| | 02:58 | Excel applies the filter.
| | 02:59 | Again to clear it, click Clear
Filter and to get rid of the slicer,
| | 03:03 | right-click it and click Cut.
| | 03:05 | Another way that we can limit the data
that appears in Excel 2010 PivotTables is
| | 03:10 | to use what is called a Search Filter.
| | 03:12 | Previously, you could filter based
on items or based on certain rules.
| | 03:16 | For example, if you wanted all sales
after 2007, you could create that kind of
| | 03:21 | rule but it was very difficult to
find items within a PivotTable list.
| | 03:26 | So let's say that I wanted to
filter based on the names of plants.
| | 03:31 | In this case, Hansel & Petal carries two
different varieties of rosebushes and I
| | 03:35 | know from experience that those
names have Rosa at the front of them.
| | 03:40 | So if I want to filter based on
product names, all I need to do is create a
| | 03:44 | filter that searches for Rosa, R-O-S-A.
| | 03:49 | To create the product name filter,
click the Down arrow and then, in the
| | 03:53 | search box, type 'Rosa'.
| | 03:57 | When I do, Rosa "Burgundy"
and Rosa "Iceberg" appear.
| | 04:00 | Those are the items that I
want and they're already selected.
| | 04:03 | So they will appear in the
PivotTable, click OK and there you have it.
| | 04:08 | I'll get rid of some of these other row
labels, such as the Region, and we'll get
| | 04:13 | rid of the Year, so that we just see
sales for the Burgundy and the Iceberg
| | 04:19 | rosebushes for each month.
| | 04:22 | If we want to create a chart in Excel
2010 that uses this PivotTable data, we
| | 04:27 | can create a pivot chart.
| | 04:29 | To do that, click any cell in the
PivotTable, on the Insert tab, click the type
| | 04:33 | of chart you want to create.
| | 04:35 | In this case, I'll just create a
column chart and there it appears.
| | 04:39 | Now this chart isn't laid out particularly well.
| | 04:41 | So what I will do is I will change the
order of the fields on the horizontal
| | 04:45 | axis, so that we get the product name
first and then the order. There we are.
| | 04:50 | Now we can see our Burgundy and
Iceberg sales based on each month and if I
| | 04:55 | want, I can expand the chart, so that
we get the names of each of the months,
| | 04:59 | visible within the chart.
| | 05:01 | Pedal Jones' sales analysis relies on
the flexibility of PivotTable, which she
| | 05:05 | can use to rearrange her data to
emphasize the aspects of her data that she
| | 05:09 | finds to be most important.
| | 05:11 | The new capabilities in Excel 2010
enable her to present her data more
| | 05:15 | visually, find the specific data she
wants to work with and summarize her data
| | 05:19 | using more advanced pivot charts than
were available in previous versions of
| | 05:23 | the program.
| | Collapse this transcript |
| Summarizing data visually| 00:01 | As the business has grown, Hansel &
Petal have revised their product pulling
| | 00:04 | procedures to make them more efficient.
| | 00:06 | While the current process is simply a
reordering of the previous steps the order
| | 00:10 | runners were expected to take, it is
different enough that the owners wanted to
| | 00:14 | distribute a document that contains a
summary of the steps and a conceptual
| | 00:17 | diagram indicating how the greenhouse
and nursery areas are grouped together.
| | 00:22 | When the owners analyze their old
process, they realize that the runners, the
| | 00:26 | employees who went out into the
greenhouse and nursery to pull products for
| | 00:28 | orders, weren't taking efficient routes.
| | 00:31 | When Hansel & Petal designed the new
process, they had a consultant build a
| | 00:34 | program that would analyze the incoming
orders and set a route that would allow
| | 00:38 | the runner to take the most efficient
path possible through the greenhouse and
| | 00:41 | nursery and without overloading their cart.
| | 00:44 | The diagram here on the left shows the
way that the greenhouse and nursery and
| | 00:48 | packing area are laid out.
| | 00:50 | The Shrubs and Container Plants are
out in the nursery and the Herbaceous
| | 00:54 | Perennials and Cacti &
Succulents are in the greenhouse.
| | 00:58 | The owners created this SmartArt diagram
to indicate the way things will be laid out.
| | 01:03 | To illustrate the new process, the
owners created a new SmartArt image.
| | 01:06 | On the Insert tab, they just clicked SmartArt.
| | 01:09 | The process is a cycle, meaning that
it repeats and they used their favorite
| | 01:14 | Block Cycle diagram.
| | 01:16 | The basic diagram that they
selected has five items, which is correct.
| | 01:19 | The process they're
describing has exactly five steps.
| | 01:22 | With the diagram in place,
they can start adding text.
| | 01:26 | First item and the second and
they're just changing the text.
| | 01:31 | All you do is click on a block and start typing.
| | 01:38 | Finally, unload cart and once the
cart is unloaded, they can start the
| | 01:43 | process all over again.
| | 01:45 | Rather than stay with this simple blue
diagram, we can change the color so it
| | 01:48 | fits in with a Hansel &
Petal corporate color scheme.
| | 01:51 | To do that, you right-click any of the
boxes, click Format Shape and then click
| | 01:56 | Solid Fill, which is already selected
because the box does have a solid fill.
| | 01:59 | Go to Color and select the
color that you want to use.
| | 02:03 | This workbook has already had a number
of colors applied so we can select one of
| | 02:07 | the recent colors and I will select Lime.
| | 02:11 | Click Close, go to the next shape,
click Format Shape, Solid Fill, click the
| | 02:16 | color and we'll use blue, very
close to the blue that we have there.
| | 02:21 | And because the Format Shape dialog
box is what's called a modal dialog box.
| | 02:26 | You don't have to close it, if you
want to use it for another shape.
| | 02:29 | So for example, after I click this shape,
I can click this shape and the dialog
| | 02:33 | box changes to reflect the settings for
the block that I've currently selected.
| | 02:38 | So now I can change to another color,
click another box, select another color,
| | 02:46 | click the final box, click the
final color and now click Close.
| | 02:52 | The company has been using the new
procedure in a limited way for the past three
| | 02:55 | months and they've collected some data
that shows how much better this process
| | 02:59 | is working than the previous process.
| | 03:02 | That data is contained on sheet number one.
| | 03:05 | This table, the Shipping Times table,
contains all the packing times for the
| | 03:09 | orders that were created since January 4, 2007.
| | 03:14 | The table on the right contains the
average time for each of those months.
| | 03:17 | To illustrate how much more effectively
things are working under the new system,
| | 03:21 | we can create the chart that shows
how the packing time has decreased.
| | 03:25 | If we are looking for just the
individual orders, we can create a chart,
| | 03:28 | clicking any cell on the table
and creating an XY scatter chart.
| | 03:34 | The XY scatter chart gives an individual
data point to each measure within the table.
| | 03:39 | So for example, if we looked closely
enough, we could find the dot in this XY
| | 03:43 | scatter chart that corresponds to the
number 42, which was the packing time.
| | 03:47 | You'll see that for the first several
hundred orders, or 150 orders, packing
| | 03:52 | times average around 50.
| | 03:54 | After they revised the process for the
first time, packing times were anywhere
| | 03:58 | from about 40 until 13 minutes, but then
under the new system, which started very
| | 04:03 | recently, packing times
have come down dramatically.
| | 04:06 | If you want to see how those times work as
an average, then you can create a line chart.
| | 04:12 | To do that, you use the data on the
right side and then on the Insert tab, click
| | 04:17 | Line and click the type of chart that you want.
| | 04:20 | This chart appeared very quickly
as did the previous XY scatter chart.
| | 04:24 | Charts in Excel 2010 are much more
efficient and appear and are re-rendered
| | 04:28 | much more quickly than it
was possible in Excel 2007.
| | 04:32 | For example, if I want to move this
chart to its own chart sheet, I can click
| | 04:37 | the chart and then click Move
Chart and select a new chart sheet.
| | 04:41 | When I click OK, the chart appears
there and again, the rendering is smooth,
| | 04:46 | seamless, and very quick.
| | 04:48 | The new plant pulling procedure
has increased the order renders
| | 04:51 | efficiency significantly.
| | 04:53 | When the runners aren't gathering
products for the company's web and mail
| | 04:55 | orders, they are free to help customers
visiting the store or who call in with a question.
| | 05:00 | The less time the runners spend
pushing heavy carts, the more time they can
| | 05:03 | spend with the store's customers.
| | Collapse this transcript |
| Pasting data and formatting with precision| 00:00 | Petal Jones received a note from a
regional sales representative indicating that
| | 00:04 | hydrangeas were selling very
well for another mail order company.
| | 00:08 | Hansel and Petal doesn't
currently offer hydrangeas by mail order,
| | 00:11 | so we're pulling the sales rep's
data into a workbook for analysis.
| | 00:14 | The first thing we'll do is copy the
data from the other workbook into this
| | 00:19 | NewProductReports workbook.
| | 00:20 | So we're just going over here and I
will copy the headers, press Ctrl+C, shift
| | 00:27 | back to the other workbook and now I
can paste in what I have just copied.
| | 00:32 | In previous versions of Excel, we
would've had to try a bunch of different paste
| | 00:37 | options to see which one we wanted.
| | 00:38 | But instead, in Excel 2010, we can use what's
called Paste Preview or Paste Live Preview.
| | 00:44 | To do that, we click the Down Arrow of
the Paste button on the Home tab of the
| | 00:48 | Ribbon and then hover the mouse
pointer over one of these icons, which shows
| | 00:52 | us, without actually doing the paste
what the data will look like when we
| | 00:56 | paste it into the worksheet.
| | 00:57 | So for example, if I wanted to paste it
normally, I could hover over this icon.
| | 01:02 | If I wanted to only paste
the formulas, I could do that.
| | 01:05 | If I wanted to paste it and keep the
source formatting, I could do that.
| | 01:09 | In this case, what I want to do is paste
in the values along with the formatting
| | 01:13 | and keeping column width.
| | 01:14 | To do that, I hover over this icon,
which is the Keep Source Column Widths icon,
| | 01:19 | click it and Excel finishes
the paste operation for me.
| | 01:23 | If I thought that I saw something I
liked, but I realize that I want to do it
| | 01:26 | over, I can click the Paste Options
button here at the bottom right side, and I
| | 01:31 | get my palette back, and I can paste
any of the other options that I want here.
| | 01:35 | If I want to get rid of the palette,
I can either click up here, or I can
| | 01:39 | press the Escape key.
| | 01:41 | I can also copy the data from the
previous worksheet onto this worksheet.
| | 01:45 | So switching back to the other
document, I can select those cells, press
| | 01:50 | Ctrl+C to copy, switch back over to
the other window and paste. I can either
| | 01:57 | paste the values only, paste the
values with number formatting or paste the
| | 02:01 | values with all formatting.
| | 02:03 | In this case, there is no difference
because I only had number formatting in
| | 02:06 | those cells, so I'll select this option.
| | 02:10 | Now that I have the data in the worksheet,
I can add an image of a hydrangea flower.
| | 02:14 | To do that, I can insert the picture, click
the file I want to add and then click Insert.
| | 02:20 | When I do, the photo appears on my screen.
| | 02:23 | The photo is quite large, so I'll
change the Height down to 2 inches and Excel
| | 02:30 | changes the Width automatically
to match the change in height.
| | 02:33 | Now that the image is small enough for
me to work with all at one time on the
| | 02:36 | screen, I can remove the image's background.
| | 02:39 | In other words, I want to focus on the
hydrangea flowers themselves and get rid
| | 02:43 | of the green leaves in the back.
| | 02:45 | To do that, I select the image and then
on the Picture Tools, Format custom tab
| | 02:49 | of the ribbon, I can click
the Remove Background button.
| | 02:52 | When I do, Excel analyzes the image and it
separates the foreground from the background.
| | 02:58 | In this case, everything looks to be correct.
| | 03:00 | So I can click the Remove Background
button again and Excel removes the background.
| | 03:05 | But notice that the image is
still the same size as it was.
| | 03:10 | In other words, even though the
background is clear, it is still
| | 03:12 | technically part of the image.
| | 03:14 | If I were to drag one of the handles
on the side, I would resize the entire
| | 03:18 | image, I wouldn't take away
any of the blank space around it.
| | 03:21 | I'll undo the change I just made.
| | 03:23 | If I want to eliminate those null areas
from the background of the image, then
| | 03:27 | I can crop the image.
| | 03:29 | To do that, select the image, again
on the Format tab, I can click Crop.
| | 03:34 | When I do, Excel displays
crop handles around the image.
| | 03:38 | I can move my mouse pointer over
one of the controls to drag them.
| | 03:41 | In this case, I'll move in from a corner,
so I'm affecting the bottom and right
| | 03:47 | side at the same time and I'll do the
same thing for the other three corners.
| | 03:52 | And in this case, actually I can just
drag in from the left side so I already
| | 03:56 | have my top and bottom set and there we are.
| | 04:00 | When I'm done, I can click Crop, and
Excel reduces the image to a manageable size.
| | 04:05 | Rather than have the image set by itself though, I
would like to add a little bit of flair to it.
| | 04:10 | So I'll change the picture style.
| | 04:12 | To do that, with the image selected,
go up to the Picture Styles gallery and
| | 04:18 | select the style that I want to add.
| | 04:20 | I will add a black matte frame, click it
and Excel provides the matte around the side.
| | 04:26 | The black matte, to me, is a little bit
overwhelming, especially when you consider
| | 04:29 | the other colors that are being
used in the worksheet right now.
| | 04:32 | So what I'll do is I will keep the
interior black, but I'll change the outlying
| | 04:37 | border to a slightly softer
color, such as a dark gray.
| | 04:41 | To do that, I can click Picture
Border and select a new color.
| | 04:48 | The new Paste Preview feature in Excel
2010 helps you determine how data will
| | 04:52 | appear when you paste it into a
workbook without the drudgery of finishing the
| | 04:56 | paste and then undoing the
operation and trying another option.
| | 04:59 | In addition, the new image editing
tools enable you to make changes that
| | 05:03 | normally would have required
you to open another program.
| | 05:06 | You can't do everything in Excel 2010
that you could do in a dedicated image
| | 05:10 | editing program, but the new
capabilities let you stay in Excel and work
| | 05:14 | more efficiently.
| | Collapse this transcript |
|
|
