Freelancer logo
Log In Sign Up
Post a Project
EXPLORE
Data Mining
Data Processing
Excel
Visual Basic
Web Search
Profile cover photo
You're now following
Error following user.
This user does not allow users to follow them.
You are already following this user.
Your membership plan only allows 0 follows. Upgrade here.
Successfully unfollowed
Error unfollowing user.
You have successfully recommended
Error recommending user.
Something went wrong. Please refresh the page and try again.
Email successfully verified.
User Avatar

Hrithik S.

@shawkeen

4.9
2
1.1
1.1
100%

Excel Expert | Data Analysis & Automation

$15 USD / Hour
・
Flag of
India (12:43 AM)
・
Joined on September 1, 2024
$15 USD / Hour
・
I am an Excel expert with over 3 years of experience in data analysis, automation, and financial modeling. I specialize in building efficient Excel solutions that streamline processes and enhance data management. My expertise includes advanced formulas, VBA programming, Power Query, Power Pivot, and dynamic dashboards. Whether you need complex reports, automated workflows, or insightful data analysis, I can help you achieve your goals with precision and speed. I am available for part-time projects, offering reliable support to businesses seeking to optimize their Excel tasks.
Verifications
On time
100%
On budget
100%
Accept rate
100%
Freelancer Excel Experts India
See all Excel Experts in India

Portfolio

Portfolio

