|
HU Credits:
0
Degree/Cycle:
1st degree (Bachelor)
Responsible Department:
Accounting
Semester:
1st Semester
Teaching Languages:
Hebrew
Campus:
Mt. Scopus
Course/Module Coordinator:
Mr Elad Prager
Coordinator Office Hours:
flexible
Teaching Staff:
Mr. elad parger
Course/Module description:
Introduction to Excel as a powerful tool for data management, data processing and decision making process.
Course/Module aims:
To acquire basic and advanced tools in Excel in order to: collect, manage and analyze data.
Get the right tools to work with the software in additional accounting courses.
Learning outcomes - On successful completion of this module, students should be able to:
The students will acquire theoretical and practical knowledge and skills in addressing accounting, management, economic and business tasks via Excel. The students will be introduced to most of the programs' features and will be qualified to write and fix basic and advanced Excel functions and formulas. The students will be able to diagnose Excel errors, use Nested Functions, timely updated functions, managing text, splitting data..
Mathematical, statistical, financial, text, date and time, logical function, statistical analysis, array formulas.
Editing, recording, sorting, filtering and formatting tools, including special copy/paste, data verification, conditional formatting.
Producing advanced and dynamic reports and views including sensitivity tables, pivot tables and charts, all chart tools and spark lines, Solver ,goal seek etc.
Attendance requirements(%):
80%
Teaching arrangement and method of instruction:
Lectures in in Zoom
Assignments
Final exam
Course/Module Content:
Relational and fixed references
Keyboard shortcut
Logical functions and conditions – if, and , or, nested functions.
Mathematical functions
Statistical functions
Financial functions
Conditional Formatting
Vlookup / Hlookup
Advanced and basic data filtering
Sort
Database Functions (countifs, sumifs etc.)
Pivot Table
Charts, spark lines
Print preview
Sensitivity tables
Goal seek
SOLVER
Required Reading:
none
Additional Reading Material:
all files are in the course site at moodle.
MIS Cases - Decision Making with Application Software 4th Edition by M. Lisa Miller (2008). Prentice Hall.
Management Science: The Art of Modeling with Spreadsheets, 4th Edition ,Stephen G. Powell, Kenneth R. Baker (2013). Wiley.
Grading Scheme :
Written / Oral / Practical Exam 100 %
Additional information:
Type of grade: pass / fail
All students must submit 2 assignments on time and pass the home exam in order to pass the course
See moodle for the syllabus and more information
|
