Sam Hijazi
Sam Hijazi
  • 242
  • 306 368

Відео

"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...
Video 002
Переглядів 1272 роки тому
Introduction to Excel, Fill handle, Using Sum funciton
Video 001
Переглядів 832 роки тому
Very easy introduction to MS Excel.
Creating M-M relationship using SQL
Переглядів 364 роки тому
Creating M-M relationship using SQL
Chi - Square Testing for Independence
Переглядів 504 роки тому
Chi - Square Testing for Independence
Chi -Square Goodness of Fits
Переглядів 424 роки тому
Chi -Square Goodness of Fits
Dr. Hijazi Chatpter 10 Video 2
Переглядів 304 роки тому
Dr. Hijazi Chatpter 10 Video 2
Dr Hijazi Chapter 10 video 1
Переглядів 264 роки тому
Dr Hijazi Chapter 10 video 1
Excel Subtotal
Переглядів 384 роки тому
Excel Subtotal
Chapter 8 SQL Examples
Переглядів 874 роки тому
Chapter 8 SQL Examples
Recording #250
Переглядів 164 роки тому
Recording #250
Creating Table SQL
Переглядів 564 роки тому
Creating Table SQL
SQL EXISTS and CASE
Переглядів 2144 роки тому
SQL EXISTS and CASE
Chatper 008
Переглядів 194 роки тому
Chatper 008
Chapter 8 Video 002
Переглядів 174 роки тому
Chapter 8 Video 002
Ch8 - video 001
Переглядів 424 роки тому
Ch8 - video 001
SQL Quiz 4
Переглядів 184 роки тому
SQL Quiz 4
Sql quiz 3
Переглядів 164 роки тому
Sql quiz 3
Peer-to peer VS. Client Server
Переглядів 664 роки тому
Peer-to peer VS. Client Server
SQL Difference between Having and Where
Переглядів 574 роки тому
SQL Difference between Having and Where

