• LinkedIn Social Icon
  • Twitter Social Icon
  • Facebook Social Icon
  • YouTube Social  Icon
  • Snapchat Social Icon
  • Google+ Social Icon

Contact

724-590-9164

Visitor counter

©2019 by Dr. Veronica Paz, CPA, CITP, CFF, CGMA

Click on the boxes below to access the lessons. 

Make this yours. Add images, text and links, or connect data from your collection.

Getting Started

Getting Started

and

Acquainted with Excel

Workbooks

Creating Basic Workbooks, Entering data into Cells and Renaming.

Worksheet Tools

Copying, Moving, 

Formatting Worksheets

Formulas

Basic Formulas such as

SUM,

Average, Count, IF  

Conditional Formatting

Applying,  finding, and clearing cell with conditional formatting.  e

Comments

Adding, Showing

&

Hiding Comments 

Trace Precedents

Initiating trace precedents &

Finding Errors

Security Features

Adding Passwords to workbooks

& worksheets

Charts

Creating, Selecting, Moving and 

Formatting Charts

Pivot Tables

Creating, Manipulating

&

Changing Pivot Tables

Sorting & Filterting

Sorting 

Filtering Data 

Video Library

A collection of

Excel Tutorial

Videos

Readings

Beginning Excel

OER Textbook

Learning How to Use 

Microsoft Excel 

Others

Activities

Excel Workshop Week 3 Paz, an Event on GoSoapBox.

To join, here's what to do:

  1. Browse to app.gosoapbox.com on your own computer, tablet, or smartphone.

  2. Type in 665-364-820 in the Access Code field.

  3. Enter their name prior to joining.

‚Äč

Data Files

Revenue Data File 

Lesson Plan & Notes