Microsoft Excel

2.1 Opening Microsoft Excel 2.2 Microsoft Excel Startup Screen 2.4 Introduction to the Excel Interface 2.5 Customizing the Excel Quick Access Toolbar 2.6 More on the Excel Interface 2.7 Understanding the Structure of an Excel Workbook 2.8 Saving an Excel Document 2.9 Opening an Existing Excel Document 2.10 Common Excel Shortcut Keys 3.1 Entering Text to Create Spreadsheet Titles 3.2 Working with Numeric Data in Excel 3.3 Entering Date Values in Excel 3.4 Working with Cell References 3.5 Creating Basic Formulas in Excel 3.6 Relative Versus Absolute Cell References in Formulas 3.7 Understanding the Order of Operation 4.1 The structure of an Excel Function 4.2 Working with the SUM() Function – Excel 4.3 Working with the MIN() and MAX() Functions 4.4 Working with the AVERAGE() Function 4.5 Working with the COUNT() Function 4.6 Adjacent Cells Error in Excel Calculations 4.7 Using the AutoSum Command 4.8 Excel’s AutoSum Shortcut Key 4.9 Using the AutoFill Command to Copy Formulas 5.1 Moving and Copying Data in an Excel Worksheet 5.2. Inserting and Deleting Rows and Columns 5.3. Changing the Width and Height of Cells 5.4 Hiding and Unhiding Excel Rows and Columns 5.5 Renaming an Excel Worksheet 5.6. Deleting an Excel Worksheet 5.7 Moving and Copying an Excel Worksheet 6.1 Working with Font Formatting Commands 6.2. Changing the Background Color of a Cell 6.3. Adding Borders to Cells 6.4. Formatting Data as Currency Values 6.5. Formatting Percentages 6.6. Using Excel’s Format Painter 6.7. Creating Styles to Format Data 6.8. Merging and Centering Cells 6.9. Using Conditional Formatting 7.1 Inserting Images and Shapes into an Excel Worksheet 7.2 Inserting Shapes In Excel 7.3 Formatting Excel Shapes 7.4. Working with Excel SmartArt 8.1. Creating an Excel Column Chart 8.2. Working with the Excel Chart Ribbon 8.3. Adding and Modifying Data on an Excel Chart 8.4. Formatting an Excel Chart 8.5. Moving a Chart to another Worksheet 8.6. Working with Excel Pie Charts 9.1. Viewing your Document in Print Preview 9.2. Changing the Margins, Scaling and Orientation 9.3 Adding Header and Footer Content 9.4 Printing a Specific Range of Cells 10.1. Intro to Excel Templates 10.3. Opening an Existing Template 10.4. Creating a Custom Template 13.1 Understanding Excel List Structure 13.2 Sorting a List Using Single Level Sort 13.3 Sorting a List Using Multi-Level Sorts 13.4 Using Custom Sorts in an Excel List 13.5 Filter an Excel List Using the AutoFilter Tool 13.6 Creating Subtotals in a List 13.7 Format a List as a Table 13.8 Using Conditional Formatting to Find Duplicates 13.9 Removing Duplicates in Excel 14.1 Excel DSUM Function Single Criteria 14.2 Excel DSUM Function with OR Criteria 14.3 Excel DSUM Function with AND Criteria 14.4 Excel Function: DAVERAGE() 14.5 Excel Function: DCOUNT() 14.6 Excel Function: SUBTOTAL() 15.1 Creating an Excel Data Validation List 15.2 Excel Decimal Data Validation 15.3 Adding a Custom Excel Data Validation Error 15.4 Dynamic Formulas by Using Excel Data Validation Techniques 16.1 Importing Data from Text Files into Excel 16.2 Excel 2019

8.2. Working with the Excel Chart Ribbon

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 place empty down there, I have now got two new tabs at the top of my Screen, Design and Format and I think I double clicked on there so it gave me this format chart area and it, closed that we do not need that right now.

So just like in the chart. Two new tabs from the two new tabs, this is my chart tools ribbon.

I have got some design options that I can get into, I have got some formatting options. This is where you will find all the features that deal with your chart. Now I want to show off a couple of them here. Couple of the features. And we will talk about a few others as we continue through this discussion of charts.

Now first off, I have got a chart title and the range, All it says is chart title that is not very descriptive, This should say monthly budget. I am just going to click where it says chart title, I will go into there, highlight that text and I am just going to call this monthly budgets. Now the chart title was given to me by default the chart title itself is a chart option. It is something you could turn on and off and if with my chart selected I will go back to the Design tab, I do have some options to change the way my chart looks to change the way my title looks as well as other operations.

I can go to the little plus sign and site here I will find all sorts of elements of the chart, One of them is chart title.

Working with the Excel Chart Ribbon 1

Now something else you can do whether it is on the Layout tab or in the plus sign deals with the legend, I like the ledge and I want to keep it out there but I do not like it at the bottom, I want to put it at the top. Typically, when I read a chart it is kind of top to bottom, So I want to start at the top see the legend and then see the data. Something small but I just like the flow better this way. Then, in the plus side or the Layout tab will find the Legend, go a little arrow here and I am going to tell it to put it at the top.

Layout tab you will find something similar to the plus sign you will see chart elements with all the options chart titled, data chart and so on.

So, save little set up just found on the Layout tab rather than the plus sign.

Now something else you can do whether it is on the Layout tab or in the plus sign deals with the legend, I like the ledge and I want to keep it out there but I do not like it at the bottom, I want to put it at the top, Typically when I read a chart it is kind of top to bottom. So, I want to start at the top see the legend and then see the data. Something small but I just like the flow better this way.

So in the plus side or the Layout tab will find the legend, go a little arrow here and I am going to tell it to put it at the top, Now I have got my legend there at the top of my chart.

Working with the Excel Chart Ribbon 2

These are simple little changes whether it is your title or the legend or some other feature.

But we are trying to manipulate the chart to make it more accessible. It is a visual element and the quicker the users can glance at the chart and recognize the data and make those business intelligent decisions based on what we are presenting the better off we are going to be So think about how you want to leave or chart out what options do we want. There is a whole slew of stuff that you can mess around with here. I could spend an hour just talking about charts and all the features that are involved instead of a chart. But let us talk about just one more thing here and this is something that I want to point out more because I want to show you that you know what. Even though you have all these features you want to be careful about how much you add to the chart.

Once again, we do not want to make it too cluttered, We still want to make it accessible and readable.

Try it out. Poke around see what different options you have here. Try manipulate your chart, adding some of these chart elements.