Excel 101: Introduction to Spreadsheets Part 2 (Currently Unavailable)

Author: David H. Ringstrom

This on-demand course by Excel expert David Ringstrom, CPA, builds on the discussion in part 1 of his two-part series on spreadsheets. You’ll gain exposure to ways you can same time working in Excel, such as with pivot tables, charts, and the Table feature. David also shares a variety of techniques, including how to minimize data entry, identify duplicate entries, 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 course.

Publication Date: January 2018

Designed For
Practitioners who wish to expand their knowledge of working with Excel spreadsheets.

Topics Covered

• Adding fields to a blank pivot table to create instant reports.
• Spell-checking spreadsheets by way of a keyboard shortcut or menu command.
• Adding fields to a blank pivot table to create instant reports.
• Limiting access to sensitive workbooks by way of password protection.
• Removing the Table feature from Excel spreadsheets once it's no longer needed or simply erasing the alternate row shading.
• Swapping out data within worksheet cells by way of the Replace feature.
• Identifying other cells a formula relies on by way of the Trace Precedents feature.
• Using Text to Columns in any version of Excel to quickly separate city, state, and ZIP code into separate columns.
• Separating first/last names into two columns without using formulas or retyping.
• Identifying duplicates in a list using Conditional Formatting.
• Using Text to Columns in any version of Excel to quickly separate city, state, and ZIP code into separate columns.
• Building a basic chart within an Excel worksheet.

Learning Objectives

• Identify the location of the Field List command within Excel's ribbon menu interface.
• Identify the feature that allows you to separate data into multiple columns.
• Identify the ribbon tab that contains the Total Row command.

Level
Basic

Instructional Method
Self-Study

NASBA Field of Study
Computer Software & Applications (2 hours)

Program Prerequisites
None

Advance Preparation
None