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

Level up your learning in 2024 with PASS Data Community Summit
by Additional Articles on 5. 8. 2024 at 0:00
Did you know that the general program for PASS Data Community Summit 2024 (November 4-8) was recently unveiled? This year's lineup includes over 150 […]
Create Document Templates in a SQL Server Database Table
by Additional Articles on 5. 8. 2024 at 0:00
Learn how to create document templates in a database table and use SQL to replace specific keywords in the templates for content customization. The […]
Git, GitHub and Visual Studio Code for SQL Server
by Daniel Calbimonte on 5. 8. 2024 at 0:00
Learn how to get started with Git and Visual Studio Code. The post Git, GitHub and Visual Studio Code for SQL Server appeared first on […]
Power BI DirectQuery, Gateways And SQL Queries That Return Lots Of Rows
by Chris Webb on 4. 8. 2024 at 8:30
Recently I was working with a customer using DirectQuery mode and where all traffic to the data source had to go through an on-premises data gateway […]
Announcing general availability of Tabular Model Definition Language (TMDL)
on 2. 8. 2024 at 10:39
We are happy to announce that the Tabular Model Definition Language (TMDL) has now reached General Availability (GA)!
Deep dive into DAX query view for web
on 2. 8. 2024 at 7:00
We are excited to announce you can now write DAX queries with DAX query view for web from published semantic models in the workspace.
Redgate Summit: The Database Landscape - New York
by Additional Articles on 2. 8. 2024 at 0:00
Join Redgate at the last Redgate Summit event of the year! This series of events is hosted across the globe for data professionals who want to […]