Overview

Massive update December 2022This Excel course is 2 courses in 1. It contains all the study and training material for Candidates for the following certification examsMO-210 (Microsoft Excel 365) as well as for MO-200 (Excel 2019).More than 1.000.000 students have trusted TEST4U for their successful exam preparation since 2003.Among them have been MOS World Champions! This is how efficient this way of learning is!Just take a look at these stories below:*******************************"It's simple to use, has a lot of different tasks, good looking interface and was of great help while I was preparing for the MOS 2018 World Championship."Tarik D."It was a great course. I loved how they had a mix of video lecture and hands-on practice. I really appreciate that they let me go back and review the course as much as I needed and they provided me with 5 hours of Test4U practice time which gave me a sense of what to expect on the exam. I took both the Associate and Expert exams on the same day and did awesome on both (976 for Associate and 972 for Expert)! Thank you Udemy for providing this training!"Angie K S.*******************************WHAT TO EXPECT FROM THIS COURSE? - Do you wish you too could pass the Microsoft Office Specialist Exam MO-210 or MO-200 fast and easy?- Do you hate spending too much time on the same, boring, basic staff?- Do you wish you had an experienced, responsive team to support and guide you every step of the way, with premium resources and 20+ years of expertise?Well, then you are in the right place, at the right time! This course will guide you all the way from the beginning to make you achieve the desired industry associate level of skills to pass the MO-210 or MO-200 exams.In fact, we have designed this course in such a way, so that by the time you finish the practice tests and assignments, we believe that you will be 100% ready to take the MO-210 or MO-200 exams and achieve an excellent passing score!WHY TRUST US?That's because we have been teaching IT skills and have been preparing students to take such exams for more than 20 years. Our strategy delivers optimum passing results and this is why students keep returning to purchase more courses and pass more exams with flying colors!Our proven method of teaching will:Keep your interest rate highKeep you engaged at all timesGuide you all the wayMake you experiment and learn by doingAbove all, our method of teaching will make you ready to pass your MO-210 or MO-200 exams.This is not just our saying! Read what our students have said about our way of teaching!*******************************"What I enjoyed when getting involved with this course is the fact that it is not just video-watching. You need to get your hands dirty and actually solve exercises, which is the only way to gain a new skill. Let's be honest, learning how to use an Office suite is nothing like learning about history of arts, so practice needs to be on the table. For anyone who is interested in learning instead of wasting a few Euro, this is the course to choose."Oliver B."This course serves a double cause: First it helps you get the certificate with minimum effort since the questions are almost the same. Practicing on the extra software makes you ready. Secondly, the course actually teaches you how to use excel in an engaging way. Although I enrolled because I wanted to pass the exam, I realized that the second cause was far more important."Meghan*******************************HOW IS THIS COURSE DIFFERENT? When you start learning by the way that we have been teaching all these years, you'll discover the great power that comes with the learning by doing approach. Apart from lectures, assignments and video-solutions, we have included in this course Practice Exams that familiarize you with the exam interface and recreate real exam conditions. This is how a double purpose is served: You will learn how to properly use Excel as well as Prepare adequately for your Certification exam.There is even more.By joining this course, you have access to 300+ Performance based exam simulation questions for Windows or Mac. These are Live-in-the-app questions which let you interact with the installed applications to get your hands dirty and make you learn by doing.Soon you will feel confident enough that you have done all the practice that is necessary, so as to be and feel prepared for your MO-210 or MO-200 exams.The skills you will have gained by this course:Are practical and will follow you even if you use another Microsoft Office versionAre hard-to-forget and can be put immediately to workWill get you to pass the exam, without even realizing you are being testedWill shape the way you use technologyYOU ONLY NEED THIS COURSE IF...Here's the bottom line.You need this course because it's a pity to waste all the exam fee money and have to take it all over again. Get there adequately prepared and pass it the first time.You also need this course because the new Microsoft Office Specialist certification exam is rather hard and you need all the help you can have.But most importantly, you need this course because it will not only help you pass the certification exams, but also give you the great advantage of actually gaining new skills and improving the way you have been using technology so far.Enroll today and benefit from Udemy's no-questions-asked, 30-day, money-back guarantee.More than 1.000.000 students have trusted the TEST4U way of learning since 2003. Be the next one.*******************************"The course gives good overview of what you need to know and how to apply it in and beyond the course. I purchased the whole series (MO100, 200, 300, 101, 201 and 500) and passed all of them including the MO-400. Teacher explains in a very easy and controlled way how to solve the questions and how to perform an action."Rob V.*******************************THE COURSE AT A GLANCEIn this course you will find:52 lessons explaining certain interesting subjects of the MO-210 and MO-200 syllabi, accompanied by52 lesson files to help you reproduce everything that you watch2 lessons explaining the examination process and the structure of the multi-project question127 assignments properly categorized127 distinct exercise files for each of the above assignments127 solution videos for every assignment2 practice exams which contain 80+ exam-like tasks!!!300+ Performance based exam simulation questionsTHE COURSE IN DETAIL52 lessons explaining certain interesting subjects of the MO-210 and MO-200 syllabi, accompanied by 52 lesson files to help you reproduce everything that you watchStarting from scratch, we explain everything that is necessary for you to gain the skills needed and go ace the MOS exam. To help you practice on what you see, we give you access to the same files that we have used during our video-making, so that you can practice at your own pace.2 lessons explaining the examination process and the structure of the multi-project questionPreparing for exam participation is not just knowing the syllabus. You need to also be familiar with the exam environment and interface. Here we explain to you all the MOS exam secrets, so that you get no surprises on the exam day!127 assignments properly categorizedIn this course you will practice on the following categories:Manage Worksheets and WorkbooksManage Data Cells and RangesManage Tables and Table DataPerform Operations with Formulas and FunctionsManage ChartsProjects127 distinct files for each of the above assignmentsEach and every assignment comes with its distinct file(s) that are necessary to answer the assignment 127 solution videos, one for every assignmentAll assignments are accompanied by detailed video solutions. We recommend you try to solve the assignments without viewing the solution. This way you will better understand your limitations and be able to focus on them. You can then see the video after you have solved it, to know if you answered the question correctly.2 Practice exams similar to the ones you will face in the examThis is very important!Certiport has introduced a new kind of examination, which consists of multiple project questions. To help you understand how to approach this exam and give you the chance to practice on such exam formats, we have included 2 such practice exams in this course which contain 80+ exam-like tasks.300+ Performance based exam simulation questionsGrab your Windows or Mac PC to gain access to 300+ or 130+ Performance-based exam simulation questions respectively! Performance-based exam simulation questions help you put all your newly gained knowledge into practice immediately and transform it into hard skills on Microsoft Excel.Fast feedback from our instructorsWe give feedback to all assignments, usually within one or two working days. Although in many cases we have been known to answer within a few hours.*******************************MICROSOFT OFFICE SPECIALIST EXAM OBJECTIVE DOMAINS1) MANAGE WORKSHEETS AND WORKBOOKSImport data into workbooksImport data from text filesImport data from online sources (only for MO-210 exam)Import data from.csv files (only for MO-200 exam)Navigate within workbooksSearch for data within a workbookNavigate to named cells, ranges, or workbook elementsInsert and remove hyperlinksFormat worksheets and workbooksModify page setupAdjust row height and column widthCustomize headers and footersCustomize options and viewsManage the Quick Access toolbarDisplay and modify worksheets in different viewsFreeze worksheet rows and columnsChange window viewsModify built-in workbook propertiesDisplay formulasPrepare workbooks for collaboration and distributionSet a print areaSave and export workbooks in alternative file formatsConfigure print settingsInspect workbooks and correct issuesManage comments and notes (only for MO-210 exam)2) MANAGE DATA CELLS AND RANGESManipulate data in worksheetsPaste data by using special paste optionsFill cells by using Auto FillInsert and delete multiple columns or rowsInsert and delete cellsGenerate numeric data by using RANDBETWEEN() and SEQUENCE() (only for MO-210 exam)Format cells and rangesMerge and unmerge cellsModify cell alignment, orientation, and indentationFormat cells by using Format PainterWrap text within cellsApply number formatsApply cell formats from the Format Cells dialog boxApply cell stylesClear cell formattingFormat multiple worksheets by grouping (only for MO-210 exam)Define and reference named rangesDefine a named rangeReference a named range (only for MO-210 exam)Name a table (only for MO-200 exam)Summarize data visuallyInsert SparklinesApply built-in conditional formattingRemove conditional formatting3) MANAGE TABLES AND TABLE DATACreate and format tablesCreate Excel tables from cell rangesApply table stylesConvert tables to cell rangesModify tablesAdd or remove table rows and columnsConfigure table style optionsInsert and configure total rowsFilter and sort table dataFilter recordsSort data by multiple columns4) PERFORM OPERATIONS BY USING FORMULAS AND FUNCTIONSInsert referencesInsert relative, absolute, and mixed referencesUse structured references in formulas (only for MO-210 exam)Reference named ranges and named tables in formulas (only for MO-200 exam)Calculate and transform dataPerform calculations by using the AVERAGE(), MAX(), MIN() and SUM() functionsCount cells by using the COUNT(), COUNTA(), and COUNTBLANK() functionsPerform conditional operations by using the IF() functionSort data by using the SORT() function (only for MO-210 exam)Get unique values by using the UNIQUE() function (only for MO-210 exam)Format and modify textFormat text by using RIGHT(), LEFT(), and MID() functionsFormat text by using UPPER(), LOWER(), and LEN() functionsFormat text by using the CONCAT() and TEXTJOIN() functions5) MANAGE CHARTSCreate chartsCreate chartsCreate chart sheetsModify chartsAdd data series to chartsSwitch between rows and columns in source dataAdd and modify chart elementsFormat chartsApply chart layoutsApply chart stylesAdd alternative text to charts for accessibility

Skills

Reviews