In this course Excel expert David Ringstrom, CPA shares many Excel tips and tricks that he uses to fly through Excel every day. He's fond of stating "Either you work Excel, or it works you!". This course is designed to help you use Excel more effectively. In this course David teaches primarily from Excel 2010, but covers differences in Excel 2003, 2007, and 2013 where applicable.


Instructions:
Please complete the course video, review questions, and successfully complete the qualified assessment with a minimum of 100% accuracy within one year of course enrollment.

Note: Nano CPE Coming Soon

Learning Objectives
Upon successful completion of this course, the user should be able to:
  • Identify how to combine text into one column or separate it into several by way of simple Excel techniques.
Last updated/reviewed: May 02, 2025
Prerequisites
Course Complexity: Basic
No advanced preparation or prerequisites are required for this course.
Education Provider Information
Company: Illumeo, Inc., 75 East Santa Clara St., Suite 1215, San Jose, CA 95113
Contact: For more information regarding this course, including complaint and cancellation policies, please contact our offices at (408) 400- 3993 or send an e-mail to courses@illumeo.com.
Instructor for this course
  Course Overview CPE
Course Syllabus
COURSE MATERIAL
  Text to Columns Wizard10:00
  Slides: Excel Tips & Tricks: Text to Column WizardPDF
  Excel Tips & Tricks: Text to Column Wizard GlossaryPDF
  Excel Efficiency Tips and Tricks I-Excel 2003XLS
  Excel Efficiency Tips and Tricks I-Excel 2007-2013XLSX
REVIEW AND TEST
  REVIEW QUESTIONSquiz
 FINAL EXAMexam