Class 10 - Objective Domain Section 5 - Create Charts and Objects | David Murphy | Skillshare

Playback Speed

  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x

Class 10 - Objective Domain Section 5 - Create Charts and Objects

teacher avatar David Murphy, University Lecturer

Watch this class and thousands more

Get unlimited access to every class
Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

Watch this class and thousands more

Get unlimited access to every class
Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

Lessons in This Class

11 Lessons (32m)
    • 1. Class Introduction

    • 2. 5.1.1 Create a New Chart

    • 3. 5.1.2 and 5.1.3 Add Additional Data

    • 4. 5.1.4 Analyse Data using Quick Analysis

    • 5. 5.2.1 Resize Charts

    • 6. 5.2.2 Add or Modify Chart Elements

    • 7. 5.2.3 and 5,2,4 Apply Chart Styles and Move Charts

    • 8. 5.3.1 Insert Text Boxes and Shapes

    • 9. 5.3.2 Insert Images

    • 10. 5.3.3 Modify Object Properties

    • 11. 5.3.4 Add Alternative Text for Accessibility

  • --
  • Beginner level
  • Intermediate level
  • Advanced level
  • All levels
  • Beg/Int level
  • Int/Adv level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.





About This Class


Class 10 - Objective Domain Section 5 - Create Charts and Objects

This is the tenth and final class in a series of classes designed to prepare you to take the 77-727 MOS (Microsoft Office Specialist) exam in Core Excel. 

If you are a complete beginner then you should review all of the lectures. 

If you have some level of beginner or intermediate skills in Excel, then you might want to attempt the set project first and discover the gaps in your skills. These can then be addressed by reviewing the lectures.

So this series of classes is designed for everyone who wants to get independent certification of their Excel skills.

This class covers section 5 of the Objective Domain for the 77-727 exam.

In addition, if you want to test yourself under exam conditions, then a further set of classes will be available (77-727 Practice Exams and Video Solutions) which provide you with 3 practice exams, comprising 105 project tasks, with which you can test yourself under exam conditions and time constraints. A full set of video solutions are available with these classes also.

When you complete this series of classes you will be fully prepared to obtain this valuable certification and obtain independent certification of your Core Excel skills from Microsoft, a qualification that is highly valued throughout the world.

Meet Your Teacher

Teacher Profile Image

David Murphy

University Lecturer


With over twenty years experience as a systems analyst and project manager with significant experience in the design and implementation of major projects for some of the worlds largest companies, Dave Murphy changed career track in 2000 and has been a professional university educator for over eighteen years. His main interests are in Microsoft Certifications, Project Management and Business Process Analysis. Dave has a B.Sc (Hons) from Trinity College Dublin and an M.Sc Degree in Computing. In addition to obtaining PRINCE2 Practitioner status, Dave is also a Microsoft Certified Professional in Managing Projects with Microsoft Project, has multiple Microsoft Office Specialist certifications and is a MOS examiner.

See full profile

Class Ratings

Expectations Met?
  • Exceeded!
  • Yes
  • Somewhat
  • Not really
Reviews Archive

In October 2018, we updated our review system to improve the way we collect feedback. Below are the reviews written before that update.

Why Join Skillshare?

Take award-winning Skillshare Original Classes

Each class has short lessons, hands-on projects

Your membership supports Skillshare teachers

Learn From Anywhere

Take classes on the go with the Skillshare app. Stream or download to watch on the plane, the subway, or wherever you learn best.


