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

1)https://docs.google.com/spreadsheets/d/1ZZq6yh9Lnz-LfKiJYZ8cc3EG8wd0x6P4/edit?usp=share_link&ouid=108872164429750898673&rtpof=true&sd=true

2)Due to version issue, I did'nt work on excel.Please kindly acceppt the answers given below

Female clients income and loan amount using new function

In new function we use the filter option to summarize the data

=Filter(Array,Include,[if_empty])

Select the table range with array--------> Then,Gender column is selected as for "Include"

In Include we give the required data like "M" or "F" then press the enter we get the data.

Using pivot table we also Summarize the Data

3) I didn'nt able to save the macros due to the large dataset. It shows errror. In my challenges I Upload the macros with small data set.

4)Vba Code for check spelling mistake

Sub SpellCheckSheet()

Application.ScreenUpdating = True

Dim xRg As Range

Call unprotect_sheet

Set xRg = ActiveSheet.Range("A:C")

xRg.CheckSpelling

Call protect_sheet

End Sub

5) Vba code for convert given data to pdf

Sub SaveAsPDF()

Dim WS As Worksheet

Dim FileName As String
Dim FilePath As String

Set WS = ActiveSheet

FileName = "Result PDF"

WS.PageSetup.Orientation = xlPortrait

FilePath = ThisWorkbook.Path

WS.ExportAsFixedFormat Type:=xlTypePDF, FileName:=FilePath & "\" & FileName & ".pdf", _ Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False

MsgBox "Completed", vbInformation, ""

End Sub