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

1) Dashboard - I have created an interactive dashboard with the given requirements by using a slicer.

When we click on "M" all the graphs in dashboard changes and vice versa.

2)Female clients- I have done the challenge in seperate sheet named Female clients.

Male clients - I have done the challenge in seperate sheet named Male clients.

For DCOUNT function i have did the solution at last in the applicants data dataset.

3) (a)I have created macros for conditional formatting and freeze panes.

(b)Code to convert select data into PDF format.

Sub SavedDataAsPdf()

Dim saveLocation As String

saveLocation = "C:\Users\nsatya\Downloads\new.pdf" Selection.ExportAsFixedFormat Type:=xlTypePDF, _ Filename:=saveLocation

End Sub

(c)For Spelling mistakes code is below.

Public Sub SpellingMistakes()

Dim ws As Worksheet

Dim cell As Range

Set ws = ActiveSheet

For Each cell In ws.UsedRange

If Not Application.CheckSpelling(cell.Value) Then

cell.Interior.Color = RGB(0, 255, 0) ' Red color

End If

Next cell

End Sub

The attachment for the excel file. Check the below link.

https://docs.google.com/spreadsheets/d/1gLJNafPhOQmsOXHQVnhKudpmfrX52CLY/edit?usp=sharing&ouid=105950619174151509006&rtpof=true&sd=true