Finance math in Excel

Blog » Excel » Finance math in Excel

Here you can find articles on Excel functions for financial calculations and mathematics, e.g. how to calculate interest in Excel, the interest rate, how the present value works or, for example, the aliquoted interest yield for bonds.

This page this page has no other subpages
View all posts from the category: List of Articles in Finance math in Excel category »

Don’t miss out from category:

It seems we can’t find what you’re looking for. Perhaps searching can help.

ETL | Mage.ai – Charts, Analysis, Testing, Overview, Cleansing
In this guide, we will take a look at the features that Mage.ai offers for data analysis. While this tool is primarily used for ETL pipelines, it […]
ETL | Mage.ai – Database configuration in io_config.yaml and secrets (passwords)
In this guide, we will take a look at how to configure the io_config.yaml file in Mage.ai. We will also explore how to hide and encrypt access […]
Mage.ai | Error UnicodeDecodeError: ‘charmap’ codec – Windows
This article will be related to troubleshooting. Today, I managed somehow to write a comment that caused the entire Mage.ai instance to crash due to […]
ETL | Mage.ai – Dbt Installation (pip/conda) and project initialization
In the previous article – ETL | Mage.ai – Solid Alternative to Airflow – Intro and Installation we introduced the ETL tool Mage.ai […]
ETL | Mage.ai Pipeline – data flow – Python, SQL Server
In a recent article dedicated to introducing Mage.ai – a tool for creating and managing ETL processes, I promised at the end that we would try […]
Bulk Copy Program (BCP) Utility – Fast Bulk Import and Export in SQL Server
BCP is a utility that is installed by default with SQL Server editions and is used for bulk import or export of a large volume of data in […]
SQL Server Table and Index Compression (Data Compression), Pros/Cons
Table and index compression is a functionality that has been available in various SQL Server editions for a while. It has been available in all […]
SSRS – Handling multiple value parameter/filters in reporting services
In the past, I have written several tutorials on reporting services (you can find them in the reporting services – SSRS category). I have gone […]
Data Masking in SQL Server – How to Hide Data in a Specific Column
Data masking is a feature that allows you to completely or partially mask selected data in a database. Access to unmask the data can also be granted […]
SSRS | How to Create an Amortization Calculator in SQL Server – Including a Report with Parameters
Lately, I’ve been dedicating a lot of time to financial mathematics in Excel. I’ll try to leverage that and shift the focus from Excel to […]

Resources: Power BI News and Blogs a BI Blogs and Magazines – SQL Server, Excel, Reporting

Full vs. Incremental Loads – Data Engineering with Fabric
by John Miner on 17. 4. 2024 at 0:00
Learn how to perform full and incremental loads in Fabric with a little SparkSQL. The post Full vs. Incremental Loads – Data Engineering with […]
Get the most out of SQL Server Agent logs
by Additional Articles on 17. 4. 2024 at 0:00
If you haven’t migrated your workloads to a managed database platform yet, you’re probably still relying on SQL Server Agent for various […]
On-premises data gateway April 2024 release
on 16. 4. 2024 at 16:00
We are excited to announce the April 2024 release of the on-premises data gateway!
Copilot in Power BI: Soon available to more users in your organization
on 16. 4. 2024 at 8:00
We have some exciting announcements to share regarding Copilot in Microsoft Fabric. The information in this blog post has also been shared with […]
SQL Performance Tuning tips for newbies
by Esat Erkec on 15. 4. 2024 at 12:12
The purpose of this article is to give newbies some basic advice about SQL performance tuning that helps to improve their query tuning skills in SQL […]
Finding Sister Locations to Help Each Other: Answers & Discussion
by Additional Articles on 15. 4. 2024 at 0:00
This week’s query exercise asked you to find two kinds of locations in the Stack Overflow database. The post Finding Sister Locations to Help Each […]
Disaster Recovery and High Availability Solutions in SQL Server
by Smit Dagli on 15. 4. 2024 at 0:00
Learn about disaster recovery and high availability options in SQL Server with details on the tradeoffs you make when choosing from Availability […]