![Codible](/img/default-banner.jpg)
- Видео 149
- Просмотров 8 570 382
Codible
Добавлен 5 июн 2011
Mainly focused on Microsoft Excel - basic proficiency in Excel, Financial Analysis using Excel, business analytics using Excel. From time to time I also post some videos on Big Data Analytics using Hadoop, Ruby on Rails, programming, SQL, and related topics.
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.
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.
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
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
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
how to upload from local machine?
Excellent explanation. Thank you!
Thank you so much! This was incredibly clear and helpful
helpful
Thank you!😇
Solved my problem another video couldn't, thank!
Informative video ❤
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.
Thanks
Best explanation on the net! Excellent investment / excel content timeless information... even after 11 years! Thank You!🤑
Thanks a lot, buddy! You are my hero! Your explanation was so simple and clear. I regret not finding you sooner.
Thanks to you.
God Bless you my friend. This solved my problem.
Thank you so much
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?
how to load a csv file from our disk to GCP using PYSPARK
Thank you so much for this tutorial! I FINALLY understand this now!
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.
Thank you very much!!
Thank you so much for the video!
GUYS WARNING: NOT ALWAYS IRR makes NPV = 0, based on your cash flows! Don’t ruin your models by trying to make it real
Thank you so much! This was clearly explained and nicely done!
Helpful
the files are in PARQUET now. no problem?
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
0:42
1:00
1.00
0:07
bro 11 year video saved me in 2023 thank you.
If the cash flows are paid at the beginning of each year then what happens
Thank you very much-
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?
THANK YOU!
God bless you. This was so helpful
hi can you help me make efficient frontier curve for 10 stocks
Thanks, this is the first time I found circular reference useful, all this time I was wondering why Excel has this.
Uploading credential.json file failed in gcp vm instance any suggestions
Well explained, thank you
thank you so much...great help
tankes bro you just saved me from been grounded
How to directly send file to bucket, without downloading on vm
Thank you for simplifying this
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.
This video was less useful for my exam than an other one. But thank you, your are the goat
Excellent explain in very simple style...
this video helped me pass exam ! My parents would have sent me to military school if i had failed !!
mood
This is a great explanation, but is this Excel still available? I get an error when I attempt to download.
Thank you, this helped me through my Finance 101 class!
Thank you you helped us for our group project ! you explain well this concept !
2nd week of doing this project. Still doing the efficient frontier. I think that we understood it now. Let's do it !
FINALLY I DID IT ! You saved my life bro