-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathExcel.html
More file actions
180 lines (135 loc) · 7.84 KB
/
Excel.html
File metadata and controls
180 lines (135 loc) · 7.84 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
<!DOCTYPE HTML>
<!--
Massively by HTML5 UP
html5up.net | @ajlkn
Free for personal and commercial use under the CCA 3.0 license (html5up.net/license)
-->
<html>
<head>
<title>Ibad Ullah Portfolio</title>
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=no" />
<link rel="stylesheet" href="assets/css/main.css" />
<noscript><link rel="stylesheet" href="assets/css/noscript.css" /></noscript>
</head>
<body class="is-preload">
<!-- Wrapper -->
<div id="wrapper" class="fade-in">
<!-- Intro -->
<div id="intro">
<h1>
Ibad Ullah</h1>
<p>Skilled in using Microsoft Excel for data analysis tasks such as data cleaning, pivot tables, formulas and functions, merge/combine,
data validation, customize charts and dashboards.<br></a></a></p>
<ul class="actions">
<li><a href="#header" class="button icon solid solo fa-arrow-down scrolly">Continue</a></li>
</ul>
</div>
<!-- Header -->
<header id="header">
<a href="Excel.html" class="logo">Ibad Ullah</a>
</header>
<!-- Nav -->
<nav id="nav">
<ul class="links">
<li><a href="index.html">SQL</a></li>
<li><a href="Python.html">Python</a></li>
<li><a href="Tableau.html">Tableau</a></li>
<li class="active"><a href="Excel.html">Excel</a></li>
<li><a href="Projects.html">Projects</a></li>
<li><a href="Cert.html">Certificate</a></li>
<li><a href="Contact.html">Contact</a></li>
</ul>
<ul class="icons">
<li><a href="https://www.linkedin.com/in/ibad-ullah-8a949822b/" class="icon brands alt fa-linkedin"><span class="label">linkedin</span></a></li>
<li><a href="https://github.com/IbadDE" class="icon brands alt fa-github"><span class="label">GitHub</span></a></li>
<li><a href="https://twitter.com/ibad_the_DA" class="icon brands alt fa-twitter"><span class="label">Twitter</span></a></li>
<li><a href="https://www.kaggle.com/ibadkhanml" class="icon brands alt fa-kaggle"><span class="label">kaggle</span></a></li>
<li><a href="https://medium.com/@ibadullah99" class="icon brands alt fa-medium"><span class="label">medium</span></a></li>
</ul>
</ul>
</nav>
<!-- Main -->
<div id="main">
<!-- Featured Post -->
<article class="post featured">
<header class="major">
<h2><a href="https://github.com/IbadDE/Excel-Project/tree/main/1.%20Chart%20Customization">Customize Charts</a></h2>
</header>
<a href="https://github.com/IbadDE/Excel-Project/tree/main/1.%20Chart%20Customization" class="image main"><img src="images/customize.JPG" alt="" /></a>
<p>Showing advance customized Excel chart. The chart highlights key insights and trends in the data, making it easy to understand and interpret.
This shows my proficiency in Excel data visualization and ability to create visually appealing and informative charts.</p>
<ul class="actions special">
<li><a href="https://github.com/IbadDE/Excel-Project/tree/main/1.%20Chart%20Customization" class="button large">View Project</a></li>
</ul>
</article>
<!-- Posts -->
<section class="posts">
<article>
<header>
<h2><a href="https://github.com/IbadDE/Excel-Project/tree/main/Cleaning%20Data">Data Cleaning and Preparation Using Excel<br />
</a></h2>
</header>
<a href="https://github.com/IbadDE/Excel-Project/tree/main/Cleaning%20Data" class="image fit"><img src="images/data cleaning.jpg" alt="" /></a>
<p> In these projects, I used Excel to clean and prepare data, ensuring consistency and accuracy. I utilized various Excel functions and tools,
such as filtering and data validation, to efficiently clean the data. The project showcases my ability to work with large datasets and make them ready
for analysis. The project is available on a public repository for others to replicate the cleaning process.</p>
<ul class="actions special">
<li><a href="https://github.com/IbadDE/Excel-Project/tree/main/Cleaning%20Data" class="button"> View Project</a></li>
</ul>
</article>
<article>
<header>
<h2><a href="https://github.com/IbadDE/Excel-Project/tree/main/Dashboards"> Dashboards <br />
</a></h2>
</header>
<a href="https://github.com/IbadDE/Excel-Project/tree/main/Dashboards" class="image fit"><img src="images/spending habits.JPG" alt="" /></a>
<p> These dashboards are designed to be user-friendly and visually appealing, showcasing key trends and patterns.
I used advanced Excel features such as pivot tables, slicers, and charts to create customized dashboards that meet users’
needs. It demonstrates my proficiency in Excel data visualization and my ability to create informative and visually engaging
dashboards. The project is available on a public repository for others to review and replicate the dashboard creation process and
for positive feedback.</p>
<ul class="actions special">
<li><a href="https://github.com/IbadDE/Excel-Project/tree/main/Dashboards" class="button"> View Project</a></li>
</ul>
</article>
<article>
<header>
<h2><a href="https://github.com/IbadDE/Excel-Project/tree/main/Formulas"> Functions & Formulas<br />
</a></h2>
</header>
<a href="https://github.com/IbadDE/Excel-Project/tree/main/Formulas" class="image fit"><img src="images/functions.jpg" alt="" /></a>
<p>This repo showcases my proficiency in using various Excel formulas and functions to analyze data. It includes examples of commonly used functions such as VLOOKUP,
LEFT, RIGHT, MID, POSITION, SUM, as well as data validation techniques and other functions. It demonstrates my ability to work with complex data and use
Excel to perform advanced data analysis tasks.</p>
<ul class="actions special">
<li><a href="https://github.com/IbadDE/Excel-Project/tree/main/Formulas" class="button">View Profile</a></li>
</ul>
</article>
<article>
<header>
<h2><a href="https://github.com/IbadDE/Excel-Project/tree/main/Combine-Merge%20%20dataset"> Merging Data<br />
</a></h2>
</header>
<a href="https://github.com/IbadDE/Excel-Project/tree/main/Combine-Merge%20%20dataset" class="image fit"><img src="images/merg.JPG" alt="" /></a>
<p>These projects demonstrate my proficiency in using Power Query to merge data from multiple sources efficiently. I used advanced functions like Merge, Append, and
Join to manipulate complex datasets. The merged data is cleaned and formatted for analysis.</p>
<ul class="actions special">
<li><a href="https://github.com/IbadDE/Excel-Project/tree/main/Combine-Merge%20%20dataset" class="button">View Profile</a></li>
</ul>
</article>
<!-- Copyright -->
<div id="copyright">
<ul><li>© Untitled</li><li>Design: <a href="https://html5up.net">HTML5 UP</a></li></ul>
</div>
</div>
<!-- Scripts -->
<script src="assets/js/jquery.min.js"></script>
<script src="assets/js/jquery.scrollex.min.js"></script>
<script src="assets/js/jquery.scrolly.min.js"></script>
<script src="assets/js/browser.min.js"></script>
<script src="assets/js/breakpoints.min.js"></script>
<script src="assets/js/util.js"></script>
<script src="assets/js/main.js"></script>
</body>
</html>