Create a report using PowerQuery, Macro VBA, List Functions and Data Validation functions for Data Reporting of Supply Chain Management companies

AIM:

To analyze loan applicants data and to present appropriate report on shared data for IJS BANK LTD. As a business analyst , we should demonstrate the using dashboard into MS excel.

We used MACRO VBA, List functions and Data Validation for Data reporting of supply chain managment companies.

PROJECT LINK:

https://drive.google.com/file/d/1REZJqkiRhtXBgA4zG7Nim9p-SqUTftQo/view?usp=sharing

Recorded Macro for conditional formatting of total income And freezing panes of first row

Public Sub pdf()
Dim saveFile As String
saveFile = "C:UsersHPDesktoppdf"
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _
Filename:=saveFile
End Sub

Public Sub spell()
ActiveSheet.CheckSpelling
End Sub