Mastery in MS Excel
Objective
The course is designed to equip a student, common person and working professionals that how who want to progress from beginnerlevel skills to advanced proficiency in Excel, covering topics like data analysis, automation, and visualization. It provides theoretical background as well as in depth practical approach of MS Excel.
Target Audience
Graduate or Post Graduate in Arts, Commerce , Science, Engineering and Management Stream.
Duration of Course
8 weeks
Credit Weight
2 Credits
Certificate
The participants will be provided with a certificate upon successful completion of the course.
Career Advancement
Microsoft Excel are in high demand across a variety of industries for their ability to analyze data, automate processes, and create visual reports. The following career positions are available in the industries.
MIS (Management Information Systems) Executive, Data Analyst, Financial Analyst, Business Analyst, Supply Chain Analyst, Operations Analyst, Data Visualization Specialist, HR Analyst, Excel Trainer.
Module - 1 Working with Spreadsheet
- Elements of Spread Sheet
- Creating of Spread Sheet
- Concept of Cell Address [Row and Column] and selecting a Cell
- Entering Data [text, number, date] in Cells Page 2 of 9
- Page Setup
- Printing of Sheet
- Saving Spread Sheet
- Opening and Closing
- Manipulation of Cells & Worksheet
- Modifying / Editing Cell
- Formatting Cell (Font, Alignment, Style)
- Cut, Copy, Paste & Paste Special
- Changing Cell Height and Width
- Inserting and Deleting Rows, Column
- AutoFill
- Sorting and filtering data
- Using tables for data management
- Freezing panes and splitting windows for easier navigation
- Formatting cells and applying conditional formatting
- Data validation (creating drop-down lists and restricting data entry)
Module - 2
- Introduction to basic functions: SUM, AVERAGE, MIN, MAX, COUNT
- Using Formulas for Numbers (Addition, Subtraction, Multiplication & Division)
- AutoSum
- Introduction to advanced functions: IF, AND, OR, VLOOKUP, HLOOKUP
- Nested IF functions
- Date functions: TODAY, NOW, DATE, DATEDIF, and WEEKDAY
- Text functions: LEFT, RIGHT, MID, CONCATENATE, LEN, and FIND
- Using logical operators and conditional calculations
- LOOKUP functions for cross-referencing data
Module - 3
- Creating basic charts: bar, column, line, and pie charts
- Formatting charts: titles, legends, and axis labels
- Introduction to advanced chart types: scatter plots, combo charts, and histograms
- Adding data labels, trendlines, and error bars
- Introduction to Pivot Tables
- Grouping, sorting, and filtering Pivot Table data
- Calculated fields and items in Pivot Tables
- Creating Pivot Charts for data visualization
Module - 4
- Using Excel’s Analysis Toolpak
- Descriptive statistics: mean, median, mode, standard deviation, variance
- Regression analysis and forecasting
- Data tables and scenario analysis
- Goal Seek and Solver for optimization
Learning Management System (LMS) Panel:
- Lifetime Access: Students can log in securely at any time.
Course Features
- Live Online Classes: Engage in real-time sessions with instructors
- Interactive Sessions: Participate in discussions and Q&A to enhance learning.
- Practical Sessions: Apply concepts through hands-on activities.
- Class Recordings: Access recordings of live classes for review at your convenience
- Self-Learning Videos: Benefit from pre-recorded videos to reinforce learning.
- Digital Course Materials: Receive a soft copy of all course content.
- Assignments: Complete practical assignments to apply your knowledge.
- Practice Assessments: Test your understanding with practice quizzes.
- Final Assessment: Evaluate your overall progress with a comprehensive exam.