We All Need to Do It (But, Generally Don’t)

Image for post
Image for post
FileDateCorrector — Must Have Utility for Cleaning Files

The Problem

Solving the Problem


Coming to Microsoft 365 (I Hope) Soon!

Image for post
Image for post


Part 2 — Building Basic Data Analysis with Excel Power Tools

Image for post
Image for post
Date Dimension Table Query — Viewed in PowerQuery Editor

Overview


Part 1 — Building Basic Data Analysis with Excel Power Tools

Image for post
Image for post

Overview


Use of the INDIRECT and SEARCH functions can turbocharge your Conditional formatting in Excel!

Image for post
Image for post
SEARCH function to highlight rows based on variable

INTRODUCTION

HOW?


Learn to reduce reliance on the Ribbon — You are on your way!

Image for post
Image for post
Excel Ribbon Commands Collapsed
YouTube Channel — Hide Ribbon Commands Quick Vid

Natively built into Gmail — desktop and mobile apps — and it’s awesome!

Compose email and click “Send” dropdown arrow

  • “Schedule send” will show as an option.
Image for post
Image for post
Compose email and click “Send” dropdown arrow

Schedule when to Send. Done.


#TwinzTechTip #TwinzTalk

Image for post
Image for post
Compare 2 Lists in Excel — MATCH, VLOOKUP, or Power Query?

Basic Power Query makes this easy!


#TwinzTechTip #TwinzTalk

Image for post
Image for post
Files List from Folder — Power Query Loaded into Excel as Table

Finally, it is easy…using Power Query!

1️⃣ Select “Data >> Get Data >> From File >> From Folder”.


It’s not as hard as you think…

Image for post
Image for post
Image Courtesy — Mike Quindazzi ✨ from Linkedin

Don Tomoff

It’s time for DIFFERENT— On a mission to challenge the status quo to a more productive and effective end… #digital #Excel #data #analytics

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store