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

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

رمز خود را فراموش کرده اید؟
وب سایت تخصصی شرکت فرین
خانه » فروشگاه » Complete Techniques for MO-210 Excel 365 Apps Certification

Complete Techniques for MO-210 Excel 365 Apps Certification

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

70 lectures, practice exercises with all lectures, comprehensive Exercise Book with video solutions


01 - Introduction
  • 001 Course Introduction
  • 001 Exercise-Book-for-MO-210-Excel-Associate.pdf
  • 001 MO-210-Skills-Measured.pdf
  • 002 How the exam is conducted
  • 003 Try It Yourself Exercises
  • external-links.txt

    • 02 - Introducing the Microsoft Excel User Interface
  • 001 Introducing the Excel 365 Apps User Interface
  • 002 Essential Navigation Skills
  • 003 Entering Information

    • 03 - Import Data Into Workbooks
  • 001 Customers.csv
  • 001 HelpLess-Details.txt
  • 001 Import Data into Workbooks
  • 001 Import-Data-into-Workbooks-TIY.pdf
  • 001 Names.txt
  • 001 employees.zip

    • 04 - Navigate Within Workbooks
  • 001 Search for Data within a Workbook
  • 001 Search-For-Data-within-a-Workbook-TIY.pdf
  • 001 Search-for-Data.xlsx
  • 002 Hyperlinks.xlsx
  • 002 Navigate.xlsx
  • 002 Navigate to Named Cells, Ranges etc - Insert and Remove Hyperlink
  • 002 Navigate-Within-Workbooks-TIY.pdf

    • 05 - Format Worksheets and Workbooks
  • 001 Modify Page Setup
  • 001 Modify-Page-Setup.pdf
  • 001 Modify-Page-Setup.xlsx
  • 002 Adjust Row Height and Column Width
  • 002 Adjust-Row-Height-and-Column-Width.xlsx
  • 002 Adjust-Row-Height-and-Column-Width-TIY.pdf
  • 003 Customise Headers and Footers
  • 003 Customise-Headers-and-Footers.pdf
  • 003 Customise-Headers-and-Footers.xlsx
  • 004 Customise-the-QAT.pdf
  • 004 Manage the Quick Access Toolbar
  • 004 customise-the-qat.zip
  • 005 Display and Modify Worksheets in Different Views
  • 005 Display-and-Modify-Worksheets-in-Different-Views-TIY.pdf
  • 005 Display-in-Different-Views.xlsx
  • 006 Freeze Worksheet Rows and Columns
  • 007 Change Window Views
  • 007 Change-Window-Views.pdf
  • 007 Change-Window-Views.xlsx
  • 008 Modify Built-in Workbook Properties
  • 008 Modify-Built-in-Properties.pdf
  • 008 Modify-Properties.xlsx
  • 009 Display Formulas
  • 009 Display-Formulas.pdf
  • 009 Display-Formulas.xlsx

    • 06 - Prepare Workbooks for Collaboration and Distribution
  • 001 Set a Print Area
  • 001 Set-a-Print-Area.pdf
  • 001 Set-a-Print-Area.xlsx
  • 002 Save and Export Workbooks in Alternative File Formats
  • 002 Save-Alternatives.xlsx
  • 002 Save-and-Export-Workbooks-in-Alternative-File-Formats.pdf
  • 003 Configure Print Settings
  • 003 Configure-Print-Settings.pdf
  • 003 Configure-Print-Settings.xlsx
  • 004 Inspect1.xlsx
  • 004 Inspect2.xlsx
  • 004 Inspect3.xlsx
  • 004 Inspect Workbooks and Correct Issues
  • 004 Inspect-and-Correct-Issues.pdf
  • 005 Manage Comments and Notes
  • 005 Manage-Comments.xlsx
  • 005 Manage-Comments-TIY.pdf

    • 07 - Manipulate Data in Worksheets
  • 001 Paste Data by using Special Paste Options
  • 001 Paste-Special.pdf
  • 001 Paste-Special.xlsx
  • 002 Auto-Fill.pdf
  • 002 Auto-Fill.xlsx
  • 002 Fill Cells by using Auto Fill
  • 003 Insert and Delete Multiple Columns, Rows and Cells
  • 003 Insert-Delete.xlsx
  • 003 Insert-and-Delete.pdf
  • 004 Generate Numeric Data by using RANDBETWEEN() and SEQUENCE()
  • 004 RANDBETWEEN-SEQUENCE.xlsx
  • 004 Randbetween-Sequence.pdf

    • 08 - Format Cells and Ranges
  • 001 Merge and Unmerge Cells
  • 002 Modify Cell Alignment, Orientation and Indentation
  • 003 Format Cells by using Format Painter
  • 004 Merge-Align.pdf
  • 004 Merge-Align.xlsx
  • 004 Wrap Text within Cells
  • 005 Apply Number Formats
  • 005 Apply-Number-Formats.pdf
  • 005 Apply-Number-Formats.xlsx
  • 006 Apply Cell Formats from the Format Cells Dialog Box
  • 007 Apply Cell Styles
  • 007 Apply-Cell-formats.xlsx
  • 007 Apply-Cell-formats-and-Styles.pdf
  • 008 Apply-Cell-formats.xlsx
  • 008 Apply-Cell-formats-and-Styles.pdf
  • 008 Clear Cell Formatting

    • 09 - Define and Reference Named Ranges
  • 001 Define and Reference a Named Range
  • 001 Define-and-Refererence-Named-Range.pdf
  • 001 Named-Range.xlsx

    • 10 - Summarize Data Visually
  • 001 Insert Sparklines
  • 001 Insert-sparklines.pdf
  • 001 Sparklines.xlsx
  • 002 Apply Built-in Conditional Formatting
  • 002 Apply-Conditional.pdf
  • 002 Apply-Conditional.xlsx
  • 003 Remove Conditional Formatting
  • 003 Remove-Conditional.pdf
  • 003 Remove-Conditional.xlsx

    • 11 - Create and Format Tables
  • 001 Create Excel Tables from Cell Ranges & Convert Tables to Cell Ranges
  • 001 Create-Tables.pdf
  • 001 Create-Tables.xlsx

    • 12 - Modify Tables
  • 001 Apply and Configure Table Styles including Total Rows
  • 002 Add or Remove Table Rows and Columns
  • 002 Modify-Tables.pdf
  • 002 Modify-Tables.xlsx

    • 13 - Filter and Sort Table Data
  • 001 Filter Records
  • 001 Filter-Records.pdf
  • 001 Filter-Records.xlsx
  • 002 Multiples.xlsx
  • 002 Sort Data by Multiple Columns
  • 002 Sort-by-Multiples.pdf

    • 14 - Insert References
  • 001 Insert Relative, Absolute and Mixed References (Part 1)
  • 002 Insert Relative, Absolute and Mixed References (Part 2)
  • 002 Insert-References.pdf
  • 002 Insert-References.xlsx
  • 003 Use Structured References in Formulas

    • 15 - Calculate and Transform Data
  • 001 Perform Calculations by using the AVER(), MAX(), MIN() and SUM() Functions
  • 002 Calculate-Using-Functions.xlsx
  • 002 Calculate-using-functions.pdf
  • 002 Count Cells by using the COUNT(), COUNTA() and COUNTBLANK() Functions
  • 003 IF-Functions.pdf
  • 003 IF-Functions.xlsx
  • 003 Perform Conditional Operations by using the IF() Function
  • 004 Sort Data by using the SORT() Function
  • 004 Sort-Function.xlsx
  • 004 Sort-Functions.pdf
  • 005 Get Unique Values by using the UNIQUE() Function
  • 005 Unique.xlsx
  • 005 Unique-Functions.pdf

    • 16 - Format and Modify Text
  • 001 Format Text by using Text Functions
  • 002 Format Text using CONCAT & TEXTJOIN Functions
  • 002 Text-Functions.xlsx
  • 002 Text-functions.pdf

    • 17 - Create Charts
  • 001 Create Charts and Chart Sheets

    • 18 - Modify Charts
  • 001 Add Data Series to Charts and Switch Between Rows and Columns in Source Data
  • 002 Add and Modify Chart Elements
  • 002 Modify-Charts.xlsx
  • 002 Modify-charts.pdf

    • 19 - Format Charts
  • 001 Apply Chart Layouts and Styles
  • 002 Add Alternative Text to Charts for Accessibility

    • 20 - Solutions to Course Exercises
  • 002 Navigate Within Workbooks
  • 003 Format Worksheets and Workbooks
  • 004 Customize Options and Views
  • 005 Configure Content for Collaboration
  • 006 Manipulate Data in Worksheets
  • 007 Format Cells and Ranges
  • 008 Define and Reference Named Ranges
  • 009 Create, Format and Modify Tables
  • 010 Filter and Sort Table Data
  • 011 Insert References and Calculate and Transform Data
  • 012 Format and Modify Text
  • 013 Create Charts
  • 014 Modify and Format Charts

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

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

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 26767
    حجم: 2923 مگابایت
    مدت زمان: 335 دقیقه
    تاریخ انتشار: ۲۶ آذر ۱۴۰۲
    دسته بندی محصول
    Udemy
    Udemy
    مشاهده دوره های Udemy
    دیگر آموزش های این مدرس
    طراحی سایت و خدمات سئو

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