Chester Tugwell
Chester Tugwell
  • 914
  • 46 432 380
How to Delete Temporary and Cached Files In Windows | Delete Junk Files in Windows
In this Microsoft Windows tutorial I demonstrate how to delete temporary and cached files.
🕰️Timestamps
00:00 Introduction
00:06 Empty the Prefetch folder
00:40 Empty the Temp folder
01:24 Empty %temp%
02:03 Use the Disk Clean-up utlility
03:07 Empty the SoftwareDistribution folder
03:46 Delete File Explorer history
03:54 Delete Microsoft Store files
04:31 Flush DNS cache
04:55 Use Storage Sense
06:01 Delete browser cache
#windowstutorials #windowstips #windowstipsandtricks
Переглядів: 253

Відео

FREE Google Forms QR Code Generator
Переглядів 31111 годин тому
In this Google Forms video tutorial I explain how to create a free QR code for your Google form. Use this link to access the free QR generator on adobe.com: www.adobe.com/express/feature/image/qr-code-generator #googleformstutorial #qrcode
How to Create a Fillable Form in Google Docs
Переглядів 22121 годину тому
In this Google Docs video tutorial I explain how to make a fillable form in Google Docs including text fields where you can type on a line, text boxes, drop-downs and checkboxes. 🕰️ Timestamps 00:00 Introduction 00:28 Add a graphic and title to the form 01:28 Create fillable short text fields - type on a line 04:15 Create drop-downs and checkboxes 07:35 Create fillable text boxes #googledocstut...
Google Forms - Make a Multiple-Choice Grid and a Tick Box Grid
Переглядів 15523 години тому
In this Google Forms video tutorial, I explain how to make a multiple-choice grid and a tick box grid. 🕰️ Timestamps 0:00 Introduction 0:25 Create a multiple-choice grid 3:18 Create a tick box grid #googleformstutorial #googleformtutorial
How to Make a Google Form - Complete Tutorial
Переглядів 212День тому
In this video tutorial, I explain how to create a Google Form 🕰️ Timestamps 00:00 Create a new form 00:22 Give the form a title and filename 00:52 Create short answer questions 01:22 Create a date question 01:44 Create an upload file question 02:20 Create a multiple-choice question 02:56 Create a checkboxes question 03:37 Create a linear scale question 04:08 Create a drop-down question 04:38 Ad...
How to Automatically Sort Data in Google Sheets | Sort as You Type
Переглядів 35614 днів тому
In this Google Sheets video tutorial explain how to automatically sort data as you type. This solution requires an App Script which is available here: bluepecantraining.co.uk/how-to-automatically-sort-data-in-google-sheets/ #googlesheets #googlesheetstips #googlesheetstutorial
📅Google Sheets Calendar DATE PICKER - A Quick Way of Entering Dates in Google Sheets
Переглядів 30214 днів тому
In the Google Sheets video tutorial, I demonstrate two methods for creating a date picker that automatically appears in cells that need to contain dates. #googlesheets #googlesheetstutorial #googlesheetstips
Excel FILTER Function Across Multiple Worksheets
Переглядів 93921 день тому
Download the featured file here: bluepecantraining.co.uk/excels-filter-function-filter-across-multiple-worksheets/ In this Microsoft Excel video tutorial I explain how to use the FILTER function to apply the same filter across multiple worksheets. This can be achieved using the VSTACK function. Blue Pecan Computer Training Ltd offers on-site or online Excel training for businesses. Training can...
Excel FILTER Function Top or Bottom n Values With Criteria
Переглядів 64721 день тому
Download the featured file here: www.bluepecantraining.com/wp-content/uploads/2024/06/Top-N-Values.xlsx Blue Pecan Computer Training Ltd offers on-site or online Excel training for businesses. Training can be delivered at your business premises in the south-east of England or via Teams wherever you are in the world. Visit our training page at www.bluepecan.co.uk In this Microsoft Excel video tu...
Excel FILTER Function - Case-Sensitive Filter | How to Perform a Case-Sensitive Filter in Excel
Переглядів 62421 день тому
Click here to download the featured file: www.bluepecantraining.com/wp-content/uploads/2024/05/Case-Sensitive.xlsx In this Microsoft Excel video tutorial I explain how to perform a case-sensitive filter using the FILTER function. Blue Pecan Computer Training Ltd offers on-site or online Excel training for businesses. Training can be delivered at your business premises in the south-east of Engla...
Excel FILTER Function - Return Duplicates / Identify Duplicates Across Two Columns Using Formula
Переглядів 69228 днів тому
Download the featured file here: www.bluepecantraining.com/wp-content/uploads/2024/05/Return-Duplicates.xlsx In this Microsoft Excel video tutorial I explain how to return or identify duplicates using the FILTER function. In the example used in the video I identify duplicate rows where the combination of values in two columns is duplicated. The same method can be used where are 3, 4, 5 (or more...
Excel PivotTable Calculated Fields | How to Multiply or Divide Columns | Data Model -SUMX & AVERAGEX
Переглядів 577Місяць тому
Download the featured file here:www.bluepecantraining.com/wp-content/uploads/2024/06/Calculated-Fields.xlsx In this Microsoft Excel video tutorial I explain how to use calculated fields in a PivotTable. More specifically I demonstrate how to perform calculations on two or more columns. This is fairly straightforward if you're adding or subtracting, but not so simple if you are multiplying or di...
Excel FILTER Function: Sort on Multiple Columns | FILTER & SORT Together
Переглядів 634Місяць тому
Download the featured file here: www.bluepecantraining.com/wp-content/uploads/2024/05/Sort-on-Multiple-Columns.xlsx In this Microsoft Excel video tutorial I explain how use the FILTER and SORT functions together and how to use the SORT function to sort on multiple columns. #exceltricks #exceltips #exceltutorial
Excel FILTER Function | Non Adjacent Columns | Return Specific Columns & Reorder Columns
Переглядів 577Місяць тому
Download the featured file here:www.bluepecantraining.com/wp-content/uploads/2024/05/Non-adjacent-columns.xlsx In this Microsoft Excel video tutorial I explain how to use the CHOOSECOLS function to return non-adjacent columns when using the FILTER function. I also demonstrate how to reorder columns.
Excel FILTER Function with WILDCARD Criteria: Partial Match, Contains, Begins With, Ends With
Переглядів 791Місяць тому
Download the featured file here: www.bluepecantraining.com/wp-content/uploads/2024/05/Wildcard-Criteria.xlsx In this Microsoft Excel video tutorial I explain how to use wildcard criteria with the FILTER function. 🕰️ Timestamps 00:00 Introduction 00:41 Contains criteria 02:54 Begins with criteria 04:47 Ends with with criteria 05:43 Characters in a specified position criteria #exceltricks #excelt...
Excel FILTER Function Multiple Criteria | AND OR Criteria
Переглядів 1 тис.Місяць тому
Excel FILTER Function Multiple Criteria | AND OR Criteria
How to Create an Index in Word
Переглядів 581Місяць тому
How to Create an Index in Word
Relative Frequency Table in Excel | How to Calculate Relative Frequency in Microsoft Excel
Переглядів 469Місяць тому
Relative Frequency Table in Excel | How to Calculate Relative Frequency in Microsoft Excel
Cumulative Frequency Formula in Excel | Create a Cumulative Frequency Distribution Table
Переглядів 805Місяць тому
Cumulative Frequency Formula in Excel | Create a Cumulative Frequency Distribution Table
Cumulative Percentage Formula in Excel | Cumulative Percentage Calculator Example
Переглядів 1,3 тис.Місяць тому
Cumulative Percentage Formula in Excel | Cumulative Percentage Calculator Example
How to Delete Multiple Rows or Columns Based on Criteria
Переглядів 1 тис.Місяць тому
How to Delete Multiple Rows or Columns Based on Criteria
How to Create a Checklist in Excel | Interactive Checklist Template with Checkboxes
Переглядів 2,3 тис.Місяць тому
How to Create a Checklist in Excel | Interactive Checklist Template with Checkboxes
How to Remove the Background From an Image for Free | With Offline App and Online App
Переглядів 3772 місяці тому
How to Remove the Background From an Image for Free | With Offline App and Online App
How to Quickly Check Your Windows Version | How to Copy Windows Version Info to Clipboard
Переглядів 3212 місяці тому
How to Quickly Check Your Windows Version | How to Copy Windows Version Info to Clipboard
Remove Microsoft Account from Windows 11 | Create Local Account
Переглядів 1,7 тис.2 місяці тому
Remove Microsoft Account from Windows 11 | Create Local Account
How to Perform a MEDIANIFS Calculation in Excel with One or More Criteria - 3 Methods 🔥
Переглядів 5632 місяці тому
How to Perform a MEDIANIFS Calculation in Excel with One or More Criteria - 3 Methods 🔥
Easily Recover Deleted files from a USB, Pen Drive, Memory / SD Card Using a FREE Microsoft App
Переглядів 3472 місяці тому
Easily Recover Deleted files from a USB, Pen Drive, Memory / SD Card Using a FREE Microsoft App
Windows - Boot in Safe Mode and How to Exit Safe Mode
Переглядів 2482 місяці тому
Windows - Boot in Safe Mode and How to Exit Safe Mode
AVERAGEIFS Function Excel | Single or Multiple Criteria | AVERAGEIFS Between Two Dates
Переглядів 6512 місяці тому
AVERAGEIFS Function Excel | Single or Multiple Criteria | AVERAGEIFS Between Two Dates
How to Include Headings that Appear Before the Table of Contents in the Table of Contents
Переглядів 3352 місяці тому
How to Include Headings that Appear Before the Table of Contents in the Table of Contents

КОМЕНТАРІ

  • @puzzlingbubbles
    @puzzlingbubbles 6 годин тому

    wow i cant believe it was that easy. thanks a lot!

  • @solarwinds-
    @solarwinds- 11 годин тому

    I found a 5th reason why your formulas are not calculating. If the formulas do not match they will give a return of zero. I had =8.34*11 in cell i3 and =[@[July Due]]+17 in i3. I changed cell i3 to =17*2 and it gave the correct sum of 914.08

  • @LilYoda66
    @LilYoda66 15 годин тому

    Thank you so much! It helped a lot :)

  • @patienceifeoma4153
    @patienceifeoma4153 17 годин тому

    Thanks sir

  • @thuthukaniclive6056
    @thuthukaniclive6056 18 годин тому

    Worked for me

  • @sowrayouil8606
    @sowrayouil8606 18 годин тому

    Legend thanks for the help

  • @iamfrizia
    @iamfrizia 19 годин тому

    can this be done in power bi?

  • @barryfox4577
    @barryfox4577 22 години тому

    Worked an absolute treat and saved hours of frustration - thanks ever so much!

  • @elizabethphellemon1581
    @elizabethphellemon1581 22 години тому

    Came on UA-cam to search for just this, and your video popped up, less than 2 minutes I got what came here for with a clear understanding. Thank you so much.

  • @Zenin_Toji95
    @Zenin_Toji95 День тому

    Bro there is no mice and pointing devices option in my device manager

  • @prabodanijayawansa5049
    @prabodanijayawansa5049 День тому

    Thank you❤

  • @robmcdiarmid
    @robmcdiarmid День тому

    The fix for manual row height setting (problem #2) should not be to manually set it again. You should go to Table Properties > Row Tab > Next Row (until you get to the messed up one) and clear the specified height from that specific row. That way you're not perpetuating the problem by manually setting it again. The rest of these are very helpful.

  • @Trishafuninthesun11
    @Trishafuninthesun11 День тому

    Great video. Can you show us how to delete a chart? I can't find any YT videos on this for Excel 11.

  • @niazkathick1050
    @niazkathick1050 День тому

    Thank you❤

  • @trashbandido5360
    @trashbandido5360 День тому

    Oh god bless you. You are king

  • @CRICKETLOVERS-qv1vg
    @CRICKETLOVERS-qv1vg 2 дні тому

    Thank you very Much for this idea.

  • @princejoe290
    @princejoe290 2 дні тому

    good video, it gives me idea. But what I want to understand is how to get the last sale of the specific person. e.g. Bob.

  • @Suganthkumarfak27
    @Suganthkumarfak27 2 дні тому

    Kindly share me if you have any links to perform the same with multiple sheets. Say we have Demo1, Demo2 and Demo3 Sheets

  • @dushanshalina4676
    @dushanshalina4676 2 дні тому

    It’s getting blank cells with conditions as the last row. How can I correct it?

  • @BettyO-777
    @BettyO-777 2 дні тому

    Superb, you have made my day:)

  • @MANODOPAOyPR
    @MANODOPAOyPR 2 дні тому

    wow man it is a good vidio, you help me, thanks

  • @KarthikUpadhyaya
    @KarthikUpadhyaya 2 дні тому

    Great video, thank you so much sir

  • @sdwxrld6024
    @sdwxrld6024 2 дні тому

    Clear formatting Remove all character formats from the text in Wordpad and then leaving out the empty character text.

  • @silviopoggi8193
    @silviopoggi8193 2 дні тому

    As always, vey helpful. Thank You!

  • @vishalkuche572
    @vishalkuche572 2 дні тому

    Very useful 👍🏻

  • @jayshreekulkarni3974
    @jayshreekulkarni3974 2 дні тому

    Great!!! i got the solution , explained in very simple manner. Thank you.

  • @raisinmydog
    @raisinmydog 3 дні тому

    Selecting the character turn and reducing font size did the trick. Thank you!

  • @blackerblue8337
    @blackerblue8337 3 дні тому

    YOUR AMAZING

  • @pavolbar
    @pavolbar 3 дні тому

    good stuff mate, thanks, id did solved my issue with a huge document

  • @fizzl3sah
    @fizzl3sah 3 дні тому

    What if i want to recover files that was in the desktop?

  • @eronvalle924
    @eronvalle924 3 дні тому

    For path insert what did you Copy and Paste ?

  • @RealThrillMedia
    @RealThrillMedia 3 дні тому

    Worked great!! Thank you

  • @yoklug
    @yoklug 3 дні тому

    thanks a lot

  • @UnknownChannel88889
    @UnknownChannel88889 3 дні тому

    What if you want it to be based on a specific cell value thats not a number.

  • @nezmaf
    @nezmaf 3 дні тому

    Looking forward even to meeting you if you ever came to Dubai

  • @nezmaf
    @nezmaf 3 дні тому

    This tutorial video was one of the best. Explaining well, and clearly, all details are said nothing is ignored. Tune of voice and speed etc. Why not everyone around the world is not following this guy? well-educated person

  • @sudhakarooty8288
    @sudhakarooty8288 3 дні тому

    Absolutely beautiful..sir

  • @kulwindersingh-ju4br
    @kulwindersingh-ju4br 3 дні тому

    you are ownsome sir , the best i make a cross on this , my problem is resolved now ..

  • @Grizzler231
    @Grizzler231 3 дні тому

    Thank You Good Sir!

  • @antonelloguadambino7974
    @antonelloguadambino7974 3 дні тому

    Thanks

  • @febriamel9040
    @febriamel9040 4 дні тому

    Mr.. How about 4 last sales?

  • @chrisoleson9570
    @chrisoleson9570 4 дні тому

    Swive me, I'm confused after trying to follow this.

  • @catsare2cute943
    @catsare2cute943 4 дні тому

    Thanks 🙏🏼

  • @ken-sy4tp
    @ken-sy4tp 4 дні тому

    When i type in A or H it tells me “you can only enter A for absent, p for present & h for holiday on a working day. This is the only part I’m having trouble with

  • @dileepmatcha8594
    @dileepmatcha8594 4 дні тому

    Thank you

  • @ananthavishnumheman3067
    @ananthavishnumheman3067 4 дні тому

    Thanks a lot 🎉

  • @user-js4yw4er4z
    @user-js4yw4er4z 4 дні тому

    Thank you very much

  • @fu2201
    @fu2201 4 дні тому

    Perfect Thanks

  • @paulgriffith6401
    @paulgriffith6401 4 дні тому

    Brilliant and very well explained

  • @rioaltha7837
    @rioaltha7837 4 дні тому

    Oh come on it's helpful thankyou so much sir 🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻 hope you always healthy and happy 🤝🏻🤝🏻🤝🏻