وب سایت تخصصی شرکت فرین
دسته بندی دوره ها

در حال حاضر محصولی در سبد خرید شما وجود ندارد.

رمز خود را فراموش کرده اید؟
وب سایت تخصصی شرکت فرین
خانه » فروشگاه » شبکه و سیستم عامل » Office 365 » MO-200 Microsoft Excel 365/2019 Associate Certification

MO-200 Microsoft Excel 365/2019 Associate Certification

سرفصل های دوره

80 lectures, individual practice exercises, comprehensive Exercise eBook AND MO-200 practice exam and video solutions


1 - Introduction
  • 1 - Course Introduction
  • 1 - MO-200-Associate-Exercise-Book-Excel-365-2019-V1-2021.pdf
  • 1 - MO-200-Objective-Domain-MOS-Uni.pdf
  • 2 - Extracting the Student Resource files
  • 2 - MO-200-Final-Student-Resource-Files.zip
  • 3 - Certiport Registration.txt
  • 3 - Certiport Remote Testing Facilities.txt
  • 3 - Certiport Testing Centre Locator.txt
  • 3 - Exams from Home Test Candidate Guide.txt
  • 3 - Exam Interface Tutorial Review.txt
  • 3 - How the exam is conducted
  • 3 - Microsoft Official MO200 Site.txt
  • 4 - Try It Yourself Exercises

    • 2 - Introducing the Microsoft Excel User Interface
  • 5 - Introducing the Excel User Interface
  • 6 - Essential Navigation Skills
  • 7 - Entering Information

    • 3 - 11 Import Data into Workbooks
  • 8 - 111 and 112 Part 1 Import Data from txt and csv Files
  • 9 - 111 and 112 Part 2 Import Data from txt and csv Files
  • 9 - 1112TIY.pdf
  • 9 - Customers.csv
  • 9 - HelpLess-Details.txt
  • 9 - Names.txt

    • 4 - 12 Navigate Within Workbooks
  • 10 - 121 and 122 Search for Data within a Workbook
  • 10 - 1212.xlsx
  • 10 - 1212TIY.pdf
  • 11 - 121 Excel 365 Comments and Notes
  • 12 - 123.xlsx
  • 12 - 123TIY.pdf
  • 12 - 123 Insert and Remove hyperlinks

    • 5 - 13 Format Worksheets and Workbooks
  • 13 - 131.xlsx
  • 13 - 131TIY-v2.pdf
  • 13 - 131 Modify Page Setup
  • 14 - 132.xlsx
  • 14 - 132TIY.pdf
  • 14 - 132 Adjust Row Height and Column Width
  • 15 - 133.xlsx
  • 15 - 133TIY.pdf
  • 15 - 133 Customise Headers and Footers
  • 15 - mos-university.zip

    • 6 - 14 Customise Options and Views
  • 16 - 141.zip
  • 16 - 141TIY.pdf
  • 16 - 141 Customise the Quick Access Toolbar
  • 17 - 142.xlsx
  • 17 - 142TIY.pdf
  • 17 - 142 Display and Modify Workbook Content in different Views
  • 18 - 143 Freeze Worksheet Rows and Columns
  • 19 - 144.xlsx
  • 19 - 144TIY.pdf
  • 19 - 144 Change Window Views
  • 20 - 145.xlsx
  • 20 - 145TIY.pdf
  • 20 - 145 Modify Basic Workbook Properties
  • 21 - 146.xlsx
  • 21 - 146TIY.pdf
  • 21 - 146 Display Formulas

    • 7 - 15 Configure Content for Collaboration
  • 22 - 151.xlsx
  • 22 - 151TIY.pdf
  • 22 - 151 Set a Print Area
  • 23 - 152.xlsx
  • 23 - 152TIY.pdf
  • 23 - 152 Save Workbooks in Alternative File Formats
  • 24 - 153.xlsx
  • 24 - 153TIY.pdf
  • 24 - 153 Configure Print Settings
  • 25 - 154TIY.pdf
  • 25 - 154 Inspect Workbooks for Issues
  • 25 - 1541.xlsx
  • 25 - 1542.xlsx
  • 25 - 1543.xlsx

    • 8 - Manage Worksheets & Workbooks Exam Seminar
  • 26 - Seminar Series Manage Worksheets & Workbooks

    • 9 - 21 Manipulate Data in Worksheets
  • 27 - 211.xlsx
  • 27 - 211TIY.pdf
  • 27 - 211 Paste Data by Using special Paste Options
  • 28 - 212.xlsx
  • 28 - 212TIY.pdf
  • 28 - 212 Fill Cells by using Auto Fill
  • 29 - 212 Additional Clarification on Fill Series
  • 30 - 213.xlsx
  • 30 - 213TIY.pdf
  • 30 - 213 and 214 Insert and Delete Multiple Columns Rows and Cells
  • 30 - 214.xlsx
  • 30 - 214TIY.pdf

    • 10 - 22 Format Cells and Ranges
  • 31 - 221 Merge and Unmerge Cells
  • 32 - 222 Modify Cell Alignment and Indentation
  • 33 - 223 Format Cells by using Format Painter
  • 34 - 224 Wrap Text Within Cells
  • 34 - 221234.xlsx
  • 34 - 221234TIY.pdf
  • 35 - 225.xlsx
  • 35 - 225TIY.pdf
  • 35 - 225 Apply Number Formats
  • 36 - 226 Apply Cell Formats from the Format Cells Dialog Box
  • 37 - 227 Apply Cell Styles
  • 37 - 2267.xlsx
  • 37 - 2267TIY.pdf
  • 38 - 228 Clear Cell Formatting

    • 11 - 23 Define and Reference Named Ranges
  • 39 - 231 Define a Named Range
  • 40 - 232 Name a Table
  • 40 - 2312.xlsx
  • 40 - 2312TIY.pdf

    • 12 - 24 Summarise Data Visually
  • 41 - 241.xlsx
  • 41 - 241TIY.pdf
  • 41 - 241 Insert Sparklines
  • 42 - 242.xlsx
  • 42 - 242TIY.pdf
  • 42 - 242 Apply Builtin Conditional Formatting
  • 43 - 243.xlsx
  • 43 - 243TIY.pdf
  • 43 - 243 Remove Conditional Formatting

    • 13 - 31 Create and Format Tables
  • 44 - 311 & 313 Create Excel Tables and Convert Tables from and to Cell Ranges
  • 44 - 3113.xlsx
  • 44 - 3113TIY.pdf
  • 45 - 312 322 and 323 Apply and Configure Table Styles including Total Rows

    • 14 - 32 Modify Tables
  • 46 - 321 Add or Remove Tables Rows and Columns
  • 46 - 3213.xlsx
  • 46 - 3213-and-312TIY.pdf

    • 15 - 33 Filter and Sort Table Data
  • 47 - 331.xlsx
  • 47 - 331TIY.pdf
  • 47 - 331 Filter Records
  • 48 - 332.xlsx
  • 48 - 332TIY.pdf
  • 48 - 332 Sort Data by Multiple Columns

    • 16 - 41 Insert References
  • 49 - 411 Part 1 Insert Relative Absolute and Mixed References
  • 50 - 411.xlsx
  • 50 - 411TIY.pdf
  • 50 - 411 Part 2 Insert Relative Absolute and Mixed References
  • 51 - 412.xlsx
  • 51 - 412TIY.pdf
  • 51 - 412 Reference Named Ranges and Named Tables in Formulas

    • 17 - 42 Calculate and Transform Data
  • 52 - 421 Perform Calculations using the AVERAGE MAX MIN and SUM Functions
  • 53 - 422 Count Cells using the COUNT COUNTA and COUNTBLANK functions
  • 53 - 4212.pdf
  • 53 - 4212.xlsx
  • 54 - 423.xlsx
  • 54 - 423TIY.pdf
  • 54 - 423 Perform Conditional Operations by using the IF Function

    • 18 - 43 Format and Modify Text
  • 55 - 431 and 432 Format Text RIGHT LEFT MID Upper Len Functions
  • 56 - 433 Format Text by using the CONCAT and TEXTJOIN Functions
  • 56 - 4313.xlsx
  • 56 - 4313TIY.pdf

    • 19 - 51 Create Charts
  • 57 - 511 Create Charts
  • 58 - 512 Create Chart Sheets
  • 58 - 5112.xlsx
  • 58 - 5112TIY.pdf

    • 20 - 52 Modify Charts
  • 59 - 521 and 522 Add and Switch Data Series in Charts
  • 60 - 523 Add and Modify Chart Elements
  • 60 - 52123.xlsx
  • 60 - 52123TIY.pdf

    • 21 - 53 Format Charts
  • 61 - 531 and 532 Apply Chart Layouts and Styles
  • 61 - 5312.xlsx
  • 61 - 5312TIY.pdf
  • 62 - 533.xlsx
  • 62 - 533TIY.pdf
  • 62 - 533 Add Alternative Text to Charts for Accessibility

    • 22 - MO200 Practice Exam
  • 63 - How To Use the Practice Exam
  • 64 - Equipment-Details.txt
  • 64 - Project 1 Solution
  • 64 - exam-1-project-1.zip
  • 65 - Project 2 Solution
  • 65 - exam-1-project-2.zip
  • 66 - Project 3 Solution
  • 66 - exam-1-project-3.zip
  • 67 - Project 4 Solution
  • 67 - exam-1-project-4.zip
  • 68 - Project 5 Solution
  • 68 - exam-1-project-5.zip
  • 69 - Project 6 Solution
  • 69 - exam-1-project-6.zip

    • 23 - Solutions to Course Exercises
  • 70 - Objective Domain 11
  • 71 - Objective Domain 12
  • 72 - Objective Domain 13
  • 73 - Objective Domain 14
  • 74 - Objective Domain 15
  • 75 - Objective Domain 21
  • 76 - Objective Domain 22
  • 77 - Objective Domain 23 and 24
  • 78 - Objective Domain 31 and 32
  • 79 - Objective Domain 33
  • 80 - Objective Domain 41 and 42
  • 81 - Objective Domain 43
  • 82 - Objective Domain 51
  • 83 - Objective Domain 52 and 53

    • 24 - Bonus Lectures
  • 84 - Bonus Lecture About MOS University
    • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید اشتراک افزودن به سبد خرید
    خرید دانلودی فوری

    در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 14960
    حجم: 4817 مگابایت
    مدت زمان: 395 دقیقه
    تاریخ انتشار: 29 خرداد 1402
    دسته بندی محصول
    Udemy-Training
    Udemy-Training
    مشاهده دوره های Udemy-Training
    دیگر آموزش های این مدرس
    طراحی سایت و خدمات سئو

    139,000 تومان
    افزودن به سبد خرید