Codible
Codible
  • 149
  • 8 545 743
Date functions in Excel
Walks you through some of the date functions, such as:
today() - for getting today's date,
datevalue() - for getting the date from a text field,
year(), month(), day() and weekday() for extracting year, month or day number from a date,
date() for joining numbers to get a date,
workday() - to get the date that is a certain number of working days away from the current date,
networkdays() - to get the difference in working days between two given dates, and
datediff() - to get the number of days, months or years elapsed between two dates.
Переглядів: 856

Відео

Overview of text functions in Excel
Переглядів 5603 роки тому
This video provides an overview of some important text manipulation functions in Excel - how to extract the first few characters of a string, last few characters, middle few characters, convert all strings to upper or lowercase or propercase, replace some characters by location or by content, trip strings - remove unwanted blanks, and so on.
Import files from Google Storage into Google BigQuery and write queries
Переглядів 17 тис.3 роки тому
This video walks you through how to import a CSV file from Google Storage, into Google BigQuery, and how to write queries on this file. It then shows you how to save your results to a new table in BigQuery, and save (export) this table back to a csv file in Google Storage.
Using Excel Circular References To Do Calculations
Переглядів 18 тис.3 роки тому
This video shows you how to use the Excel Circular References feature to perform iterative calculations. These are calculations where two or more cells are inputs to each other - e.g. cell C5 is an input to the formula in cell C9, and cell C9 is also an input into the formula in cell C5. This demo uses the example of a company's pre-tax and post-tax profit.
Using PySpark on Dataproc Hadoop Cluster to process large CSV file
Переглядів 17 тис.3 роки тому
This video shows you how to use JupyterLab terminal on Dataproc Hadoop Cluster, to import very large CSV files from the internet, directly onto your Google Cloud Storage (without first downloading these large files to your personal computer). Next, it shows you how to process these files using PySpark dataframes on Jupyter Notebook, transform the data, and save updated data to your Google Storage.
Connecting to a Hadoop cluster on Google Dataproc with Jupyter Notebook
Переглядів 7 тис.3 роки тому
This video takes you through how to create a simple Hadoop cluster on Google Dataproc, along with all the settings needed to be able to (a) connect to the cluster using a Jupyter Notebook, (b) save the Jupyter Notebook on a Google Storage bucket, and (c) connect to the cluster Master computer through a terminal. This is part-1 of a two-part series. (In part 2, I will walk you through how to imp...
Understanding normal distribution concept with Excel norm.dist example
Переглядів 2,6 тис.3 роки тому
This video gives a simple grocery store example of normal distribution and shows how to use the Excel norm.dist function to calculate some useful probabilities for a normal distribution.
Creating a Histogram in Excel
Переглядів 41 тис.3 роки тому
See how to create a histogram in Excel.
Installing Analysis Toolpak in Excel for Statistical Analysis
Переглядів 17 тис.3 роки тому
This video demonstrates how to install the Analysis Tookpak for statistical analysis in Excel.
Introduction to Excel and walk-through of important features
Переглядів 3694 роки тому
This is an introductory video of Excel, covering topics such as (i) How to start Excel and open a file (ii) A description of the layout, tabs, ribbons, columns, rows (iii) Cells, ranges, worksheets (iv) Data entry - creation of a simple table of data (v) Formatting data and text (vi) Basics of automatic computation using formulas
How much should you save for retirement? Use the Excel Future Value function to calculate.
Переглядів 3 тис.4 роки тому
If you save a certain fixed amount, an "annuity", every month or every period, what will be the value of that entire stream of cash flows, at a future date? I show you how to calculate this from first principles. Then, I show you the excel future value function to calculate this.
Run queries on your Google Cloud bucket data using BigQuery
Переглядів 6 тис.4 роки тому
You can store tabular data in csv or other formats on Google Storage, in buckets. To query this data, you can use Google BigQuery. This video shows you how. See my book for more: www.amazon.com/Data-Analytics-Google-Cloud-Hands-ebook/dp/B087XZZ2C6/
Uploading large files to Google Storage using a VM Instance
Переглядів 11 тис.4 роки тому
If you have a really large file - upwards of 100 MB - that you want to import to your Google Cloud storage, you can bypass your personal computer, and instead use Google Cloud VM Instance. This is quicker and more efficient. This video shows you how. See my book for more details: www.amazon.com/Data-Analytics-Google-Cloud-Hands-ebook/dp/B087XZZ2C6/ Install the wget command in Linux: sudo apt-ge...
Google Storage - how to upload a file to a bucket
Переглядів 10 тис.4 роки тому
Learn to upload a csv file to a bucket on Google Cloud's Storage.
Import tab delimited text file into excel 2019
Переглядів 88 тис.4 роки тому
Describes how to import a tab-delimited text file into Excel 2019. Shows how to treat column headings properly, and create an excel table with column headings.
Login to AWS EC2 via Windows 10 OpenSSH, without Putty
Переглядів 13 тис.4 роки тому
Login to AWS EC2 via Windows 10 OpenSSH, without Putty
Excel - using match and index functions together
Переглядів 2,5 тис.4 роки тому
Excel - using match and index functions together
Using Excel Match function to row number of a text in a range
Переглядів 31 тис.4 роки тому
Using Excel Match function to row number of a text in a range
index function
Переглядів 4714 роки тому
index function
Headers and footers in excel 2016
Переглядів 6735 років тому
Headers and footers in excel 2016
Excel range name manager
Переглядів 2,1 тис.5 років тому
Excel range name manager
Connect to AWS EC2 instance via ssh from windows
Переглядів 130 тис.5 років тому
Connect to AWS EC2 instance via ssh from windows
Create range names from table fields in Excel
Переглядів 11 тис.5 років тому
Create range names from table fields in Excel
Range names in Excel 2016
Переглядів 4905 років тому
Range names in Excel 2016
Codible SQLite video 11: SQL query with subquery, both referencing the same table
Переглядів 2,2 тис.5 років тому
Codible SQLite video 11: SQL query with subquery, both referencing the same table
Codible SQLite video 10: subquery with interblock reference in SQLite3
Переглядів 3155 років тому
Codible SQLite video 10: subquery with interblock reference in SQLite3
Codible SQLite video 9: SQLite3: retrieval with multiple levels of nesting
Переглядів 9516 років тому
Codible SQLite video 9: SQLite3: retrieval with multiple levels of nesting
Codible SQLite video 8: Subquery with IN keyword in SQLite3
Переглядів 4176 років тому
Codible SQLite video 8: Subquery with IN keyword in SQLite3
Codible SQLite video 7: Doing a self-join of a table with itself in SQLite3
Переглядів 9476 років тому
Codible SQLite video 7: Doing a self-join of a table with itself in SQLite3
Codible SQLite video 6: SQLite3 - how a JOIN works
Переглядів 8026 років тому
Codible SQLite video 6: SQLite3 - how a JOIN works

КОМЕНТАРІ

  • @sherylofwona2821
    @sherylofwona2821 День тому

    Thank you so much! This was incredibly clear and helpful

  • @walelala
    @walelala 6 днів тому

    helpful

  • @reshmag7825
    @reshmag7825 18 днів тому

    Thank you!😇

  • @deandanderson4006
    @deandanderson4006 Місяць тому

    Solved my problem another video couldn't, thank!

  • @Alpines_5th
    @Alpines_5th Місяць тому

    Informative video ❤

  • @kaitlinaffleck9676
    @kaitlinaffleck9676 Місяць тому

    This video made me realize that my professor has no idea what he is talking about and I'm completely screwed. He gets his assignment questions from Chegg.

  • @sulochanavijerathna9600
    @sulochanavijerathna9600 Місяць тому

    Thanks

  • @user-ym3bm7lm4v
    @user-ym3bm7lm4v Місяць тому

    Best explanation on the net! Excellent investment / excel content timeless information... even after 11 years! Thank You!🤑

  • @redrhino2048
    @redrhino2048 2 місяці тому

    Thanks a lot, buddy! You are my hero! Your explanation was so simple and clear. I regret not finding you sooner.

  • @ahmedali3017
    @ahmedali3017 2 місяці тому

    Thanks to you.

  • @teslazation
    @teslazation 3 місяці тому

    God Bless you my friend. This solved my problem.

  • @mustardwithglasses6508
    @mustardwithglasses6508 3 місяці тому

    Thank you so much

  • @esek308
    @esek308 3 місяці тому

    That's certainly a way to **** an employee out of 150 bucks. Why exactly is the employee benefit based on a value that already has the employee benefit deducted from it?

  • @figh761
    @figh761 3 місяці тому

    how to load a csv file from our disk to GCP using PYSPARK

  • @beagloopers2462
    @beagloopers2462 4 місяці тому

    Thank you so much for this tutorial! I FINALLY understand this now!

  • @districtgrandlodgesanorth1557
    @districtgrandlodgesanorth1557 6 місяців тому

    So, fundamentally it's good to know how iterative calculations work. Practically the outcome of this calculation is wrong, and this is the worst method for calculating 5% of the after tax profit: Total tax = 40K therefore After tax profit is 60K, and 5% of 60k = 3k): If I was the employee I'd be pissed at the above outcome. There is an inherent danger in creating circular references like this, and this is a classic example of that danger. Rather add additional steps to the calculation than use a function where you are not familiar with the appropriate application.

  • @rhui8136
    @rhui8136 6 місяців тому

    Thank you very much!!

  • @merjenorazmammedova6516
    @merjenorazmammedova6516 7 місяців тому

    Thank you so much for the video!

  • @human8461
    @human8461 7 місяців тому

    GUYS WARNING: NOT ALWAYS IRR makes NPV = 0, based on your cash flows! Don’t ruin your models by trying to make it real

  • @omarriveraguzman7729
    @omarriveraguzman7729 8 місяців тому

    Thank you so much! This was clearly explained and nicely done!

  • @henrymuhindi1858
    @henrymuhindi1858 8 місяців тому

    Helpful

  • @rodrigoayarza9397
    @rodrigoayarza9397 8 місяців тому

    the files are in PARQUET now. no problem?

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

    Is it possible to apply the circuit breaker technique to one specific tab or even specific range on one worksheet ? The key is to avoid missing other potential circular loop error

  • @nikhilbhosale8279
    @nikhilbhosale8279 10 місяців тому

    0:42

  • @nikhilbhosale8279
    @nikhilbhosale8279 10 місяців тому

    1:00

  • @nikhilbhosale8279
    @nikhilbhosale8279 10 місяців тому

    1.00

  • @nikhilbhosale8279
    @nikhilbhosale8279 10 місяців тому

    0:07

  • @ddcupload7373
    @ddcupload7373 10 місяців тому

    bro 11 year video saved me in 2023 thank you.

  • @siyatunzi7790
    @siyatunzi7790 10 місяців тому

    If the cash flows are paid at the beginning of each year then what happens

  • @pattymercedes7080
    @pattymercedes7080 11 місяців тому

    Thank you very much-

  • @thinBillyBoy
    @thinBillyBoy 11 місяців тому

    If you want to find the NPV for one year but only have the cashflow total for that year do you still call it NPV?

  • @antseriknomper976
    @antseriknomper976 11 місяців тому

    THANK YOU!

  • @bigstepper4125
    @bigstepper4125 11 місяців тому

    God bless you. This was so helpful

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

    hi can you help me make efficient frontier curve for 10 stocks

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

    Thanks, this is the first time I found circular reference useful, all this time I was wondering why Excel has this.

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

    Uploading credential.json file failed in gcp vm instance any suggestions

  • @user-iu9bq8tv6f
    @user-iu9bq8tv6f Рік тому

    Well explained, thank you

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

    thank you so much...great help

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

    tankes bro you just saved me from been grounded

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

    How to directly send file to bucket, without downloading on vm

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

    Thank you for simplifying this

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

    Simple yet comprehensive. Thank you. For me, I didn't realize "Bins" effectively represents "What range do you want to separate data in to (aka, 10 to 20 means "if a value is between 10 or 19, place in category "10"")." "Input" is simply "What actual values do you have, regardless if ordered appropriately." This was extremely helpful. Thank you.

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

    This video was less useful for my exam than an other one. But thank you, your are the goat

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

    Excellent explain in very simple style...

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

    this video helped me pass exam ! My parents would have sent me to military school if i had failed !!

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

    This is a great explanation, but is this Excel still available? I get an error when I attempt to download.

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

    Thank you, this helped me through my Finance 101 class!

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

    Thank you you helped us for our group project ! you explain well this concept !

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

      2nd week of doing this project. Still doing the efficient frontier. I think that we understood it now. Let's do it !

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

      FINALLY I DID IT ! You saved my life bro

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

    I have tried to follow the exact steps using different stocks and a larger data set however the frontier is not curved what would you recommend I do.

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

    Top mateiral brother. Very useful