MS Excel

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