КОМЕНТАРІ

  • @surbanoclarabel5544
    @surbanoclarabel5544 9 місяців тому

    Thank youu sir

  • @jizelolasiman2242
    @jizelolasiman2242 9 місяців тому

    Thank you sir

  • @britneysalin-jv9rk
    @britneysalin-jv9rk 9 місяців тому

    Thank you

  • @saddamalameer6994
    @saddamalameer6994 Рік тому

    thank you very very much, I was hopeless for this solution...

  • @loreleitrageser3904
    @loreleitrageser3904 Рік тому

    'PromoSM' 🤘

  • @grizzlybear-plays9607
    @grizzlybear-plays9607 Рік тому

    thanks a lot, a quick view of this solved my problem. thanks

  • @thepassingpawn
    @thepassingpawn 2 роки тому

    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?

  • @bentonjones6978
    @bentonjones6978 2 роки тому

    What does the P value represent?

    • @antygona-iq8ew
      @antygona-iq8ew 2 роки тому

      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.

  • @johng5295
    @johng5295 2 роки тому

    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++💥

  • @9986916092
    @9986916092 2 роки тому

    Can you post a video for performing the same in scilab plz

  • @xxbeastxx8060
    @xxbeastxx8060 2 роки тому

    can we use function argument if yes, How ?

  • @Attairtube
    @Attairtube 2 роки тому

    THANK YOU

  • @aa-vg4vs
    @aa-vg4vs 2 роки тому

    life saver, thank you

  • @jamiyana4969
    @jamiyana4969 2 роки тому

    Thank you so much! You literally saved my life on my econometrics test

  • @supakitpaipan543
    @supakitpaipan543 2 роки тому

    Thx Bro.

  • @abeeralrabea4933
    @abeeralrabea4933 2 роки тому

    ربي يوفقك ياغالي

  • @tamiltamil-hj9yb
    @tamiltamil-hj9yb 2 роки тому

    very bay explanation

  • @kotrynele
    @kotrynele 3 роки тому

    So what is the optimal amount of ads and sales? Is it the derivative of the function equalized to 0 to find the Max?

    • @chandrakanthmalyala1942
      @chandrakanthmalyala1942 2 роки тому

      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

  • @pandaonsteroids5154
    @pandaonsteroids5154 3 роки тому

    Pssshhh. I don't really know what you did but thanks. Lol.

  • @18dvasquez
    @18dvasquez 3 роки тому

    So helpful! Thank you!

  • @samkaur3972
    @samkaur3972 3 роки тому

    Hi

  • @tajfataband6413
    @tajfataband6413 3 роки тому

    how can I put this in to my web ?

  • @aditibhushan19
    @aditibhushan19 3 роки тому

    Wow, Well Explained .. Thank you so much

  • @jongcheulkim7284
    @jongcheulkim7284 4 роки тому

    Thank you so much

  • @flynn1698
    @flynn1698 4 роки тому

    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

  • @aminipo8829
    @aminipo8829 4 роки тому

    bad explanation

  • @LEO_rumano
    @LEO_rumano 4 роки тому

    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)

  • @michelelombardo681
    @michelelombardo681 4 роки тому

    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?

  • @changbadinesh
    @changbadinesh 5 років тому

    This is linear regression not nonlinear

    • @namanbader
      @namanbader 2 роки тому

      this is nonlinear because it has a nonlinear component in the form of ln(x)

  • @gloriavalentinernesto7652
    @gloriavalentinernesto7652 5 років тому

    It's wonderful... God bless you 💖

  • @josemiguelbaztan9607
    @josemiguelbaztan9607 5 років тому

    this is really cool.. why would anyone dislike this video? Thank you Sam!

  • @TheStraightPath
    @TheStraightPath 5 років тому

    Assalam Alaykum, thank you for these awesome videos!

  • @dinhvietcuong2239
    @dinhvietcuong2239 5 років тому

    Nothing was better...

  • @robertcormia7970
    @robertcormia7970 6 років тому

    This is well organized and fairly easy to follow. I was able to complete the exercise after playing a few sections over. It works.

  • @tska84
    @tska84 6 років тому

    you can't rename them to A1 and A2 because those are already the names of other cells that exist in the spreadsheet

  • @mamtapandey7410
    @mamtapandey7410 6 років тому

    In which version excel such kind of facility available? Plz help me.

    • @Sanghitabasu50
      @Sanghitabasu50 4 роки тому

      2007 se suru karke jitne versions h sab mein milega.

  • @albatrossBird007
    @albatrossBird007 6 років тому

    how can we convert the excel sheet that you made into android app?

  • @NavdeepSingh-kn7uu
    @NavdeepSingh-kn7uu 6 років тому

    mis leading it already an excel application. Nothing new developed

  • @beedoog0717
    @beedoog0717 6 років тому

    Nice

  • @ahmedsaadoun7541
    @ahmedsaadoun7541 6 років тому

    thannkss very helpfull

  • @mominahussain5552
    @mominahussain5552 6 років тому

    Watch this in 1.5 x speed

  • @JosephAsamoah
    @JosephAsamoah 6 років тому

    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.

  • @Georgia90
    @Georgia90 6 років тому

    thank you very much!

  • @celltrix1
    @celltrix1 6 років тому

    Thank you for this great video!

  • @anassawadi498
    @anassawadi498 6 років тому

    Thanks Dr sam

  • @johannafuchshuber8163
    @johannafuchshuber8163 7 років тому

    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

  • @Taylor14Baseball
    @Taylor14Baseball 7 років тому

    Thank god for the new mic haha

  • @rockangelie5
    @rockangelie5 7 років тому

    Thank you! This helped me understand.

  • @Mono-xz5qh
    @Mono-xz5qh 7 років тому

    Hi Dr. Hijazi, thank you for posting this video. how can I contact you to ask some question?

  • @khadkhad8057
    @khadkhad8057 7 років тому

    mlih