Course Detail

Home / Course Detail
Microsoft Excel Office Course

Microsoft Excel Office Course - CIA Softango Education Pvt. Ltd.

Course Detail

Email to Friend Share Course Report Abuse

Course Description

  • 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

Apply Now Quick Query

Institute Overview

CIA Softango Education Pvt. Ltd.
Jammu, Jammu and Kashmir, India
11 Current Posted Courses

We have trained more than 30,000 youths in Tally, Account, Finance, Taxation and in other skilled based courses. The dream behind was to develop a cadre of skilled youth. CIA (Softango Education Pvt. Ltd) dreams to fill the gap and convert unskil... Read More

Related Courses

Google Map

Quick Links
Courses By City
Courses By Categories
Contact Us
Copyright © 2025 TrainWick.com. All Rights Reserved - Trainwick