Discover and read the best of Twitter Threads about #excel

Most recents (24)

It's important to have a roadmap for Data Science and Analysis before starting a career in this rapidly evolving field. In this thread,l'll share the roadmap that has helped me establish a solid foundation, comprehend the entire spectrum, & keep pace with the latest technologies.
Why is it important to have a roadmap?

- Clear understanding of the field: Data science & analysis is a multidisciplinary field encompassing statistics, machine learning, programming, & data visualization. It helps in understanding skills required for each domain, & how they fit
- Setting clear goals: Having a roadmap helps in setting clear goals & objectives for your career. It allows you prioritize the skills to learn & which projects to work on to achieve those goals. It also helps in defining a path to success & a timeline to reach those milestones.
Read 25 tweets
As the #rstats course material is not public (yet?) or available as online training (yet?), I thought I am sharing some slides from the deck.

The course covers all steps of the #DataScience workflow as featured in @hadleywickham's fantastic #R4DS 📕 r4ds.had.co.nz/index.html The title slide of the workshop "Reproducible Data AnalThree avatars (customised versions of the lovely Open Peeps A chapter slide entitled "What is This Course About?&quA conceptional representation of the data science workflow:t
Let's start with session 1:
"Introduction to #rstats and #rstudio" ®️ The title slide for the first session of the "ReproduciA slide explaining what the R programming language is:  &quoA comparison of R and Rstudio, taken from ModernDive: R is tA screenshot of Rstudio with the default panes: Script (uppe
The fundamentals of R includes:

* values
* assignments and objects
* functions
* data types
* unknown values
* vectors
* factors
* packages
* tabular data
* data generation
* data import A colorful overview of how functions work: the function nameA function might return a value, which is printed on a new lA colorful representation of objects and assignments in R: tA colorful explanation of vectors that start with the vector
Read 16 tweets
Top 25 SQL Interview Questions and Answers

🧵
There are certain SQL concepts which you should be familiar with if you plan to attend an #SQL interview. No matter which RDBMS you use wether it is MySQL, Oracle, Microsoft SQL Server, #PostgreSQL or any other, these SQL concepts are common for all of the popular RDBMS.
Read 5 tweets
6 Must have line charts for business data analysis 📈👌 💯

🧵
1. Indexed chart for comparing trend
2. #Sparkline for tiny insight
3. Spaghetti line #chart for bringing focus
4. Smoothed line chart for evening out edge
5. Forecast chart to predict future value based on trend & seasonality
6. Line chart combination when just a line won't do
▶ Line charts are similar to #scatterplots except that they connect the data points with lines. Choose a line chart when ordering and joining the #data points by their X-axis values highlights meaningful changes in the vertical Y-axis variable.
Read 4 tweets
🚀 You can become a data analyst in 90 days without spending a cent! Yes, you heard that right.

With the right approach and dedication, anyone can become a #dataanalyst . Here are the steps to follow( Make sure the order is maintained)

🧵
Learn Excel - Time : 12 days
🎙️ Tutorials -
lnkd.in/eWmC2vf8
🏗️ Projects -
lnkd.in/ew5y5KP7
Learn Basic Statistics - Time : 3 days
🎙️ Tutorials -
lnkd.in/emKawHBs
Read 10 tweets
📊 Hey Folks

✍ So Day - 6 on #powerbi 🚀

🧵👇
⚠ Today I Made a Awesome #America Retail Analysis Dashboard

🎇 The beauty of Power BI is that you can look at each element to make better #decisions. The #dashboard's visual representation allows users to quickly see the #data that's relevant for the choices they have to make
🔥Then, define clear objectives to ensure that the dashboard accurately reflects your desired outcomes. 👇

