Advanced Excel Syllabus

Excel

Module 1: Introduction to Advanced Excel

1.      Overview of Excel Interface and Shortcuts

2.      Customizing Ribbon and Quick Access Toolbar

3.      Working with Templates and Themes

Module 2: Data Handling and Management

1.      Data Sorting and Filtering (Advanced Options)

2.      Data Validation and Drop-down Lists

3.      Removing Duplicates and Data Cleaning Techniques

4.      Consolidating Data from Multiple Sheets

Module 3: Advanced Formulas and Functions

1.      Logical Functions: IF, AND, OR, XOR, IFERROR

2.      Lookup Functions: VLOOKUP, HLOOKUP, XLOOKUP

3.      Text Functions: LEFT, RIGHT, MID, LEN, TRIM, CONCATENATE

4.      Date and Time Functions: DATE, TIME, EDATE, NETWORKDAYS

5.      Mathematical Functions: ROUND, ROUNDUP, ROUNDDOWN, CEILING, FLOOR

6.      Array Formulas and Dynamic Arrays

7.      Advanced Financial Functions: PMT, PV, FV, RATE, NPV, IRR

Module 4: Data Analysis Tools

1.      PivotTables and PivotCharts

2.      Creating Dynamic PivotTables

3.      Grouping and Slicers in PivotTables

4.      Power Query Basics for Data Transformation

5.      What-If Analysis: Goal Seek, Scenario Manager, Data Tables

Module 5: Data Visualization

1.      Creating and Formatting Charts (Bar, Line, Pie, Combo, etc.)

2.      Sparklines and Conditional Formatting

3.      Advanced Chart Customization

4.      Interactive Dashboards Using Form Controls

Module 6: Macros and Automation

1.      Introduction to Macros and VBA Basics

2.      Recording and Editing Macros

3.      Using Loops and Conditions in VBA

4.      Automating Reports and Tasks with VBA

Module 7: Data Security and Protection

1.      Protecting Worksheets and Workbooks

2.      Restricting Editing and Formatting Options

3.      Password Protection and Encryption

Module 8: Collaborative Tools and Integration

1.      Sharing Workbooks and Tracking Changes

2.      Merging and Comparing Workbooks

3.      Importing and Exporting Data (CSV, XML, SQL, etc.)

4.      Integrating Excel with Word, PowerPoint, and Outlook

Module 9: Advanced Problem-Solving Techniques

1.      Solver Tool for Optimization Problems

2.      Advanced Filters and Criteria-Based Analysis

3.      Database Functions: DSUM, DCOUNT, DAVERAGE

Module 10: SQL, Python, and Power BI Basics

1.      SQL Basics: SELECT, INSERT, UPDATE, DELETE Queries

2.      Data Retrieval and Joins in SQL

3.      Python Basics: Data Types, Variables, and Loops

4.      Data Analysis with Pandas and NumPy

5.      Data Visualization with Matplotlib and Seaborn

6.      Power BI Basics: Data Import and Transformation

7.      Creating Reports and Dashboards in Power BI

Module 11: Practical Projects and Case Studies

1.      Financial Modeling and Budget Planning

2.      Sales and Marketing Analysis

3.      Inventory Management System

4.      HR Management Reports

5.      Business Dashboards and KPI Reporting

Srno.    Coruse                Duration                         Fees                  Module

1           Basic Level         Approx. One Month.    1500 -/ INR      All Excel Options+Functions.

2           Middle Level      Approx. Two Month.    3000 -/ INR      Excel Options + Modules upto 9

3           Advance Level   Approx. Three Month. 10,000 -/ INR   Power BI +Sql +Python Lang.

                                    

Assessment: Regular Tests, Assignments, and Final Project Evaluation

Certification: Certificate of Completion from Disha Institute

 

Number of Days Depends on your practice and feedback. The more you practice and review your work, the faster you will complete the course.

For Batch time and Fess contact to Below Address and Number.

  Zamanat Sir

(MCA / Bsc. I.T / ‘A’ / ‘O’ / CCC / Govt. Certified  Domain Skill Trainer )

    

Disha Institute 153 Vijay Nagar Opp. Rg Pg College W.K Road Meerut 

(9411617329 , 9458516690) 


Comments

Post a Comment

Popular posts from this blog

SYNTAX OF ALL PROGRAMMING LANGUAGES

  C LANGUAGE   #include<stdio.h> #include<conio.h> void main() { float area,length,breath;           clrscr();           printf("enetr length");           scanf("%f",&length);           printf("enter breath");           scanf("%f",&breath);           area=length*breath;           printf("area of rectangle%f",area);           getch(); } IMPORTANTS THING TO REMEMBER 1.     PROCEDURAL LANGUAGE 2.     SAVE WITH .C IN C/CPP COMPILER 3.     PRIMITIVE AND NON PRIMITIVE 4.     PRINTF ...
Read more

Most Important Question and Answer for O Level Exam (Best of Luck to All O Level Students)

Best of luck to all the students appearing for the exams!  Stay focused and give your best!  Click Here for Important Questions and Answer of O level Exams. IT & TOOL (M1R5.1) JAN 2023 SET 2 IT & TOOL (M1R5.1) JAN 2023 SET 3 WEB PUBLISHING (M2R5.1) JAN 2023 SET 3 PYTHON PROGRAMMING (M3R5.1) JAN 2023 SET 2 INTERNET OF THING (M4R5.1) JAN 2023 SET 2 CLICK HERE FOR ANOTHER SET  Students appearing for the O Level January Examination can now download their Admit Cards from the official website of NIELIT (National Institute of Electronics and Information Technology) . Steps to Download Admit Card: Visit the official NIELIT website – https://student.nielit.gov.in . Click on the Download Admit Card link under the O Level Examination section. Enter your Registration Number and Date of Birth as required. Verify your details and click Submit to download the admit card. Print a hard copy of the admit card and carry it to the exam center. Importa...
Read more