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

MO-211: Microsoft Excel Expert (Microsoft 365 Apps)

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

Learn the skills for the new MO-211 Excel certification. Create PivotTables, simple macros, advanced charts and formulas


1 - Introduction
  • 1 - Introduction
  • 2 - Welcome to Udemy.html
  • 3 - How to get the best out of your Udemy course
  • 4 - Do you want autotranslated subtitles in more languages.html
  • 5 - Curriculum
  • 6 - CustomFormatting.pdf
  • 6 - MO-211ExamRequirements230303.pdf
  • 6 - Resources.html
  • 6 - Section-2-Start.xlsx

  • 2 - Manage workbooks and Prepare workbooks for collaboration
  • 7 - Reference data in other worksheets
  • 7 - Section-2-Start.xlsx
  • 8 - 2 Reference data in other workbooks
  • 9 - 4 Manage workbook versions
  • 10 - 5 6 Protect worksheets and cell ranges and Restrict editing
  • 11 - 7 Protect workbook structure
  • 12 - Practice Activity Number 1.html
  • 13 - Practice Activity Number 1 The Solution

  • 3 - Format and validate data
  • 14 - 12 Create custom number formats integers
  • 14 - CustomFormatting.pdf
  • 14 - Section-3-Start.xlsx
  • 15 - 12 Create custom number formats fractions
  • 16 - 12 Create custom number formats dates and adding text and symbols
  • 17 - 12 Create custom number formats sections and colors
  • 18 - 13 Configure data validation numbers
  • 19 - 13 Configure data validation dates text and circle invalid data
  • 20 - 16 Remove duplicate records
  • 21 - Practice Activity Number 2.html
  • 22 - Practice Activity Number 2 The Solution

  • 4 - Create and modify PivotTables and PivotCharts
  • 23 - 39 Create PivotTables
  • 24 - 44 Configure value field settings
  • 25 - 40 Modify field selections and options PivotTable options and Refresh
  • 26 - 40 Modify field selections and options the PivotTable Analyze and Design tabs
  • 27 - 42 Group PivotTable data
  • 28 - 41 Create slicers
  • 29 - 41 Create timelines
  • 30 - 43 Add calculated fields
  • 31 - 4548 PivotCharts
  • 32 - Practice Activity Number 3.html
  • 33 - Practice Activity Number 3 The Solution

  • 5 - Create and modify advanced charts
  • 34 - 37 Create and modify dualaxis charts
  • 35 - 38a Box Whisker chart
  • 36 - 38b Combo chart and adding a dynamic chart title
  • 37 - 38c Funnel chart
  • 38 - 38d Histogram chart
  • 39 - 38e Sunburst chart
  • 40 - 38f Waterfall chart
  • 41 - Practice Activity Number 4.html
  • 42 - Practice Activity Number 4 The Solution

  • 6 - Perform logical operations in formulas
  • 43 - 20a n 33 IF NOT and using the Evaluate Formula button
  • 44 - 20l m AND and OR
  • 45 - 20l m Nesting AND and OR functions
  • 46 - 20b c IFS SWITCH
  • 47 - 20df SUMIF AVERAGEIF COUNTIF
  • 48 - 20gk SUMIFS AVERAGEIFS COUNTIFS MAXIFS MINIFS
  • 49 - 20o LET
  • 50 - Practice Activity Number 5.html
  • 51 - Practice Activity Number 5 The Solution

  • 7 - Look up data by using functions and use advanced date and time functions
  • 52 - 21bc The VLOOKUP function
  • 53 - 21b The difference between VLOOKUP and SUMIF
  • 54 - 21c HLOOKUP and looking for approximate matches
  • 55 - 21d MATCH
  • 56 - 21e INDEX
  • 57 - 21a XLOOKUP
  • 58 - 22 23 NOW TODAY and WEEKDAY
  • 59 - 23 WORKDAY
  • 60 - Practice Activity Number 6.html
  • 61 - Practice Activity Number 6 The Solution

  • 8 - Perform data analysis
  • 62 - 25 Perform whatif analysis by using Goal Seek
  • 63 - 25b Perform whatif analysis by using Scenario Manager
  • 64 - 26 Forecast data by using the AND IF and NPER functions
  • 65 - 27 Calculate financial data by using the PMT function
  • 66 - 28 Filter data by using FILTER
  • 67 - 29 Sort data by using SORTBY
  • 68 - Practice Activity Number 7.html
  • 69 - Practice Activity Number 7 The Solution

  • 9 - Other formula topics
  • 70 - 8 Configure formula calculation options
  • 71 - 11 Generate numeric data by using RANDARRAY
  • 72 - 14 Group and ungroup data
  • 73 - 15 Calculate data by inserting subtotals and totals
  • 74 - 24 Summarize data from multiple ranges by using the Consolidate feature
  • 75 - 30 Trace precedence and dependence
  • 76 - 31 Monitor cells and formulas by using the Watch Window
  • 77 - 32 Validate formulas by using error checking rules
  • 78 - Practice Activity Number 8.html
  • 79 - Practice Activity Number 8 The Solution

  • 10 - Fill cells based on existing data and apply advanced conditional formatting
  • 80 - 9 Fill cells by using Flash Fill
  • 81 - 10 Fill cells by using advanced Fill Series options
  • 82 - 17 19 Create custom conditional formatting rules and managing rules
  • 83 - 18 Create conditional formatting rules that use formulas number conditions
  • 84 - 18 Create conditional formatting rules that use formulas datetext conditions
  • 85 - Practice Activity Number 9.html
  • 86 - Practice Activity Number 9 The Solution

  • 11 - Create and modify simple macros
  • 87 - 34 35 Record and name simple macros
  • 88 - 3 Enable macros in a workbook
  • 89 - 36 Edit simple macros
  • 90 - 1 Copy macros between workbooks
  • 91 - Practice Activity Number 10.html
  • 92 - Practice Activity Number 10 The Solution

  • 12 - Conclusion
  • 93 - Whats Next
  • 94 - Thank you very much
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    افزودن به سبد خرید
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    شناسه: 14159
    حجم: 5482 مگابایت
    مدت زمان: 479 دقیقه
    تاریخ انتشار: ۲۹ خرداد ۱۴۰۲
    طراحی سایت و خدمات سئو

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