Curated Video
Excel: Freezing Panels in Excel
In this video, the concept of 'Freezing Panes' will be discussed, a feature that assists in maintaining the visibility of column or row labels when navigating through large spreadsheets.
Curated Video
Excel: Sorting and Filtering Data in Excel
This video will introduce tools to sort and filter data, teaching how to organize data in alphabetical order, reverse sort, and create custom sorts using multiple criteria. It also demonstrates how to filter records based on specific...
Curated Video
Excel: Common Excel Functions
This video introduces the student to a variety of basic functions available in Excel, including SUM, AVERAGE, MIN, and MAX, and how to apply them to a range of cells, thereby enabling the student to perform basic statistical analyses on...
Curated Video
Excel: Absolute and Relative References in Excel
This video discusses the difference between relative and absolute cell addressing, showcasing how to create formulas using both types and their unique behaviors when copied and pasted.
Curated Video
Excel: Creating Simple Excel Formulas
This video explains how to create simple mathematical formulas, such as multiplication, and how to format cells for specific data types like currency. Additionally, it demonstrates the process of copying and pasting formulas to different...
Curated Video
Excel: How to Use an Excel Function
We'll explore the powerful mathematical capabilities of Excel, showcasing how to create formulas to sum a series of cells with ease.
Curated Video
Excel: Formatting Cells in Excel
You'll discover how to format cells to meet your specific needs, altering text styles, changing text and background color, modifying the typeface, and adding borders around cells.
Curated Video
Excel: Exploring the Excel Interface
In this section, we're going to introduce you to the world of Excel's interface. Together, we'll explore the variety of tools at your disposal, located in the ribbon, tabs, and menus at the top of your screen.You'll discover how to...
Curated Video
Excel: Entering and Editing Data in Excel
You will learn to confidently input various types of data into Excel cells, including text, numerical data, and formulas.
Curated Video
القوائم المنسدلة المترابطة في الإكسل - طريقة INDIRECT
تصميم القوائم المسندلة في الإكسل بطريقة معادلة Indirect
Curated Video
تعامل مع الإكسل بطريقة احترافية
تعامل مع الإكسل بطريقة احترافية من خلال الاختصارات والأدوات المفيدة
Curated Video
خطوة بخطوة | تجميع البيانات من عدة ملفات باستخدام الكويري في برنامج الإكسل
فيديو متميز يعرض الطريقة الأقوى والأمثل في عملية تجميع البيانات من عدة ملفات في برنامج الإكسل، والتحديث يتم بكبسة زر! تابعوا معنا هذا الدرس من السلسلة التعليمية خطوة بخطوة. المدرب: المنذر سفان
Curated Video
Learn Shapes in French for Kids - تعليم الأشكال للاطفال باللغة الفرنسية
Let's Learn the ٍFrench Shapes with this cartoon Video from The Little Muslim in a fun and unique way with our cute characters. This video will make your kids laugh and smile while teaching the names of most basic shapes: Circle,...
Curated Video
Fruits in French for Kids - أسماء الفواكه باللغة الفرنسية للأطفال
Let's Learn the ٍFruits in French with this cartoon Video from The Little Muslim in a fun and unique way with our cute characters. This video will make your kids laugh and smile while teaching the names of fruits in French: Apple,...
Curated Video
R Programming for Statistics and Data Science - Creating a Data Frame in R
This video explains creating a data frame in R. This clip is from the chapter "Data Frames" of the series "R Programming for Statistics and Data Science".This section explains data frames.
APMonitor
Find Equation Roots with Excel
Two examples show how to (1) find the roots of a cubic equation and (2) find the roots of the Redlich Kwong equation of state that relates pressure and temperature to molar volume for read gasses.
APMonitor
Solve Linear Equations with Python
Linear equations such as A*x=b are solved with NumPy in Python. This tutorial demonstrates how to create a matrix (A) and vector (b) as NumPy arrays and solve the set of equations with linalg.solve
APMonitor
Nonlinear Regression in Python
A three parameter (a,b,c) model y = a + b/x + c ln(x) is fit to a set of data with the Python APMonitor package. This tutorial walks through the process of installing the solver, setting up the objective (normalized sum of squared...
APMonitor
MathCAD Functions and Matrices
Mathcad is a tool to arrange, calculate, and visualize engineering calculations and functions can help with reusing expressions in subsequent evaluations. Use the following worksheets to step through example problems related to using...
APMonitor
Curve Fit with Excel and Python
Nonlinear regression with heart rate data is shown in both Microsoft Excel and Python. GEKKO and SciPy curve_fit are used as two alternatives in Python. Heart rate data is available at...
APMonitor
Fit Nonlinear Model to Data with Excel
Microsoft Excel adjusts parameters to minimize the difference between measured and predicted values. This tutorial demonstrates how to calculate the sum of squared errors and minimize error with the Solver add-in. See...
APMonitor
Simulate Differential Equations with Python ODEINT
The heights of a dual gravity drained tank are solved with the Scipy.integrate function ODEINT. This example demonstrates how to solve the differential equation and plot the solution.
Catalyst University
Lineweaver-Burk Equation Theory and Derivation
Lineweaver-Burk Equation Theory and Derivation
APMonitor
Numpy and Loops in Python
This introductory homework assignment solution covers Numpy and loops (for and while) in Python. The example problems use simple vectors and matrices, reshaping, index referencing, initialization, dot product, cross product, matrix...