Codible
Codible
  • Видео 149
  • Просмотров 8 570 382
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.
Просмотров: 859

Видео

Overview of text functions in Excel
Просмотров 5643 года назад
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
Просмотров 19 тыс.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 тыс.4 года назад
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 тыс.4 года назад
See how to create a histogram in Excel.
Installing Analysis Toolpak in Excel for Statistical Analysis
Просмотров 18 тыс.4 года назад
This video demonstrates how to install the Analysis Tookpak for statistical analysis in Excel.
Introduction to Excel and walk-through of important features
Просмотров 3764 года назад
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
Просмотров 90 тыс.5 лет назад
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 тыс.5 лет назад
Login to AWS EC2 via Windows 10 OpenSSH, without Putty
Excel - using match and index functions together
Просмотров 2,5 тыс.5 лет назад
Excel - using match and index functions together
Using Excel Match function to row number of a text in a range
Просмотров 31 тыс.5 лет назад
Using Excel Match function to row number of a text in a range
index function
Просмотров 4775 лет назад
index function
Headers and footers in excel 2016
Просмотров 6795 лет назад
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
Просмотров 12 тыс.5 лет назад
Create range names from table fields in Excel
Range names in Excel 2016
Просмотров 4915 лет назад
Range names in Excel 2016
Codible SQLite video 11: SQL query with subquery, both referencing the same table
Просмотров 2,3 тыс.6 лет назад
Codible SQLite video 11: SQL query with subquery, both referencing the same table
Codible SQLite video 10: subquery with interblock reference in SQLite3
Просмотров 3166 лет назад
Codible SQLite video 10: subquery with interblock reference in SQLite3
Codible SQLite video 9: SQLite3: retrieval with multiple levels of nesting
Просмотров 9546 лет назад
Codible SQLite video 9: SQLite3: retrieval with multiple levels of nesting
Codible SQLite video 8: Subquery with IN keyword in SQLite3
Просмотров 4196 лет назад
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
Просмотров 9526 лет назад
Codible SQLite video 7: Doing a self-join of a table with itself in SQLite3
Codible SQLite video 6: SQLite3 - how a JOIN works
Просмотров 8066 лет назад
Codible SQLite video 6: SQLite3 - how a JOIN works

Комментарии

  • @Matias-eh2pn
    @Matias-eh2pn 12 дней назад

    how to upload from local machine?

  • @rainesilk9791
    @rainesilk9791 Месяц назад

    Excellent explanation. Thank you!

  • @sherylofwona2821
    @sherylofwona2821 2 месяца назад

    Thank you so much! This was incredibly clear and helpful

  • @walelala
    @walelala 2 месяца назад

    helpful

  • @reshmag7825
    @reshmag7825 2 месяца назад

    Thank you!😇

  • @deandanderson4006
    @deandanderson4006 3 месяца назад

    Solved my problem another video couldn't, thank!

  • @Alpines_5th
    @Alpines_5th 3 месяца назад

    Informative video ❤

  • @kaitlinaffleck9676
    @kaitlinaffleck9676 3 месяца назад

    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 3 месяца назад

    Thanks

  • @user-ym3bm7lm4v
    @user-ym3bm7lm4v 3 месяца назад

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

  • @redrhino2048
    @redrhino2048 4 месяца назад

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

  • @ahmedali3017
    @ahmedali3017 4 месяца назад

    Thanks to you.

  • @teslazation
    @teslazation 5 месяцев назад

    God Bless you my friend. This solved my problem.

  • @mustardwithglasses6508
    @mustardwithglasses6508 5 месяцев назад

    Thank you so much

  • @esek308
    @esek308 5 месяцев назад

    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 5 месяцев назад

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

  • @beagloopers2462
    @beagloopers2462 6 месяцев назад

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

  • @districtgrandlodgesanorth1557
    @districtgrandlodgesanorth1557 8 месяцев назад

    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 8 месяцев назад

    Thank you very much!!

  • @merjenorazmammedova6516
    @merjenorazmammedova6516 9 месяцев назад

    Thank you so much for the video!

  • @human8461
    @human8461 9 месяцев назад

    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 10 месяцев назад

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

  • @henrymuhindi1858
    @henrymuhindi1858 10 месяцев назад

    Helpful

  • @rodrigoayarza9397
    @rodrigoayarza9397 10 месяцев назад

    the files are in PARQUET now. no problem?

  • @josephng4289
    @josephng4289 11 месяцев назад

    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 Год назад

    0:42

  • @nikhilbhosale8279
    @nikhilbhosale8279 Год назад

    1:00

  • @nikhilbhosale8279
    @nikhilbhosale8279 Год назад

    1.00

  • @nikhilbhosale8279
    @nikhilbhosale8279 Год назад

    0:07

  • @ddcupload7373
    @ddcupload7373 Год назад

    bro 11 year video saved me in 2023 thank you.

  • @siyatunzi7790
    @siyatunzi7790 Год назад

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

  • @pattymercedes7080
    @pattymercedes7080 Год назад

    Thank you very much-

  • @thinBillyBoy
    @thinBillyBoy Год назад

    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 Год назад

    THANK YOU!

  • @bigstepper4125
    @bigstepper4125 Год назад

    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