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

7.4. Working with Excel SmartArt

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 through basic shapes, this is called Smart Art.

Through Smart Art. We can create very fancy diagrams through a couple of simple clicks of our mouse.

I am going to go up to Insert tab top of my screen on the Insert tab We saw illustrations earlier. We had pictures online pictures we had Excel shapes that is where you got some of your basic shapes.

Now in the past if I want to create something like an org chart or maybe a process flow diagram, I would have to use basic shapes and really start to diagram this myself create all the rectangles in the organization chart create the connector lines, It was a huge hassle. Now, Right below the Excel shapes, I have Smart Art and Smart Art are some canned out-of-the-box fancy diagrams.

I will click on Smart Art icon to open Smart Art graphic window. And I have got all these different categories of Smart Art, that I can pick from fancy little diagrams.

I am going to go to a process, and I have got all these process diagrams. I can pick from. I am going to grab this kind of do not circle one here. It is called The Circle X timeline.

So, I got some type of process that I wanted to demonstrate to my users over some timeline through this Smart Art graphic are selected.

Working with Excel SmartArt 1

I can now diagram this process this timeline process through these nice graphical shapes that give

I can now diagram this process this timeline process through these nice graphical shapes. that give me this nice little table here on the left, I can start to manipulate the shapes and the content within those shapes. I would say something like oh you know, if I am going through a document approval process this is over some period. So, my first step in getting a document approved is I got to create the document.

Working with Excel SmartArt 2

Now, this diagram gave me two major steps. However, you know what I think, I need a third one in this creation and approval of the document.

So what I am going to do is after you collect responses ass responses, I will hit my Enter key, this creates a third additional subset, but I do not want to that subset, I want the next major step. up above I have got some additional tools with the smart select that I get two new tabs design and format on the design tab underneath create graphic, I have got the one sublets selected but I am going to promote it, I am going to move it up in the hierarchy.

Working with Excel SmartArt 3

And now I have got a next major step and we will call this line final approval.

I have got this fancy diagram that, I could have created through the simple shapes that we were talking about earlier, but this is streamlined.

Now if you want to do some formatting with this you got all sorts of formatting options. I mean it is like the border. Not a specific shape but just the border. I will go up to my design tab and here I got smart art styles and you got all sorts of styles to pick from and just hover my mouse over the top of these, they are pretty slick.

Working with Excel SmartArt 4

That is a slick one if you want to get into the nitty gritty of formatting your shapes. You are smart are all by yourself.

Working with Excel SmartArt 5

You not to use styles all of those are quick and dirty and just right away you can format your shape but you can also go to the Format tab and you can do all your formatting to your heart’s content.

Try it out. Use a style or maybe hop over to the Format tab and format it on your own.