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/… Image
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.
Read 6 tweets
How to AutoFit cell sizes in Excel!

🗂️ 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
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
Read 5 tweets
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🧵 Image
-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
-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.
Read 6 tweets
How to alternate row colors in Excel!

🗂️ 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
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
Read 5 tweets
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 Image
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 Image
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?" Image
Read 25 tweets
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😁 ImageImage
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 😊 ImageImage
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
Read 5 tweets
87% of data science projects fail.

One reason is the lack of production.

Here's an easy solution. 🧵

#datascience #python #R #rstats #career Image
This is called an #API (Application Programming Interface). Image
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.
Read 6 tweets
आज सर्वच क्षेत्रात कुठे ना कुठे Excel चा वापर केला त्यामुळे एक्सेल शिकणं आणि प्रभावीपणे त्याचा वापर करणं खूप महत्त्वाचं आहे, तुम्हाला सुद्धा एक्सेल शिकायची इच्छा असेल तर हा कोर्स नक्कीच तुम्हाला मदत करेल, ट्विट बुकमार्क करा म्हणजे कोर्स तुम्हाला परत शोधावा लागणार नाही👇
🧵१/७ Image
Read 7 tweets
🧵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 Image
🧵2/8 CSV Files: The "read.csv" function is a go-to for reading comma-separated values files. For improved performance and more flexibility, consider using the "read_csv" function from the readr package or the fread function from the data.table package. 📃 #CSV #RStats
🧵3/8 Excel Files: The readxl package provides functions like "read_excel" for reading data from Excel files (.xls and .xlsx). Alternatively, the openxlsx package offers more features, including reading and writing Excel files. 📊 #Excel #RStats
Read 9 tweets
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 🧵
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. 🤑
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. 💰
Read 12 tweets
How to make a dynamic calendar in Excel!

🗂️ 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
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
Read 5 tweets
How to use the series tool in Excel!

🗂️ 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
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
Read 5 tweets
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
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
🎬 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!!!)
Read 4 tweets
How to translate in Google Sheets!

🗂️ 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
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
Read 5 tweets
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/ A kraken strangling a coin-operated judge automata whose rob
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/
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/
Read 30 tweets
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

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!