About the Course
Every professional who is aiming for a lucrative job profile and every fresh graduates / post graduates who is looking forward to join the corporate world must know the intricacies of Excel reporting. Excel reporting is not all about performing some functions but Excel reporting is meant for digging a raw data set with such expertise that the raw data set provides the management with necessary information for decision making. This course will equip the students not only with Excel functionality but will also train the students with how to prepare effective reports using Excel 2007.
There are 2 parts of this course -
i. Excel Reporting
ii. Data Analysis using Excel
TRAINING METHODOLOGY -
a. Theory discussion
b. Practical Implementation
c. Case studies from different sectors
e. Knowledge Tests
TRAINING MATERIALS -
a. Printed Handouts
c. PDF files
TOTAL DURATION -
50 Hours Classroom Training.
COMPLEMENTARY SERVICE -
a. 5 hours of communication skills training.
Topics CoveredMs – Excel Curriculum
•Basic Operators - + - * / ^
•Functions – Sum , Max, Min, Average
•Paste And Paste Special
•Dates – Day, Month, Year, Edate, Eomonth, Text, Networkdays, Workday
•Referencing – Absolute And Relative
•Activate And Deactivate Gridlines
•Grouping, Cell Range Naming, Hide/Unhide Columns And Rows
•Vlookup With Match
•Hlookup With Match
•Index And Match
•Sumif, Countif, Nested Ifs, Concatenate, Upper, Lower, Proper, Trim, Len, T, N, Rept, Search , Find, Left, Right, Mid, Replace, Substitue, And, Or, Iserror, Isblank, Isnumber, Istext, Iferror
•What If Analysis – Data Table, Goal Seek And Scenario Manager
•Data Analysis Tool Pack – Statistical Analysis Case Studies
•Macro – Recording, Running
•Introduction To Vba
Who should attend10 + 2 / B.A./ B.SC. / B.COM / B.E. / B.TECH. / DIPLOMA / M.A. /M.SC. / M.COM / M.B.A.
Pre-requisitesi. Basic understanding of English Language
What you need to bringThe student needs to carry his or her laptop
ii. Notebook and pen will be supplied
Key TakeawaysThe student will be ready to work as M.IS. professional, data analyst, research analyst, equity analyst , sales analyst, or any other role which requires reporting skills.
The student will also be proficient to churn out high quality reports that will help him or her to impress the management in the organization or the faculty team of the college.