Discover and read the best of Twitter Threads about #excel
Most recents (24)
An #Excel #error in the Austrian social democrats leadership election occurred when aggregating results together into a spreadsheet. #Doskozil was leader from the 3rd to the 5th of June. Following the correction #Babler leads the party. #risk #Excelgate
bloomberg.com/news/articles/…
bloomberg.com/news/articles/…
We have countless examples of spreadsheet errors in political organisation. The mistakes made are elementary and often occur when passing information from system A to system B manually. A basic lack of checking, corroboration and validation has derailed democracy once again
These errors are great examples of how little thought is put into the use of spreadsheets for critical decision making. So much confidence was bestowed on #Excel, no one bothered to check if it was correct. Its a mistake we repeat time and again.
How to AutoFit cell sizes in Excel!
🗂️ Don’t forget to save this post!
#excel #exceltips #exceltricks #spreadsheets #corporate #accounting #finance #workhacks #tutorials
🗂️ Don’t forget to save this post!
#excel #exceltips #exceltricks #spreadsheets #corporate #accounting #finance #workhacks #tutorials
Level up in Excel + AI in one hour!!! 💃🏼 You’re invited to a FREE live Excel + AI class with Miss Excel!
• Session 1 - Wed, May 31 at 9am EST: event.webinarjam.com/register/54/mg…
• Session 2 - Thur, June 1 at 2pm EST: event.webinarjam.com/register/55/6o…
Note: This tweet contains affiliate links
• Session 1 - Wed, May 31 at 9am EST: event.webinarjam.com/register/54/mg…
• Session 2 - Thur, June 1 at 2pm EST: event.webinarjam.com/register/55/6o…
Note: This tweet contains affiliate links
In this 1 hour power-packed session, you will learn our top Excel tricks + tips on how to leverage AI Tools like ChatGPT to save you hours in your week!
🗓️ Two date / time options (same content at each):
• Wed, May 31 at 9am EST
• Thur, June 1 at 2pm EST
🗓️ Two date / time options (same content at each):
• Wed, May 31 at 9am EST
• Thur, June 1 at 2pm EST
FUNCTION ARGUMENT WINDOW IN EXCEL📊.
To get a basic understanding of excel formulas and funtion( SUM,COUNT,MIN, MAX etc) as a beginner in data analysis learning excel, the use of the Fucntion argument window is relevant and will also be a guide to gain understanding.
A Thread🧵
To get a basic understanding of excel formulas and funtion( SUM,COUNT,MIN, MAX etc) as a beginner in data analysis learning excel, the use of the Fucntion argument window is relevant and will also be a guide to gain understanding.
A Thread🧵
-The Function Argument Window or Dialog box is helpful when building a formula. It helps to list the argument required for the function, identify which arguments are required or optional, show the result of a calculation or initial result of the function.
#data #excel
#data #excel
-It also help with understanding and using Nested functions-for example, when you want to put a MATCH function inside of a VLOOKUP function. It isn't easily understood for the first time trying it out, but you can use the function argument dialog for each function in the formula.
How to alternate row colors in Excel!
🗂️ Don’t forget to save this post!
#excel #exceltips #exceltricks #spreadsheets #corporate #accounting #finance #workhacks #tutorials
🗂️ Don’t forget to save this post!
#excel #exceltips #exceltricks #spreadsheets #corporate #accounting #finance #workhacks #tutorials
Level up in Excel + AI in one hour!!! 💃🏼 You’re invited to a FREE live Excel + AI class with Miss Excel!
• Session 1 - Wed, May 31 at 9am EST: event.webinarjam.com/register/54/mg…
• Session 2 - Thur, June 1 at 2pm EST: event.webinarjam.com/register/55/6o…
Note: This tweet contains affiliate links
• Session 1 - Wed, May 31 at 9am EST: event.webinarjam.com/register/54/mg…
• Session 2 - Thur, June 1 at 2pm EST: event.webinarjam.com/register/55/6o…
Note: This tweet contains affiliate links
In this 1 hour power-packed session, you will learn our top Excel tricks + tips on how to leverage AI Tools like ChatGPT to save you hours in your week!
🗓️ Two date / time options (same content at each):
• Wed, May 31 at 9am EST
• Thur, June 1 at 2pm EST
🗓️ Two date / time options (same content at each):
• Wed, May 31 at 9am EST
• Thur, June 1 at 2pm EST
Tack @Kvalitetsaktie för er ovärderliga utbildning och inspiration. Satt i helgen lyssnade, antecknade & njöt när ni diskuterade er filosofi (avs 108), världsklass! Tänkte dela med mig av en summering av KAP-filosofin. OBS: är en glad amatör så res för div fel & misstolkningar
KAP citat #1
"The basic ideas of investing are to look at stocks as business, use the market's fluctuations to your advantage, and seek a margin of safety. That's what Ben Graham taught us. A hundred years from now, they will still be the cornerstones of investing," /Buffett
"The basic ideas of investing are to look at stocks as business, use the market's fluctuations to your advantage, and seek a margin of safety. That's what Ben Graham taught us. A hundred years from now, they will still be the cornerstones of investing," /Buffett
Marknaden är på kort sikt irrationell men rationell på lång. Detta använder man till sin fördel och utnyttjar felprissättningar. Sen tillkommer trender, flockbeteende och indexvikt. "Vem vill du helst sälja dina aktier till, en indexfond som automatiskt viktar upp eller Ola?"
Happy Sunday Everyone,
I think I am feeling well enough to make this tweet
So I want to share a small win here. I am participating in the Data Analytics Super League organized by @lighthall_co and I want to share that I advanced to level 3 in flying colors
Top of the table😁
I think I am feeling well enough to make this tweet
So I want to share a small win here. I am participating in the Data Analytics Super League organized by @lighthall_co and I want to share that I advanced to level 3 in flying colors
Top of the table😁
The Level 2 challenge was a murder mystery challenge to find who the killer is and we were to solve the challenge using SQL
If you dug deeper you'd find out that there was someone who hired it.
Nothing complex but it was fun, felt like a detective 😊
If you dug deeper you'd find out that there was someone who hired it.
Nothing complex but it was fun, felt like a detective 😊
My submission: drive.google.com/drive/folders/…
If you want to try it out yourself and have fun with SQL, check here
lighthall.co/challenge/cd01…
Thank you @lighthall_co and @thenaijacarguy for the challenge
it is getting really interesting and level 3 is not easy
If you want to try it out yourself and have fun with SQL, check here
lighthall.co/challenge/cd01…
Thank you @lighthall_co and @thenaijacarguy for the challenge
it is getting really interesting and level 3 is not easy
87% of data science projects fail.
One reason is the lack of production.
Here's an easy solution. 🧵
#datascience #python #R #rstats #career
One reason is the lack of production.
Here's an easy solution. 🧵
#datascience #python #R #rstats #career
This is called an #API (Application Programming Interface).
An API allows the user to make requests using a tool they are comfortable with.
The API runs a program that the data scientist has created on the server.
And the API returns a result.
The API runs a program that the data scientist has created on the server.
And the API returns a result.
आज सर्वच क्षेत्रात कुठे ना कुठे Excel चा वापर केला त्यामुळे एक्सेल शिकणं आणि प्रभावीपणे त्याचा वापर करणं खूप महत्त्वाचं आहे, तुम्हाला सुद्धा एक्सेल शिकायची इच्छा असेल तर हा कोर्स नक्कीच तुम्हाला मदत करेल, ट्विट बुकमार्क करा म्हणजे कोर्स तुम्हाला परत शोधावा लागणार नाही👇
🧵१/७
🧵१/७
🧵1/8 Loading datasets from various sources is crucial for data analysis. In this thread, we'll explore how to read datasets from different sources and software using R! 📚 #RStats #DataScience
Want to know how to calculate the return on your investments?
Look no further than the IRR & XIRR functions in 'MS Excel' to make smarter investment decisions!
Let's dive into the differences and find out which one is right for you. 📈💰 #excel #finance #investing 🧵
Look no further than the IRR & XIRR functions in 'MS Excel' to make smarter investment decisions!
Let's dive into the differences and find out which one is right for you. 📈💰 #excel #finance #investing 🧵
So, what exactly is the IRR function?
In simple terms, it's a formula that calculates the rate of return that makes the net present value (NPV) of a series of cash flows equal to zero. 🤑
In simple terms, it's a formula that calculates the rate of return that makes the net present value (NPV) of a series of cash flows equal to zero. 🤑
To use the IRR function, you'll need to input a series of cash flows for a given investment.
These cash flows can be positive or negative and can occur at different points in time. 💰
These cash flows can be positive or negative and can occur at different points in time. 💰
How to make a dynamic calendar in Excel!
🗂️ Don’t forget to save this post!
#excel #exceltips #exceltricks #spreadsheets #corporate #accounting #finance #workhacks #tutorials
🗂️ Don’t forget to save this post!
#excel #exceltips #exceltricks #spreadsheets #corporate #accounting #finance #workhacks #tutorials
Level up in Excel in one hour!!! 💃🏼 You’re invited to a FREE live Excel class with Miss Excel!
🤍 Register Now + 24 Hour Replay: linktr.ee/CheatSheets
#excel #exceltips #exceltricks #ai #spreadsheets #corporate #accounting #finance #workhacks #tutorials
🤍 Register Now + 24 Hour Replay: linktr.ee/CheatSheets
#excel #exceltips #exceltricks #ai #spreadsheets #corporate #accounting #finance #workhacks #tutorials
In this 1 hour power-packed session, you will learn our top Excel tricks + tips on how to leverage AI Tools like ChatGPT to save you hours in your week!
🗓️ Two date / time options (same content at each):
• Thursday, 27 April 2023, 12PM EST
• Friday, 28 April 2023, 3PM EST
🗓️ Two date / time options (same content at each):
• Thursday, 27 April 2023, 12PM EST
• Friday, 28 April 2023, 3PM EST
How to use the series tool in Excel!
🗂️ Don’t forget to save this post!
#excel #exceltips #exceltricks #spreadsheets #corporate #accounting #finance #workhacks #tutorials
🗂️ Don’t forget to save this post!
#excel #exceltips #exceltricks #spreadsheets #corporate #accounting #finance #workhacks #tutorials
Level up in Excel in one hour!!! 💃🏼 You’re invited to a FREE live Excel class with Miss Excel!
🤍 Register Now + 24 Hour Replay: linktr.ee/CheatSheets
#excel #exceltips #exceltricks #spreadsheets #corporate #accounting #finance #workhacks #tutorials
🤍 Register Now + 24 Hour Replay: linktr.ee/CheatSheets
#excel #exceltips #exceltricks #spreadsheets #corporate #accounting #finance #workhacks #tutorials
In this 1 hour power-packed session, you will learn our top Excel tricks + tips on how to leverage AI Tools like ChatGPT to save you hours in your week!
🗓️ Two date / time options (same content at each):
• Thursday, 27 April 2023, 12PM EST
• Friday, 28 April 2023, 3PM EST
🗓️ Two date / time options (same content at each):
• Thursday, 27 April 2023, 12PM EST
• Friday, 28 April 2023, 3PM EST
Level up in Excel in one hour!!! 💃🏼 You’re invited to a FREE live Excel class with Miss Excel!
🤍 Register Now + 24 Hour Replay: linktr.ee/CheatSheets
#excel #exceltips #exceltricks #ai #spreadsheets #corporate #accounting #finance #workhacks #tutorials
🤍 Register Now + 24 Hour Replay: linktr.ee/CheatSheets
#excel #exceltips #exceltricks #ai #spreadsheets #corporate #accounting #finance #workhacks #tutorials
In this 1 hour power-packed session, you will learn our top Excel tricks + tips on how to leverage AI Tools like ChatGPT to save you hours in your week!
🗓️ Two date / time options (same content at each):
• Thursday, 27 April 2023, 12PM EST
• Friday, 28 April 2023, 3PM EST
🗓️ Two date / time options (same content at each):
• Thursday, 27 April 2023, 12PM EST
• Friday, 28 April 2023, 3PM EST
🎬 If you can’t make it live, replays will be available for 24 hours - however extra presents for those who come live!
✨ Once registered, remember to save the date into your favorite calendar app!
🍹 Have your computer and favorite drink ready! (This will be fun I promise!!!)
✨ Once registered, remember to save the date into your favorite calendar app!
🍹 Have your computer and favorite drink ready! (This will be fun I promise!!!)
How to translate in Google Sheets!
🗂️ Don’t forget to save this post!
#excel #exceltips #exceltricks #spreadsheets #corporate #accounting #finance #workhacks #tutorials
🗂️ Don’t forget to save this post!
#excel #exceltips #exceltricks #spreadsheets #corporate #accounting #finance #workhacks #tutorials
Level up in Excel in one hour!!! 💃🏼 You’re invited to a FREE live Excel class with Miss Excel!
🤍 Register Now + 24 Hour Replay: linktr.ee/CheatSheets
#excel #exceltips #exceltricks #spreadsheets #corporate #accounting #finance #workhacks #tutorials
🤍 Register Now + 24 Hour Replay: linktr.ee/CheatSheets
#excel #exceltips #exceltricks #spreadsheets #corporate #accounting #finance #workhacks #tutorials
In this 1 hour power-packed session, you will learn our top Excel tricks + tips on how to leverage AI Tools like ChatGPT to save you hours in your week!
🗓️ Two date / time options (same content at each):
• Thursday, 27 April 2023, 12PM EST
• Friday, 28 April 2023, 3PM EST
🗓️ Two date / time options (same content at each):
• Thursday, 27 April 2023, 12PM EST
• Friday, 28 April 2023, 3PM EST
Today's Twitter threads (a Twitter thread).
Inside: The Golden Rule (them what has the gold makes the rules); and more!
Archived at: pluralistic.net/2023/03/25/con…
#Pluralistic 1/
Inside: The Golden Rule (them what has the gold makes the rules); and more!
Archived at: pluralistic.net/2023/03/25/con…
#Pluralistic 1/
I'm kickstarting the #audiobook for my next novel, an anti-finance finance thriller about #SiliconValley scams called *Red Team Blues*. #Amazon's #Audible refuses to carry my audiobooks because they're #DRM free, but crowdfunding makes them possible:
kickstarter.com/projects/docto… 2/
kickstarter.com/projects/docto… 2/
The Golden Rule (them what has the gold makes the rules): Dobbs, SVB, the Internet Archive, antitrust and the law's foundation in norms, not consistency.
3/
3/
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
