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.
Prerequisites
No advanced preparation or prerequisites are required for this course.