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
- 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.
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 course covers all steps of the #DataScience workflow as featured in @hadleywickham's fantastic #R4DS 📕 r4ds.had.co.nz/index.html
The fundamentals of R includes:
* values
* assignments and objects
* functions
* data types
* unknown values
* vectors
* factors
* packages
* tabular data
* data generation
* data import
* values
* assignments and objects
* functions
* data types
* unknown values
* vectors
* factors
* packages
* tabular data
* data generation
* data import
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.
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
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.
🚀 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)
🧵
With the right approach and dedication, anyone can become a #dataanalyst . Here are the steps to follow( Make sure the order is maintained)
🧵
⚠ 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
🎇 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
#PowerBI #100DaysOfCode #100daysofcodechallenge #Data #100daysofcoding #developer #DataScience #dataScientist #DataAnalytics #excel #SQL #tableau #visualization #Dashboard
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
' 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
#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
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.
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.
Automatically fill data down columns by hitting CTRL E.
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.
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.
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.
Learn to work with Date and Time in Excel like a PRO with these tutorials:
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.
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.
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.
💥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
📦 '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
📦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
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.
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.
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.
Excel DATA VALIDATION is one powerful tool.
Here are TEN [10] tutorials to get up to speed:
#excel #exceltips #exceltricks #exceltutorials #excelformulas
Here are TEN [10] tutorials to get up to speed:
#excel #exceltips #exceltricks #exceltutorials #excelformulas
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.
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:.’
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:.’
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.
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.
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.
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 =.
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.
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.
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 :
Q16 ) Write an SQL query to report all customers who never order anything.
Return the result table in any order.
Return the result table in any order.
Hey Folks 😃
📗Here are my Last 15 days Of SQL Questions Series Practice
🧵👇
📗Here are my Last 15 days Of SQL Questions Series Practice
🧵👇
Day 1 -
Day 2 -
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.
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.
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!
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!
