Courses by Software
Courses by Semester
Courses by Domain
Tool-focused Courses
Machine learning
POPULAR COURSES
Post Graduate Program in Hybrid Electric Vehicle Design and AnalysisPost Graduate Program in Computational Fluid DynamicsPost Graduate Program in CADPost Graduate Program in CAEPost Graduate Program in Manufacturing DesignPost Graduate Program in Computational Design and Pre-processingPost Graduate Program in Complete Passenger Car Design & Product DevelopmentSuccess Stories
Project 2 - Create a report using PowerQuery, Macro VBA, List Functions and Data Validation functions for Data Reporting of Supply Chain Management companies
The below is link to Dashboard https://docs.google.com/spreadsheets/d/1U2-YBp2mopGDFowI7Vaj00PJdOvxRCIc/edit?usp=drive_link&ouid=103286046492277190255&rtpof=true&sd=true The below is link to macros file https://docs.google.com/spreadsheets/d/1km0Bm8VFvkT84pGQcgMnOc94rPY083yD/edit?usp=drive_link&ouid=103286046492277190255&rtpof=true&sd=true…
Anupama Yeragudipati
updated on 07 Jun 2023
The below is link to Dashboard
The below is link to macros file
Link of pdf file
https://drive.google.com/file/d/1huhGgNQq_B-w4VaLaKc9PI8YrXLUo2Vl/view?usp=drive_link
The VBA code is mentioned below
For conditional formatting a macro is recorded and conditional formatting using different criterias has been done and freeze planes of first row
Public Sub ExcelToPDF()
Dim ThisRng As Range
Dim strfile As String
Dim myfile As Variant
If Selection.Count = 1 Then
Set ThisRng = Application.InputBox("Select a range", "Get Range", Type:=8)
Else
Set ThisRng = Selection
End If
strfile = "Selection" & "_" _
& Format(Now(), "yyyymmdd_hhmmss") _
& ".pdf"
strfile = ThisWorkbook.Path & "\" & strfile
myfile = Application.GetSaveAsFilename _
(InitialFileName:=strfile, _
FileFilter:="PDF Files (*.pdf), *.pdf", _
Title:="Select Folder and File Name to Save as PDF")
If myfile <> "False" Then
ThisRng.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
myfile, Quality:=xlQualityStandard, IncludeDocProperties:=True, _
IgnorePrintAreas:=False, OpenAfterPublish:=True
Else
MsgBox "No File Selected. PDF will not be saved", vbOKOnly, "No File Selected"
End If
End Sub
Sub SpellCheckInSpecificSheets()
Worksheets("Sheet1").CheckSpelling
End Sub
Sub SpellCheckInSelectedCells()
Selection.CheckSpelling
End Sub
Leave a comment
Thanks for choosing to leave a comment. Please keep in mind that all the comments are moderated as per our comment policy, and your email will not be published for privacy reasons. Please leave a personal & meaningful conversation.
Other comments...
Be the first to add a comment
Read more Projects by Anupama Yeragudipati (15)
Supervised Learning - Prediction Week 3 Challenge
1. Perform Gradient Descent in Python with any loss function.Refer to Jupyter Notebook attached.2. Difference between L1 & L2 Gradient descent method.The L1 and L2 Gradient Descent methods refer to optimization techniques used to minimize a loss function in machine learning, often in conjunction with regularization.…
27 Jan 2025 07:49 PM IST
Basics of Probability and Statistics Week 1 Challenge
Why there is a difference in the formula of variance for population and sampleChatGPT said:ChatGPTThe difference in the formula for variance between a population and a sample arises due to the concept of1. Population Variance:The formula for the population variance is:σ2=1N∑i=1N(xi−μ)2\sigma^2 = \frac{1}{N} \sum_{i=1}^{N}…
16 Jan 2025 07:35 PM IST
Basics of ML & AL Week 2 Challenge
1)The values from the table:X:0,1,2,3,4P(X):0.35,0.25,0.15,0.15,0.101. Mean (μ):The mean is calculated as:μ=∑X⋅P(X)μ=(0⋅0.35)+(1⋅0.25)+(2⋅0.15)+(3⋅0.15)+(4⋅0.10)μ=0+0.25+0.30+0.45+0.40=1.40Mean (μ) = 1.402. Variance (σ2):The variance is:σ2=∑P(X)⋅(X−μ)2First, calculate (X−μ)2 for each X:X=0(0−1.4)2=1.96X=1(1−1.4)2=0.16X=2(2−1.4)2=0.36X=3(3−1.4)2=2.56X=4(4−1.4)2=6.76Now…
07 Jan 2025 03:45 PM IST
Project 2 - Supply and Demand Gap Analysis
Detailed Documentation of Renewable Energy Share AnalysisBy Yeragudipati AnupamaAim:The aim of this project is to analyze the renewable energy share across various regions from 1965 to 2021, focusing on identifying global trends, regional differences, and the impact of economic development on the adoption of renewable…
05 Dec 2024 12:41 PM IST
Related Courses
0 Hours of Content
Skill-Lync offers industry relevant advanced engineering courses for engineering students by partnering with industry experts.
Our Company
4th Floor, BLOCK-B, Velachery - Tambaram Main Rd, Ram Nagar South, Madipakkam, Chennai, Tamil Nadu 600042.
Top Individual Courses
Top PG Programs
Skill-Lync Plus
Trending Blogs
© 2025 Skill-Lync Inc. All Rights Reserved.