MS Excel

by GIT Solutions Pvt Ltd Claim Listing

Microsoft Excel is a spreadsheet program that is used to record and analyse numerical data. Think of a spreadsheet as a collection of columns and rows that form a table. Alphabetical letters are usually assigned to columns and numbers are usually assigned to rows.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

GIT Solutions Pvt Ltd Logo

img Duration

30 Hours

Course Details

Microsoft Excel is a spreadsheet program that is used to record and analyse numerical data. Think of a spreadsheet as a collection of columns and rows that form a table. Alphabetical letters are usually assigned to columns and numbers are usually assigned to rows.

The point where a column and a row meet is called a cell. The address of a cell is given by the letter representing the column and the number representing a row.

 

Content:

  • Calculating Data with Advanced Formulas
  • Manage Cell and Range Names
  • Calculate Data Across Worksheets
  • Use Specialized Functions
  • Analyze Data with Logical and Lookup Functions
  • Organizing Worksheet and Table Data
  • Create and Modify Tables
  • Format Tables
  • Sort or Filter Worksheet or Table Data
  • Calculate Data in a Table or Worksheet
  • Presenting Data Using Charts
  • Create a Chart
  • Modify Charts
  • Format Charts
  • Customizing and Enhancing Workbooks and the Excel Environment
  • Customize the Excel Environment
  • Customize Workbooks
  • Create and Use Templates
  • Working with Built-in Functions
  • Use the IF function.
  • Use the SUMIF function.
  • Use the nested IF function.
  • Use the PMT function.
  • Use the lookup (VLOOKUP, HLOOKUP) functions.
  • Use the MATCH and INDEX functions.
  • Use database functions.
  • Use Date & Time Function, Trim, Round, Ceiling etc.
  • Working with Multiple Workbooks
  • Vizag Branch

    47-3-29/2, 5th lane, Vizag

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