Call: +91-9146304108

Email: info@keerti.org

08:00AM to 08:00PM

Give a Missed Call +91-8039-118-377

Apply Now
Register now and secure your future



Testimonial

Advanced Excel

Duration: 2 Months

$75
Advance Excel

Course Overview

Objective: This Advanced Excel Course will empower the participants to perform complex calculations, more efficiently, using various Excel functions. This course also trains them in organizing and analyzing large volumes of data. The student will also learn creating MIS reports In Excel, designing and using templates, consolidating and managing data from multiple workbooks. This course leads to Microsoft Office Specialist Certification in Excel

Duration: 2 Months

ADVANCED FILE TASKS

1. Saving and File Management
2. Converting and Encrypting Files
3. File Properties and Digital Signatures
4. File Accessibility and Compatibility



WORKING WITH FUNCTIONS AND FORMULAS
1. Working with Named Ranges 2. Array Functions (SUMIF & AVERAGEIF)
3. Formula Auditing
4. Formulas with Absolute References
5. Text Functions
6. Financial Functions

MANAGING TABLES IN MICROSOFT EXCEL
1. Creating Excel Tables
2. Working with Records and Filters
3. Advanced Filters


ADVANCED FUNCTIONS IN EXCEL
1. Using Error Functions
2. Using Logical Functions
3. Using Array Formulas
4. Using Rounding Functions

DATA TOOLS IN EXCEL

1. Text to Columns
2. Flash Fill
3. Remove Duplicates
4. Data Validation
5. Consolidate
6. Sparkline

GROUPING & OUTLINING AND SUBTOTALS

1. Outlining and Grouping Data
2. Using the Subtotals Tool




WHAT-IF ANALYSIS

1. Exploring Scenarios
2. Goal Seek and Data Tables
3. Using Solver


ADVANCED PIVOTTABLES & CHARTS

1. Getting Started with PivotTables
2. Formatting a PivotTable
3. Using the Classic PivotTable Layout
4. Formatting a PivotChart
5. Calculated Fields in Pivot Tables
6. Showing Pivot Data as a Percentage
7. Creating Custom Pivot Tables Styles
8. Slicers

ADVANCED EXCEL TASKS

1. Excel and Hyperlinks
2. Using Custom AutoFill Lists
3. Sharing Workbooks




CREATING HLOOKUP AND VLOOKUP FUNCTIONS

1. Using the VLOOKUP Function
2. Using the HLOOKUP Function




ADVANCED CONDITIONAL FORMATTING

1. Editing Standard Formatting Rules
2. Using Formulas in Conditional Formatting

ADVANCED LOOKUP FUNCTIONS

1. Using the Index Function
2. Using the Match Function Using
3. Index and Match Together
4. Using Index and Match with Array
5. Formula Using the Indirect Function