Mastery In MS Excel

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.

Syllabus:

• Module - 1   Working with Spreadsheet
• Unit 1 : Introduction of MS Excel
• 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
• Unit 2 : Working With Worksheets
• 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
• Unit 3 : Data Management
• 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  
• Unit 1 : Working with Formulas and Functions
• Introduction to basic functions: SUM, AVERAGE, MIN, MAX, COUNT
• Using Formulas for Numbers (Addition, Subtraction, Multiplication & Division)
• AutoSum
• Unit 2 : Advanced Formulas and Functions
• 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  
• Unit 1 : Data Visualization with Charts and Graphs
• 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
• Unit 2 : Pivot Tables and Pivot Charts
• 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  
• Unit 1 : Advanced Data Analysis with Excel
• 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