- 48
- 73 581
The Outlier
Приєднався 6 вер 2017
📈 Data from & for Africa
📊 Master data visualisation with our expert-led training
📰 Free newsletter
📊 Master data visualisation with our expert-led training
📰 Free newsletter
Conditional formatting in Excel
Learn conditional formatting in just 4 minutes and make the patterns in your dataset stand out.
📰 Sign up for our FREE newsletter: theoutlier.co.za/newsletter/yt
📊 Master data visualisation with our expert-led training: datastorytelling.theoutlier.co.za/
#spreadsheettips #training #exceltricks #500subs #follow #dataviz #visualisation
📰 Sign up for our FREE newsletter: theoutlier.co.za/newsletter/yt
📊 Master data visualisation with our expert-led training: datastorytelling.theoutlier.co.za/
#spreadsheettips #training #exceltricks #500subs #follow #dataviz #visualisation
Переглядів: 52
Відео
3 ways to remove empty rows in Excel
Переглядів 42721 день тому
Discover 3 simple ways to remove empty rows in Excel and keep your spreadsheets neat and organised! Ideal for all skill levels. 📰 Sign up for our FREE newsletter: theoutlier.co.za/newsletter/yt 📊 Master data visualisation with our expert-led training: datastorytelling.theoutlier.co.za/ #spreadsheettips #training #exceltricks #500subs #follow #dataviz #visualisation
The Outlier: Our year in review
Переглядів 38Місяць тому
🎉 A year of data storytelling, impactful visuals and milestones! 🚀 From award-winning projects to training sessions, here’s a snapshot of The Outlier’s 2024 highlights. #yearinreview 📰 Sign up for our FREE newsletter: theoutlier.co.za/newsletter/yt 📊 Master data visualisation with our expert-led training: datastorytelling.theoutlier.co.za/ #datastorytelling #TheOutlier #training #500subs #2024 ...
Quick tips to clean Excel data
Переглядів 710Місяць тому
In this video, we walk you through essential tips and tricks for cleaning up a dataset in Excel. Key takeaways: - Always start your data in cell A1 - Bold the first row for clarity - Freeze the first row to simplify working with large datasets We also demonstrate using functions like TRIM and PROPER to tidy up the data. 📰 Sign up for our FREE newsletter: theoutlier.co.za/newsletter/yt 📊 Master ...
OpenRefine Part 3: Clustering and editing
Переглядів 912 місяці тому
In the third video of our OpenRefine series, Gemma Gatticchi from The Outlier explores the clustering and editing tool. 📰 Sign up for our FREE newsletter: theoutlier.co.za/newsletter/yt 📊 Master data visualisation with our expert-led training: datastorytelling.theoutlier.co.za/ #spreadsheettips #training #exceltricks #500subs #follow #dataviz #visualisation
OpenRefine Part 2: Removing duplicates and version history
Переглядів 1042 місяці тому
In the second video in our OpenRefine series, Gemma Gatticchi from The Outlier explores the version history tool, showing you how to undo mistakes with ease. She also demonstrates how to spot and remove duplicate data entries quickly. 📰 Sign up for our FREE newsletter: theoutlier.co.za/newsletter/yt 📊 Master data visualisation with our expert-led training: datastorytelling.theoutlier.co.za/ #sp...
OpenRefine Part 1: Downloading OpenRefine and merging datasets
Переглядів 1612 місяці тому
Kickstarting our OpenRefine series, Gemma Gatticchi from The Outlier guides you through downloading OpenRefine and combining multiple files into a single dataset. 📰 Sign up for our FREE newsletter: theoutlier.co.za/newsletter/yt 📊 Master data visualisation with our expert-led training: datastorytelling.theoutlier.co.za/ #spreadsheettips #training #exceltricks #500subs #follow #dataviz #visualis...
Build an Excel Christmas budget
Переглядів 3322 місяці тому
The holiday season is here and so are the expenses! Learn how to create a simple and effective Christmas budget using Excel. Want to download the FREE template? Click here: www.theoutlier.co.za/how-to/2024-11-18/89705/free-excel-template-keeping-track-of-christmas 📰 Sign up for our FREE newsletter: theoutlier.co.za/newsletter/yt 📊 Master data visualisation with our expert-led training: datastor...
Create a free AI dashboard in seconds
Переглядів 2432 місяці тому
Looking for an easier way to create data visualisations? Check out how to use Claude.ai for quick, insightful dashboards that bring your data to life! If you like this video please remember to subscribe! 📰 Sign up for our FREE newsletter: theoutlier.co.za/newsletter/yt 📊 Master data visualisation with our expert-led training: datastorytelling.theoutlier.co.za/ #spreadsheettips #training #excelt...
Making a power outage calendar in Excel
Переглядів 2022 місяці тому
Based on the idea of the Outlier's loadshedding calendar, a simple way to make a similar calendar in Excel.
Quick Excel Trick: Linking check boxes and progress bars
Переглядів 1043 місяці тому
In under 3 minutes, discover how to add checkboxes in #Excel and link them to a progress bar to keep track of tasks with ease! 📰 Sign up for our FREE newsletter: theoutlier.co.za/newsletter/yt 📊 Master data visualisation with our expert-led training: datastorytelling.theoutlier.co.za/ #spreadsheettips #training #exceltricks #500subs #follow
Stripe chart | Supercharging Excel Data Visualisations
Переглядів 733 місяці тому
In this video, we work through how to create stripe charts. These are thin, vertical coloured lines that display data over time. 📰 Sign up for our FREE newsletter: theoutlier.co.za/newsletter/yt 📊 Master data visualisation with our expert-led training: datastorytelling.theoutlier.co.za/ #spreadsheettips #training #exceltricks #500subs #follow
Heat map | Supercharging Excel Data Visualisations
Переглядів 2773 місяці тому
In this video, we discuss how to create heat maps. These are colour-coded grids or cells that represent intensity and patterns over time.
Sparkline charts | Supercharging Excel Data Visualisations
Переглядів 693 місяці тому
Sparkline charts | Supercharging Excel Data Visualisations
Intro to basic spreadsheets: cleaning, sorting and simple calculations
Переглядів 1424 місяці тому
Intro to basic spreadsheets: cleaning, sorting and simple calculations
How to combine content from multiple cells in Google Sheets
Переглядів 2,8 тис.Рік тому
How to combine content from multiple cells in Google Sheets
How to add up data with the SUM formula in Google Sheets
Переглядів 6912 роки тому
How to add up data with the SUM formula in Google Sheets
How to import data into Google Sheets
Переглядів 1,3 тис.2 роки тому
How to import data into Google Sheets
#3 How to format data in Google Sheets
Переглядів 1932 роки тому
#3 How to format data in Google Sheets
#2 How to insert and hide columns and rows in Google Sheets
Переглядів 1782 роки тому
#2 How to insert and hide columns and rows in Google Sheets
#1 How to freeze panes in Google Sheets
Переглядів 2872 роки тому
#1 How to freeze panes in Google Sheets
MHC spoke to Daneel Knotze about investigative journalism & accountability
Переглядів 822 роки тому
MHC spoke to Daneel Knotze about investigative journalism & accountability
Patricia Andago on data in the journalism space
Переглядів 772 роки тому
Patricia Andago on data in the journalism space
Adam Oxford on the importance of data literacy in journalism
Переглядів 442 роки тому
Adam Oxford on the importance of data literacy in journalism
what if it's more than two values?
Wow could you please make more videos on that. And, I want to ask you a question how to avoid from cleaning the data for the second time. For example, now you have done all of these cleaning and made different things, such as; removing duplicates...etc. For the second time, I want to apply the same thing, so I need a short way in Openrefine to apply the same things I have done before in one click.
Very good presentation although I would have formatted the numbers properly.
This explains things very clearly. Looking forward to the next installment.
Glad you enjoyed it, Anne!
thanks
It's a pleasure! You can subscribe to our free newsletter for more tips and tricks: theoutlier.co.za/newsletter/yt
Oh ! So the Guptas were also busy with other countries Mr president you forget that we only have this problem because of Mr Zuma the Guptas and corruption Don't you know Pravin Gordon said that the people have got to eat a little bit .....like the rest of the country , it is broken because of greed ....😢😢
Scholastica feels data collection has a role in journalism 👍
that filters rows NOT columns. clickbait!
So helpful!
Why is the Copy to Clipboard option greyd out? It the same to me and I could really use it!
Hi, In tabula, A) is it possible to get page number from which we got dataframe B) read one page at a time Thanks in advance
Hi, In tabula, Is it possible to get page number from which we got dataframe Thanks in advance
ТЫ БЕЗМАМНЫЙ
ТЫ БЕЗМАМНЫЙ
ТЫ БЕЗМАМНЫЙ
Hi how to indicate a especific geo location to pull it off, like query LOCAL supermermarket and not one closest to server?
I've downloaded Tabua in order to single out a particular page or more IN THE SAME FORM THAT IS IN THE ORIGINAL PDF FILE (with pics and colors, not only tablets). How should I do this?
Great tutorial. Really shows how powerful sheets is. Do you know how to get 1 piece of data from a table into sheets? For instance, in your example, if you only wanted to import population density from g13?
My PDF is 16 pages, only 5 of which I want to use, and has been at "Waiting to be processed..." for 40 minutes. In the console window, it had a few warnings, but it doesn't show anywhere that it is stopped. 2020-05-10 09:04:11.452:INFO:oejsh.ContextHandler:main: Started o.e.j.w.WebAppContext@2ff5659e{/,file:/C:/Users/USERNAME/AppData/Local/Temp/jetty-0.0.0.0-8080-tabula.jar-_-any-6505886263116367752.dir/webapp/,AVAILABLE}{file:/F:/Programs/Tabula/tabula/tabula.jar} 2020-05-10 09:04:11.452:WARN:oejsh.RequestLogHandler:main: !RequestLog 2020-05-10 09:04:11.483:INFO:oejs.ServerConnector:main: Started ServerConnector@4b85edeb{HTTP/1.1}{0.0.0.0:8080} 2020-05-10 09:04:11.483:INFO:oejs.Server:main: Started @24361ms May 10, 2020 9:06:07 AM org.apache.pdfbox.pdmodel.font.FileSystemFontProvider loadDiskCache WARNING: New fonts found, font cache will be re-built May 10, 2020 9:06:07 AM org.apache.pdfbox.pdmodel.font.FileSystemFontProvider <init> WARNING: Building on-disk font cache, this may take a while May 10, 2020 9:06:10 AM org.apache.pdfbox.pdmodel.font.FileSystemFontProvider <init> WARNING: Finished building on-disk font cache, found 215 fonts
Ah, I opened a new browser window, typed in the IP address, and it shows my document in the new window... the original window still shows the same status. So, I'm good for now. (NOTE: I usually fix my problems within a minute after posting online about it. LOL)
Hi. Thank you for your explanation. How can you get a single value (not a list or a table) from a web page into GSheets?
How to turn chinese
Which programing language is usein this software??
java
EXCELLENT ! THANK YOU SIR
It's a pleasure! Sign up for our FREE newsletter for more tips and tricks: theoutlier.co.za/newsletter/yt
What if the PDF is a flattened Application Form with complex fields such as Checkboxes, Radio Buttons, Drop-Down Lists, Date Fields ...etc. Will this work?
Excelente software!!! Me gustó mucho!!!
It's a pleasure! Sign up for our FREE newsletter for more tips and tricks: theoutlier.co.za/newsletter/yt
Thank you !
It's a pleasure! Sign up for our FREE newsletter for more tips and tricks: theoutlier.co.za/newsletter/yt