Automate File Cleanup

preview_player
Показать описание

This video shows how to use Excel to automate file cleanup tasks like deleting column, and counting and adding rows. It is a step-by-step guide for how to do this with Excel's built-in power query. Specifically:
- Power Query intro
- Change source file
- Handling file structure changes (renamed columns, new columns)

Chapters in this video:
00:00 - Introduction
00:17 - Exercise 1
02:17 - click-start
02:22 - Exercise 2
03:15 - Exercise 3

Also, check out these videos with time saving Excel Hacks:

  1. Excel University
  2. power automate desktop
  3. power automate
  4. excel
  5. microsoft excel
  6. excel tips and tricks
Рекомендации по теме
Automate File Cleanup 0:06:12

Automate File Cleanup

Automate Data Clean-up 0:09:40

Automate Data Clean-up with Power Query - Auto Format & Combine Multiple Sheets - Save Time

Automate Disk Cleanup 0:06:05

Automate Disk Cleanup using Task Scheduler

Cleanup File Clutter 0:01:00

Cleanup File Clutter Using Power Automate RPA #shorts

Automate PC Cleanup: 0:03:03

Automate PC Cleanup: Temporary File Cleaner using Batch Script

Use Outlook Archive 0:11:11

Use Outlook Archive to FREE SPACE & CLEAN UP Your Mailbox

How To Import 0:20:38

How To Import & Clean Messy Accounting Data in Excel | Use Power Query to Import SAP Data

How to Cleanup 0:10:53

How to Cleanup Your Computer - Fully Delete Temporary Files and Free Disk Space

Python Automation Projects: 0:15:13

Python Automation Projects: Automatic desktop cleanup (Part 1)

How to easily 0:17:10

How to easily automate boring Excel tasks with Power Query!

AUTOMATE Data Cleaning 0:06:09

AUTOMATE Data Cleaning with Excel Power Query

Learn Power Query 0:18:45

Learn Power Query & Automate Boring Data Tasks in 15 Minutes!

How to Clean 0:08:05

How to Clean C Drive In Windows 11 (Make Your PC Faster)

Building an Automated 0:16:51

Building an Automated File Sorter in File Explorer using Python | Python Projects for Beginners

How to Automate 0:02:23

How to Automate Windows File Cleaning (and Why You Should)

Start Automating Your 0:13:07

Start Automating Your Life Using Python! (File Management with Python Tutorial)

Automated backups cleanup 0:12:13

Automated backups cleanup in sql | sql old backups cleanup | Maintenance plans in sql

AUTOMATE Data CLEANING 0:11:53

AUTOMATE Data CLEANING using Power Query

Automate File Deletion 0:05:50

Automate File Deletion Using Python

Power Automate - 0:13:13

Power Automate - How to filter SharePoint Folders and SubFolders & Delete Files?

06.Maintenance plan for 0:03:54

06.Maintenance plan for Automated Backups and old Backup Cleanup

Python Automation Project: 0:03:08

Python Automation Project: File Organizer using Python | Codex Python

Python Automation || 0:09:57

Python Automation || file organizer || Automatic desktop cleanup || python project with source code

Delete Empty Rows 0:00:26

Delete Empty Rows with these Excel Shortcuts #shorts

Комментарии
Автор

Thanks Jeff. It's a great guidance.

trietluong
Автор

Thanks, especially for the error description and solution. Paul

PaulEBrownbill
Автор

That was a great video.
Do you know if the excel has some formula using a change the color of the text or number? For example, if you use Xlookup formula, when you bring the text or number and, in this formula, use other formula to change the color.
Thank you.

gonzuic
Автор

No need to edit a query to change the data source. In Excel go to Data -> Get Data -> Data Source Settings... and change it there.
Also to select all columns in Power Query, select one column and then hit [Ctrl]A.

jerrydellasala
Автор

What about if the file location never changes but the file is replaced by a different named file, such as one indicating the date along with a name?

bczaru