This presentation by Excel expert David Ringstrom, CPA, is designed for those who haven’t worked with Excel spreadsheets before or who haven’t used them in several years. David explains spreadsheet basics, different file types you can create, keyboard shortcuts to simplify repetitive tasks, Excel’s rows and columns grid, and much more.

David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. He draws your attention to any differences in Excel 2013, 2010, or 2007 during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.

Spreadsheet Basics: Saving Excel Files
Spreadsheet Basics: Managing Column Widths
Spreadsheet Basics: Formatting Numbers
Spreadsheet Basics: Excel Order of Operations
Spreadsheet Basics: Working with Dates
Spreadsheet Basics: Copying Formulas
Spreadsheet Basics: Monitoring Print Scales
Spreadsheet Basics: Duplicating Worksheets
Spreadsheet Basics: Minimize Clutters
Spreadsheet Basics: Data Filtering

Note: Nano CPE Coming Soon

Learning Objectives
  • Explore and explain spreadsheet basics, different file types, keyboard shortcuts to simplify repetitive tasks, Excel’s rows and columns grid and much more.
Last updated/reviewed: September 24, 2024
Prerequisites
Course Complexity: Foundational
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 .
Instructor for this course
Course Syllabus
COURSE MATERIAL
  Excel's Order of Operations9:11
  Slides: Spreadsheet Basics: Excel Order of OperationsPDF
  Workbook: Excel Efficiency: Spreadsheet BasicsXLSX
  12 Month Income StatementXLSB
  Spreadsheet Basics: Excel Order of Operations GlossaryPDF
REVIEW AND TEST
  REVIEW QUESTIONquiz
 FINAL EXAMexam