Microsoft Excel
Excel Book CD
The link below links to the CD with the files shown in the chapters. Feel free to access the folder and download the files you want to study on your own.
Attendance Link
CAC 140 Advance Excel
Please create a new folder for your Excel 2 assignments. Use the following naming structure:
2019 CAC 140 ADV Excel LastName
Please share with: izcampos@outlook.com
Data for Example 1
| Hire Date | First Name | Last Name | Salary Scale | Starting Salary |
| 10/5/2019 | Joel | Adams | 3 | 38521 |
| 10/8/2019 | David | Banner | 4 | 45210 |
| 10/15/2019 | Jill | Williams | 1 | 31584 |
| 10/20/2019 | Kendall | Lopez | 1 | 36548 |
| 10/22/2019 | Cory | Scott | 4 | 44123 |
FINAL REVIEW
Class Schedule
Class Dates:
July 2, 9, 16, 18, 23, 25, 26 (Midterm), 30
August 1, 6, 8, 9 (Final)
CAC 120: Excel for Accounting
Data for Example 3
| Item Number | Category | Item | Price |
| GS-1 | Fruit | Apples | $ 1.00 |
| GS-2 | Fruit | Orange | $ 2.00 |
| GS-3 | Fruit | Pear | $ 3.00 |
| GS-4 | Fruit | Mango | $ 4.00 |
| GS-5 | Dairy | Milk | $ 5.00 |
| GS-6 | Dairy | Yogurt | $ 6.00 |
| GS-7 | Dairy | Cheese | $ 7.00 |
| GS-8 | Meat | Chicken | $ 8.00 |
| GS-9 | Meat | Beef | $ 9.00 |
| GS-10 | Vegetables | Leek | $ 10.00 |
| GS-11 | Vegetables | Tomato | $ 11.00 |
| GS-12 | Vegetables | Carrot | $ 12.00 |
| GS-13 | Vegetables | Potato | $ 13.00 |
Data for Example 2
| Purchases | |||||
| Category | Item | Quanity | Price | Total | |
| 1 | Vegetables | Tomatoes | 10 | 1.46 | 14.60 |
| 2 | Meat | Sausage | 1 | 3.99 | 3.99 |
| 3 | Vegetables | Onion | 2 | 0.89 | 1.78 |
| 4 | Fruit | Mangoes | 10 | 0.99 | 9.90 |
| 5 | Fruit | Bananas | 10 | 0.99 | 9.90 |
| 6 | Other | Rice | 10 | 1.99 | 9.90 |
| 7 | Dairy | Milk | 10 | 2.99 | 29.90 |
Onedrive Files as of 7.25.2019
2019 CAC120 LastName
- 7.2.19 (Folder)
- Exercise 1 Calendar
- 7.9.19 (Folder)
- Exercise 2 Questionnaire
- Exercise 3 Analysis
- 7.16.19 (Folder)
- EL1-C1-P2-FillCells.xlsx
- EL1-C1-P3-MoExps
- EL1-C2-P1-HCReports
- EL1-C2-P2-DWTests
- 7.18.19 (Folder)
- EL1-C2-VB-Formulas
- EL1-C2-CS-AASFebSales
- EL1-C2-CS-AASFebCommissions
- 7.23.19 (Folder)
- EL1-C4-VB-HERExpress
- Exercise 4 Analysis II
- 7.25.2019
- Visual Benchmark P.94 (EL1-C3-VB-BTBookings)
DATA for Example
| Customer | State | Spent | Purchases | Age |
| Customer 1 | CA | 1000 | 10 | 20 |
| Customer 2 | FL | 250 | 20 | 30 |
| Customer 3 | NV | 350 | 30 | 25 |
| Customer 4 | CA | 500 | 40 | 30 |
| Customer 5 | FL | 800 | 50 | 55 |
| Customer 6 | CO | 950 | 60 | 60 |
| Customer 7 | NY | 1500 | 10 | 48 |
| Customer 8 | CA | 1000 | 20 | 50 |
| Customer 9 | CA | 100 | 30 | 20 |
| Customer 10 | OR | 50 | 40 | 25 |
Onedrive Folder Name
Create a OneDrive folder called “2019 CAC 120 Excel LastName”
Share your folder with izcampos@outlook.com
Syllabus
COUNT, COUNTA, COUNTIF, COUNTIFS
The exercise below will be practice for you to use the count formulas, including determining percentages.
Questionnaire
Academic Integrity
Academic integrity will be taken seriously. This includes the avoidance of cheating or plagiarism; maintenance of academic standards; honesty and rigor in submitted work.
Excel files are tagged with metadata that allow me to see who made a file, when it was made and on what computer it was made. There are instances where you are allowed to work with a partner; this does not mean copy files.
We will take advantage of all the features an outlook account gives you including:
- Access to Office Suite Online: You have access to an online version of the Office Suite including all the programs we will cover in class. The online versions does not contain all the features in the local version but the most important features are present.
- OneDrive: Your outlook account comes with online storage. We will take advantage of this by sharing files with each other as well as with me. The majority of your projects will be submitted electronically, no hard copies will ever be accepted unless they are requested.
Assignment Submission
All assignments given in class are due by the 5:00PM of the following class. Any late assignment will be receive a 10% late penalty. I.e. the highest grade for a perfect assignment will be 90%.
The first 30 minutes of class will be treated as in class work time for you to catch up on projects.