Class 4 (Objective Domain 1.5) : 77-727 Exam - Techniques for MOS Core Excel Certification | David Murphy | Skillshare

Playback Speed

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

Class 4 (Objective Domain 1.5) : 77-727 Exam - Techniques for MOS Core Excel Certification

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

10 Lessons (25m)
    • 1. Class Introduction

    • 2. 1.5.1 Set a Print area

    • 3. 1.5.2 Save Workbooks in Alternative File Formats

    • 4. 1.5.3 Print All or Part of a Workbook

    • 5. 1.5.4 Set Print Scaling

    • 6. 1.5.5 Display Repeating Rows

    • 7. 1.5.6 Inspect a Workbook for Hidden Properties

    • 8. 1.5.7 Inspect a Workbook for Accessibility Issues

    • 9. 1.5.8 Inspect a Workbook for Compatibility Issues

    • 10. Domain 1.5 - Exercises Video Solution

  • --
  • 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 4 - Objective Domain Section 1.5 - Configure Worksheets and Workbooks for Distribution

This is the fourth in a series of 10 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 1.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. 1.5.1 Set a Print area: When you're printing worksheet, you may not want to print a complete worksheets, but only selected portion of us in order to do so, except provides an option to specify a range of cells as the print area, which will ensure that only dissection of the worksheets is always selected for printing. To do so, you just select the part of the work sheet you want to print and then go to the page. They are time and click on the print pulled a print area pulled down. There are only two options here to set or to clear the print area. They only go to the print command on the backstage. You can say that only data of the worksheet is shown in the print preview area. You can clear the print A by pressing the Clear Print Area command and I'll turn to write Print on. The selection of the worksheet is select what you want print on on the print options in the backstage uses Pullum unspecified that you only want to print what have Bean currently selected 3. 1.5.2 Save Workbooks in Alternative File Formats: we saw an objective 1.1 point two how to import text data into an Excel file. Excel Off also provides a nisi method. Three. Various The process on to export data to over 54 months in to Save as dialog box to save our type. Drop down list includes an extensive list of different former for saving the worksheet data , many of which you're never going to have to use. Saving an Excel file in a different farmers is just amount of selected type you want to use . For example, if I want to create a Pdf file, then I just specified PDFs of five type. Both pdf on the Dell Be filed. Former and CFE returned for comma separated values or comedy limited Far are to farmers, which are very commonly years. On some occasions, you may get a warning miss to tell you that some features of the workbook may be lost if you saved selected file format. This is sure of CF file type, which only contained text data. This means that when saving warp accusing to Cioffi, former Excel will discard anything that is not pure data. Therefore, your CFE workbook should not use Excel features. Since it's formless self formatting charts and multiple worksheets, Excel will display the following morning question of a warning. Just accepted this to Kate and press Yes, When saving to pdf, you have options as to which information you want to retain. If I select the options button, I get this dialog box. It should, as you specify what pages I want to print on, whether I want the whole workbook to be saved of the pdf file, it's important to note that the default is said to Onley say the current walk. She's so if you want the complete walk book to be safe to a Pdf, you have to modify the default options here. I can ask to specify whether I want to document properties on little non printing information to be saved with the five 4. 1.5.3 Print All or Part of a Workbook: two printed Excel. You need to go to the file tab and select the print command in the back. Said you like so there. Three options select. Print the current network she's or she eats print all worksheet in the entire workbook or print the currently selected range of says in the current active worksheet. And as you have only one worksheet as your active work, she's when you print the active. She's excitable. Only print the content of that worksheet if you want to print more than one more cheese but not the entire walk book at the same time, they must select all of these worksheet of a group first and then print them. For example, if you want to print both of the worksheet in The Helps Airlines Walk book, then I have to select both worksheet forced by holding down the control K and clicking on each of the worksheets. This allows me to have multiple worksheets selected at any one time. I can now print both worksheet simultaneously. If I just want the Prince selection from our walkies, then I just select what it is that I want to print and then specify the prince election option from the Print Command 5. 1.5.4 Set Print Scaling: you can use a skating feature and accept a limited number of pages wide on door tall. When you go to print spreadsheet, scaling means to shrink or in large, for instance, you can shrink the content of fist, making it smaller. Or you can scale the content. Nor is to magnify the content, making it bigger and easier to read. There are two ways to access skating featured in Excel. You can use this scale fist group on the page layout tub. Or you can use the prince setting available for the backstage print command. Let's look at the page day an option for us here Concert fight the number of pages wide on the number of pages tall that you want to print. For example, if I specify two pages wide by two pages tall, we can see the effect in the print preview area. Notice that this is actually a custom scaling setting. As you can see from this dialog box, the scanning percentage can be changed to fit more information into a smaller space. So if I said this 50% that means that I confuse a complete page into 50% of the usual space Because the page has been shrunk to size, the page has been scaled down. In this case, if I click on the expanded option here, you can see that the dialogue box provides an option to force the printing to fit to a specified number of pages you can also adjust. This came for Penn for using the print command from the backstage view. There are several options for your prince settings, but if you go to the bottom of the list, you see the scale to face option by default. Excel sets the substitute. No scaling. The pull down menu provides a number of other options. We have fit home on page fish, all calling them on page Phil Rosenbaum page or customize Skating options. Fit to one page is great if you don't have someone state in the worksheet. If you do, then the text lumpy readable because it would have been scaled in such a smaller size like this, you won't be able to read it. The print orientation has been said to landscape, and currently the print preview shows torturing pages using the scared fifth feature provided with four options to choose from, we select the fish, all calling the mom Paige and say the effect. Let's review this step by step. Go to the fine menu in the ribbon. Click on the print command. Open the scared fit Drop down box. Select fish, all calling the moon page to the right of the prince. Sentences to print. Preview Noticed that the patient was went down from 13 to 3. If you use the next button to page true, you can see that each page includes all of the columns. Sometimes it's easy to Sector four assumptions fit on one page in their example. If you have chosen that option, the content would have been so tiny it would have been impossible to read the printout. Keep something in mind when you make changes using the scale. Options were modifying only the print there, changing the options in the scant if it to does not affect the standard. Rajiv, you on the screen 6. 1.5.5 Display Repeating Rows: We've seen an objective 1.4 point for how we can freeze it a spare roles and comes on the screen in order to keep information system heading un display all the time while I was scrolling through a worksheet. This feature only applies on the screen when you want to do the same thing for printing. Then use the print titles option, which is available from the page layout tab. By printing titles, you designate specific data. Roller days of columns are both to print on every page of the printed worksheets. Typically, these rows and columns contained the text Dave's that identify the profits of the data in the rows or columns in this world, Chief, you can see in the print preview that I scrolled down the printer pulls, the titles disappear, and I can only say the raw data, which make it very difficult to know what they refer to. I need to keep the title visible on each page of the printers so that it can easily relate two days into the meaning. If you go to the pays a a tab and select the Print Titles command, we get the page set of dialogue box, which is open on the She tab, which is where I can control print titles. You can select Climb a row, headers or the Rangers says you want to print by selecting directly from the worksheet. So if I select well three as the role to repeat at the top of each page, you can see this when they go to the print preview option. Here, you can select most Boro's, but they must be side by side. Similarly, I can do the same for the Collier they want to repeat. So if I want Collier, 80 on every page, just click on the head of a column A and you can see the effect on the Apprentice Airport. 7. 1.5.6 Inspect a Workbook for Hidden Properties: we've seen an objective 1.4 point six how we can modify the document Properties are metadata for a workbook. While this is used for defining important properties of a workbook, this information may not be appropriate for sharing with other users. The document inspectors designed to look for certain type of data stored on MacBooks on report them to you. Some of these Eisen's includes comments, revision marks. Document versions are annotations, contain the names of people who have made changes are made notations in the Workbook Walk Park meta data that amazing may include information about the originator information on the head of the four others, including watermarks, hidden days, rows, columns and more cheats. Our custom data that is not visible in the document. The report is often useful to help you to find hidden off private information the workbook that they intend to share a published for other people to use. By knowing that these types of data exists in the workbook, you can make a decision on Twitter's appropriate to leave the state in, or removers. We can go to the darkened inspector by clicking on the file time to get to the back save you and then clicking on this check for issues Button on selecting the Inspect Document Command. There are quite a number of options select from in this dialog box. If I leave them all checked. Impressed Inspect Button You can see that there is person information associative this workbook on that I can no removed if necessary. This dialog box shows items that the document inspector identified which may choose not to share If you intend to shoot this document others document inspector provides an option to remove the eyes of automatically by clicking to remove all button so that you don't have to remove them manually. You can re inspect to make sure that the data has been removed. No, If you look at the workbook advanced properties, you can see that the fears that have the Paris and information I know blank 8. 1.5.7 Inspect a Workbook for Accessibility Issues: computer of opened of many new opportunity for Paris's with disabilities to enable them to become more self sufficient and enhance their career opportunities. Windows on the MIC Soft officers are designed with several features to assist persons overcome their physical limitations. However, workbook should avoid certain attributes that can make it. That can make it more difficult for users with disabilities. There are design issues which should keep in mind when you're creating your workbooks. The following guidelines are recommended in order to ensure that people with physical limitations can use your worksheets years. Descriptive text images on objects Computers can translate Texas speech to the people with sight. Disabilities can use the information. The walk book images and objects, however, cannot be fully access directly in this way. And so it's important that you include text descriptions off surge objects as part of your normal design. The descriptions are entered into workbooks using the altar text option. Now we haven't covered how to inside minutely images in exchanges. Yes, brought demonstrate this issue so that should be aware of it. When we do come onto it on sorties, images in excel, uncertain image into my worksheet here on now in the right click in the image of the option to view the former picture dialog box. The size and properties option allows me to select the altar text options. Hair cannot description. We should be converted to speech for the computer. If there is appropriate cell for to do so, those visually impaired person would have a sense of what was appearing on the screen worksheet tab Names should clearly describe the purpose of the respect of worksheets. For example, Rand ever worked to maintain schedule instead of using the default name of she won. Yes, Descriptive. Heading for data rows and columns. Huge range names wherever possible to allow users to move quickly between significant part of the worksheet. Create dense works. Pesci's by minimizing the use of empty cells. Avoid using empty roles and climbs wherever possible. Hi pulling should display as descriptive text instead of the default year. L. For example, help his airline's website instead of Hastey TPS for such for such help, US airlines don't come. Use take phones that are plain a sensory found searchers Aerial Helvetica over Donna is recommended. Sensory funds are more block like unlike the little extensions at the end of the strokes use a high contrast color difference between the foreground and the background, So these are the generally recommended guideline for improving accessibility. You can check her where your worksheet meat. These guidelines, by using the check accessibility option which can be accessed by going to the back, said you and then to the check for issued pulled on on click on check accessibility. You can see the excels indicating that there are some issues and you could see that the forces is the lack of all texts on the image I inserted. These are suggestion for improvements on a not mandatory. 9. 1.5.8 Inspect a Workbook for Compatibility Issues: Comme possibility means whether a particular file can be rather over by the version of Excel that you're using. You're using Excel 2016 to complete this course, however, the happy many elevations of the product on people still using men of the older versions Excel 2007 on later versions, including, except 2016 all years, the same file four months for saved Walk books, which have the extension dot x l as X at the end of the find them. If you have in years of who it is next and 97 2002 dozen two or 2003 then you must save your workbook at the new and different file, using the older former to enable them to open it. These walk books used to file extension of doubt X s to savor, were working the former then click file, then save us and then click the Hour for Savers Type and Select Excel 97 to 2000 and three Walk book as the type Excel 2016 is able to open any off these walk books, even though they were created by older Excel versions. You can make changes. I conduct content and save what book back to the old of former example informing that workbook is being used by an older former for displaying the world's compatibility mold next to the workbook name in the title bar. However, a Cell 2016 has many features and capabilities that just did not exist or work differently in these area versions except provides a few twos. Have checked the world work on short notice. Composite bill with Area Excel versions. These tunes are available in the backstage You by the file Tough on in the info category the check of the maybe problems with converting your workbook to a different file formats other than the X l as X click files info. Check for issues on, then check compatibility. Any potential problem between the variation will appear in the list. You there needs to decide whether to continue saving the file in the five former. All return to the Duckman to make appropriate changes. If I check this workbook compatibility issues, you can see that there are no because, like razors in Excel 2016 10. Domain 1.5 - Exercises Video Solution: Okay, so we're gonna open the workbook. The marketing plan, the marking airlines marking Plan Workbook and go to the market plan will just work sheet. He goes, go to work. Pocomoke. She's never going to save this file. PdF. So we go to save us, tell us where we want saves the issue here, though, if he's like pdf file type, which I'm just about to do, Type in the name complete marketing plan, complete plant. But you have options on the pdf. Most important with this, the whole workbook complete workbook that make sure that all the works either in the pdf what? Why? That won't pay. Only one of them obey. Now in the marketing time budget worksheets. We're going to set the FleetCenter prints setting from the page layers, print titles and you can see that Row three is already in here. So that's fine. But it's okay. Now we're going to inspect it. This the marketing plan which worksheet for heaven force. So we click on check for issues we can select. We could be selective about what we want to inspect, but in this case being just press OK and you can see that we do get issues and we can remove the world we want to remove. So removed the document properties in Paris and information. That's the goal set of print area. So we select the printer this cave be three to after 11 along the page that we've got this print area option on the pull damages. It set the print area. Next, we're going to open Going to save this finds a comma delimited text font. So it's like to save us. I'll be telling where we want to put the file. I'm putting on the desktop. In this case, it's the fires type. So I want a CF VR comma Separated values file. It will warn you because you're going to lose some of the features that you have in except where Quote Because you're saving this of pure text. Just accept accept the loss and fun, never going to inspect the workbook again and remove any comments annotations, person information, document properties from the workbook. We just finished in CF force And here we are. There aren't any because we moved married around and that's okay. No, gonna clear the print area. So print area clear to print area. That's very simple to do. Now make sure at the wrong column heading the grid of displayed. So we have options here to have on the print. We can have the grid lines and heading, displayed or enough for just a question checking the check box.