7.2 Inserting Shapes In Excel

Inserting Excel Shapes 5

We are talking about inserting additional elements into an Excel document. We just saw images those two little images there at the top. Now we want to take-a-look at what is called Excel shapes. Through Excel shapes We have all sorts of shapes that we can add to an Excel …

Read More »

6.9. Using Conditional Formatting

Using Conditional Formatting 2

Like I said this document is really coming together very presentable very professional and clean looking, Now I am going to give you a scenario here. This is probably something that you have done before in the past or perhaps you watch somebody do this. Have you ever printed out …

Read More »

6.8. Merging and Centering Cells

Merging and Centering Cells 2

This document has really come a long way since we started building it. It used to just be a blob of numbers out there, just black text floating inside this Excel worksheet. We have really started to spice it up with colors and borders and background colors, Formatting this document. …

Read More »

6.7. Creating Styles to Format Data

Creating Styles to Format Data 3

Now the next operation that I want to perform here has a similar concept, think of formatting when you format something. There is a number of options that you can perform, I could change the font the color of the font the background and borders the font size, Italicize it …

Read More »

6.6. Using Excel’s Format Painter

Using Excel's Format Painter 1

The next option, I want to take-a-look at it here is going to help streamline your efforts as you formatted document especially really large documents. We are going to talk about the format painter. Now I want to point out that the format painter is exclusive to Excel, You will …

Read More »

6.5. Formatting Percentages

Formatting Percentages 1

In the previous lecture we are talking about formatting numeric values numeric values as currency. But I also talked about that you know what we have some percentages here, and when I did the wrong calculation, I got a percentage but it is a decimal percentage and I want to …

Read More »

6.4. Formatting Data as Currency Values

Formatting Data as Currency Values 2

So, way back in the earlier discussions we are talking about different types of data that you can add to an excel worksheet. You add text you had numeric data you had dates you had functions and formulas. Now I want to revisit the idea of the numbers, we have …

Read More »

6.3. Adding Borders to Cells

Adding Borders to Cells 4

I start talking about how through formatting you can start to create separation in the different areas of content that you have in your Microsoft Excel worksheet. I added background colors to really create separation. Now I am going to add to this idea of creating separation based on our …

Read More »