Certificate In Advance Excel

by Certified Institute For Accounting (CIA) Claim Listing

Certificate in Advance Excel is offered by Certified Institute For Accounting (CIA). The main purpose of CIA ( Softango Education Pvt. Ltd) is to develop a new education environment especially in computer along with account filling the skill and demand gap.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Certified Institute For Accounting (CIA) Logo

img Duration

Please Enquire

Course Details

Certificate in Advance Excel is offered by Certified Institute For Accounting (CIA). The main purpose of CIA ( Softango Education Pvt. Ltd) is to develop a new education environment especially in computer along with account filling the skill and demand gap.

 

Course Module:

  • Overview of the Basic Excel
  • Working with functions-Writing conditional expressions (using IF) ~ Using logical functions (AND, OR, NOT),Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX),Using VLookUP to consolidate Data from Multiple Sheets
  • Data Validations-~ Specifying a valid range of values for a cell ~ Specifying a list of valid values for a cell ~ Specifying custom validations based on formula for a cell
  • Working with Templates-~ Designing the structure of a template ~ Using templates for standardization of worksheets
  • Sorting and Filtering Data-~ Sorting tables ~ Using multiple-level sorting ~ Using custom sorting ~ Filtering data for selected view (AutoFilter) ~ Using advanced filter options
  • Working with Reports-~ Creating subtotals ~ Multiple-level subtotals ~ Creating Pivot tables ~ Formatting and customizing Pivot tables ~ Using advanced options of Pivot tables ~ Pivot charts
  • More Functions-~ Date and time functions ~ Text functions ~ Database functions ~ Power Functions (CountIf, CountIFS, SumIF, SumIfS)
  • Formatting ~ Using auto formatting option for worksheets ~ Using conditional formatting option for rows, columns and cells
  • Pune Branch

    Flat No. 202, 133 Blue pearl Orange Tree Society, Sus Gaon, Pune
  • Delhi Branch

    401- 4th Floor, D-30, Siddharth Complex, Near Laxmi Nagar Metro Station, Opp Metro Pillar No. 33, Nearest Domino's,Laxmi Nagar, Delhi

Check out more MS Excel courses in India

IIPS (Indian Institute Of Professional Studies) Logo

FoxPro Programming/MS Access

FoxPro Programming/MS Access course is offered by IIPS (Indian Institute Of Professional Studies). IIPS not only endeavors to impart training in highly professional skills to match the best in the world, but also plans to develop a sense of responsibility towards our own nation and society.

by IIPS (Indian Institute Of Professional Studies) [Claim Listing ]
CTC Education Logo

Advance Excel

Microsoft Excel course is offered by CTC Education for advance level. We also conduct classes for school students according to their syllabus. We try to perform many small real live projects in concerned class to improve the tricks & skills of students.

by CTC Education [Claim Listing ]
Talent Mark Academy Logo

Advance Excel Course

Our Advanced Excel 2019 course covers in-depth every topic you will need in your professional career for any industry whether banking, manufacturing, trading or service sector.

by Talent Mark Academy [Claim Listing ]
Shree Computer Training Center Logo

MS Access (2010)

MS Access course is offered by Shree Computer Training Center. Shree Computer Training Center offers short-term courses and certificate courses. Our courses are run and managed by seasoned professionals who lead a team of educators and trainers.

by Shree Computer Training Center [Claim Listing ]
Cloud Career Solutions Logo

MS Word

MS Word course is offered by Cloud Career Solutions.We provide all kinds of Software Training which provides you overall benefits for Academics and as well as Professional. We also provide training without any age constraint. Providing a Service with Best Quality is our Motive.

by Cloud Career Solutions [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy