Efficient Calculation Techniques
Performing Complex Calculations More Efficiently
Excel Functions for Dynamic Projects
Using Various Excel Functions in Dynamic Projects
Writing Conditional Expressions (IF)
Using Logical Functions (AND, OR, NOT)
Using Lookup and Reference Functions (VLOOKUP, HLOOKUP, MATCH, INDEX)
VLOOKUP with Tables and Dynamic Ranges
Nested VLOOKUP with Exact Match
Using VLOOKUP to Consolidate Data from Multiple Sheets
Data Management & Analysis
Organizing and Analyzing Large Volumes of Data
Consolidating and Managing Data from Multiple Workbooks
Using External Data Sources
Using Data Consolidation Feature
Consolidating Data from Multiple Sheets
Management Information Systems (MIS)
Creating MIS Reports
Designing and Using Templates
Pivot Table Mastery
Formatting and Customizing Pivot Tables
Using Advanced Options of Pivot Tables and Pivot Charts
Viewing Subtotals Under Pivot
Show Value As (% of Row, % of Column, Running Total, Compare with Specific Field)
Advanced Formatting and Validation
Conditional Formatting for Rows, Columns, and Cells
Data Validation in Financial Functions
Date, Time, and Form Tools
Advanced Date & Time Functions
Creating Forms with Radio Buttons, Selection Tools, and Other Programming Tools
Creating Slicer (Excel 2013 Version)
Productivity Enhancements
Advanced Shortcut Keyboard Commands
10th
Course Code : CCC
Course Code : TALLY - 01
Course Code : CCC+
Course Code : ADCA
Course Code : DCA
Course Code : DCA - IT
Course Code : FOR KIDS
Course Code : FOR BEGINNERS
Course Code : TALLY - 02
Course Code : ADCA - IT
Course Code : TP - 01
Course Code : TP - 02
Course Code : S-BCC
Course Code : PERSONAL BATCH
Course Code : S-DOA
Course Code : S-AD-OA
Course Code : S-CL
Course Code : S-CL ++
Course Code : S-HT
Course Code : S-HT-5
Course Code : S-CSS
Course Code : S-CSS3
Course Code : S-CPP
Course Code : S-ADE
Course Code : M-DIPLOMA LANGUAGE
Course Code : S-DS
Course Code : S-MADC
Course Code : S-CAE
Course Code : CCC
Course Code : TALLY - 01
Course Code : CCC+
Course Code : FOR KIDS
Course Code : FOR BEGINNERS
Course Code : TALLY - 02
Course Code : TP - 01
Course Code : TP - 02
Course Code : S-BCC
Course Code : PERSONAL BATCH
Course Code : S-DOA
Course Code : S-AD-OA
Course Code : S-CL
Course Code : S-CL ++
Course Code : S-HT
Course Code : S-HT-5
Course Code : S-CSS
Course Code : S-CSS3
Course Code : S-CPP
Course Code : S-ADE
Course Code : S-DS
Course Code : S-MADC
Course Code : S-CAE
Course Code : ADCA
Course Code : DCA
Course Code : DCA - IT
Course Code : ADCA - IT
Course Code : M-DIPLOMA LANGUAGE
