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

The Complete Excel Bootcamp: From Beginner to Expert

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

Learn essential Excel skills with a beginner's guide, including formulas, spreadsheets, charts, pivot tables, dashboards


1. Introduction
  • 1.1 Datasets.pdf
  • 1.2 Datasets.zip
  • 1. Introduction to the Course
  • 2.1 Datasets.pdf
  • 2.2 Datasets.zip
  • 2. What is Excel and why use it

  • 2. The Basics of Excel
  • 1.1 Datasets.pdf
  • 1.2 Datasets.zip
  • 1. Understanding Excel s Interface
  • 2.1 Datasets.pdf
  • 2.2 Datasets.zip
  • 2. A Note about the Course
  • 3.1 Datasets.pdf
  • 3.2 Datasets.zip
  • 3. Introduction to the Excel Ribbon
  • 4.1 Datasets.pdf
  • 4.2 Datasets.zip
  • 4. Introduction to Project 1
  • 5.1 Datasets.pdf
  • 5.2 Datasets.zip
  • 5. Styling on Excel
  • 6.1 Datasets.pdf
  • 6.2 Datasets.zip
  • 6. Cell Referencing and Introduction to Basic Formulas
  • 7.1 Datasets.pdf
  • 7.2 Datasets.zip
  • 7. Formatting Cells on Excel
  • 8.1 Datasets.pdf
  • 8.2 Datasets.zip
  • 8. Referencing other Sheets, Hiding and Changing Tab Colours
  • 9.1 Datasets.pdf
  • 9.2 Datasets.zip
  • 9. Adding Notes and Comments on Excel

  • 3. Tables and Formulas on Excel
  • 1.1 Datasets.pdf
  • 1.2 Datasets.zip
  • 1. Tables on Excel
  • 2.1 Datasets.pdf
  • 2.2 Datasets.zip
  • 2. Sorting, Filtering, Slicing and Removing Duplicates
  • 3.1 Datasets.pdf
  • 3.2 Datasets.zip
  • 3. Introduction to Project 2
  • 4.1 Datasets.pdf
  • 4.2 Datasets.zip
  • 4. Introduction to Formulas and Functions (Working with Operations)
  • 5.1 Datasets.pdf
  • 5.2 Datasets.zip
  • 5. Using Functions in Excel
  • 6.1 Datasets.pdf
  • 6.2 Datasets.zip
  • 6. Working with Inequalities
  • 7.1 Datasets.pdf
  • 7.2 Datasets.zip
  • 7. Using the Formula Bar and tracing precedents and dependents
  • 8.1 Datasets.pdf
  • 8.2 Datasets.zip
  • 8. Working with Dates (Using WEEKDAY and WEEKNUM)
  • 9.1 Datasets.pdf
  • 9.2 Datasets.zip
  • 9. Working with Errors
  • 10.1 Datasets.pdf
  • 10.2 Datasets.zip
  • 10. Using Name Manager
  • 11.1 Datasets.pdf
  • 11.2 Datasets.zip
  • 11. Using Round and an Introduction to Nested Formulas

  • 4. Popular Functions and Formulas
  • 1.1 Datasets.pdf
  • 1.2 Datasets.zip
  • 1. Introduction to Project 3
  • 2.1 Datasets.pdf
  • 2.2 Datasets.zip
  • 2. Joining Cells using Ampersand and TEXTJOIN
  • 3.1 Datasets.pdf
  • 3.2 Datasets.zip
  • 3. Separating Text using TEXTSPLIT and Text to Columns
  • 4.1 Datasets.pdf
  • 4.2 Datasets.zip
  • 4. Using Lookup Functions (VLOOKUP)
  • 5.1 Datasets.pdf
  • 5.2 Datasets.zip
  • 5. Using XLOOKUP
  • 6.1 Datasets.pdf
  • 6.2 Datasets.zip
  • 6. Using HLOOKUP
  • 7.1 Datasets.pdf
  • 7.2 Datasets.zip
  • 7. Changing Case using Formulas on Excel
  • 8.1 Datasets.pdf
  • 8.2 Datasets.zip
  • 8. Using the TRIM Function
  • 9.1 Datasets.pdf
  • 9.2 Datasets.zip
  • 9. Extracting Text from Excel
  • 10.1 Datasets.pdf
  • 10.2 Datasets.zip
  • 10. Using Find and Replace
  • 11.1 Datasets.pdf
  • 11.2 Datasets.zip
  • 11. Using IF Statements
  • 12.1 Datasets.pdf
  • 12.2 Datasets.zip
  • 12. Conditional Formatting
  • 13.1 Datasets.pdf
  • 13.2 Datasets.zip
  • 13. Data Bars, Icon Sets and Color Scales

  • 5. Charts, Pivot Tables and Dashboards
  • 1.1 Datasets.pdf
  • 1.2 Datasets.zip
  • 1. Introduction to Charts
  • 2.1 Datasets.pdf
  • 2.2 Datasets.zip
  • 2. Creating Column Charts
  • 3.1 Datasets.pdf
  • 3.2 Datasets.zip
  • 3. Creating Bar Charts on Excel
  • 4.1 Datasets.pdf
  • 4.2 Datasets.zip
  • 4. Creating Line Charts on Excel
  • 5.1 Datasets.pdf
  • 5.2 Datasets.zip
  • 5. Creating Histograms on Excel
  • 6.1 Datasets.pdf
  • 6.2 Datasets.zip
  • 6. Creating Spark Lines on Excel
  • 7.1 Datasets.pdf
  • 7.2 Datasets.zip
  • 7. Introduction to Pivot Tables
  • 8.1 Datasets.pdf
  • 8.2 Datasets.zip
  • 8. Adding Percents to Pivot Tables
  • 9.1 Datasets.pdf
  • 9.2 Datasets.zip
  • 9. Filters, Slicers and Timelines in Pivot Tables
  • 10.1 Datasets.pdf
  • 10.2 Datasets.zip
  • 10. Introduction to Pivot Charts
  • 11.1 Datasets.pdf
  • 11.2 Datasets.zip
  • 11. Dashboards on Excel

  • 6. Important Formulas and Tips to Know
  • 1.1 Datasets.pdf
  • 1.2 Datasets.zip
  • 1. Working with Dates on Excel (adding, subtracting dates)
  • 2.1 Datasets.pdf
  • 2.2 Datasets.zip
  • 2. Using SUMIF on Excel
  • 3.1 Datasets.pdf
  • 3.2 Datasets.zip
  • 3. Hiding Rows and Columns on Excel
  • 4.1 Datasets.pdf
  • 4.2 Datasets.zip
  • 4. Data Validation on Excel
  • 5.1 Datasets.pdf
  • 5.2 Datasets.zip
  • 5. Remove Duplicates on Table
  • 6.1 Datasets.pdf
  • 6.2 Datasets.zip
  • 6. Using Grouping on Excel
  • 7.1 Datasets.pdf
  • 7.2 Datasets.zip
  • 7. Fill in Blanks in Excel
  • 8.1 Datasets.pdf
  • 8.2 Datasets.zip
  • 8. Using Search and Find
  • 9.1 Datasets.pdf
  • 9.2 Datasets.zip
  • 9. Freezing Rows and Columns
  • 10.1 Datasets.pdf
  • 10.2 Datasets.zip
  • 10. Protecting Sheets, Cells and Workbooks
  • 11.1 Datasets.pdf
  • 11.2 Datasets.zip
  • 11. Printing on Excel
  • 12. Conclusion
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    افزودن به سبد خرید
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 10249
    حجم: 3255 مگابایت
    مدت زمان: 342 دقیقه
    تاریخ انتشار: ۴ اردیبهشت ۱۴۰۲
    طراحی سایت و خدمات سئو

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