12344276
This project leverages the WeatherAPI to fetch enhanced weekly weather data, including forecasted conditions, air quality, and astronomical details, across multiple specified locations. The script uses Google Apps Script to access and parse the API data for each site, storing it in a structured Google Sheet with detailed weather attributes like temperature, humidity, wind, sunrise/sunset, and pollutant levels (e.g., PM2.5 and PM10). By automating daily updates, this tool provides an up-to-date, comprehensive view of environmental conditions across various geographic points, supporting operational planning and environmental management decisions.
Humidity and Temperature Data with Real Time update
12214604
Overview: This Excel VBA macro automates the extraction of financial data from a specified website. It navigates to individual pages for stock symbols, retrieves specific data points, and populates them into an Excel sheet. Features: Automated Web Navigation: Uses Internet Explorer to fetch data from pages dedicated to financial symbols. Data Extraction: Captures key financial metrics, including quote names and various industry classifications. Dynamic Data Entry: Populates data into designated columns in Excel based on the fetched information. Error Handling: Manages potential issues with data retrieval to ensure robustness. Efficient Processing: Incorporates delays to handle page load times and avoid potential request issues. Benefits: Streamlines financial data collection directly into Excel, reducing manual data entry and enhancing accuracy. Ideal for financial analysts or anyone needing automated updates for stock symbols.
Excel VBA:Automated Web Data Extraction for Financial Symbol
12214594
Overview: This Excel VBA macro automates the process of importing and managing web data tables. It efficiently fetches HTML table data from a given URL, formats it, and creates official Excel tables with dynamic names. Features: Automated Data Fetching: Retrieves up to 15 tables from a specified URL. Dynamic Table Creation: Names tables based on the sheet name and index, avoiding overlap with existing tables. Advanced Formatting: Headers: Black text, centered alignment, and consistent borders. Data: Numbers formatted to two decimal places, with text and numeric alignment adjusted as needed. Error Handling: Robust handling for HTTP request issues. Clean Up: Deletes old tables to avoid overlap and maintains a clean workspace. Benefits: Streamlines data import and ensures professional formatting, reducing manual effort and enhancing data presentation. Ideal for users needing frequent updates from web sources.
Excel VBA Macro: Fetch, Format, and Manage Web Data Tables
12344276
This project leverages the WeatherAPI to fetch enhanced weekly weather data, including forecasted conditions, air quality, and astronomical details, across multiple specified locations. The script uses Google Apps Script to access and parse the API data for each site, storing it in a structured Google Sheet with detailed weather attributes like temperature, humidity, wind, sunrise/sunset, and pollutant levels (e.g., PM2.5 and PM10). By automating daily updates, this tool provides an up-to-date, comprehensive view of environmental conditions across various geographic points, supporting operational planning and environmental management decisions.
Humidity and Temperature Data with Real Time update
12214604
Overview: This Excel VBA macro automates the extraction of financial data from a specified website. It navigates to individual pages for stock symbols, retrieves specific data points, and populates them into an Excel sheet. Features: Automated Web Navigation: Uses Internet Explorer to fetch data from pages dedicated to financial symbols. Data Extraction: Captures key financial metrics, including quote names and various industry classifications. Dynamic Data Entry: Populates data into designated columns in Excel based on the fetched information. Error Handling: Manages potential issues with data retrieval to ensure robustness. Efficient Processing: Incorporates delays to handle page load times and avoid potential request issues. Benefits: Streamlines financial data collection directly into Excel, reducing manual data entry and enhancing accuracy. Ideal for financial analysts or anyone needing automated updates for stock symbols.
Excel VBA:Automated Web Data Extraction for Financial Symbol
12214594
Overview: This Excel VBA macro automates the process of importing and managing web data tables. It efficiently fetches HTML table data from a given URL, formats it, and creates official Excel tables with dynamic names. Features: Automated Data Fetching: Retrieves up to 15 tables from a specified URL. Dynamic Table Creation: Names tables based on the sheet name and index, avoiding overlap with existing tables. Advanced Formatting: Headers: Black text, centered alignment, and consistent borders. Data: Numbers formatted to two decimal places, with text and numeric alignment adjusted as needed. Error Handling: Robust handling for HTTP request issues. Clean Up: Deletes old tables to avoid overlap and maintains a clean workspace. Benefits: Streamlines data import and ensures professional formatting, reducing manual effort and enhancing data presentation. Ideal for users needing frequent updates from web sources.
Excel VBA Macro: Fetch, Format, and Manage Web Data Tables
Changes saved
4.9 · 2 Reviews
Reviews
K
Generate and Filter Permutation Numbers • $21 SGD
Delivered on time as I expected. Highly recommend to hire him.. ?
Karthick K.
@karthickk39
•
Flag of
Singapore, Singapore
•
4 months ago
Share
K
Excel Macro enabled sheet to Download Stock Industry classification data from NSE -- 2 • $20 USD
Even though Hrithik S is a new freelancer, I selected him based on the expertise he demonstrated during my initial chats on my project requirements. He patiently attended to all my code requirements and resolved them. He has very good knowledge on excel macros and python codes. I recommend him to anyone who needs his expert knowledge on those fields.
Palanisamy S.
@kumartech
•
Flag of
Doha, Qatar
•
5 months ago
Share
Experience
Accounts Payable Specialist
Dec, 2023 - Present
•
1 year, 1 month
Genpact
Dec, 2023 - Present
•
1 year, 1 month
Serve as the primary contact for vendors, employees, and customers in the P2P process, resolving queries and providing payment status updates. Address payment processing issues, PO amendments, vendor blocks, and reimbursements. Handle urgent same-day payments and ensure timely, accurate transactions. Utilize advanced Excel, Power BI, and Power Query to improve efficiency. Maintain strong stakeholder relationships and support smooth Accounts Payable operations.
Flag of
Kolkata, India
Dec, 2023 - Present
•
1 year, 1 month
Financial Analyst
Nov, 2020 - Dec, 2023
•
3 years, 1 month
TCS
Nov, 2020 - Dec, 2023
•
3 years, 1 month
Analyzed financial statements for 1,000+ global companies, ensuring data accuracy and resolving discrepancies. Achieved 98% accuracy in financial data reviewed for investor reporting via Bloomberg. Conducted benchmarking to provide insights for investor analysis. Leveraged advanced Excel skills, including macros, boosting productivity by 13% and reducing task time by 67%. Organized and led a team outing, enhancing cohesion and collaboration to meet project goals effectively.
Flag of
Kolkata, India
Nov, 2020 - Dec, 2023
•
3 years, 1 month
Education
MCom
2022 - 2024
•
2 years
Flag of
India
2022 - 2024
•
2 years
BCom
2017 - 2020
•
3 years
Flag of
India
2017 - 2020
•
3 years
CMA Inter
2016 - 2017
•
1 year
Flag of
India
2016 - 2017
•
1 year
Invite sent successfully!
Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Freelancer logo Ireland / English
Help & Support

Freelancer

Categories Projects Contests Freelancers Enterprise Innovation Challenges AI Development Membership Preferred Freelancer Program Project Management Local Jobs Photo Anywhere Showcase API for Developers Get Verified Desktop App

About

About us How it Works Security Investor Sitemap Stories News Team Awards Press Releases Careers

Terms

Privacy Policy Terms and Conditions Copyright Policy Code of Conduct Fees and Charges

Partners

Escrow.com Loadshift Warrior Forum

Apps

Apple App Store logoGoogle Play logo
Copy to clipboard failed, please try again after adjusting your permissions.
Copied to clipboard.

Registered Users

Total Jobs Posted

Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)

Copyright © 2025 Freelancer Technology Pty Limited (ACN 142 189 759)

Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.