Skip Main Navigation
Page Content
This event has ended

Save This Event

Event Saved

Excel Leverage: Formatting with Text Functions (1-Hour Online Class)

Office Leverage

Multiple Dates

Excel Leverage: Formatting with Text Functions (1-Hour...

Share Excel Leverage: Formatting with Text Functions (1-Hour Online Class)

Event Details

Format list of data in Excel in less than five clicks.

Excel Leverage:

Time Savers | Formatting Text with Functions


“After taking this webinar, my sales team is glad I can…”

  • Separate data using Text to Columns
  • Apply the Concatenate function to combine data
  • Copy formulas with AutoFill
  • Format text with upper/lower/proper functions
  • Use find and replace to clean-up data
  • Extract data using the LEFT function
  • Apply the CLEAN and TRIM functions
  • Transpose values to create a record
  • Apply other Text functions based on need

We simplify it so in just 60-minutes you will learn how to:

  • Separate names into columns with 3 clicks
  • Normalize a data list
  • Use text functions to format data
  • Extract data from cells based on content
  • Switch vertical data to horizontal data
  • Remove irrelevant data in 2 clicks
  • Make the keyboard dance with shortcuts


Class Duration

60 minutes plus 15-minute pre-class lounge to ask project-specific questions.


Cost & Registration

$30 plus minimal processing fee. Upon successful registration you will receive an exercise file for the class as well as login details.



Recommended Prerequisite Webinars

Excel Leverage : Getting Started Best Practices

Excel Leverage : Optimizing Tables & Lists


You will get the more out of this webinar if you are comfortable with:

Highlighting cells with the mouse and keyboard, and knowing how to 


About Us 


Office Leverage inspires business innovation with interactive Microsoft Office® training programs that improve employee productivity. We design custom onsite training to meet the growth objectives of our clients. Our “Office Leverage: 60 Minute to Shine” webinars teach individuals essential skills in Microsoft Word, Excel, PowerPoint and Outlook to compete in today’s marketplace. Our instructors are Microsoft Office Specialist® Master Instructor certified.


We are based in Los Angeles, California. All classes are listed in Pacific Standard Time. Contact us to customize a training program for you. 888.364.4222

Contact info [at] to talk to us.



View other Excel Leverage webinar titles 



NOTE: Excel Leverage webinars are designed for use on a PC with Excel 2007 or 2010. If you do not have this software, you are welcome to register and participate as an observer.



Have questions about Excel Leverage: Formatting with Text Functions (1-Hour Online Class)? Contact Office Leverage


Office Leverage

Office Leverage is a help desk for the most popular desktop applications in the world. If you have a quick question, tweet it @OfficeLeverage. If you want to learn skills quickly with a patient instructor, attend our live workshops or online webinars. If you want us to design a spreadsheet for your organization, give us a call at 888.364.4222. We have facilitated over a 1,000 classes and know how to make Microsoft Office work for business.


We support Word, Excel, PowerPoint, Outlook, Access and Publisher. | 888.364.4222 | 60-Minute Excel Leverage Webinars for $30


Microsoft Office® and Microsoft Excel® are registered trademarks of Microsoft Corporation.


We are based in Los Angeles, California. Contact us to customize a training program for you. 888.364.4222

  Contact the Organizer

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.