Short Term Courses

Courses

Short Term Courses

It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.

Learn from Industry Experts

We have industry experts in our team

Learn the Latest Top Skills

Get knowledge on latest softwares.

Lifetime Access & Support

Get support from our faculty Lifetime

Courses

Short Term Courses

Eligibility & Course Duration

Course Duration - 1 Month or 2 Months

Course Outline
  • Introduction To O.S.
  • Windows
  • MS Word
  • MS Excel
  • MS Powerpoint
  • Introduction to Internet

Eligibility & Course Duration

Course Duration - 1 Month or 2 Months

Course Outline
  • Introduction To Advance Excel
  • Vlookup
  • Hlookup
  • Group/Ungroup
  • Consolidate Data
  • Macros
  • Advance Filter
  • Date & Time Formula
  • What if Analysis
  • Nested IF condition
  • Average If
  • Average Ifs
  • Count
  • Mathematical Formulas:
  • Subtotal
  • Logical Functions
  • Get day name from date
  • Get month name from date
  • Two way lookup
  • Index Function
  • Match Function
  • Two way lookup with
  • Index and Match
  • Statistical Analysis Easier
  • PMT Formula
  • Data Validation
  • Concatenate Formula
  • Text to Columns
  • Pivot Table / Pivot chart
  • Slicer
  • Chart Options
  • Hide / Unhide
  • Protect / Unprotect
  • worksheet
  • Hyperlink
  • Trace precedents
  • Trace Dependents
  • Remove Arrows
  • Evaluate Formula
  • Sorting
  • Freeze Panes
  • Transpose Data
  • Forecast
  • Conditional Formatting
  • Frequency
Contact For More Information

Related Courses You may Like

USA Taxation
(5.00)

USA Taxation

Tally Prime
(5.00)

Tally Prime

Advance Excel
(5.00)

Advance Excel

Perfect Computer Education

Perfect Computer Education was incorporated in 1994, driven by a shared purpose of filling out the gap of Education and helping students launch their growth-focused careers.

Company
Courses
Contact

© 2024 Perfect Computer Education. All rights reserved.