- 242
- 306 368
Sam Hijazi
Приєднався 24 бер 2010
Відео
"Understanding Excel's Logical Operators: AND, OR, XOR, and NOT"
Переглядів 127Рік тому
Description: In this Excel tutorial video, we'll be delving into the world of logical operators, specifically the AND, OR, XOR, and NOT operators. We'll start by explaining the concept of logical operators and their importance in data analysis. Then, we'll dive into each operator and demonstrate how they work using practical examples. By the end of this video, you'll have a solid understanding ...
"Excel for Beginners: Simple Charting - Column, Combo, Sparklines, and Thermometer Charts"
Переглядів 39Рік тому
In this beginner-friendly tutorial, we'll show you how to create simple charts in Excel that can help you visualize your data and make better decisions. Whether you're a student, a small business owner, or just someone who wants to analyze their data, this video will teach you a practical skill that you can use in your daily life. We'll start by explaining the different types of charts you can ...
"Excel for Beginners: How to Use PMT() and Create an Amortization Table to Track Interest Payments"
Переглядів 74Рік тому
In this beginner-friendly tutorial, we'll show you how to use the PMT() function in Excel to create an amortization table and track interest payments over a period of time. Whether you're a student, a small business owner, or just someone who wants to keep track of their finances, this video will teach you a practical skill that you can use in your daily life. We'll start by explaining what the...
"Excel Formulas for Beginners: Count, CountA, CountIFS, SumIFS, and AverageIFS"
Переглядів 67Рік тому
In this video, we will explore some of the most commonly used Excel formulas for data analysis and reporting. We will start with the basic Count and CountA formulas, which can be used to count the number of cells that contain data in a range, or the number of non-empty cells in a range, respectively. Next, we will dive into more advanced formulas like CountIFS, SumIFS, and AverageIFS. These for...
Pra"Excel if() Function for Practical Use: A Beginner's Guide"ctical if function
Переглядів 74Рік тому
Welcome to our UA-cam video on "Practical Use of if() Function in Excel". If you're new to using Microsoft Excel or just starting out with programming, you might be curious about how to use the if() function for practical purposes. In this video, we'll explain how to use the if() function to make decisions based on certain conditions. We'll walk you through some simple examples, showing you how...
"Mastering vlookup() and hlookup() Functions in Excel: A Beginner's Guide"
Переглядів 100Рік тому
Welcome to our UA-cam video on "Making Quick Decisions in Excel with vlookup() and hlookup() Functions". If you're looking to make quick decisions based on a range of criteria in Excel, you'll be interested in learning about vlookup() and hlookup() functions. In this video, we'll explain how vlookup() and hlookup() functions work, and show you how to use them to quickly find and retrieve data f...
"Understanding Nested if() Functions in Excel: A Beginner's Guide"
Переглядів 58Рік тому
Welcome to our UA-cam video on "Mastering Nested if() Functions in Excel: A Beginner's Guide". If you've been using if() functions in Excel and are looking to take your skills to the next level, you might be interested in learning about nested if() functions. Nested if() functions are powerful tools that allow you to perform complex calculations and analysis in Excel. In this video, we'll take ...
"Excel if() Functions Made Easy: A Step-by-Step Tutorial for Beginners"
Переглядів 98Рік тому
Welcome to our UA-cam video on "Excel if() Functions Made Easy: A Step-by-Step Tutorial for Beginners". If you're new to using Microsoft Excel or just starting out with programming, you might find if() functions to be a bit intimidating. But don't worry - we're here to make it easy! In this video, we'll take you through the basics of if() functions, explaining what they are and how they work. W...
Video 2 Simple Calculations
Переглядів 123Рік тому
Title: "Excel Tutorial: Simple Calculations with Dr. Sam Hijazi" Description: In this Excel tutorial, Dr. Sam Hijazi demonstrates how to perform simple calculations using functions such as average, sum, absolute address, and relative address. Whether you're a beginner or an intermediate user, this video is perfect for anyone looking to improve their Excel skills. Follow along as Dr. Hijazi walk...
"Excel's Rule of Orders: How Mathematical Calculations are Performed in Excel"
Переглядів 3862 роки тому
Welcome to our UA-cam video on "How Excel Does Mathematical Calculations: Understanding the Order of Operations". If you're new to using Microsoft Excel or just starting out with programming, you might be curious about how Excel does its mathematical calculations. In this video, we'll explain the rule of orders or the order of operations, which Excel uses to perform mathematical calculations. W...
SQL Difference between Having and Where
Переглядів 574 роки тому
SQL Difference between Having and Where
Thank youu sir
Thank you sir
Thank you
thank you very very much, I was hopeless for this solution...
'PromoSM' 🤘
thanks a lot, a quick view of this solved my problem. thanks
select name, population, concat(round(100*population/ (select population from world where name = 'germany')),'%') as pergermany from world where continent = 'europe'; this query says the round function needs 2, 3 arguments. so when i alter the query select name, population, concat(round(100*population/ (select population from world where name = 'germany'), 0),'%') as pergermany from world where continent = 'europe'; the output looks like: Albania 2821977 3.000000000000% Andorra 76098 0.000000000000% Austria 8504850 11.000000000000% Belarus 9467000 12.000000000000 how can it be fixed?
What does the P value represent?
P value is probability of rejecting Ho while is true. Is called type one error. As standard p if p value is bigger than 0.05 Ho stands otherwise is rejected. A much better explanation of F test you will find on channel Top Tip Bio : Perform a two samples F test in Excel.
Thanks in a million. Great content. Awesome. Very well explained. I couldn't find this explanation--simply put anywhere else. Great teachers are hard to find. Grade: A++💥
Can you post a video for performing the same in scilab plz
can we use function argument if yes, How ?
THANK YOU
life saver, thank you
Thank you so much! You literally saved my life on my econometrics test
Thx Bro.
ربي يوفقك ياغالي
very bay explanation
So what is the optimal amount of ads and sales? Is it the derivative of the function equalized to 0 to find the Max?
It has to be so when you are going with GRG non linear. But if you do not select multi start option, you will end up with local optimal solution rather than global optimal solution
Pssshhh. I don't really know what you did but thanks. Lol.
So helpful! Thank you!
Hi
how can I put this in to my web ?
Wow, Well Explained .. Thank you so much
Thank you so much
my lecturer force us to make an app using ms excel despite he never teach us about tht. im so mad rn but thanks to this video i can finally figure smthng out. hopefully
Hi
Plz reply
bad explanation
these data 4153.2 ; -8757.9 ; R^2 = 92.26% are obtained (without using Solver) ,with only one formula selection 5 Files + 2 Columns (in office 365 is not necessary) , paste =LINEST(B3:B12,LN(A3:A12),,1) CTRL+SHIFT+ENTER (in office 365 is not necessary)
Sorry, but I am a bit confused on the business logic behind the setup... how can the "Number of ads" be explained by the "Volume of sales", shouldn't the variables actually be switched around to explain the relation?
This is linear regression not nonlinear
this is nonlinear because it has a nonlinear component in the form of ln(x)
It's wonderful... God bless you 💖
this is really cool.. why would anyone dislike this video? Thank you Sam!
Assalam Alaykum, thank you for these awesome videos!
Nothing was better...
This is well organized and fairly easy to follow. I was able to complete the exercise after playing a few sections over. It works.
you can't rename them to A1 and A2 because those are already the names of other cells that exist in the spreadsheet
In which version excel such kind of facility available? Plz help me.
2007 se suru karke jitne versions h sab mein milega.
how can we convert the excel sheet that you made into android app?
mis leading it already an excel application. Nothing new developed
Nice
thannkss very helpfull
Watch this in 1.5 x speed
Hi will an F-test still be useful if am comparing decimal values ( 0 -1) with whole large numbers ?Am trying to do a validity test from two different methods.
thank you very much!
Thank you for this great video!
Thanks Dr sam
You're welcome my young friend.
Very nice trick, do you think we can do it with unbalanced tasks and persons. I have the same problem with much more persons than tasks. Thanks for your answer
Thank god for the new mic haha
Thank you! This helped me understand.
You are so welcome!!
Hi Dr. Hijazi, thank you for posting this video. how can I contact you to ask some question?
mlih