Welcome to Datasoft Institute

Admissions Open : DCA Plus, AHDCA, AHCCA, A/c Plus, Digital Marketing, Office Automation, Computerized Accounting, Taxation, O Level, CCC, C Prog, C++ Prog, Python, Java, My SQL & DISTANCE EDUCATION Prog : MBA (Dual Specilization), M Com, B Com, MA, BA etc.

CERTIFICATE IN ADVANCE EXCEL ( DS020 )

BASIC INFORMATION

Excel Interface Review: Quick Recap of Basic Excel Functions, Customizing the Ribbon and Toolbar, Working with Multiple Sheets and Workbooks, Cell Referencing: Relative, Absolute, and Mixed.

Advanced Formulas & Functions: Logical Functions: IF, AND, OR, IFERROR, Lookup & Reference: VLOOKUP, HLOOKUP, XLOOKUP, INDEX, MATCH, Text Functions: TEXT, LEFT, RIGHT, MID, CONCAT, TEXTJOIN, Date & Time Functions: TODAY, NOW, DATEDIF, EDATE, Math & Statistical: SUMIFS, COUNTIFS, AVERAGEIFS, ROUND, RANK.

Data Analysis Tools: Sorting and Filtering (Advanced Filters), Conditional Formatting with formulas, Data Validation (drop-down lists, restrictions), What-If Analysis: Goal Seek, Data Tables, Scenario Manager, Pivot Tables and Pivot Charts, Grouping, Filtering, and Calculated Fields in Pivot Tables.

Charts and Visualization: Creating and Customizing Charts, Dynamic Charts with Named Ranges, Combo Charts (Bar + Line), Sparklines, Conditional Formatting in Charts.

Advanced Excel Tools: Named Ranges, Form Controls (Checkboxes, Drop-downs), Data Consolidation, Remove Duplicates & Flash Fill, Grouping & Outlining Data.

Excel Dashboard Design (Intro): Creating Interactive Dashboards, Linking Charts, Tables, and Filters, Using Slicers with Pivot Tables, Designing Layout for Reporting.

Importing & Exporting Data: Importing Data from Text, CSV, Web, and Other Sources, Cleaning and Transforming Data, Connecting Excel to Access or SQL (Intro Level).

Protection and Security: Worksheet and Workbook Protection, Locking Cells and Ranges, Password-Protecting Files, Tracking Changes and Comments.

Introduction to Macros (Optional): Recording and Running a Macro, Assigning Macros to Buttons, Understanding Basic VBA Code (Optional).

Qual : 8th or 10th or Above