How to create databases and tables. Use select, insert, delete, update commands etc.
In this video tutorial, we will show you how to connect SQL Server Management Studio to an SQL Server, then…
Read More
Data Scraping from web using Selenium, WebDriver and XPath
In this video tutorial we will show you how to install Selenium, WebDriver-Manager and how to use them to get/scrape…
Pivot Tables, Pivot Charts Filters and Slicers
In this video tutorial we will show you how to create pivot tables and pivot charts. How to use slicers,…
How to use World Bank API (WBGAPI) and Pandas to import data, and draw charts
In this video tutorial we will teach you how to use World Bank API (WBGAPI) to import data and statistics…
How to use COUPDAYBS/COUPDAYS/COUPDAYSNC to calculate number of coupon days
In this video tutorial we will show you how to calculate number of coupon days using COUPDAYBS, COUPDAYS and COUPDAYSNC…
How to install Power BI Desktop and create your first Chart
In this video tutorial we will show you how to install Microsoft Power BI Desktop for free and how to…
Easiest way to download, install/setup and use python (WinPython Tutorial)
Today we will show you how to download, install and use WinPython which is the most easy and portable version…
How to use AMORDIGRC function to calculate depreciation
AMORDIGRC is used to calculate degressive depreciation. This function was created for French accounting system however after changes in their…
How to use ACCRIT function to calculate Accrued Interest
In this video tutorial we will show you how to calculated accrued interest using MS Excel built in ACCRINT function.
Calculating variance and standard deviation in Python and drawing a chart
In this video we will show you how to calculate variance and standard deviation from a very simple dataset in…