Discover and read the best of Twitter Threads about #Ref
Most recents (9)
Selama pake Excel, kendala yg sering aku alamin pas berkutat sama byk data itu kadang ada
nilai yg masih belum diketahui formatnya.
Untungnya ada fungsi IS yg bisa ngebantu "recheck" nilainya sebelum akua lanjutin formula nya
Aku mau coba tunjukin di sini. Semoga bermanfaat
nilai yg masih belum diketahui formatnya.
Untungnya ada fungsi IS yg bisa ngebantu "recheck" nilainya sebelum akua lanjutin formula nya
Aku mau coba tunjukin di sini. Semoga bermanfaat
1. ISBLANK
Fungsi ini dipake buat meriksa cell nya kosong atau nggak. Kalau kosong, ISBLANK bakal
ngehasilin nilai TRUE dan kalau nggak, hasilnya bakal jadi FALSE.
Syntax Fungsi
=ISBLANK(Value)
Noted : Kalau Sel nya isinya tanda spasi saja, berarti bukan Blank ya
Fungsi ini dipake buat meriksa cell nya kosong atau nggak. Kalau kosong, ISBLANK bakal
ngehasilin nilai TRUE dan kalau nggak, hasilnya bakal jadi FALSE.
Syntax Fungsi
=ISBLANK(Value)
Noted : Kalau Sel nya isinya tanda spasi saja, berarti bukan Blank ya
2. ISFORMULA
Aku sering pakai ini buat ngecek suatu cell itu lagi ada rumusnya atau nggak.
Kalau cell ada
rumus/formula, cell bakal ngasih nilai TRUE meskipun hasil formulanya Error dan nilai FALSE kalau nggak ada formulanya
Syntax Fungsi:
=ISFORMULA(Reference)
Aku sering pakai ini buat ngecek suatu cell itu lagi ada rumusnya atau nggak.
Kalau cell ada
rumus/formula, cell bakal ngasih nilai TRUE meskipun hasil formulanya Error dan nilai FALSE kalau nggak ada formulanya
Syntax Fungsi:
=ISFORMULA(Reference)
Hud (a) هود was the prophet of the people of 'Ad and his name is mentioned seven times in the Qur'an and a sura of the Qur'an is named after him. He is considered among the descendants of the Prophet Noah (a). Hud (a) was himself from the people of 'Ad, 1/6
A long time ago,
a great tribe lived in the
South of Arabia.
They were called Ad.
They were very clever and
could do many things.
They used the mountains
for their homes.
They carved out great mansions
with wonderful pillars.
They called their city Iram.
It was very famous./2
a great tribe lived in the
South of Arabia.
They were called Ad.
They were very clever and
could do many things.
They used the mountains
for their homes.
They carved out great mansions
with wonderful pillars.
They called their city Iram.
It was very famous./2
7 must-know number formatting Excel tips:
1. Custom Format (with emojis)
Tired of boring data? Give it some personality by visualizing your data with Emojis 🙂. Open the Format Cells dialog box > Number Tab > Custom > enter ‘[Color 10]0.00%🙂;[Color 3]-0.00%☹️’ as type.
Tired of boring data? Give it some personality by visualizing your data with Emojis 🙂. Open the Format Cells dialog box > Number Tab > Custom > enter ‘[Color 10]0.00%🙂;[Color 3]-0.00%☹️’ as type.
2. Add Text to Numbers
Adding text to numbers such as ‘Million’ manually is time-consuming and will cause calculation errors because the values are read as text. Instead, use custom formatting. Open the Format Cells box > Number Tab > Custom > enter ‘#,, “Million”’ as type.
Adding text to numbers such as ‘Million’ manually is time-consuming and will cause calculation errors because the values are read as text. Instead, use custom formatting. Open the Format Cells box > Number Tab > Custom > enter ‘#,, “Million”’ as type.
A thread of the 'top' universities in #REF2021 ranked by their #GenderPayGap and #EthnicityPayGap. The UK university median gender pay gap is 14.7%; the UK university median ethnicity pay gap is 9%.
#REFresults #REF
#REFresults #REF
1. Loughborough University. This university has a median gender pay gap of 31.3% and a median ethnicity pay gap of 11.1%.
2. University of Exeter. This university has a median gender pay gap of 21.7% and a median ethnicity pay gap of 12%.
#REFresults #REF2021
2. University of Exeter. This university has a median gender pay gap of 21.7% and a median ethnicity pay gap of 12%.
#REFresults #REF2021
3. University of Lancaster. This university has a median gender pay gap of 21.6% and doesn't report its median ethnicity pay gap.
4. University of East Anglia. This university has a median gender pay gap of 21.6% and doesn't report its median ethnicity pay gap data.
#REFresults
4. University of East Anglia. This university has a median gender pay gap of 21.6% and doesn't report its median ethnicity pay gap data.
#REFresults
And #ECRday2022 is off! We're kicking off with a panel on 'The Early Career Journey' with a team of @qub_belfast experts. Before we get started: some housekeeping! Thanks are due to @DNIRE1, Alice at @QUBPostdoc & @WrayRamona for being so amazingly helpful & supportive 🙏
@DNIRE1 @QUBPostdoc @WrayRamona We also need to thank @QUBResearchPol for the funding that enabled us to pay all our speakers & chairs: only right to reward their time, expertise & generosity!
@DNIRE1 @QUBPostdoc @WrayRamona @QUBResearchPol Speaking of chairs, today we are in the hands of @J_O_McCullough, who is a @nbcdtp PhD Candidate at @ModLangs_QUB.
Excel Skill and Concepts a Data Analyst Should Know
Check this 🧵🧵🧵 for more details
Kindly RT 🙏
Check this 🧵🧵🧵 for more details
Kindly RT 🙏
It is always encouraged that a data analyst should learn how to use Excel or other spreadsheet app to work with data. As a matter of fact, Excel is the closest tool to understanding complex challenges in your Journey.
If you can do it with Excel, you can figure it out for others
If you can do it with Excel, you can figure it out for others
Mastering Excel is a Journey and what you end up knowing still depends hugely on your role.
I will however highlight some concepts you should be familiar with as a Data Analyst in Excel.
Note: It is not sufficient to be familiar with them, you should Know WHEN TO USE THEM.
I will however highlight some concepts you should be familiar with as a Data Analyst in Excel.
Note: It is not sufficient to be familiar with them, you should Know WHEN TO USE THEM.
Seuraa (pitkähkö) ketju aiheista taloudellinen riippumattomuus ja vaurastuminen 👇#sijoittaminen #kansankapitalismi #FIRE
Kipinä ketjulle lähti tästä mainiosta jutusta, jossa haastateltavina aiheen tiimoilta @ViljanenJesse ja @Nuukablog. Suosittelen muuten ottamaan molemmat herrat seurantaan, jos ei vielä ole!
is.fi/taloussanomat/…
is.fi/taloussanomat/…
En varmaankaan tässä ketjussa kerro mitään, mitä ei olisi jo jonkun muun toimesta jossain kerrottu. Ajattelin kuitenkin koota omia ajatuksia, koska voin ja haluan. Deal with it.
From today's session on Financial Modeling.
The models we build depend on the stories we want to tell and the questions we want to answer.
The most important of building the model is figuring out the question we are trying to answer.
Do that first before you start with Excel.
The models we build depend on the stories we want to tell and the questions we want to answer.
The most important of building the model is figuring out the question we are trying to answer.
Do that first before you start with Excel.
Our ability to generate scenarios for stress testing and sensitivity analysis is limited by acceptable and common ranges.
Understanding the distribution of drivers we are modeling can lead to richer and far more appropriate scenarios.
Understanding the distribution of drivers we are modeling can lead to richer and far more appropriate scenarios.
While most model builders are comfortable with putting together a balance sheet and income statement, quite a few struggle with statement of cash flows. If they can or could, they would skip it.
You can't balance your balance sheet or pass model cross checks without one.
You can't balance your balance sheet or pass model cross checks without one.
Everyday since news of #ukricuts #gcrfcuts broke another set of previously unimaginable consequences occur:-
1) end of peer review for grants - it was already on a shoogly peg but who is now going to donate labour to laborious review of proposals - including risk assessments? 😐
1) end of peer review for grants - it was already on a shoogly peg but who is now going to donate labour to laborious review of proposals - including risk assessments? 😐
2) Applications for funding - it takes two years constant work to go from idea to successful application with success rates low. To do this needs trust that if successful your work will be funded throughout (stage-gated). Right now I can’t imagine why I would EVER apply again.
3/ Partnerships. It takes years to build towards equitable partnerships in contexts of conflict & impoverishment. Some of mine are over 14 years in making. Steady, constant care. This is why they worked. Why they were funded. 1 secretive stroke of a 🇬🇧 pen and ‘poof’ - #ukricuts
