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

جمع جزء: 139,000 تومان

مشاهده سبد خریدتسویه حساب

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

77-727 Microsoft Excel 2016 Core Certification

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

Prepare with confidence for the 77-727! Includes complete exercise book, individual lecture exercises and practice exam!


1 - Introduction
  • 1 - What is Microsoft Office Specialist MOS Certification
  • 2 - Objective-Domain-MOS-Uni.pdf
  • 2 - Understanding the Objective Domain
  • 3 - Certiport Testing Centre Locator.txt
  • 3 - Certiport Tutorial.txt
  • 3 - Compass Overview.txt
  • 3 - Exams from Home Information.txt
  • 3 - How is the exam be conducted and what will it be like
  • 3 - MOS Core Excel Microsoft Information.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 - Student Exercise Files
  • 8 - Course Exercise Workbook.html
  • 8 - Course-Workbook-March-2020.pdf
  • 9 - Student Files
  • 9 - Student-Resource-Files-April-2020.zip

    • 4 - 11 Create Worksheets and Workbooks
  • 10 - 111.pdf
  • 10 - 111 Create a Workbook
  • 11 - 112TIY.pdf
  • 11 - 112 Importing Data from a Delimited Text File
  • 11 - Customers.csv
  • 11 - HelpLess-Details.txt
  • 11 - Names.txt
  • 12 - 113TIY.pdf
  • 12 - 113 Add a Worksheet to an Existing Workbook
  • 12 - Multi-Sheets.xlsx
  • 13 - 114.xlsx
  • 13 - 114TIY.pdf
  • 13 - 114 Copy and Move a Worksheet
  • 14 - Exercises Domain 11
  • 14 - Objectives-1.1-Exercises-MOS-University.pdf

    • 5 - 12 Navigate in Worksheets and Workbooks
  • 15 - 121 & 122 Search & Navigate to a Named Cell Range or Workbook Element
  • 15 - 1212.pdf
  • 15 - 1212.xlsx
  • 16 - 122 Named Ranges
  • 17 - 123.pdf
  • 17 - 123.xlsx
  • 17 - 123 Insert and Remove hyperlinks
  • 18 - Exercises Domain 12
  • 18 - Objective-1.2-Exercises.pdf

    • 6 - 13 Format Worksheets and Workbooks
  • 19 - 131 to 133 Changing Worksheet Characteristics
  • 19 - 13123.xlsx
  • 19 - 13123TIY.pdf
  • 20 - 134.xlsx
  • 20 - 134TIY.pdf
  • 20 - 134 Modify Page Setup
  • 21 - 135.xlsx
  • 21 - 135TIY.pdf
  • 21 - 135 Insert and Delete Columns or Rows and Cells
  • 22 - 136.xlsx
  • 22 - 136TIY.pdf
  • 22 - 136 Change Workbook Themes
  • 23 - 137.xlsx
  • 23 - 137TIY.pdf
  • 23 - 137 Adjust Row Height and Column Width
  • 24 - 138.xlsx
  • 24 - 138TIY.pdf
  • 24 - 138 Insert Headers and Footers
  • 25 - Exercises Domain 13
  • 25 - Objective-1.3-Exercises-MOS-University.pdf

    • 7 - 14 Customise Options and Views for Worksheets and Workbooks
  • 26 - 141 and 142 Hide or Unhide Worksheets Columns and Rows
  • 26 - 1412.xlsx
  • 26 - 1412TIY.pdf
  • 27 - 143.zip
  • 27 - 143TIY.pdf
  • 27 - 143 Customise the Quick Access Toolbar
  • 28 - 144.xlsx
  • 28 - 144TIY.pdf
  • 28 - 144 Change Workbook Views
  • 29 - 145.xlsx
  • 29 - 145TIY.pdf
  • 29 - 145 Change Window Views
  • 30 - 146.xlsx
  • 30 - 146TIY.pdf
  • 30 - 146 Modify Document Properties
  • 31 - 147.xlsx
  • 31 - 147TIY.pdf
  • 31 - 147 Change Magnification by using Zoom Tools
  • 32 - 148.xlsx
  • 32 - 148TIY.pdf
  • 32 - 148 Display Formulas
  • 33 - Exercises Domain 14
  • 33 - Objective-1.4-Exercises-MOS-Uni.pdf

    • 8 - 15 Configure Worksheets and Workbooks for Distribution
  • 34 - 151.xlsx
  • 34 - 151TIY.pdf
  • 34 - 151 Set a Print Area
  • 35 - 152.xlsx
  • 35 - 152TIY.pdf
  • 35 - 152 Save Workbooks in Alternative File Formats
  • 36 - 153 Print All of Part of a Workbook
  • 37 - 154 Set Print Scaling
  • 38 - 155 Display Repeating Row and Column Titles on Multipage Worksheets
  • 38 - 15345.xlsx
  • 38 - 15345TIY.pdf
  • 39 - 156.xlsx
  • 39 - 156TIY.pdf
  • 39 - 156 Inspect a Workbook for Hidden Properties or Personal Information
  • 40 - 157.xlsx
  • 40 - 157TIY.pdf
  • 40 - 157 Inspect a Workbook for Accessibility Issues
  • 41 - 158.xlsx
  • 41 - 158TIY.pdf
  • 41 - 158 Inspect a Workbook for Compatibility Issues
  • 42 - Exercises 15
  • 42 - Objective-1.5-Exercises-MOS-Uni.pdf

    • 9 - Manage Worksheets & Workbooks Exam Seminar
  • 43 - Seminar Series Manage Worksheets & Workbooks

    • 10 - 21 Insert Data in Cells and Ranges
  • 44 - 211.xlsx
  • 44 - 211TIY.pdf
  • 44 - 211 Replace Data
  • 45 - 212.xlsx
  • 45 - 212TIY.pdf
  • 45 - 212 Cut Copy or Paste Data
  • 46 - 213.xlsx
  • 46 - 213TIY.pdf
  • 46 - 213 Paste Data by using Special Paste Options
  • 47 - 214.xlsx
  • 47 - 214TIY.pdf
  • 47 - 214 Fill Cells by using Auto Fill
  • 48 - 215.xlsx
  • 48 - 215TIY.pdf
  • 48 - 215 Insert and Delete Cells
  • 49 - Exercises Domain 21
  • 49 - Objectives-2.1-Exercises-MOS-Uni.pdf

    • 11 - 22 Format Cells and Ranges
  • 50 - 221 Merge Cells
  • 51 - 222 Modify Cell Alignment and Indentation
  • 52 - 223 Format Cells by using Format Painter
  • 53 - 224 Wrap Text Within Cells
  • 53 - 221234.xlsx
  • 53 - 221234TIY.pdf
  • 54 - 225.xlsx
  • 54 - 225TIY.pdf
  • 54 - 225 Apply Number Formats
  • 55 - 226 Apply Cell Formats
  • 56 - 227 Apply Cell Styles
  • 56 - 2267.xlsx
  • 56 - 2267TIY.pdf
  • 57 - Exercises Domain 22
  • 57 - Objective-2.2-Exercises-MOS-Uni.pdf

    • 12 - 23 Summarise and Organise Data
  • 58 - 231.xlsx
  • 58 - 231TIY.pdf
  • 58 - 231 Insert Sparklines
  • 59 - 232 and 233 Outline Data and Insert Subtotals
  • 59 - 2323.xlsx
  • 59 - 2323TIY.pdf
  • 60 - 234.xlsx
  • 60 - 234TIY.pdf
  • 60 - 234 Apply Conditional Formatting
  • 61 - Exercises Domain 23
  • 61 - Objective-2.3-Exercises-MOS-Uni.pdf

    • 13 - 31 and 32 Create and Manage Tables
  • 62 - 311 and 312 Create an Excel Table from a Cell Range and Reverse
  • 63 - 313 Add or Remove Table rows and Columns
  • 64 - 321 to 323 Table Styles
  • 64 - 3123.xlsx
  • 64 - 3123TIY.pdf
  • 65 - Exercises Domain 31 and 32
  • 65 - Objectives-3.1-and-3.2-Exercises-MOS-Uni.pdf

    • 14 - 33 Filter and Sort a Table
  • 66 - 331.xlsx
  • 66 - 331TIY.pdf
  • 66 - 331 Filter Records
  • 67 - 332 and 333 Sort Data
  • 68 - 334 Remove Duplicate Records
  • 68 - 33234.xlsx
  • 68 - 33234TIY.pdf
  • 69 - Exercises Domain 33
  • 69 - Objective-3.3-Exercises-MOS-Uni.pdf

    • 15 - 41 Summarise Data by Using Functions
  • 70 - 411 Part I Insert References
  • 71 - 411.xlsx
  • 71 - 411TIY.pdf
  • 71 - 411 Part II Absolute References
  • 72 - 412 Perform Calculations by using the SUM Function
  • 73 - 413 to 415 Using the Average MIN MAX and COUNT Functions
  • 73 - 4125.xlsx
  • 73 - 4125TIY.pdf
  • 74 - Exercises Domain 41
  • 74 - Objective-4.1-Exercises-MOS-Uni.pdf

    • 16 - 42 Perform Conditional Operations by Using Functions
  • 75 - 421.xlsx
  • 75 - 421TIY.pdf
  • 75 - 421 Perform Logical Operations by using the IF Function
  • 76 - 422 to 424 Using the AverageIF COUNTIF and SUMIF Functions
  • 76 - 4224.xlsx
  • 76 - 4224TIY.pdf
  • 77 - Exercises Domain 42
  • 77 - Objective-4.2-Exercises-MOS-Uni.pdf

    • 17 - 43 Format and Modify Text by Using Functions
  • 78 - 431 to 433 Format Text by using Text Functions
  • 78 - 4313.xlsx
  • 78 - 4313TIY.pdf
  • 79 - Exercises Domain 43
  • 79 - Objective-4.3-Exercises-MOS-Uni.pdf

    • 18 - 51 Create Charts
  • 80 - 511 Create a New Chart
  • 81 - 512 and 513 Add Additional Data Series and Switch Rows and Columns
  • 82 - 514 Analyse Data by using Quick Analysis
  • 82 - 5114.xlsx
  • 82 - 5114TIY.pdf
  • 83 - Exercises Domain 51
  • 83 - Objective-5.1-Exercises-MOS-Uni.pdf

    • 19 - 52 Format Charts
  • 84 - 521 Resize Charts
  • 85 - 522 Add and Modify Chart Elements
  • 86 - 523 and 524 Apply Chart Layouts and Styles and Move Charts
  • 86 - 5214.xlsx
  • 86 - 5214TIY.pdf
  • 87 - Exercises Domain 52
  • 87 - Objective-5.2-Exercises-MOS-Uni.pdf

    • 20 - 53 Insert and Format Objects
  • 88 - 531 Insert Text Boxes and Shapes
  • 89 - 532 Insert Images
  • 90 - 533 Modify Object Properties
  • 91 - 534 Add Alternative Text to Objects for Accessibility
  • 91 - 5314.xlsx
  • 91 - 5314TIY.pdf
  • 91 - moss-university-logo4.zip
  • 92 - Exercises Domain 53
  • 92 - Objective-5.3-Exercises-MOS-Uni.pdf

    • 21 - 77727 Sample Practice Exam
  • 93 - How To Use the Practice Exam
  • 94 - Project 1 Solution
  • 94 - project-1-pilots-and-passengers.zip
  • 95 - Project 2 Solution
  • 95 - project-2-income-analysis.zip
  • 96 - Project 3 Solution
  • 96 - project-3-sales-analysis.zip
  • 97 - Project 4 Solution
  • 97 - project-4-pilot-performance.zip
  • 98 - Project 5 Solution
  • 98 - project-5-monthly-merchandise-sales-analysis.zip
  • 99 - Project 6 Solution
  • 99 - project-6-helpless-airlines-marketing-plan-2017-to-2022.zip
  • 100 - Project 7 Solution
  • 100 - project-7-training-sales.zip

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

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

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

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