Welcome‎ > ‎

Excel

At ASB we see the value for all users to have a foundational understanding of Microsoft Excel. This software manages data and can be used in many classes. Students should familiarize themselves with the following features to be ready to use this software when needed in class.

  • Able to modify the contents and understand the difference between a cell, column, and row.
  • Control the height, or width of columns and rows.
  • Understand and be able to use a formula for calculations
  • Can create, modify, and develop graphs, charts, and pivot tables.
If you are unable to do any of these, use the videos below to help you familiarize yourself with Microsoft Excel.

Below is a list of skills that you should know how to do with Excel. If you need more step by step instruction, we have a YouTube Channel for Tutorials. You can click on the Excel Tutorial button below to go directly to tutorials related to Excel.


Click above to go to the YouTube Tech Skill Tutorial Channel

This will take you to a series of videos which support learning.




 
 Videos    Skills Covered
   Practice Exercis
(YouTube Video)
  Overview
  • Introduction to the layout
  • Tabs
  • Features of 2007
 
(YouTube Video)
   Basic Skills
  • Creating a new SS
  • Cell Address
  • Columns/Rows
  • Editing
  • Saving
 

Create a new spreadsheet in excel.

Name it ‘SUBJECTS’. Add all the subjects that you are currently enrolled in to the first column of this spreadsheet.

Move to the second column of this sheet and add the Teachers name for that particular subject.

Save this file as SUBJECTS and then close.
(YouTube Video)
   Tips for using Excel
  • Sheets
  • Zoom
  • Quick Access Toolbar
  • Microsoft Button
  • Excel Options
  Open the recently saved file called ‘SUBJECTS’.

Create a new sheet in the file and name it Activities. Enter all the information about the activities that you are part of during your school day.

After doing this add quick access tools to the quick menu i.e. Quick Save, Print Preview, etc. 
(YouTube Video)
   Formatting
  • Bold
  • Underline
  • Font Color
  • Border
  • Fill Color
  • Cell Formating
  • Cell Alignment
  • Merging Cells
  In the first column of the first sheet mark all the subject names with different colors and ensure that they are all bold, italicized and underlined.

Create a border color for all the cells and change the cell width to 40.

Merge the top 2 cells and enter the text as ‘Personal Information’. 
(YouTube Video)
   Editing
  • Copy/Cut/Paste
  • Drag and Drop Moving
  • FIll Handle
  Add another column to the SUBJECTS file called ‘Sr. No.’ and enter 1,2 in the first 2 cells. Then select the 2 cells by pressing the shift key.

Hold the small black square on the right hand corner of a cell and drag to fill the consequent values in a particular series. 
(YouTube Video)
   Columns & Rows
  • Manual or AutoFit
  • Insert row or olumn
  • Deleting rows or columns
  Make sure that the columns and rows autofit to the cells content.

If you feel that a piece of information is not necessary, delete it.
(YouTube Video)
   Formulas
  • Simple formulas
  • Cell reference
  Create a simple table for displaying student grade data and calculate the averages.

The final display should look like the table given below 
(YouTube Video)
   Graphs and Charts
  • Insert Tab
  • Selecting data
  • Graphing
  • Designing
  • Axis and Title Options
  Create a graph of the data that you have created in the above section for the student grades.

Try to create a couple of graphs so that you can get a feel of what the different type of graphs look like and how the data can be used.

Change the axis and titles around till you get the result you need.
       
       



Spring 2009

 

 

 

 

 

 

 

 

EXAM

EXAM

EXAM

 

FINAL

STUDENT NAMES

STUDENT ID

#1

#2

#3

PART.

AVERAGE

Student 1

99999

94

74

89

90

85.9

Student 2

99998

81

73

83

65

76.8

Student 3

99997

93

91

97

80

91.65

Student 4

99996

98

83

88

90

89.3

Student 5

99995

95

94

90

90

92.45

 

 

 

 

 

 

 

 

Averages

92.2

83

89.4

 

 

Comments