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

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

رمز خود را فراموش کرده اید؟
وب سایت تخصصی شرکت فرین
خانه » فروشگاه » آموزش های اداری و آفیس » آموزش Microsoft Excel » 77-728 Microsoft Excel 2016 Expert Certification

77-728 Microsoft Excel 2016 Expert Certification

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

77-728 Microsoft Certified Excel Expert - includes lectures, test exercises and video solutions PLUS Practice Exam


1 - Introduction
  • 1 - Introduction
  • 2 - March-2021-Objective-domain-Excel-Expert.pdf
  • 2 - Understanding the Objective Domain
  • 3 - COVID19 Testing Arrangements Exams From Home.txt
  • 3 - Certiport Testing Centre Locator.txt
  • 3 - Certiport Tutorial.txt
  • 3 - Console 8 Testing Interface.txt
  • 3 - How is the exam be conducted and what will it be like
  • 3 - MOS Expert Excel Microsoft Information.txt
  • 3 - Microsoft Official MOS Site.txt
  • 4 - Try It Yourself Exercises

    • 2 - 11 Manage Workbooks
  • 5 - 111T.pdf
  • 5 - 111 Save a Workbook as a Template
  • 6 - 112.pdf
  • 6 - 112 Copy Macros between Workbooks
  • 6 - macro-version-of-marketing-budget-workbook.zip
  • 7 - 1-pm.xlsx
  • 7 - 9-am.xlsx
  • 7 - 11-am.xlsx
  • 7 - 113TIY.pdf
  • 7 - 113 Reference Data in Another Workbook
  • 8 - 1.1.4-Structured-References.pdf
  • 8 - 114 Reference Data by using Structured References
  • 9 - 115TIY.pdf
  • 9 - 115 Enable Macros in a Workbook
  • 10 - 116TIY.pdf
  • 10 - 116 Display Hidden Ribbon Tabs

    • 3 - 12 Manage Workbook Review
  • 11 - 121 Restrict Editing
  • 12 - 122 Protect a Worksheet
  • 12 - 121122TIY.pdf
  • 12 - Hours-Worked.xlsx
  • 13 - 123TIY.pdf
  • 13 - 123 Configure Formula Calculation Options
  • 13 - Hours-Worked.xlsx
  • 14 - 124TIY.pdf
  • 14 - 124 Protect Workbook Structure
  • 15 - 125TIY.pdf
  • 15 - 125 Manage Workbook Versions
  • 16 - 126TIY.pdf
  • 16 - 126 Encrypt a Workbook with a Password

    • 4 - Objective Domain 1 Exercises & Solutions
  • 17 - Domain Objective 1 Manage Workbook Options and Settings Exercises & Solutions
  • 17 - HelpLess-Airlines-Passenger-Numbers.xlsx
  • 17 - Objective-Domain-1-Exercises.pdf
  • 17 - Sales-Information-Data.xlsx

    • 5 - 21 Apply Custom Data Formats and Validation
  • 18 - 2.1.1-Custom-Number-Formats.pdf
  • 18 - 211.xlsx
  • 18 - 211TIY.pdf
  • 18 - 211 Create Custom Number Formats
  • 19 - 212TIY.pdf
  • 19 - 212 Populate Cells by using Advanced Fill Series Options
  • 19 - 212-Resource.xlsx
  • 20 - 9-am.xlsx
  • 20 - 213TIY.pdf
  • 20 - 213 Configure Data Validation

    • 6 - 22 Apply Advanced Conditional Formatting and Filtering
  • 21 - 221TIY.pdf
  • 21 - 221 Create Custom Conditional Formatting Rules
  • 21 - 221-Monthly-Revenue.xlsx
  • 22 - 222TIY.pdf
  • 22 - 222 Create Conditional Formatting Rules that use Formulas
  • 22 - 222-Sales-Information.xlsx
  • 22 - Excel-workbook-for-2.2.2-Conditional-formatting-rules-that-use-formulas.xlsx
  • 22 - Monthly-Revenue.xlsx
  • 23 - 222 TIY Explanatory Lecture
  • 24 - 223TIY.pdf
  • 24 - 223 Manage Conditional Formatting Rules
  • 24 - 223-Conditions.xlsx

    • 7 - 23 Create and Modify Custom Workbook Elements
  • 25 - 231 Create Custom Colour Formats
  • 26 - 232 Create and Modify Cell Styles
  • 27 - 233 Create and Modify Custom Themes
  • 28 - 234 Part I Create and Modify Simple Macros
  • 29 - 234 Part II Create and Modify Simple Macros
  • 30 - 235 Part I Insert and Configure Form Controls
  • 31 - 2.3.5-Part-II-HelpLess-Airlines-Query-Form.pdf
  • 31 - 235 Part II Insert and Configure Form Controls
  • 31 - Template-for-Part-II-Insert-and-Configure-From-Controls.xlsx
  • 32 - 235 Part III Insert and Configure Form Controls

    • 8 - 24 Prepare a Workbook for Internationalisation
  • 33 - 241 and 242 Display Data in Multiple International Formats
  • 34 - 243 Manage Multiple Options for Body and Heading Fonts

    • 9 - Domain Objective 2 Exercises & Solutions
  • 35 - Domain Objective 2 Apply Custom Data Formats and Layouts Exercises & Solutions
  • 35 - HelpLess-Airlines-Marketing-Plan-2017-to-2022.xlsx
  • 35 - Objective-Domain-2-Exercises.pdf
  • 35 - Sales-Information-Data.xlsx

    • 10 - 31 Apply Functions in Formulas
  • 36 - 311 Perform Logical Operations by using AND OR and NOT Functions
  • 36 - HelpLess-Nested.xlsx
  • 36 - Sales-Information.xlsx
  • 37 - 312 Perform Logical Operations by using Nested Functions
  • 38 - 313 Perform Statistical Operations by using SUMIFS AVERAGEIFS and COUNTIFS

    • 11 - 32 Look Up Data by using Functions
  • 39 - 321 and 322 Look Up Data by using the VLOOKUP & HLOOKUP Functions
  • 40 - Hlookup Clarification Lecture
  • 41 - 323 Look Up Data by using the INDEX and MATCH Functions
  • 41 - 321234TIY.pdf
  • 41 - Lookup-Functions.xlsx

    • 12 - 33 Apply Advanced Date and Time Functions
  • 42 - 331TIY.pdf
  • 42 - 331 & 2 NOW TODAY Functions and Serialise Numbers
  • 42 - 331-Functions.xlsx

    • 13 - 34 Perform Data Analysis and Business Intelligence
  • 43 - Introduction to Domain Objective 34
  • 44 - 341 Part I Connecting to Data with Power Pivot
  • 45 - 341 Part II More on Power Pivot
  • 46 - 341 Part III Measures
  • 47 - 341 Part IV Get and Transform
  • 48 - 342TIY.pdf
  • 48 - 342 Consolidate Data
  • 48 - 342-4-pm.xlsx
  • 48 - 342-9-am.xlsx
  • 49 - 343TIY.pdf
  • 49 - 343 Perform Whatif Analysis by using Goal Seek and Scenario Manager
  • 49 - 343-HelpLess-Charter-Scenario.xlsx
  • 49 - 343-HelpLess-Income-Ranges.xlsx
  • 50 - 344 Cube Functions Part I
  • 51 - 344 Cube Functions Part II
  • 52 - 344 Cube Functions Part III
  • 53 - 345TIY.pdf
  • 53 - 345 Calculate Data by using Financial Functions

    • 14 - 35 Troubleshoot Formulas
  • 54 - 351 Trace Precedence and Dependence
  • 55 - 352 Monitor Cells and Formulas by using the Watch Window
  • 56 - 353 Validate Formulas by using Error Checking Rules
  • 57 - 351-HelpLess-Income-Ranges.xlsx
  • 57 - 354 Evaluate Formulas
  • 57 - 351234TIY.pdf

    • 15 - 36 Define Named Ranges and Objects
  • 58 - 361 and 362 Name Cells and Data Ranges
  • 59 - 363 Name Tables
  • 60 - 364 Manage Named Ranges and Objects
  • 60 - 361234.xlsx
  • 60 - 361234TIY.pdf

    • 16 - Domain Objective 3 Exercises & Solutions
  • 61 - Consolidation-Exercise.xlsx
  • 61 - Cube-functions.xlsx
  • 61 - Domain Objective 3 Create Advanced Formulas Exercises & Solutions
  • 61 - Flight-Date-and-Times.xlsx
  • 61 - HelpLess-Airlines-Marketing-Plan-2017-to-2022.xlsx
  • 61 - HelpLess-Charter-Scenarios.xlsx
  • 61 - Raw-Sales-Data.xlsx
  • 61 - Sales-Information-Data.xlsx
  • 61 - Section-3-Exercises-Jan-2019.pdf
  • 61 - Trace-Problems.xlsx
  • 61 - Training-Sales.xlsx

    • 17 - 41 Create Advanced Charts
  • 62 - 411 Add Trendlines to Charts
  • 63 - 412TIY.pdf
  • 63 - 412 Create Dualaxis Charts
  • 63 - 412-Combo-and-Dual-Axis-Charts.xlsx
  • 64 - 413 Save a Chart as a Template

    • 18 - 42 Create and Manage Pivot Tables
  • 65 - 421TIY.pdf
  • 65 - 421 Create Pivot Tables
  • 65 - Training-Sales.xlsx
  • 66 - 422TIY.pdf
  • 66 - 422 Modify Field Selections and Options
  • 66 - Sales-Information.xlsx
  • 67 - 423TIY.pdf
  • 67 - 423 Create Slicers
  • 67 - Sales-Information-Data.xlsx
  • 68 - 424TIY.pdf
  • 68 - 424 Group Pivot Table Data
  • 68 - 424-Sales-Information-Data.xlsx
  • 69 - 425 Reference Data in a Pivot Table by using the GETPIVOTDATA Function
  • 70 - 426 Add Calculated Fields
  • 71 - 427 Format Data

    • 19 - 43 Create and Manage Pivot Charts
  • 72 - 431TIY.pdf
  • 72 - 431 Create PivotCharts
  • 72 - 431-Training-Sales.xlsx
  • 73 - 432TIY.pdf
  • 73 - 432 Manipulate Options in Existing PivotCharts
  • 73 - 432-Training-Sales.xlsx
  • 74 - 433 Apply Styles to PivotCharts
  • 75 - 434TIY.pdf
  • 75 - 434 Drill Down into PivotChart Details
  • 75 - 434-Training-Sales.xlsx

    • 20 - Domain Objective 4 Exercises & Solutions
  • 76 - Domain Objective 4 Create Advanced Charts and Tables Exercises & Solutions
  • 76 - Exercises-Domain-4-Jan-2019.docx
  • 76 - HelpLess-Airlines-Marketing-Plan-2017-to-2022.xlsx
  • 76 - Raw-Sales-Data.xlsx

    • 21 - CUBE Functions Special Lecture
  • 77 - CUBE Function Questions
  • 77 - cube-functions-questions-november-2018.zip

    • 22 - 77728 Practice Exam and Video Solutions
  • 78 - Special Exam Considerations
  • 79 - How to use the Practice Exam Files
  • 80 - Integrated-Project-1-Pilots-and-Passengers-1.xlsx
  • 80 - Project 1 Pilots and Passengers Solution
  • 81 - Integrated-Project-2-Income-Analysis.xlsx
  • 81 - Project 2 Income Analysis Solution
  • 82 - Integrated-Project-3-Sales-Analysis.xlsx
  • 82 - Project 3 Sales Analysis Solution
  • 83 - Integrated-Project-4-Pilot-Performance.xlsx
  • 83 - Project 4 Pilot Performance Solution
  • 84 - Integrated-Project-5-Monthly-Merchandise-Sales-Analysis.xlsx
  • 84 - Project 5 Monthly Merchandise Solution
  • 85 - Zipped Exam Files.html
  • 85 - Zipped-Exam-Files.zip

    • 23 - Bonus Lecture Discount Coupon Facebook Group
  • 86 - Bonus Lecture MOS University
  • 86 - MOS University Facebook Home.txt
  • 86 - MOS University Private Facebook Group.txt
  • 86 - MOS University Website.txt
  • 86 - MOS University YouTube Channel.txt
    • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    افزودن به سبد خرید
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 13270
    حجم: 7587 مگابایت
    مدت زمان: 590 دقیقه
    تاریخ انتشار: ۲۰ خرداد ۱۴۰۲
    دسته بندی محصول
    Udemy-Training
    Udemy-Training
    مشاهده دوره های Udemy-Training
    دیگر آموزش های این مدرس
    طراحی سایت و خدمات سئو

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