MVL | Course Details

Advanced Excel

Register Here

Advanced Excel

Course content

Key functions in excel:

  • Essential shortcuts
  • Absolute & Relative referencing ($)
  • Data validity and completeness
  • Data formatting - Format cleaning, date formats, Coma and decimals
  • Meaning of =, <, >, <>, <= =>
  • Use of brackets in formula

 

Important Ribbon functions:

  • Conditional formatting
  • Find & Select
  • Goal Seek
  • Calculations
  • Formula Auditing
  • Circular reference & iterative calculations

 

Working with Charts and Templates:

  • Inserting Chart
  • Different formatting options and different type of chart
  • Data sanitization & Data Analysis

 

Converting other format data to excel:

  • Conversion into Excel
  • Data formatting
  • Text conversion function

 

Logical Functions of Excel:

  • Writing conditional expressions (using IF)
  • Using nested Ifs
  • Using logical functions (AND, OR & NOT)
  • Using lookup and reference functions (VLOOKUP & HLOOKUP)
  • Limitations of V lookup and how to avoid it by using INDEX& INDEX

 

Special functions:

  • Date and time functions (TODAY, NOW, YEAR,MONTH,DAY & DATEDIF)
  • Text functions (TEXT,LEFT,RIGHT,MID & CONCATENATE etc.)
  • Statistical function (COUNT,COUNTA,COUNTBLANK, COUNTIF, COUNTIFS, SUMIF & SUMIFS)

 

Pivot & Sub-totals:

  • Creating subtotals, Multiple-level subtotals
  • Creating Pivot tables
  • Using Slicer in Pivot table
  • Formatting and customizing Pivot tables
  • Using advanced options of Pivot tables
  • Pivot charts
  • Get Pivot data function
  • Consolidating data from multiple sheets and files using Pivot tables

 

Dos and don'ts of excel:

  • Data filters
  • File formats (Reduction in Sizes)
  • Use of Paste special & Manual calculations
  • Basic errors & resolutions

Delivery mode
Classroom and Live Virtual Classroom (LVC) Mode
Duration
1 day
Course level
Advanced Level
Course Price
Indian-3,000+18% GS;T Foreign- USD120+18%GST

Contact US

MVL Consulting Private Limited

Address : #17, Laxman Villa Condominium, Paud Road, Pune, Maharashtra 411038 India 

Phone : +91 – 20 – 2546 6154

Phone : +91 – 20 – 2542 2874

Mobile: +91 – 9764 835 350

Email-id : info@mvlco.com

CIN No. : U31909MH1996PTC100429

 

Contact for Inhouse Programs

Head- Learning and Development

Name : Sangeeta Dokey

Phone : +91 9168 435 350

Email-id :sangeeta@mvlco.com

 

Enquiry