Gareth Thomas
Gareth Thomas
  • Видео 19
  • Просмотров 565 703
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
General Skills - Copy and Paste
Просмотров 10114 лет назад
General Skills - Copy and Paste

Комментарии

  • @francisjunior957
    @francisjunior957 13 часов назад

    Is there a way to do this for continuous data?

  • @rossl5908
    @rossl5908 Месяц назад

    Nonsense

  • @AfsheeNobeebux
    @AfsheeNobeebux 2 месяца назад

    You're amazing!! Thank you for sharing!!

  • @Newmoniebigella
    @Newmoniebigella 5 месяцев назад

    7 Years ago and still helpful.. I used it to write a letter and I got the job..

  • @subashicostasuraweera8594
    @subashicostasuraweera8594 6 месяцев назад

    Hi, can we do this grouping with data as well instead of numbers?

  • @Big_J
    @Big_J 7 месяцев назад

    Thanks, saved a ton of time, combining the output with pivot table&chart made it for me!

  • @donalddonegan3322
    @donalddonegan3322 11 месяцев назад

    Just found this. You, sir, are a Champion of the highest order

  • @millysanchez7137
    @millysanchez7137 Год назад

    Does this also apply to USA aswell?

  • @darleneb6661
    @darleneb6661 Год назад

    Thank you. This was very very helpful. Very detailed and to the point.

  • @alessandromonterosso94
    @alessandromonterosso94 Год назад

    This is brillant thank you ☺️

  • @Prittamvishwas
    @Prittamvishwas Год назад

    ruclips.net/video/AgD3Q8pvgOo/видео.html Simple way-Data bucketing in Excel sheet

  • @Gallienus53
    @Gallienus53 Год назад

    We don't need to see random data created. Looking to see how to group the data. Apparently one cant do it in Excel.

  • @mudasirmohammedibrahim1026
    @mudasirmohammedibrahim1026 Год назад

    thank you sire, you realled saved me

  • @jnsaudio81
    @jnsaudio81 Год назад

    List 2 generates from no where

    • @blainejb7
      @blainejb7 Год назад

      right?! i can't get mine to do that

  • @cboyda
    @cboyda Год назад

    Great examples, clear instructions, greatly appreciated, thanks for the share!

  • @dinoo82
    @dinoo82 Год назад

    wow nice! sure beats if statements. great tip!

    • @garethcthomashow
      @garethcthomashow Год назад

      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.

  • @robinmanley9946
    @robinmanley9946 Год назад

    Please do exactly this same video again but now zoom in to make it clear

  • @yamahkarim1080
    @yamahkarim1080 Год назад

    What's a good way to name those buckets? ie. 1-7 = "1 week" , 7-14 = "2 weeks", etc

  • @sedarathnadcd
    @sedarathnadcd 2 года назад

    It is simple, but work 100% . thank you

  • @EvelynRBell
    @EvelynRBell 2 года назад

    Thank you this info saved me hours of work!

  • @vaughnknight968
    @vaughnknight968 2 года назад

    Simple, quick and to the point, thanks for your help!

  • @chronicallyVirgo
    @chronicallyVirgo 2 года назад

    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!

  • @jasmine8395
    @jasmine8395 2 года назад

    Thanks Gareth

  • @a.b.o9218
    @a.b.o9218 2 года назад

    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.

  • @andrewdebona5255
    @andrewdebona5255 2 года назад

    thanks very helpful

  • @haarismo2
    @haarismo2 2 года назад

    Thank you so much!! So simple yet very useful.

  • @doddim
    @doddim 2 года назад

    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.

  • @leanar.8141
    @leanar.8141 2 года назад

    Thank you soooo much!!

  • @jeaninekolasa8113
    @jeaninekolasa8113 2 года назад

    Thankyou for the great advice!

  • @Ajit0708
    @Ajit0708 2 года назад

    Thanks Gareth

  • @varshasharma8925
    @varshasharma8925 2 года назад

    You are a life saver

  • @Jenicek25
    @Jenicek25 2 года назад

    REally helpful! I knew it could be done somehow, but forgot how. Thanks for reminding me!

  • @tomdiehl9081
    @tomdiehl9081 2 года назад

    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.

  • @davinci6101
    @davinci6101 2 года назад

    Thanks!

  • @johnhrzn1501
    @johnhrzn1501 2 года назад

    Can you make a video for Macintosh systems? PC is totally different.

    • @garethcthomashow
      @garethcthomashow 2 года назад

      Really sorry but I don't have a Mac. Hopefully someone else will be able to do this for us. Any takers out there?

  • @KevinLongUSA
    @KevinLongUSA 2 года назад

    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.

    • @KevinThurman
      @KevinThurman 2 года назад

      Totally agree. Tables and their filters are a fundamental necessity for customized views, why are the two functions not compatible??

  • @havidztoo7979
    @havidztoo7979 3 года назад

    Awesome, exactly what I was looking for, thanks so much

  • @tommytton-mills9616
    @tommytton-mills9616 3 года назад

    Thankyou, cracking video and very clear and easy to follow.

  • @dorisman2893
    @dorisman2893 3 года назад

    Great information

  • @shrutilohani
    @shrutilohani 3 года назад

    Thanks it was really helpful

  • @wanabble3
    @wanabble3 3 года назад

    Thank you Thank you 🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻❤️❤️❤️❤️

  • @basavarajs3525
    @basavarajs3525 3 года назад

    Really great video very good understanding concepts and explained in a very simple way love it.. 😎

  • @Nadiapm2001
    @Nadiapm2001 3 года назад

    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!

    • @garethcthomashow
      @garethcthomashow 2 года назад

      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.

  • @dsjtravels
    @dsjtravels 3 года назад

    thanks so much!!

  • @kopanothantsha4707
    @kopanothantsha4707 3 года назад

    Good video, but try improving, your screen is far and bit blurry and we miss some of the stuff

    • @garethcthomashow
      @garethcthomashow 2 года назад

      Thanks for the feedback. I'm still a work in progress :-)

  • @elton340
    @elton340 3 года назад

    This is great stuff, would appreciate if you or anyone could share how to extract an embeded pdf from a word document. Thanks.

  • @pauldadzie6991
    @pauldadzie6991 3 года назад

    Yeeeess, thank you so much.

  • @shubhammalhotra2868
    @shubhammalhotra2868 3 года назад

    Thanks a lot man. This reduced my time by at least 80%.

  • @b.nicole7633
    @b.nicole7633 3 года назад

    Wow! Thank you so much.

  • @jaidenoutofcontext7290
    @jaidenoutofcontext7290 3 года назад

    Thanks man it really helped with my homework I owe you one respect