#PowerBI #100DaysOfCode #100daysofcodechallenge #Data #100daysofcoding #developer #DataScience #dataScientist #DataAnalytics #excel #SQL #tableau #visualization #Dashboard
Read 4 tweets
Learn to work with TEXT Data in Excel like a PRO with these tutorials:
1. Sum Comma Separated Values in Excel with Formula using TEXTSPLIT + LAMBDA Functionhttps://youtube.com/shorts/n2zriawrz7A
2. Count Comma Separated values in a Single Cell in Excel with COUNTA and TEXTSPLIThttps://www.youtube.com/shorts/oQ6GXtJoQIg
Read 17 tweets
🐍Python is easy!

You can learn enough #Python in 8-10 hours to pick the rest up with active practice.

Here are my top 5 #free places to catch the basics:

🧵👇
1/ Codeacademy (where I first learnt Python) -
lnkd.in/eZnqKD_x
2/ MITx 6.0001 (this series is a brilliant intro to CS) -
lnkd.in/eeBXsQqr
Read 7 tweets
✍ Day 12 - Series on #Python 🤖 with @Sachintukumar📍

📢 Topic of Day - " Glob Module in Python "

🧵👇
' With the help of the Python #glob #module, we can search for all the path names which are looking for files matching a specific pattern (which is defined by us). The specified pattern for file matching is defined according to the rules dictated by the #Unix shell.

#SQL
The result obtained by following these rules for specific pattern file matching is returned in arbitrary order in output of program While using file matching pattern we have to fulfil some requirements of the glob #module because the module can travel through the list of the file
Read 5 tweets
Work smarter, not harder, with these top 3 time-saving Excel tools:
1. AutoFit

Automatically fit all column widths to the size of the data by hitting ALT H O I.
2. AutoFill

Automatically fill data down columns by hitting CTRL E.
Read 6 tweets
6 must-know text formatting Excel tips: ✍️
1. Center Across Selection

CAS cleans up data by centering text across cells without the issues that merged cells cause. Select the text followed by the cells you want to center the text across > Home tab > Alignment Settings > Center Across Selection under horizontal > OK.
2. Split Cell

Can’t decide whether to label a row or column? Try splitting the cell to label both. To split a cell, enter both labels on separate lines and move the top header to the right of the cell. Next, open the Format Cells box > Border Tab > Split Diagonal Border > OK.
Read 9 tweets
Learn to work with Date and Time in Excel like a PRO with these tutorials:
1. Make Dynamic Yearly Calendar in Excel
youtube.com/shorts/SbKgLB6…
2. Make Dynamic Monthly Calendar in Excel
youtube.com/shorts/h80IXkR…
Read 17 tweets
Save hours and your sanity using these 10 Excel shortcuts:
1. ALT H O I

Nothing is worse than passed along messy data. Instead of manually adjusting the column widths in the header to clean it up, try ALT H O I. ALT H O I automatically adjusts the selected cells’ column widths to equal the size of their contents.
2. ALT H O A

Now that we know how to adjust our cells' column widths automatically let's learn how to adjust their row heights! ALT H O A automatically adjusts the selected cells’ row heights to equal the size of their contents.
Read 13 tweets
💥14 herramientas secretas impulsadas por #RStats para ahorrar tiempo y esfuerzo en tus proyectos de datos (¡No te lo pierdas!):👀
1️⃣ ¡Edita tus datos de forma interactiva (y guarda el código)! 👀
📦 'editData' es un complemento de RStudio para editar un data.frame o un tibble de forma interactiva
🔗 buff.ly/3U5Tgjy

#DataScience #DataVisualization #dataviz #stats #analytics #RStats #Analytics
2️⃣ ¡Crea gráficos #ggplot de forma interactiva!🚀
📦esquisse es otro de mis addins favoritos de #rstudio
✅ exporta el gráfico o recupera el código para reproducir el gráfico
🔗 buff.ly/3mxLHSo
#DataScience #DataVisualization #dataviz #stats #analytics #RStats #Analytics
Read 17 tweets
5 array functions you need to know:
1. TRANSPOSE

Need to flip the rows and columns in your data table? Instead of manually interchanging each row and column, try the TRANSPOSE function. Just select the data you want to transpose as the array argument, and Excel will automatically flip your data.
2. SEQUENCE

