Excel Hacks: Capitalize on the Power of Flash Fill and Power Query


On-Demand Webinar | (Recorded)

Trainer: Anne Marie DelPrincipe, Owner, Mastering Software Unlimited 

Microsoft Excel is more than just a great spreadsheet program—it’s a powerful tool for organizing and analyzing information. Excel is also a major source of frustration when new data arrives in formats, fields, and columns that aren't so helpful. Sound familiar?

What if you were able to quickly organize, manage and retrieve information in Excel, without long formulas or complicated keyboard shortcuts?

Join Anne Marie DelPrincipe as she unveils the secrets behind Microsoft Excel's two most powerful weapons; Flash Fill and Power Query! You will leave this live webinar knowing how to:

  • Use Flash Fill to combine and extract names, format numbers, move text around in order to create new information.
  • Transform data into a normalized tables and fill in blank cells. 
  • Separate dollars and cents; combine text, currency and date, and separate hours from minutes.
  • Find duplicates across multiple tables.
  • And much more!

Bonus Handouts: 1. How to install Power Query in Excel 2.Tutorial on Power Query and Flash Fill 

Hot Tip: Control+E is the famous shortcut for centering text in Word and in PowerPoint.  However, in Excel, it is the shortcut for command for Flash Fill. In a new column, next to existing data, enter a value that represents what you want to extract and click on Control+E to fill in the rest of the information.

About the Trainer: Anne Marie DelPrincipe, MBA, owner of Mastering Software Unlimited, has over 30 years of training experience with emphasis on end-user computing and desktop publishing. Anne Marie also works as an Adjunct Professor at Raritan Valley Community College (RVCC) teaching Computer Literacy. She is a Corporate Training Specialist at RVCC and at Rutgers University teaching MS Office, Adobe products and PACE Certification. Anne Marie shares tips and techniques for Word, Excel, and PowerPoint on her blog, Anne Marie earned a B.A. in CIS and a M.B.A. in MIS from Iona College.

 Continuing Education Credits: This webinar is eligible for .1 CEU (one credit hour). 

Looking for more webinar access? Become an ASAP Professional Member and have unlimited access to ASAP's expansive webinar library. Learn More Here!


April 18, 2018

Join the Conversation

Welcome to the ASAP Circle, a community platform for peer-to-peer conversation on trending topics, professional challenges, and shared experiences. We even have designated spaces for weekly Tuesday Coffee Breaks.

Start Connecting Today!

Webinar FAQ's

What online training is included with ASAP Membership? 

You must be a Free or Professional Member to attend webinars. Certain webinars are exclusive to Professional Members ($199/year). Courses and workshops are not included with Membership. Learn more about the differences between webinars, courses, and workshops here

How do I access my webinar, course, or workshop?

Live sessions: You’ll receive a confirmation email from ON24, but your order confirmation email and Order History > Order Details will have a direct link to join as well. | On-demand: The post-checkout screen, your order confirmation email, and Order History > Order Details will have links to the on-demand materials.

Will I get a recording and certificate? 

Yes! Both the recording and certificate can be found under Order History > Order Details. For live sessions, please wait 1 to 3 business days after the live session for these materials to be uploaded (you’ll receive them via email as well). If you can’t attend the live session, you will still receive the recording.

Read more FAQs here.

American Society of Administrative Professionals

Producer of

APC  EA Ignite