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

I Am Completd Excel Project 2 Below Mention My Answers:

Data Summary of All Female Client’s for Income and Loan Amount using New Functions (hint: use unique,sort,filter functions) if These functions are not supporting in your software please give a theoritical answer.

1. the UNIQUE function to get a list of unique Salary This will give you a list of all Unique salary without duplicates.
2. the SORT function to sort the data based on income or loan amount. we can sort it in ascending or descending order.
3. the FILTER function to filter out records where the gender is female. This will give you a subset of data containing only female clients.

Check Spelling mistakes in the workbook using VBA Code

Public Sub CheckSpellingmistakes() Dim sheet As Worksheet Dim cell As Range Set sheet = ThisWorkbook.ActiveSheet For Each cell In sheet.UsedRange If Not Application.CheckSpelling(cell.Value) Then cell.Interior.Color = RGB(255, 255, 0) End If Next cell End Sub

Create VBA Code to convert selected data into pdf from applicant data

Public Sub SelecteddatatoPDF() Dim selectionRange As Range Dim SRange As Range Dim Path As String Set selectionRange = Selection Set SRange = selectionRange.SpecialCells(xlCellTypeVisible) Path = Application.GetSaveAsFilename(FileFilter:="PDF Files (*.pdf), *.pdf", Title:="Save PDF As") SRange.ExportAsFixedFormat Type:=xlTypePDF, Filename:=Path, Quality:=xlQualityStandard MsgBox "PDF successfully created.", vbInformation End Sub

Below Mention My Project Drive Link:

https://drive.google.com/drive/u/2/folders/11PU42bqvwuV7CCzz6FikI1X2LGTYEOui