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

Excel for Engineering Professionals

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

While Microsoft Excel can be a powerful tool for engineers, most engineers barely scratch the surface with its full functionality. In this course, designed for advanced Excel users, Microsoft MVP Jan Karel Pieterse gives you an overview of some of the most robust features in Excel that can help you complete many common tasks as a mechanical, chemical, or structural engineer. Get a primer on what tasks are best suited for Excel in relation to other functions and tools as well as the most useful functions for engineering projects, from ranges and lookups to strings, arrays, and more. Get ready to use Excel to solve complex problems, work with charts, and import and analyze data sets. By the end of this course, you’ll be ready to start leveraging workbooks, sheets, cells, arrays, conditions, loops, and events for VBA programming.


01 - Introduction
  • 01 - Engineering and Excel

  • 02 - 1. Spreadsheet Design Best Practices
  • 01 - Knowing when (and when not) to use Excel
  • 02 - Designing a workbook
  • 03 - Documenting your work
  • 04 - Formula habits
  • 05 - Working with engineering units
  • 06 - Improving data quality with data validation
  • 07 - Working with tables

  • 03 - 2. Essential Excel Functions
  • 01 - Date and time functions
  • 02 - Range names
  • 03 - XLOOKUP and other lookup functions
  • 04 - Statistical functions AVERAGE, STDEV, MIN, and MAX
  • 05 - String functions
  • 06 - Working with dynamic arrays

  • 04 - 3. Solving Complex Problems
  • 01 - Using Excel for process simulations
  • 02 - Goal seek
  • 03 - Excel Solver

  • 05 - 4. Working with Charts
  • 01 - Which chart type to use
  • 02 - Dos and donts
  • 03 - Working with charts Preparing your data
  • 04 - Working with charts Staging area
  • 05 - Trends in charts Trendlines

  • 06 - 5. Importing Data
  • 01 - Importing text files with Power Query
  • 02 - Importing sets of files
  • 03 - Importing the most recent file in a folder

  • 07 - 6. Data Analysis
  • 01 - When (and when not) to use PivotTables
  • 02 - Regression analysis Analysis Toolpak add-in
  • 03 - Regression analysis Helpful functions

  • 08 - 7. VBA Basics
  • 01 - Variables explained
  • 02 - Working with workbooks, worksheets, and cells
  • 03 - Working with arrays
  • 04 - Conditions If, Then, and Select Case
  • 05 - Loops For...Next and Do...Loop
  • 06 - Events Automatically run VBA code

  • 09 - 8. User-Defined Functions (VBA)
  • 01 - How to write a proper user-defined function (UDF)
  • 02 - Understanding LAMBDA functions
  • 03 - Creating a LAMBDA function

  • 10 - Conclusion
  • 01 - What have you learned
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    شناسه: 20474
    حجم: 461 مگابایت
    مدت زمان: 206 دقیقه
    تاریخ انتشار: 15 مهر 1402
    طراحی سایت و خدمات سئو

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