35 Excel shortcuts you never knew existed:

Alt + E + S + S: Split text to columns.
Alt + E + S + P: Remove duplicate values.
Alt + E + S + V: Paste values. Alt + E + S + D: Text to columns (delimited).
Alt + E + S + E: Text to columns (fixed width).
Alt + E + A + S: AutoSum (sum selected cells).

35 SQL Interview Questions & Answers You Should Know.

Repost for others

35 SQL Interview Questions & Answers You Should Know.

Repost for others

I spent a week compiling these Data Analysis Cheat Sheets for you.

Open this: 1

You're in an interview, and the interviewer asks,

"Can you tell me about yourself?"

Here is how you can answer: 1. Start with a Brief Introduction about you:

When asked about yourself in an interview.

Mention your name, where you're from, and a bit about your educational background.

Keep it concise and relevant to the job you're applying for.

For example: "My name is [Your Name]. I grew up in [Your City/Town] and recently graduated with a degree in [Your Field]."

If you are looking for Public Datasets to work on Data Analysis or Data Science.

Here are 5 Free Data Sources where you can find one for your next Project:

Rt 1. Awesome Data Github Repository
⁠
github.com/awesomedata/aw…

Dear Data Analyst.

Here is a MEGA thread on courses you need to master EXCEL and SQL on YOUTUBE.

Zero-to-Hero.

For absolutely FREE 1. Ezekiel ''DATA ANALYSIS MADE EASY''

youtube.com/@EzekielAleke

35 Excel shortcuts you never knew existed:

Alt + E + S + S: Split text to columns.
Alt + E + S + P: Remove duplicate values.
Alt + E + S + V: Paste values. Alt + E + S + D: Text to columns (delimited).
Alt + E + S + E: Text to columns (fixed width).
Alt + E + A + S: AutoSum (sum selected cells).

CISCO is offering FREE trainings and certifications for:

- Data Analytics
- Data Science
- Cybersecurity
- Web Dev
- Python
- Operating Systems & IT
- Digital Literacy

Self-paced courses, practice as you learn.

You will get certified after completing the course.

Open this THREAD to get started on your learning.

RT for someone on your TL. Data Analytics

skillsforall.com/course/data-an…

35 Excel shortcuts you never knew existed:

Alt + E + S + S: Split text to columns.
Alt + E + S + P: Remove duplicate values.
Alt + E + S + V: Paste values. Alt + E + S + D: Text to columns (delimited).
Alt + E + S + E: Text to columns (fixed width).
Alt + E + A + S: AutoSum (sum selected cells).

YouTube Channels that helped me when I was starting my career as a Data Analyst.

I am sure they will be helpful to you too.

Like and Retweet for others. If you’re yet to start your Data Analysis journey and looking for where to start.

Or you want to improve your skills.

DATA ANALYSIS MADE EASY is all you need to master Data Analytics.

It will teach you: Excel, SQL, Power BI, DAX and Python

Get it here: selar.co/bpr5

Dear Data Analysts,

Here is a MEGA thread on courses to master EXCEL and SQL on YOUTUBE.

Zero-to-Hero.

For absolutely FREE

RT First learn how to install SQL Server here

Dear Data Analysts,

Master Power BI and Tableau with these YOUTUBE courses, Zero-to-Hero.

Some give Certificate after completion, YES.

For absolutely FREE: 1. Power BI series @Alex_TheAnalyst

m.youtube.com/playlist?list=…

Want to Analyse Data using Excel?

Here are the 10 Most Common Excel Functions I teach all my students.

You should Master it too:

- Thread - As a Data Analyst, you are responsible for collecting, cleansing, and analyzing datasets to aid in problem-solving.

Dear Data Analyst.

If you want to become a Data Analyst.

Here is my New Year gift to you.

Data Analysis Zero-to-Hero FREE resources.

rt 1. Excel @learnitanywhere

m.youtube.com/playlist?list=…

2024 is a year you should take ACTIONS,

Enough of Bookmarking every tweets you see for later.

Bellow are list of Courses you need to start in 2024.

To improve your Resume and get yourself a JOB.

rt for others If you prefer reading books.

Then DATA ANALYSIS MADE EASY is all you need to master Data Analysis in 2024.

It will teach you:

- Excel
- SQL
- Power BI
- Python

Get it here: selar.co/bpr5

Everyone should learn EXCEL irrespective of your profession.

It will put you ahead of the curve.

Here are 5 YouTube videos that will help you master Excel: Excel Functions Playlist YouTube:

m.youtube.com/playlist?list=…

DATA ANALYSIS CHEAT SHEETS: SQL cheatsheet

Create an exceptional RESUME with these 6 websites for FREE.

Number 4 is my favorite: 1. Build a professional resume for free

resume.com

Master SQL and Excel with this MEGA thread.

Number 4 is my favorite.

Also comment the resources you need so I can add it to my next thread.

RT. 1. Excel 2021 Beginner Tutorial:

If you are a Data Analyst and you like to learn Data Analytics using YouTube.

Open this!!!

All Absolutely FREE: 1 Learn how to build Excel Dashboard @ezekiel_aleke