Never waste time typing out numbered lists again using Excel’s SEQUENCE function. SEQUENCE quickly and easily creates a list of sequential numbers for you. Just enter the number of rows you want in the sequential list as the rows argument.
Read 8 tweets
Excel DATA VALIDATION is one powerful tool.
Here are TEN [10] tutorials to get up to speed:

#excel #exceltips #exceltricks #exceltutorials #excelformulas
1. Prevent Duplicate Data Entries in Excel with Custom Data Validation
youtube.com/shorts/oOgZLxB…
2. Make Budgets with spending limits in Excel
youtube.com/shorts/6kw8_ba…
Read 12 tweets
10 Excel hacks 99% of users don't know: 🤯
1. Creating Barcodes

Creating scannable barcodes may seem like a difficult task, but Excel actually makes it easy. First, add an “*” before and after each product code using the ampersand symbol. Then just update the font to “libre barcode 128” to create the barcodes! Easy.
2. AutoCorrect Symbols

Instead of manually searching for and inserting symbols, you can code them into Excel using AutoCorrect. Hit ALT F T > Proofing > AutoCorrect Options. Enter the phrase that'll represent the symbol next to ‘Replace:’ and the symbol next to ‘With:.’
Read 12 tweets
7 number formatting shortcuts: 🔢
1. CTRL SHIFT !

The CTRL SHIFT ! automatically applies number formatting to the selected cells. Number format rounds numbers to two decimal places and adds commas.
2. CTRL SHIFT @

Never waste your time formatting time values manually again with the CTRL SHIFT @ shortcut. CTRL SHIFT @ automatically applies time formatting to the selected cells for you.
Read 10 tweets
5 shortcuts that will make analyzing data a little bit easier:
1. ALT =

Let Excel do the math for you with this shortcut! ALT = detects data in adjacent cells and automatically sums it using the SUM function. Just select an empty cell adjacent to the data that needs to be added and press ALT =.
2. CTRL H

Finding values in your workbook and replacing them one by one could take hours, but not with CTRL H. The CTRL H shortcut opens the find and replace dialog box, which finds a value and replaces all instances with a new specified value.
Read 8 tweets
🎯Day -17 on SQL Questions Series📓

▶️Today I Solved the #Olympic Gold Medal
Problem

🧵👇
Q17 ) In problem where we need to find player with no of gold medals won by them only for players who won only gold medals.?
📓Code Snippets :
Read 4 tweets
Day -16 on #Leetcode SQL Questions Series

🎯Today I Take a Question From
@LeetCode Platform 🔥

🧵👇
Q16 ) Write an SQL query to report all customers who never order anything.

Return the result table in any order.
🙌Thankyou @LeetCode for Providing such a great SQL Questions

📓Code Snippets : Image
Read 4 tweets
Day -15 on #Leetcode SQL Questions Series

🎯Today I Take a Question From @LeetCode Platform 🔥

🧵👇
Q15) A company's executives are interested in seeing who earns the most money in each of the company's departments. A high earner in a department is an employee who has a salary in the top three unique salaries for that department.
--- Write an SQL query to find the employees who are high earners in each of the departments.
Read 5 tweets
5 formula shortcuts all Excel users must know:
1. F4

One of the best ways to avoid errors when writing formulas is by locking reference cells. Instead of typing out the dollar sign in the cell reference, try the F4 shortcut. F4 quickly toggles through absolute/relative referencing.
2. Alt =

Do you feel like you spend too much time summing data in Excel? Try the Alt = shortcut instead. Alt = automatically sums data detected around the cell. Just select the cells that you want to add totals to, hit Alt =, and let Excel do the work for you!
Read 8 tweets

Related hashtags

Did Thread Reader help you today?

Support us! We are indie developers!


This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3.00/month or $30.00/year) and get exclusive features!

Become Premium

Too expensive? Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal Become our Patreon

Thank you for your support!