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

Master Microsoft Excel: From Beginner to Pro!

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

Unlock the full potential of Microsoft Excel and become a valuable asset in any data-driven environment today!


1. Introduction
  • 1. Introduction

  • 2. Covering the basics of Excel
  • 1. Excel Home screen
  • 2. The interface inside of Excel
  • 3. Excel workbook and status bar
  • 4.1 Shortcuts Mac.pdf
  • 4.2 Shortcuts Windows.pdf
  • 4. Excel shortcuts and how to use them
  • 5. Excel Basics Quiz.html

  • 3. Formulas and Text editing
  • 1. Working with Excel spredsheet titles
  • 2. Numberic data and how we can work with it in Excel
  • 3. Working with Date values and date formating in Excel
  • 4. Cell references and how they work in Excel
  • 5. How to work with formulas
  • 6. Absolute and relative references in Excel
  • 7. Formulas Quiz.html

  • 4. Basic functions in Excel
  • 1. The SUM() function
  • 2. How MIN(), MAX() and AVARAGE() functions works
  • 3. What is the Adjacent error in Excel
  • 4.1 Top-30-useful-excel-functions.pdf
  • 4. Lets learn the CEILING(), FLOOR() and COUNT() functions
  • 5. Auto sum in Excel
  • 6. Excel AutoFill
  • 7. Excel Functions Quiz.html

  • 5. Excel data formatting
  • 1. Formatting our fonts
  • 2. Working with background colors
  • 3. Adding borders and border-styles
  • 4. Adding our currency
  • 5. Formatting percentage in Excel
  • 6. Excels format painter
  • 7. Creating custom styles in Excel
  • 8. Creating some formatting based on conditions
  • 9. Merging cells together
  • 10. Excel Formatting Quiz.html

  • 6. Tweak an worksheet in Excel
  • 1. Moving data inside an worksheet or between workbooks
  • 2. Editing the width and height of cells
  • 3. Adding Removing rows and columns
  • 4. Hiding and showing rows or columns
  • 5. Copying or moving an Excel worksheet
  • 6. Removing a worksheet or changing a name of a worksheet
  • 7. Worksheet Tweaks Quiz.html

  • 7. Working with Charts, Images and Shapes in Excel
  • 1. Adding Excel shapes to our worksheet
  • 2. Adding images into our worksheet
  • 3. How we can work with Excel smartArt in our worksheet
  • 4. Creating an line chart in excel and playing around with the chart ribbon
  • 5. Changing the data in our line-chart and moving the line chart
  • 6. Changing the chart type and adding a bit of formating
  • 7. Chart, Images and Shapes Quiz.html

  • 8. Excel templates and how to work with them
  • 1. Excel template into
  • 2. Working with and creating templates
  • 3. Excel Templates Quiz.html

  • 9. Great job! You now have a Microsoft Excel Foundation!
  • 1. Lets do a recap on what we have done

  • 10. Working with lists inside of Excel
  • 1.1 Employment.xlsx
  • 1. The structure of an Excel list
  • 2. Multi-Level and Single-Level list sorting
  • 3. Custom sort and filtering a list in Excel
  • 4. Finding and removing duplicates
  • 5. Convert a list to a table
  • 6. Excel List Quiz.html

  • 11. List functions in Excel
  • 1.1 division sales new 200.xlsx
  • 1. The DSUM() function
  • 2.1 division sales new 200.xlsx
  • 2. DSUM() With AND-statements or OR-statements
  • 3. The DCOUNT() function
  • 4. The DAVERAGE() function
  • 5. List Functions Quiz.html

  • 12. Import Export Data
  • 1.1 names data.xlsx
  • 1. Export data to a text file in Excel
  • 2. Import data from a text file in Excel
  • 3. Import Export Quiz.html

  • 13. Data validation in Excel
  • 1.1 Leads.xlsx
  • 1. Data validation List
  • 2.1 Excel email validation formula.txt
  • 2. Excel Email validation
  • 3. Excel date validation
  • 4. Excel Text validation
  • 5. Data Validation Quiz.html

  • 14. Working with large sets of data
  • 1. Grouping column and rows together
  • 2. Freeze Panes
  • 3. Working with printing options for large sets of data

  • 15. PivotTables
  • 1.1 perfume sales.xlsx
  • 1. The power of PivotTables
  • 2. Building our first PivotTable
  • 3. Grouping and Formatting Data in our PivotTable
  • 4. PivotCharts
  • 5. Filtering data in our PivotTable
  • 6. Styling our slicer
  • 7. Modifying sourceData for our PivotTable
  • 8. PivotTable Quiz.html

  • 16. WOW! You are now a midpro in excel!
  • 1. Lets do a small recap on what we have done

  • 17. Protecting out workbook or worksheet
  • 1. Protecting cells in our worksheet
  • 2. Adding a password to our workbook and protecting the workbook structure
  • 3. Excel Protection Quiz.html

  • 18. Conditional functions in Excel
  • 1.1 Sales competition 2024.xlsx
  • 1. Excels name ranges
  • 2. The IF() function
  • 3. Nesting functions inside of Excel
  • 4. The COUNTIFS() function
  • 5. The SUMIFS() function
  • 6. Conditional Functions Quiz.html

  • 19. Textbased functions in Excel
  • 1.1 products.xlsx
  • 1. The Left(), Right(), Mid() and Len() functions
  • 2. Using IF(), LEN() and RIGHT() functions together
  • 3. Using the SEARCH() and CONCATENATE() functions
  • 4. Textbased Functions Quiz.html

  • 20. Lookup functions in Excel
  • 1.1 employee sheet vlookup.xlsx
  • 1. The VLOOKUP() function
  • 2. IFERROR() function
  • 3. Working with absolute values in our lookup functions
  • 4. The HLOOKUP() function
  • 5. The MATCH() and INDEX() functions
  • 6. Using MATCH() AND INDEX() together

  • 21. Excel Automations with Macros
  • 1. Introduction into Excel macros
  • 2. Creating our first macro
  • 3. Saving our workbook with our macro
  • 4.1 Macro.xlsx
  • 4. How to edit our macro with VBA

  • 22. Becoming a master in the What if tools inside of Excel
  • 1.1 CarLoan.xlsx
  • 1. Working with the PMT() function and Goalseek tool
  • 2.1 shipping cost.xlsx
  • 2. The solver tool
  • 3. Data Tables
  • 4.1 Scenarios.xlsx
  • 4. Creating Scenarios

  • 23. Excel Auditing
  • 1. Dependents and Precendents tracing in Excel
  • 2. Show Formulas and Evaluate Formulas
  • 3. Error Checking
  • 4. Watch Windows in Excel

  • 24. Wrapping up the course
  • 1. Congratulations! Youre now a master in Excel!
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    افزودن به سبد خرید
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 40543
    حجم: 4965 مگابایت
    مدت زمان: 458 دقیقه
    تاریخ انتشار: ۱ آبان ۱۴۰۳
    دسته بندی محصول
    طراحی سایت و خدمات سئو

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