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

Microsoft Excel – Beginners Introduction to Excel

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

Non-technical Professional Guide to Excel


1. Introduction & Simple Excel Operations
  • 1. Introduction
  • 2. Prerequisites
  • 3. Excel Knowledge Overview
  • 4.1 0. Excel file with some data.xlsx
  • 4. Understanding the Excel Environment
  • 5.1 0. Excel file with some data.xlsx
  • 5. Changing Settings in Excel Options
  • 6.1 0. Excel file with some data.xlsx
  • 6. Saving and Using Passwords for Excel
  • 7.1 1. Navigate between workbooks and worksheets.xlsx
  • 7. Navigating between Excel Worksheets
  • 8.1 1. Navigate between workbooks and worksheets.xlsx
  • 8. Navigating between Excel Workbooks
  • 9. Chapter 1 - Introduction and Basic Excel Quiz.html

  • 2. Working with Excel Data (Part 1)
  • 1.1 2. Copy and Paste Data.xlsx
  • 1. Intro to Copying & Pasting Data in Excel
  • 2.1 2. Copy and Paste Data.xlsx
  • 2. Pasting with Options
  • 3.1 2. Copy and Paste Data.xlsx
  • 3. Using the Paste Option Dialog Box
  • 4.1 2. Copy and Paste Data.xlsx
  • 4. Pasting from the Clip Board Button
  • 5.1 2. Copy and Paste Data.xlsx
  • 5. Replicating Worksheet data with Move or Copy tool
  • 6.1 3. Find and Replace.xlsx
  • 6. Intro to Find & Replace in Excel
  • 7.1 3. Find and Replace.xlsx
  • 7. Find & Replace Options
  • 8.1 3. Find and Replace.xlsx
  • 8. Find & Replace using Wild Card
  • 9.1 3. Find and Replace.xlsx
  • 9. Find & Replace using Wild Card
  • 10.1 3. Find and Replace.xlsx
  • 10. Find & Replace based on Cell Format
  • 11.1 4. Cell Formatting.xlsx
  • 11. Understanding Cells
  • 12. Increasing Cell Size, RowColumn Height & Width
  • 13.1 5. Cell Formatting (Custom Formatting).xlsx
  • 13. Understanding Excel Data Types
  • 14.1 5. Cell Formatting (Custom Formatting).xlsx
  • 14. Dates are treated like Numbers in Excel
  • 15.1 5. Cell Formatting (Custom Formatting).xlsx
  • 15. Intro to Cell Formatting
  • 16.1 5. Cell Formatting (Custom Formatting).xlsx
  • 16. Intro to Cell Formatting (2)
  • 17.1 5. Cell Formatting (Custom Formatting).xlsx
  • 17. Intro to Numbers Formatting
  • 18.1 5. Cell Formatting (Custom Formatting).xlsx
  • 18. Customizing Numbers Formatting
  • 19.1 5. Cell Formatting (Custom Formatting).xlsx
  • 19. Behavior of Text and Numbers Formatting
  • 20.1 5. Cell Formatting (Custom Formatting).xlsx
  • 20. Customizing Date Formats
  • 21.1 5. Cell Formatting (Custom Formatting).xlsx
  • 21. Cell Formatting Sample
  • 22. Chapter 2 - Working with Excel Data Part 1.html

  • 3. Working with Excel Data (Part 2)
  • 1.1 6. Data skills.xlsx
  • 1. Intro to Data Sorting in Excel
  • 2.1 6. Data skills.xlsx
  • 2. Basic Data Sorting
  • 3.1 6. Data skills.xlsx
  • 3. Sorting Data that has empty rows or columns
  • 4.1 6. Data skills.xlsx
  • 4. A better way to sort
  • 5.1 6. Data skills.xlsx
  • 5. More sorting options
  • 6.1 6. Data skills.xlsx
  • 6. Advanced Sorting options
  • 7.1 6. Data skills.xlsx
  • 7. Intro to Data Filtering in Excel
  • 8.1 6. Data skills.xlsx
  • 8. Clearing Filters & Using Search for Filtering
  • 9.1 6. Data skills.xlsx
  • 9. Filtering data based on rules
  • 10.1 6. Data skills.xlsx
  • 10. Using Advanced Filtering
  • 11.1 7. Freeze Panes and Outlines.xlsx
  • 11. Freeze Panes
  • 12.1 7. Freeze Panes and Outlines.xlsx
  • 12. Use Outlines for ExpandCollapsible Buttons
  • 13.1 8. Fill Series.xlsx
  • 13. Intro to Autofill and Fill Series
  • 14.1 8. Fill Series.xlsx
  • 14. Using Fill Dialog Box
  • 15.1 8. Fill Series.xlsx
  • 15. Fill Series with Linear & Growth
  • 16.1 8. Fill Series.xlsx
  • 16. Fill Series based on Trends
  • 17.1 8. Fill Series.xlsx
  • 17. Using Flash Fill
  • 18.1 9. Data Validation.xlsx
  • 18. Intro to Data Validation in Excel
  • 19.1 9. Data Validation.xlsx
  • 19. Creating Dropdown Lists in Excel
  • 20.1 10. Text to Columns.xlsx
  • 20. Text to Different Columns with Delimiters
  • 21.1 10. Text to Columns.xlsx
  • 21. Text to Columns using Fixed Width
  • 22. Chapter 3 - Working with Data Part 2.html

  • 4. Introduction to Excel Formulas
  • 1. Introduction to Excel Formulas
  • 2. Writing simple formulas with primitive values
  • 3.1 11. Aggregate Functions.xlsx
  • 3. Introduction to Excel Functions
  • 4.1 11. Aggregate Functions.xlsx
  • 4. How to use Functions in Excel
  • 5. Adding up with SUM function
  • 6.1 11. Aggregate Functions.xlsx
  • 6. Using Auto Sum to save time
  • 7.1 11. Aggregate Functions.xlsx
  • 7. Using AVERAGE, MIN, MAX, LARGE and SMALL
  • 8. Chapter 4 - Introduction to Formulas.html
  • 9. Wrap up
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    شناسه: 5904
    حجم: 1805 مگابایت
    مدت زمان: 240 دقیقه
    تاریخ انتشار: 3 اسفند 1401
    دیگر آموزش های این مدرس
    طراحی سایت و خدمات سئو

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