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 »7.1 Inserting Images and Shapes into an Excel Worksheet
Welcome to the next section of this Excel for Beginners book during this section, we are going to take-a-look at inserting additional elements such as images into your Excel documents. Now I do want to put another disclaimer on this section, I love images. They add a lot of visual …
Read More »6.9. Using Conditional Formatting
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
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
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
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
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
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
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 »6.2. Changing the Background Color of a Cell
The formatting that we have so far dealing with the font is only one aspect of formatting, and it is a small one. We just made something bold and change the font size. Now we have also got colors that we can throw into the mix as well not just …
Read More »