Share on Facebook

Share on Twitter

Share on LinkedIn

Share on Email

Share More

 CCI Online Learning

Live Classes

Advanced Excel Course

with Mr Vikas

Limited Seats   28th November, 2022

Original Price : 1999.00
Offer Price : 1299.00

Buy Now
View Similar Course

Special offer for GST PLUS Subscribers**

Platinum Members : 599.00

Gold Members : 799.00

Silver Members : 999.00

Share on :

Request a call back

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

About this course

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
Buy Now

Experienced Faculty

Mr Vikas

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.

Other recommended course