I hope most of us in this class have utilized Excel for something that is more creative than tracking our grocery shopping list and making a "to-do" list!
Microsoft Excel is a spreadsheet program
that is designed to capture and analyze data such as texts and numbers. However
Excel is not just restricted for data entry, creative utilization of Excel can
help data collection, finance and accounting budgeting, expense tracking and statistics
data analysis, to just name a few.
Your survey responses...
Based on your responses collected by the survey
sent out to you at the beginning of the week, some of you feel quite
proficient and comfortable using Excel. Here is a pie chart based on your responses=)
Bart's trivia
Before Excel 2007, how many columns does Excel have per spreadsheet?
That's right: before Excel 2007, it only has 256 columns per spreadsheet. It has increased to 16384 columns per spreadsheet since then!
Basic navigation...
Some Excel functions that may be useful for HR...
CONCATENATE FUNCTION
VLOOKUP FUNCTION
PIVOT TABLE FUNCTION
Now...please complete the mini-Excel exercise which can be downloaded from https://docs.google.com/spreadsheet/ccc?key=0AgF5dutUUDWzdHQ3amJWbzdsRUxiVGRlRW1WWXd2enc and email it back to me at 200202714@student.georgianc.on.ca OR if you have any questions, feel free to reach me at this email too.
You can also find the training template here: https://docs.google.com/spreadsheet/ccc?key=0AgF5dutUUDWzdFl6QVFpdzFlREpnaUdZYjRPczBYZWc
Thank you so much for reading this blog and if you have a few minutes to spare, please fill out the survey http://www.surveymonkey.com/s/BXCJG7L to let me know how I did=) Thanks again everyone!!
Basic navigation...
Number
|
Contains
|
Description
|
1
|
Title Bar
|
Contains the name of the file that is currently open.
|
2
|
Menu Bar
|
Contains various commands that can be performed by Excel.
|
3
|
Tool Bar
|
Contains buttons for some commonly commanded tasks.
|
4
|
Formula Bar
|
Displays the content of an active cell. The left hand side of the bar is the ``address`` of the active cell.
|
5
|
Column Label
|
Contains the heading of the columns.
|
6
|
Row Label
|
Contains the heading of the rows.
|
7
|
Sheet Area
|
Enters and stores the actual data (i.e. text, date and numbers).
|
8
|
Sheet Tab
|
Gives identities to sheet which is currently active.
|
9
|
Status Bar
|
Gives a status update of the entire currently active sheet.
|
Some Excel functions that may be useful for HR...
CONCATENATE FUNCTION
VLOOKUP FUNCTION
PIVOT TABLE FUNCTION
Now...please complete the mini-Excel exercise which can be downloaded from https://docs.google.com/spreadsheet/ccc?key=0AgF5dutUUDWzdHQ3amJWbzdsRUxiVGRlRW1WWXd2enc and email it back to me at 200202714@student.georgianc.on.ca OR if you have any questions, feel free to reach me at this email too.
You can also find the training template here: https://docs.google.com/spreadsheet/ccc?key=0AgF5dutUUDWzdFl6QVFpdzFlREpnaUdZYjRPczBYZWc
Thank you so much for reading this blog and if you have a few minutes to spare, please fill out the survey http://www.surveymonkey.com/s/BXCJG7L to let me know how I did=) Thanks again everyone!!