![Gareth Thomas](/img/default-banner.jpg)
- Видео 19
- Просмотров 565 703
Gareth Thomas
Великобритания
Добавлен 27 сен 2006
Excel Video Gotcha Tables and Custom Views
In this video I will show you an Excel 'gotcha' and show you how to fix it. The gotcha is that you can't use custom views when there are tables in the workbook which is a pity when you're filtering large data sets constantly and then clearing the filters.
Просмотров: 791
Видео
Excel Video Using Pivot Tables to Compare Two Lists
Просмотров 28 тыс.5 лет назад
How to use Excel pivot tables to compare data in two lists and find the differences between the lists.
How to group data in Excel into buckets or groupings
Просмотров 165 тыс.5 лет назад
How to group data into buckets or groupings for convenient filtering and data analysis.
VBA Excel Request for Help to Compare Lists
Просмотров 1606 лет назад
Can any Excel VBA experts help me to create a quick and easy piece of code to compare two lists and insert a blank cell when I find a duplicate?
How to Enter Text in Cell and Make Changes Across Multiple Worksheets
Просмотров 1277 лет назад
Two cool tricks for Excel (2010 or 2013). How to Enter Text in Cell and Make Changes Across Multiple Worksheets.
How to Create a DropDown List in Excel 2013 or Excel 2010
Просмотров 717 лет назад
How to Create a DropDown List in Excel 2013 or Excel 2010
How to link to a specific document stored in a shared drive using a hyperlink when sending an email
Просмотров 107 тыс.7 лет назад
How to link to a specific document stored in a shared drive using a hyperlink when sending an email from Outlook 2010 or 2013
How to embed a Word document or pdf into a Word document 2010
Просмотров 30 тыс.7 лет назад
Short video showing how to embed a Word document or pdf into a Word document 2010
English with Gareth - There their and theyre
Просмотров 457 лет назад
English grammar with Gareth! There, their and they're. What's the difference. This short video will explain.
How To Write A Formal Letter In English Using Microsoft Word 2013
Просмотров 29 тыс.7 лет назад
How To Write A Formal Letter In English Using Microsoft Word 2013 If you want to write a formal letter or a personal letter using Microsoft Word 2013 then this video will show you how I lay out the letter using the software and a bit about why you begin "Dear John," and always end with "Yours sincerely," as this is something many people get wrong. Don't you be that person.
5. How to create the credits analysis sheet
Просмотров 9 тыс.13 лет назад
www.magicmoneytips.com YOU HAVE FULL RIGHTS TO SHARE THIS VIDEO ON TWITTER, ON YOUR BLOG ETC. This video continues with the creation of the credit analysis part of the overall bank account/cash account analysis spreadsheet. If you like this training you have my express permission to Tweet the link or embed the video in your blog/website.
4. Creating Accounts Template Analysis - Credits
Просмотров 32013 лет назад
This video links from the previous video and explains how to build the credit analysis part of the sheet and how it is connected to the Accounts Template required by the District Treasurer. If you like this training you have my express permission to Tweet the link or embed the video in your blog/website.
3. How to create a bank account tracking system
Просмотров 11 тыс.13 лет назад
How to create a spreadsheet that tracks all of your income and expenditure and makes it easy to analyse the same and pull together your group accounts at the end of your financial year. If you like this training you have my express permission to Tweet the link or embed the video in your blog/website.
2. How to Open a New Spreadsheet
Просмотров 6 тыс.13 лет назад
How to open a new spreadsheet and begin creating a scout group accounting analysis sheet for the monthly and annual group accounts. If you like this training you have my express permission to Tweet the link or embed the video in your blog/website.
1. How to get an Excel equivalent programme for FREE (NOT Excel)
Просмотров 178 тыс.13 лет назад
31/10/2016 UPDATE!! I just want to set the record straight and explain that this very old video that I made over 6 years ago is about how to get a spreadsheet that looks and feels a bit like Excel and it's FREE. Some of the comments have called me a liar and that it's not Excel...I agree it's not Excel and I should've said from the outset that it's LIKE Excel in the main...but I NEVER set out t...
Admin 1 - Gift Aid - How to Register Your Group
Просмотров 41313 лет назад
Admin 1 - Gift Aid - How to Register Your Group
Admin 2 - Choosing an Accounting Period for your group
Просмотров 18713 лет назад
Admin 2 - Choosing an Accounting Period for your group
4. East London Scouts: Intro to Bank and Cash Account Analysis
Просмотров 15613 лет назад
4. East London Scouts: Intro to Bank and Cash Account Analysis
Is there a way to do this for continuous data?
Nonsense
You're amazing!! Thank you for sharing!!
7 Years ago and still helpful.. I used it to write a letter and I got the job..
Hi, can we do this grouping with data as well instead of numbers?
Thanks, saved a ton of time, combining the output with pivot table&chart made it for me!
Just found this. You, sir, are a Champion of the highest order
Does this also apply to USA aswell?
Thank you. This was very very helpful. Very detailed and to the point.
This is brillant thank you ☺️
ruclips.net/video/AgD3Q8pvgOo/видео.html Simple way-Data bucketing in Excel sheet
We don't need to see random data created. Looking to see how to group the data. Apparently one cant do it in Excel.
thank you sire, you realled saved me
List 2 generates from no where
right?! i can't get mine to do that
Great examples, clear instructions, greatly appreciated, thanks for the share!
wow nice! sure beats if statements. great tip!
There's probably easier or better ways to do it but I came felt this way was easier for me to understand. Not saying it's the best way though...cleverer people than I out there.
Please do exactly this same video again but now zoom in to make it clear
What's a good way to name those buckets? ie. 1-7 = "1 week" , 7-14 = "2 weeks", etc
It is simple, but work 100% . thank you
Thank you this info saved me hours of work!
Simple, quick and to the point, thanks for your help!
You're welcome!
This finally helped me. I've been searching for a solution for the past 2 hours and nothing worked. This worked wonderfully. Thank you so much!
Glad it helped!
Thanks Gareth
Thanks 😊 I need your kind assistance regarding that I wanna make the hyperlink on outlook open with multiple users at the same time, as I made hyperlink once you press on it will open new mail with a template however if someone already opened the other users can't open it at the same time, I hope to find solution for this.
thanks very helpful
No worries!
Thank you so much!! So simple yet very useful.
Glad it was helpful!
Hi, thanks for this video. I have a problem. I play golf and the handicap is very different between players. How can I group all players into groups so each group has the same avarege handicap? There are four players in a group maximum, but if thera are 19 players I have to group them 4+4+4+4+3 Regards from Iceland.
Thank you soooo much!!
Glad it helped!
Thankyou for the great advice!
You're so welcome!
Thanks Gareth
You're very welcome Ajit.
You are a life saver
Glad it helped you.
REally helpful! I knew it could be done somehow, but forgot how. Thanks for reminding me!
Any time!
How do i create the groupings for a range of %s that include negatives? For example a range of -5% to -10%. Excel is giving me a False when I try to do this.
Thanks!
Welcome!
Can you make a video for Macintosh systems? PC is totally different.
Really sorry but I don't have a Mac. Hopefully someone else will be able to do this for us. Any takers out there?
Thanks, but this doesn't solve the fundamental problem that Excel wants you to use tables, and doing so removes the view function. There is no saved view function any more, and it's ridiculous.
Totally agree. Tables and their filters are a fundamental necessity for customized views, why are the two functions not compatible??
Awesome, exactly what I was looking for, thanks so much
You're welcome!
Thankyou, cracking video and very clear and easy to follow.
Great information
Glad it was helpful!
Thanks it was really helpful
Thank you Thank you 🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻❤️❤️❤️❤️
You are so welcome
Really great video very good understanding concepts and explained in a very simple way love it.. 😎
Glad you liked it!
Hi Gareth, thank you so much! I was racking my brains trying to remember how to do this after a colleague showed me months ago, and then I found your video! Great job and thanks!
You're very welcome. The reason I make some videos occasionally is as a reminder to myself too! We can forget so much if we don't use it on a regular basis.
thanks so much!!
Good video, but try improving, your screen is far and bit blurry and we miss some of the stuff
Thanks for the feedback. I'm still a work in progress :-)
This is great stuff, would appreciate if you or anyone could share how to extract an embeded pdf from a word document. Thanks.
Yeeeess, thank you so much.
You're welcome!
Thanks a lot man. This reduced my time by at least 80%.
That's really cool. Well done.
Wow! Thank you so much.
Thanks man it really helped with my homework I owe you one respect
Glad it helped