Accounting Information Systems

1

Excel Workshop

Subject Code: ACC 202

Subject Name: Accounting Information Systems

Workshop Dates: Week 3, Week 6, Week 8 and Week 9

Workshop Location: Computer Lab

Objective: Microsoft Excel is the most used spreadsheet program in many business

activities; therefore, these workshops are aimed to provide you with the

fundamental and some advanced excel features.

Workshop Outline: The workshop questions are divided into Exercises and Practice

Questions. The lecturers are required to explain the concept with the help

of given exercises. The students are required to practice similar kind of

questions through practice questions.

2

Week 9

Overview

Exercises Practice Questions

❖ Exercise 25

Generate Data (Random numbers)

❖ Exercise 26

Pivot Table

❖ Exercise 27

Pie Chart

❖ Exercise 28

Other Recommended Charts

❖ Exercise 29

Relative and Absolute Reference

❖ Exercise 30

Split Cells

❖ Exercise 31

Collaboration

❖ Practice Question 19

Pivot Table

❖ Practice Question 20

Pivot Table

❖ Practice Question 21

Pivot Table

❖ Practice Question 22

Pivot Table

❖ Practice Question 23

Recommended Chart

3

Exercise 25 – Generate Data (Random numbers)

The RAND function generates a random decimal number between 0 and 1. Select cell A1. Type RAND()

and press Enter. The RAND function takes no arguments.

Once you have completed the exercise, your answer should look like this:

4

Exercise 26 – Pivot Table

A pivot table is a table of statistics that summarizes the data of a more extensive table. This summary

might include sums, averages, or other statistics, which the pivot table groups together in a meaningful

way. Pivot tables are a technique in data processing.

Once you have completed the exercise, your answer should look like this:

5

Practice Question 19 – Pivot Table

From the data given in the table, create a pivot table and group the data.

Once you have completed the practice question, your answer should look like this:

6

Practice Question 20 – Pivot Table

From the data given in the table, create a pivot table and group the data for customer AA.

Once you have completed the practice question, your answer should look like this:

7

Practice Question 21 – Pivot Table

From the data given in the table, create a pivot table and group the data for customer TTT.

Once you have completed the practice question, your answer should look like this:

8

Practice Question 22 – Pivot Table

From the data given in the table, create a date pivot.

Once you have completed the practice question, your answer should look like this:

9

Exercise 27 – Pie Chart

From the data given in the table below, let's learn to create a pie chart

Once you have completed the exercise, your answer should look like this:

10

Exercise 28 – Recommended Charts

From the data given in the table below, practice from the recommended chart options and create:

Clustered Column; Clustered Bar and Stacked Bar

Once you have completed the exercise, your answer should look like this:

11

Practice Question 23 – Recommended Chart

From the data given in the table below, practice from the recommended chart options and create a

Clustered Column Chart.

Once you have completed the practice question, your answer should look like this:

12

Exercise 29 – Relative and Absolute Reference

A relative reference is a reference that will change when you copy it. An absolute reference is a

reference that will not be changed during the process of copying data. Calculate the figures for the cells

highlighted in yellow colour using absolute referencing.

Once you have completed the exercise, your answer should look like this:

13

Exercise 30 – Split Cells

You can split the content of a cell into multiple adjacent cell, lets learn it via following example.

.

Once you have completed the exercise, your answer should look like this:

14

Exercise 31 – Collaboration

You and your colleagues can open, work and collaborate on the same Excel workbook. This is called co-

authoring. When you co-author, you can see each other's changes quickly — in a matter of seconds. And

with certain versions of Excel, you'll see other people's selections in different colours. If you're using a

version of Excel that supports co-authoring, you select Share in the upper-right corner, type email

addresses, and then choose a cloud location.

End of the workshop