1. Class Introduction: Hi, My name's Dave Murphy Anime University lecture myself certified professional on a mosque examiner. This is wool class in a series of classes designed to prepare you to take the Microsoft certification exam. Examine 77 77. In Core Excel, the class is arraigned of people who are relatively new to excel on, particularly at beginners. However, if you're already in Excel User and would like to get official recognition for your skills , then this is the right class for you. If you're starting to learn except from scratch, I've included lectures in class War with Siri's, which will introduce you to accept to the Excel User interface had to navigate within excel until information is entered. Worksheets. If you have some familiarity with software, then you can skip the introductory lectures and go directly to the lectures on the specific elements of the curriculum court. In each class, which Microsoft called the objective domain, I've structured each class of that. You can go directly to the project and test your skills. That way. You know what it is that you have to brush open in order to get a little certification. The most important piece of information that you need to review at this point is the objective domain for the exam. This is a corrected and provided by Microsoft, and you need to ensure that you're proficient and every element of that objective domain. If you are to succeed in the exam, I've included a pdf off the objective remain with the project for this class so printed down have available as recovery rejection off the objective remain completely exercise. You can take each one off as completed. Looking at the contents, you can see that the objective remain is divided into five main sections and that each section have forever silt sections 1.11 point 21.3 and so on. Each of the classes in this series covers one or more elements off the objective domain on the lectures air number to indicate which L'm is being covered. The class projects are specific to the skill within that section of the demand covered in class. The most exams, based on real practical experience with software in this case itself, has to be used during the test, their normal with choice type questions. It's real experience with the product that being examined So if you pass than people know that you're proficient in the level which is being tested, they can be sure of your skills. Some of you may believe that your skills in a particular aspect of the objective remains a strong enough to pass already on that. You don't need to call me the lecture material. If so, fine. Just go to the exercises, calling techniques with that part of the off the domains on test your skills. Gaining more certification is a real advantage on a great way to enhance your CV. It's the number 1 90 certification in the warmth, with over a 1,000,000 exams taken every year. These classes will ensure success and gain that qualification. So go ahead and give yourself on edge in the market place. Get certified. 2. 5.1.1 Create a New Chart: pictures worth the heaven words. That chart is a pictorial representation of the day you enter in a worksheet. Very often, the chart can get more descriptive way of representing your data. As a result, the viewing information provided by a spreadsheet may find it easier to examine. Understand the chart rather than many rows and columns of numbers. The pictorial representation of the data will often help identify trends or patterns we should otherwise remain hidden. Charts can easily be crazy by using the ribbon on the insert term. In the charts group, there are several buttons to select the chart that you want to create. However, before you can chart any data, you must select the date of first. So looking at the helpless mark helpless airlines marketing plan budget. I'd like to see these days of the charge. So I select the information on notice that I'm leaving the title out and now a conflict insert and go to the recommended chart area. This dialogue box appears with a set of charges are very common in you. For these type of data on you get a small preview of the chart as you click on the possible selections. Let's like this one and see the effect so you can see that there is a separate color bar representing each year and that the height of each bar represents the value of the spend in each category. If this set of charts doesn't meet your needs, the full set of chart types on layers are available in the all charities term of the dialogue box. Alternatively, each of the chart types can be selected directly from the ribbon on the insert tub in the charts group, except provides a very large range of chart chart options and can display worksheet information in a variety of ways, incorporating funds, pattern symbols, graphics and tree dimensional effects. The charts Horizontal axes, also known as the X axis, is okay that the bottle of the charge on the vertical axis, also known as the Y axis, is okay that the left or right hand side of the chart you can change pretty much on the aspect of the formatting and titles of the charge you create. I would explore all of the possible modifications in a later lecture. In this section of the course, Excel will automatically include a legend with the chart to explain the meaning of each line in the line chart or a column in the car in charge. Although you can remove the legend, it may be helpful to others to retain it. If your chart has more than one day's, A Siri's so crazy a chart is a simple of selecting deserves contained the days you want the chart. I'm clicking the desired chart type. Once the chart appears in the worksheet, you also see two different times for the chart tunes that you can use to create or modify chart elements. I was like liquid. In this chart, you can see that the individual elements of the chart can be selected. For example, I construct the title its own Onda Manders. This is true of most terms of the charts you create on Recover all of this in detail later on 3. 5.1.2 and 5.1.3 Add Additional Data: new days of syriza categories could be attitude work, eat at any time, but the chart may not be automatically update er's. So if I add in addition kind of days are representing 2017 you concede that the charge remains the same. To update the charge, you can do the following with the charts selectors on the chart of On the Design Top in the data group, Click Select Data to display the selected days of source dialog. Box change set of references in charge data range on click OK, the days season gone. But I could just edit them here to complete the picture so I can select the year heading to change the access titles, although it doesn't make much sense to do so on this case, if you want to switch to data between access, then only have to do is click on this bottom 4. 5.1.4 Analyse Data using Quick Analysis: I swear. Debut in previous Lecture. The first step in creating a chart. Select. Arrange yourselves whenever arranges, said the selectors. Quick announces icon displayed next to the bottom right corner cell. As you can see here, we're checking the icon. A pop up menu displays with multiple options that are often useful for select syringe. So we have four months charts, totals, tables and spark loans. We see her concert sparked lines in the next sector. By the end of the course, you have encountered all of these topics, but this and youthful short with some of the most often use them to excel. Interview selected arrange. If you look at the marketing budget plan for help Florence again, we can select the range of cells that we used earlier to generate a charge charge, which you can see here. I want to have Sarah and selectors. You can see the quick an ounce of Papa by con when I click in it. The quick announcement made a space condition. Former options. By default, you can see the very effect of a hover over each option. We have data Barth position with the cells. We could change the clothes user concepts condition formerly on so on. You can see how easy it is to create the closer Colin Charge charge, which he did in the new new electric. As you go over each icon, you can see a preview of what the chart going to look like. Similarly, with the totals options. It's a simple process. Adan Comely youth totals such as the average Count, etcetera. So all I have to do is sit at the Quicken answers to go to the total stab on here. I have the commonly years totals to select from Let's Let average and consider its compute immediately notice of a hover over Egyptian that the area where the answer is going to be place is highlighters. Now you can see the averages calculators again Sparked learned a very degenerate using this to to select the data and then the type of spark line you want 5. 5.2.1 Resize Charts: you can move charts on the location on the work she's typically, you place a chart next with source data so that users can see both at the same time. To have a charter and the work. She's simply use amounts to drag it to its new location while moving nature. Take care of him, placing the coarser to ensure that you're not moving a single component within the chart by mistake. To move an entire chart, you must take on the blank area of the chart, where no chart components are located. You can also make church larger or smaller or change the shape to resize the chart. Sick and drank. Any of the handlers will create. Located around the border of the chart. Every charter. Eight of these handles for in the corners and four midpoint between the corners. The midpoint. Hundreds I used to change the with or the height of the chart. The corner handles come used to make the chart larger or smaller in two directions at the same time, but changing the width and height simultaneously. Whenever you change side of shape for chart, the internal components would generally resize proportionately, so it's usually a good idea to resize from the corner handles so unexpected chart on right click On the most, you can see that there are quite a lot of options here, one of which is move chart. This invokes the dialog box, which allows me to move the chart with own sheet. If you do this to charge will automatically resize itself to fill the entire sheet. 6. 5.2.2 Add or Modify Chart Elements: We've seen the chairs from the Creator on selected set of data. With just a few clicks of the most. However, the chart will use a standard set of default settings you know typically want to modify the chart designed to create exactly the look you want. We have a chart selectors. The design time will be activated on it contains commands to help with the design of the chart, such as which states accepted the spin and the charge or selecting a different chart. Type Xer provides a variety of pre built layers that you can apply to your charge. You can, in further modify the chart with your own layer, changes decisions to add modify or former chart components. Such just your title data labels legends horizontal over to access. Although the ribbon option is labeled as add chart element, it can also be used to remove the element from this charge. So while I have to do is select what it is that they want to modify. Let's pick the access. So if I picked access I canoes like the horizontal vertical primary access extracting either then provide you with a text box, enter forever name. I want to give the Axis. If I want to have the days of tables generated the charter visible with the chart, then I have this choice, which allows me to position the chart and choose whether I want the danger level with the table. Each individual element on the chart could be sex, but just clicking on us, they can then directly modify order leasers if you wish. Adding, modifying or leasing chart element is not straightforward. In some cases, such as with data labels as your hover over each option, you can see the effect on the chart. 7. 5.2.3 and 5,2,4 Apply Chart Styles and Move Charts: we saw had to add modify charter arms from the previous lecture, and this victory we're going to explore some of the other choice is provided we have a chart selectors on the chart. Design options are activated. The quick layer option is used to select from one of several pre defined chart layered for the current chart type. You can see the effect on the jumper just hovering over each option. In turn, the change colors option is used. Select from one of several pre defined concept for the days of points lines or bars. Once again, you can see the effect when you hover over each of the options. The chart stars options you select from one of several pre defined chart visual stars of a hover over each election, you can see the effect on the chart. The switch row Collier is used to exchange the data rows and columns as the Data city for the chart. The Select Days option brings us back to the days of serious for the church, and you can modify what it is you want to use to generate the chart by changing the range selectors the change chart type option in both the dialogue was selected the type of chart you want to use. Finally, the Move Charity option invokes the dialogue from moving the chart with different locations in the workbook. 8. 5.3.1 Insert Text Boxes and Shapes: the Answer Tab Administrations Group. Find access to a set of options for the inclusion of graphic objects within your Excel worksheets. Let's look at these shapes. Menu. First of all, this Mannion has 160 different shapes available, including text boxes, which he used to display text rectangles, olders and lines. That's where there's a variety of what a commonly use shape shapes as first of may seem on to have a textbook when you have the ability to enter text directly into a worksheet cell, However, it's important to understand that a text box shape and all the other shapes are independent of work. Each as in other words, he cannot reference the content of a shape with a formula. Shapes, including text boxes, can be of any size because their position in a separate layer in front of the worksheet cells, I noticed that you only have rectangles than over the shape, but not squares and circles. You can use the shift key to draw symmetrical shapes, which is using the rectangle to draw a square shape or the oval to draw a circular shape. What, Holding down the shift key accepted force to shape to be a perfect square circle or other symmetrical shape. So if I say the old shape, you can see that the cursor shape becomes this cross hair type. And there, when I hold on the most, I can draw and reach signs to shape. If I hold down shift key, what performed the same action in the shape becomes a perfect circle. Excel organizes groups of shapes by type soft, which are three dimensional when used. A textbook feature available here, Excel changes the most course into this shape, and once again, you can draw and size the text box as required. Click in the location where you want the text to begin and start typing. So creating shave. Fairly straightforward. Essentially, you should play with the very shape and get used to what excel conducive for you in this respect. 9. 5.3.2 Insert Images: Excel Concert Pictures, photographs on clip art images into worksheets. It would check pictures and any of the very common image files former such a bmp, gif, jpg, PNG and tiff. To assert pictures, step out on other types of images from your local computer into the worksheet. Go to the insert term. The illustrations group on click Picture the Insert picture dialogue box and enables you to search for an answer to picture file to put into your work. She's pictures can also be inserted into the header or footer to despair and every print page. This is very often used for corporate logos, so if I scrolled my desktop, I can select the picture, but just double taking on the fun name here, the picture moving, positioned wherever the Carson is at the point of insertion, as with all of their objects, you concert into your worksheets excels. There's a picture with helds around it. These handles are used to resize the picture. When re sizing picture, you should only use one of the four corner hands to ensure that the correct aspect ratio was maintained. Otherwise, there's a picture we look very distorted like, so this is a very important point with pictures on one, which a lot of people seem to be unaware off. The online pictures option allows you to search for pictures on the Internet. So, for example, if I propose Simon's and search box, the Bing search engine will return a selection of images, and I could just highlight when I want and press the insert Putin the images and searches. Sometimes you may want to insert a company logo into the head of your worksheets. To do so, go into the insert temp than the text group and click, header and footer The walk. She is nervous, stayed in page, layered. Few noticed that the headers and footers designed menu is now available. I can now insert an image of our company logo in any part of the header. I put one into the left section, click on the picture option and then select the image. Notice that only a cone appears in the preview. You have to click into the blank area of the worksheet to view the actual results with the image you can also form at the picture and re signed this. If you go back and click into left hander section so that once again it's visible, showing the 1% picture code you can see under the head. And fortitude on the design tab may construct the former picture option. Now we can change the size of the image appropriately, I said the emphasize at 25% making sure that the lock aspect ratio is checked so as to ensure that the image won't be distorted. I know you can see that the image fits very nicely into the header of my book. She's 10. 5.3.3 Modify Object Properties: the term object. Give any image shape other elements, such as charter fires, which have their own properties and can be manipulated in their own right. We can modify an object property in a few specific ways, which are common across all object types. So if you know how to do for one, you'll be able to do so for the rest. First thing you have to know how to do is to modify an object size and appearance. Won't you drown the object? You can change its size and appearance, for instance, you rarely be able to place a shape or object in exactly the right position on the worksheet in your fourth try. You may also need to be just a side of your drawing to fit space. Available to resize an object of shape. You move for selectors the shape or object, then displays Jay's handles except lines, which only have two handles. But clicking and dragging these 100 you change shape or object side and proportion. Clicking any of the corner hands enabled you to change about the length and width of the two adjoining sides at the same time, drinking any of the midpoint handles resize is only that one side. If you want to maintain the proportionality of an object, particularly in the case of images, make sure that you re size by using the handles at the corners and not at the sides. If you want to move a shape to a new position, you do not need to select it first when you position the most course over the shape the course of changes to this shape to indicate that it's ready to move the shape directly underneath it. You dentist holder in the mobile on Dr Shaped Removal location On the work, she's to copy a shape object with location on a worksheet. Click the shapes electors. He has any of the existing methods, then to copy to the Eternal Report, then use any of the existing mental pasted to a new location to the leisure shape object. Click the shape selected them. Press the delete key When you draw shape. Excel. Use the currently selected theme to for matters, so the colors and so on undetermined. But the current team being used in Gorky's Once the shape have been drawn. You can customize using the formatting options in the ribbon So if I click on the drawing twos options, you can see that there's a whole menu of options to choose from. To modify the former of the shape, remember that you have to have an object selected for this Made, become available. Let's look at that shape Stars Group first. The same feels menu provides a set of pre defined outline and feel color combinations to apply to the shape. As I move over each of the web of presets, you can see the former of the shape changing dynamically. The shape feel option allows you to select colors, graders, textures and even pictures with which you can feel the shape. You construct the colors and passion with which you want to feel the inside of the shape. By default. Excel, Use the fill color for the current default team. You can choose no field to make the shape transparent, leaving only the shape border color instead of a solid color fill. You can also choose a picture ingredient where you intend for the shape intensely changes from on land of the object to the other or a texture to fill the inside of the shape. The shape outline option allows you to their colors and partners for the borders around the shape. As with shape filled, you can choose no off line to make the border transparent. The weight, says he allows you to choose. The thickness of the border on the dash is setting determines whether to use a solid line or a passion of dots, dashes or both from line and our shape. You can choose from several arrow patterns. Shape Effect closes out a three dimension effective shape, which is a shadow or reflection, as if a mirror play from on edge. The options available are very varied on really, it took to your own imagination as the hell you want to shape. Look once again, say, with possibilities on experiment. Now the silken had to modify images. In particular, Exam provides several image editing to fill Eddie to be just incorrect photographs and clip art objects in your worksheet. When I have a picture selectors, the picture to menu is activated. That's considered the available options. The removed background removes the background surrounding the main subject within the photograph. If this to selected excellence days and not a tab to help you identify the area of the photograph to keep or remove, so you'll be quite selective in deciding which carried of the picture you want to focus on . Continue click off the picture. You can't see what the effect will be. Remember that you have the undo button to fall back on the corrections. Upton changes the brightest and contrast settings on the just the sharpness of the ages around the very subjects within the picture or clip art. As I hover over each of the web of preset options, you can see how the picture is going to be changed. But color option ledges with just the clothes saturation and color tone settings, or change the color of the picture clippers again. You see the effect as you have over each preset option. The artistic effects option allows you to modify the picture, using very filters to achieve special effects by default pictures and say, party do not have a border. The picture border option allows you to set the core weight and dashes options for the border around the object. These are the same options are for drawing shapes. The picture effects option provides extra various three dimensional picture effects. Neither the same options of for drawing shapes the picture layered option alleged to crop or resize the picture or clip art to a shape, which is a circular square and possibly out of text box, depending which preset you select. The picture styles Options provide a pre defined set of borders or a three dimension effect , which you can apply to the picture or tip art Excel. Also crop did the fit to shape abused. The crop option allows you to hide the outer part of the picture Clip art to achieve a stronger focus on the main subject. The shape, height shape with option allows you to manage, he said. The height and width of the picture or clip art when you have a text box. Electors. The text options in the former shape in is used for formatting option for text boxes on word art objects, you know. Also, access is made by right clicking the text box and selecting the former options right click in the shape and click former shape or former text effects from the pop up menu. In fact, the right click menace options are contact sensitive. In other words, what you see his options depends on the object you've selected. If it the text box, you see the former text effect on form and shape. If it's a shape, you see former shape. If it's a picture, you see former picture if you selected textbooks and then it's like former shape. The former shape pain is displayed with text options. Tab highlighters. Similarly, the former picture pains you formatting options for clip art and pictures. This pain can also be accessed by going to the picture twos menu than the former in time and then the Picture Stars group Select the former shape Dialog box launcher. The text feel options allow you to change the field color of the text in the text box. So if I want the text to be read that I just select a solid Phil on the appropriate color. Similarly, with text outline options. If I select of solid outline on black is the color, then you can see the effect. The shape options allows me to modify the properties of the text box rather than the actual tax. Again, the options are fairly soft evidence, and you should experiment with them. So if I want a Grady in blue color for the shape. Don't just select the appropriate options. Changing the size, shape and position of a graphics object can be done very easily with Excel. Usually demands is the fastest method of making these changes. In some cases, you may not want the unrestrained freedom to make certain kinds of changes, such as changing the proportion of the heightened with which refer to as the aspect ratio to maintain this race so you can look a temporary when you use the most to resize an object . But using one of these keys at the same time, the Control K will lock the center of the object while its size and shape changes like. So to Shift K, we lock the aspect ratio of the object. Quiet signs changes like so if you used a combination of the two control and shift this love both the position on the aspect ratio of the object, like so if you're drawing the object for the first time. Using these keyboard keys were made the objects symmetrical for example, square instead of rectangle on circular instead of over. If the object has already being drawn, using these keyboard keys will maintain the current aspect ratio. For example, a noble will remain an over, except that the object will be proportionately larger or smaller. You can also rotate a graphic subject, which refers to changes. It's changing its angle. The object can be rotated clockwise or counterclockwise. You can rotate most graphic objects, including shaped pictures and clip art. However, the rotator option is not offered for lines because they only have two handles. You can change the angle of lines simply by dragging one of the hands to a different position, like so. 11. 5.3.4 Add Alternative Text for Accessibility: irrespective of the object selectors. The size and property term of the former shape pain always provides me and means of including alternative text for people with accessibility issues. This is used by programs which convert text to speech for those whose site may be impaired . This is very useful in terms of accessibility, and you should always include all to text with your embedded objects in excel. Just say the object right click, select former shape and go to the size and properties tab. Here we have the whole text option on. All you have to do is insert appropriate text to describe the object.