CCI Online Learning

Live Classes

#### with Mr Vikas

Limited Seats   28th November, 2022

##### Offer Price : 1299.00

Special offer for GST PLUS Subscribers**

Platinum Members : 599.00

Gold Members : 799.00

Silver Members : 999.00

If you have any question
please call us at : 011-411-70713

Starting Date: 28-11-2022

Timing: 8:15 PM - 10:15 PM (Monday to Friday)

Ending Date: 02-12-2022

Language: Hinglish

Faculty: Mr Vikas

## Course Content:

• Indroduction to Ribbons
• Mathematical Functions
• Text Functions & Data Validation
• Pivot Table & Charts
• Misc

## Key Features:

• E-Certificate
• E-Notes Available
• The recorded session will be provided for 3 months
• Weekday Batch
• Duration 10 Hours

## Detail Content of Advance Excel Course:

S.NoDateTopicDurationDetailed Coverage
1 Monday, 28 November, 2022 Indroduction to Ribbons 2 Hours Basic Functions: Find, Replace, Formatting, Alignment, Sorting, Filter Cell Referencing, Range Concept, Define Name, Sum(), Average, Count(), Counta(), Countblank()
2 Tuesday, 29 November, 2022 Mathematical Functions 2 Hours sumif(), sumifs(), Countif(), Countifs(), Averageif(), Averageifs(), Vlookup(), Hlookup(), row(), column(), Max(), Min(), Large(), Small(), sqrt(), power(), round(), If (), nested if(), proper(), Upper(), lower(), left(), right(), mid(), trim, len(), find(), search(), repeat(), Concatenate()
3 Wednesday, 30 November, 2022 Text Functions & Data Validation 2 Hours Datediff(), yearfrac(), day(), month(), year(), now(), today(), weekday(), hour(), minute(), second(), Sparklines, Charts (Line, Bar, column, Pie, Doughnut, Waterfall, sunburst, tree & combo), Data Validation
4 Thursday, 1 December, 2022 Pivot Table & Charts 2 Hours Pivot Table/Chart
5 Friday, 2 December, 2022 Misc 2 Hours Security/Protection, Grouping & Ungrouping, Subtotal, Hyperlink, Flashfill, Text to column, Paste special

#### Experienced Faculty

Mr Vikas, is a Business Analyst in a well renowned company. He has done a Masters in Computer Application from IGNOU University. He has been providing Data Visualization, Advance Excel, Storytelling through data and Power BI classes for the last 14 years on various platforms (online, corporate training, institutes, personal coaching etc). He has an expert in Process Optimization and Data Analysis.

﻿