From the course: SQL for Finance Professionals
Join today to access over 24,900 courses taught by industry experts.
Excel vs SQL in finance - SQL Tutorial
From the course: SQL for Finance Professionals
Excel vs SQL in finance
- [Instructor] Excel is perhaps the main tool used by financial analysts in the field. Much of the data these analysts have to work with come in the form of spreadsheets that are exported from various reporting systems. This means that when they have to manipulate and analyze that data, doing so directly in those spreadsheets rather than going to outside tools is often easier. Beyond its ease of use, spreadsheet tools like Excel are very widely used by finance professionals because of the formatting and calculation functions readily available in the tool. The formatting functionality in Excel allows users to easily communicate findings and reports in dashboards, but in addition to that, conditional formatting is another extremely helpful tool that helps in reducing errors in the data. The variety of financial functions available in Excel allow you to perform the most popular calculations that are required for…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.