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

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

رمز خود را فراموش کرده اید؟
وب سایت تخصصی شرکت فرین
خانه » فروشگاه » آموزش های اداری و آفیس » آموزش Microsoft Excel » MO-201 Complete Techniques for the MOS Excel Expert Exam

MO-201 Complete Techniques for the MOS Excel Expert Exam

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

Microsoft Excel (365/2019) Expert Certification - Comprehensive lectures, exercises and video solutions.


1 - Introduction
  • 1 - Course Introduction
  • 1 - MO-201-MOS-2019-Excel-Expert-Exercise-Book-v4.pdf
  • 1 - MO-201-Objective-Domain-MOS-Uni.pdf
  • 2 - Certiport Registration.txt
  • 2 - Compass Interface tutorial.txt
  • 2 - Exams from Home.txt
  • 2 - Exams from Home Test Candidate Guide.txt
  • 2 - How is the exam be conducted and what will it be like
  • 2 - Official Microsoft Site for the MO201 Exam.txt
  • 2 - Test Centre Locator.txt
  • 3 - Domain-1-Exercise-Resources.zip
  • 3 - Domain-2-Exercise-Resources.zip
  • 3 - Domain-3-Exercise-Resources.zip
  • 3 - Domain-4-Exercise-Resources.zip
  • 3 - Extracting the Student Resource Files
  • 4 - Try It Yourself Exercises

    • 2 - 11 Manage Workbooks
  • 5 - 111TIY.pdf
  • 5 - 111 Copy Macros between Workbooks
  • 5 - macro-version-of-marketing-budget-workbook.zip
  • 6 - 1-pm.xlsx
  • 6 - 9-am.xlsx
  • 6 - 11-am.xlsx
  • 6 - 112TIY.pdf
  • 6 - 112 Reference Data in Other Workbooks
  • 7 - 114TIY.pdf
  • 7 - 114 Manage Workbook Versions
  • 8 - 113TIY.pdf
  • 8 - 113 Enable Macros in a Workbook

    • 3 - 12 Prepare Workbooks for Collaboration
  • 9 - 121 and 122 Restrict Editing and Protect Worksheets
  • 9 - 121122TIY.pdf
  • 9 - Hours-Worked.xlsx
  • 10 - 123TIY.pdf
  • 10 - 123 Protect Workbook Structure
  • 10 - Hours-Worked.xlsx
  • 11 - 124TIY.pdf
  • 11 - 124 Configure Formula Calculation Options
  • 12 - 125TIY.pdf
  • 12 - 125 Manage Comments
  • 12 - Comments-Workbook.xlsx

    • 4 - 13 Use and Configure Language Options
  • 13 - 131 and 132 Use and Configure Language Options
  • 13 - 131132TIY.pdf
  • 13 - macro-version-of-marketing-budget-workbook.zip

    • 5 - 21 Fill Cells Based on Existing Data
  • 14 - 211TIY.pdf
  • 14 - 211 Fill Cells by using Flash Fill
  • 14 - Staff-Records.xlsx
  • 15 - 212TIY.pdf
  • 15 - 212 Fill Cells by using Advanced Fill Series Options
  • 15 - 212-Resource.xlsx
  • 16 - 212 Clarification on Advanced Series Fill Options

    • 6 - 22 Format and Validate Data
  • 17 - 221.pdf
  • 17 - 221.xlsx
  • 17 - 221TIY.pdf
  • 17 - 221 Create Custom Number Formats
  • 18 - 9-am.xlsx
  • 18 - 222TIY.pdf
  • 18 - 222 Configure Data Validation
  • 19 - 223 and 224 Group Ungroup and Sub Total Data
  • 19 - 223224TIY.pdf
  • 19 - HelpLess-Airlines-Flight-Details.xlsx
  • 20 - 225TIY.pdf
  • 20 - 225 Remove Duplicate Records
  • 20 - Monthly-Revenue.xlsx

    • 7 - 23 Apply Advanced Conditional Formatting and Filtering
  • 21 - 231TIY.pdf
  • 21 - 231 Create Custom Conditional Formatting Rules
  • 21 - 231-Monthly-Revenue.xlsx
  • 22 - 232TIY.pdf
  • 22 - 232 Create Conditional Formatting Rules that use Formulas
  • 22 - 232-Sales-Information.xlsx
  • 23 - 232 TIY Explanatory Lecture
  • 24 - 233TIY.pdf
  • 24 - 233 Manage Conditional Formatting Rules
  • 24 - 233-Conditions.xlsx

    • 8 - 31 Perform Logical Operations in Formulas
  • 25 - 311 Part 1 Perform Logical Operations by using IF and IFS Functions
  • 25 - 311-Monthly-Revenue.xlsx
  • 25 - 311-Part-1-TIY.pdf
  • 26 - 311 Part 2 Perform Logical Operations by using SWITCH AND OR and NOT
  • 26 - 311-Part-2-Sales-Information.xlsx
  • 26 - 331-Part-2-TIY.pdf
  • 27 - 311 Part 3 Perform Logical Operations by using SUMIF and Other Functions
  • 27 - 311-Part-3-Sales-Information.xlsx
  • 27 - 331-Part-3-TIY-v2.pdf

    • 9 - 32 Look Up Data by using Functions
  • 28 - 321 Part 1 Using the Vlookup and Hlookup Functions
  • 29 - Hlookup Clarification Lecture
  • 30 - 321 Part 2 Using the Match and Index Functions
  • 31 - 321TIY.pdf
  • 31 - 321 Part 3 Match and Index Function Structures
  • 31 - Lookup-Functions.xlsx

    • 10 - 33 Use Advanced Date and Time Functions
  • 32 - 331T.pdf
  • 32 - 331 Reference Date and Time by using the NOW and TODAY Functions
  • 32 - 331-Functions.xlsx
  • 33 - 332TIY.pdf
  • 33 - 332 Calculate Dates by using the WEEKDAY and WORKDAY Functions
  • 33 - 332-Functions.xlsx

    • 11 - 34 Perform Data Analysis
  • 34 - 341TIY.pdf
  • 34 - 341 Summarise Data from Multiple Ranges by using the Consolidate Feature
  • 34 - 341-4-pm.xlsx
  • 34 - 341-9-am.xlsx
  • 35 - 342TIY.pdf
  • 35 - 342 Perform WhatIf Analysis by using Goal Seek and Scenario Manager
  • 35 - 342-HelpLess-Charter-Scenario.xlsx
  • 35 - 342-HelpLess-Income-Ranges.xlsx
  • 36 - 343TIY.pdf
  • 36 - 343 Forecast Data by using the AND IF and NPER Functions
  • 36 - Financial-Functions.xlsx
  • 37 - 344TIY.pdf
  • 37 - 344 Calculate Data by using the PMT Function

    • 12 - 35 Troubleshoot Formulas
  • 38 - 351 Trace Precedence and Dependence
  • 39 - 352 Monitor Cells and Formulas by using the Watch Window
  • 40 - 353 Validate Formulas by using Error Checking Rules
  • 41 - 35TIY.pdf
  • 41 - 351-HelpLess-Income-Ranges.xlsx
  • 41 - 354 Evaluate Formulas

    • 13 - 36 Create and Modify Simple Macros
  • 42 - 361 to 363 Part 1 Record Name and Edit Simple Macros
  • 43 - 361TIY.pdf
  • 43 - 361 to 363 Part 2 Record Name and Edit Simple Macros

    • 14 - 41 Create and Modify Advanced Charts
  • 44 - 411 Create and Modify Dual Axis Charts
  • 44 - 411-Combo-and-Dual-Axis-Charts.xlsx
  • 44 - 441TIY.pdf
  • 45 - 412 Part 1 Create and Modify Charts including Box & Whisker Combo etc
  • 45 - 412-Part-1.xlsx
  • 45 - 412-Part-1-T.pdf
  • 46 - 412 Part 2 Create and Modify Charts including Box & Whisker Combo etc
  • 46 - 412-Part-2.xlsx
  • 46 - 412-Part-2-T.pdf
  • 47 - 412 Part 3 Create and Modify Charts including Box & Whisker Combo etc
  • 47 - 412-Part-3.xlsx
  • 47 - 412-Part-3-T.pdf

    • 15 - 42 Create and Modify Pivot Tables
  • 48 - Webinar on Pivot Tables and Charts March 11th 2021
  • 49 - 421TIY.pdf
  • 49 - 421 Create Pivot Tables
  • 49 - Training-Sales.xlsx
  • 50 - 422TIY.pdf
  • 50 - 422 Modify Field Selections and Options
  • 50 - Sales-Information.xlsx
  • 51 - 423TIY.pdf
  • 51 - 423 Create Slicers
  • 51 - Sales-Information-Data.xlsx
  • 52 - 424TIY.pdf
  • 52 - 424 Group Pivot Table Data
  • 52 - 424-Sales-Information-Data.xlsx
  • 53 - 425 Add Calculated Fields
  • 54 - 426 Format Data

    • 16 - 43 Create and Modify Pivot Charts
  • 55 - 431TIY.pdf
  • 55 - 431 Create PivotCharts
  • 55 - 431-Training-Sales.xlsx
  • 56 - 432TIY.pdf
  • 56 - 432 Manipulate Options in Existing PivotCharts
  • 56 - 432-Training-Sales.xlsx
  • 57 - 433 Apply Styles to PivotCharts
  • 58 - 434TIY.pdf
  • 58 - 434 Drill Down into PivotChart Details
  • 58 - 434-Training-Sales.xlsx

    • 17 - Exercise Book Solution Videos
  • 59 - Objective Domain 1 Exercise Solutions
  • 60 - Objective Domain 2 Exercise Solutions
  • 61 - Objective Domain 3 Exercise Solutions
  • 62 - Objective Domain 4 Exercise Solutions

    • 18 - MO201 Practice Exam and Video Solutions
  • 63 - How to use the Practice Exam
  • 64 - Exam 1 Project 1
  • 64 - exam-1-project-1.zip
  • 65 - Exam 1 Project 2
  • 65 - exam-1-project-2.zip
  • 66 - Exam 1 Project 3
  • 66 - exam-1-project-3.zip
  • 67 - Exam 1 Project 4
  • 67 - exam-1-project-4.zip
  • 68 - Exam 1 Project 5
  • 68 - exam-1-project-5.zip

    • 19 - Bonus Lecture
  • 69 - Bonus Lecture MOS University
  • 69 - MOS University Facebook Home.txt
  • 69 - MOS University Private Facebook Group.txt
  • 69 - MOS University Website.txt
  • 69 - MOS University YouTube Channel.txt
  • 70 - Bonus Lecture About MOS University
    • 54,900 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید اشتراک افزودن به سبد خرید
    خرید دانلودی فوری

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

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

    54,900 تومان
    افزودن به سبد خرید