Home / admin (page 4)

admin

8.2. Working with the Excel Chart Ribbon

Working with the Excel Chart Ribbon 2

Now, I mentioned several lesson ago way back when we are talking about the Excel interface, we were talking about the ribbon the standard ribbon you got home Insert Page Layout and so on but the ribbon is very dynamic. For example, if I select my charts just cooking some …

Read More »

8.1. Creating an Excel Column Chart

Creating an Excel Column Chart 1

Welcome to the next section of this Excel for Beginners book, during this section we are going to talk about our simple little spreadsheet here, something that is a bunch of numbers and tags and turning it into something much more graphical. We are going to talk about charts. Now …

Read More »

7.4. Working with Excel SmartArt

Working with Excel SmartArt 5

When Microsoft Office 2007 is released Microsoft introduced a new feature inside of Excel, Word and PowerPoint. This is a feature that prior to 2007 none of the Office applications had. And this deals with creating more complex diagrams through basic shapes, And this deals with creating more complex diagrams …

Read More »

7.3 Formatting Excel Shapes

Formatting Excel Shapes 2

All right so I have got a couple of Excel shapes out there on my document. Simple shapes nothing big. I have got a rectangle round the corner rectangle and I have got an arrow, Like I said nothing big. But now let us take-a-look at some of the formatting. …

Read More »

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 »