- Видео 18
- Просмотров 199 355
Ajay Garg
Индия
Добавлен 24 апр 2021
Hello there. I am a 19 years old self learner. I have been learning Excel, SQL and python. My ultimate goal is to become a data analyst. I have been working on different freelancer platforms for some months now and getting some work. I will share my project videos and how I tackle the problems that I face in real life. I will also upload some videos for real life work that I get on upwork and fiverr. So you can subscribe to the channel if you want..
Goal Seek - A great excel feature everyone should know about
Hi there. In this video, I explain an excel feature that I have used so many times for different purposes. I show 2-3 ways of using it but after learning it, you can use it for so many different purposes.
You can leave a comment if you have any questions related to this feature or some other excel-related thing. I will be sure to reply to it.
I will be trying to upload more such videos in near future showing some great excel, python, SQL features, tricks etc.
Thank you for watching.
You can leave a comment if you have any questions related to this feature or some other excel-related thing. I will be sure to reply to it.
I will be trying to upload more such videos in near future showing some great excel, python, SQL features, tricks etc.
Thank you for watching.
Просмотров: 13
Видео
#1 Lab 1 Population Growth - CS50 Solution
Просмотров 6710 месяцев назад
Hey there, This is a video of me showing the solution to the Lab 1 of CS50 course by Harvard. Drop a like if it helped in any way and don't forget to subscribe. More coming soon.... #CS50 #harvard #computerscience
Deploying a web application on streamlit
Просмотров 64Год назад
Hello guys. In this video - I show how you can deploy a python web application to streamlit. Twitter- @ajay garg Insta- @ajay_garg_1 LinkedIn- www.linkedin.com/in/ajay-garg-46b558224/ Fiverr- www.fiverr.com/ajaygarg9 Upwork- www.upwork.com/freelancers/~0125e09bd9d883ead3 I will upload more videos like this. My videos are mainly focused on Excel, Python and MySQL. You can subscribe to join the c...
Combine multiple CSV files using Python
Просмотров 1,7 тыс.Год назад
Hello guys, In this video- I have shown you how you can combine multiple CSV files using Python. Twitter- @ajay garg Insta- @ajay_garg_1 LinkedIn- www.linkedin.com/in/ajay-garg-46b558224/ Fiverr- www.fiverr.com/ajaygarg9 Upwork- www.upwork.com/freelancers/~0125e09bd9d883ead3 I will upload more videos like this. My videos are mainly focused on Excel, Python and MySQL. You can subscribe to join t...
How to use VLOOKUP and HLOOKUP in Excel
Просмотров 68Год назад
Hello guys, In this video- I have shown you how you can use vlookup and hlookup formulas in excel. Twitter- @ajay garg Insta- @ajay_garg_1 LinkedIn- www.linkedin.com/in/ajay-garg-46b558224/ Fiverr- www.fiverr.com/ajaygarg9 Upwork- www.upwork.com/freelancers/~0125e09bd9d883ead3 I will upload more videos like this. My videos are mainly focused on Excel, Python and MySQL. You can subscribe to join...
Convert pdf to Excel using Python (PyPDF2)
Просмотров 21 тыс.Год назад
Hello guys, In this video- I have shown you how you can extract data from multiple PDFs into an excel file. GitHub Link- github.com/ajaygithub2/pdf-to-excel Twitter- @ajay garg Insta- @ajay_garg_1 LinkedIn- www.linkedin.com/in/ajay-garg-46b558224/ I will try to upload more videos like this. I am not an advanced learner myself. My python learning is mainly focused on its data side (Pandas, numpy...
Basics of virtual environment in python
Просмотров 35Год назад
Hello guys, In this video, I am talking about virtual environment in python. What they are, why they are used, how to create, activate, deactivate and delete a virtual environment. Twitter- @ajay garg Insta- @ajay_garg_1 I will try to upload more videos like this. My python learning is mainly focused on its data side (Pandas, numpy, BeautifulSoup, selenium, natural language processing, CNNs, py...
Using selenium to download PDFs
Просмотров 3,6 тыс.Год назад
Hello guys, In this video- I have explained how you can use selenium in python to download multiple pdfs from a website. GitHub Link- github.com/ajaygithub2/download-pdfs-from-a-website Twitter- @ajay garg Insta- @ajay_garg_1 I will try to upload more videos like this. I am not an advanced learner myself. My python learning is mainly focused on its data side (Pandas, numpy, BeautifulSoup, selen...
How to delete administrator account in Windows 11/10 when there is no option to delete?
Просмотров 89 тыс.Год назад
Hello guys, In this video, I have showed how you can delete an administrator account when there is no option to delete it. Do leave a like if this video helped you. And you can subscribe if you want. I will try to regularly upload videos related to python, programming, sql, ms excel and many such topics. how to delete administrator account, administrator account delete, delete administrator acc...
Hide Password and API key using environment variables in python
Просмотров 315Год назад
Hello guys- In this video, I have shown how you can use environment variables in python in python to hide your password, API keys or usernames or anything you want.. #1 Python Project (OCR Project) ruclips.net/video/Xb6AgrXEn90/видео.html #2 Python Project (Web Scraping) ruclips.net/video/fjr1_s3QL_Y/видео.html #3 Python Project (RUclips Downloader) ruclips.net/video/2DOIUe8uFyI/видео.html #4 P...
#4 Python Real Life Project !! Email Automation Using Python
Просмотров 521Год назад
Hello guys, In this video- I have created a project on how you can automate sending emails to multiple email addresses at once using python. You can also customize names inside your message or other things if you want. Note: This script works with gmail only GitHub Link- github.com/ajaygithub2/email-automation (The one you are looking for is email_auto.py) #1 Python Project (OCR Project) ruclip...
#2 Python Real Life Project !! Scrape a website using BeautifulSoup
Просмотров 2,6 тыс.Год назад
Hello guys, In this video- I have created a project on how you can use beautifulsoup to scrape a website.(I have scraped yellowpages.com in the video). But you can really scrape any website after watching this video. GitHub Link- github.com/ajaygithub2/yellow-pages-scraper (The one you are looking for is yellowpages_yt.py) Twitter- @ajay garg Insta- @ajay_garg_1 I will try to upload more videos...
#1 Python Real Life Project !! Extract text from image using python
Просмотров 1,5 тыс.Год назад
Hello guys- In this video: I have shown a real life project on how you can extract text from an image based on certain conditions. You can even use re(regular expression) library to do all types of things and extract out text that you want. GitHub Link- github.com/ajaygithub2/extract-specific-text-from-image (name of script in this repo is img_to_text.ipynb) Don't forget to read the readme file...
Convert text case to Upper, Lower or Proper Case
Просмотров 256Год назад
In this video- How you can convert the case of text in a cell to Upper, Lower or Proper Case. Thankyou! #caseinexcel #uppercaseletter #lowercaseletters #propercase #exceltextcase change text case in excel, upper case in excel, lower case in excel, proper case in excel, convert upper to lower case
How to open excel in safe mode
Просмотров 6 тыс.Год назад
In this video- I show how you can open excel in safe mode Processing speed of data in excel increases when used in safe mode #excel #excelsafemode #safemode #excelspeed how to open excel in safe mode, how to increase working speed in excel, increase excel speed, handle big files in excel, handle large files in excel
3 Ways to convert error in number cells to numbers
Просмотров 66 тыс.Год назад
3 Ways to convert error in number cells to numbers
Create a dynamic range for data validation in excel.
Просмотров 137Год назад
Create a dynamic range for data validation in excel.
Withdrawing money from fiverr to paypal (India)
Просмотров 7 тыс.Год назад
Withdrawing money from fiverr to paypal (India)