What you'll learn -

Microsoft Excel

• Introduction & Installation
• Overview of MS Excel
• Understanding the Structure of the Workbook & Worksheet
• Introduction to the Excel Interface
• Syntax
• Ranges
• Fill
• Copying
• Sequences
• Dates
• Functions(*)
• Move Cells
• Add Cells
• Delete Cells
• Undo Redo
• Relative Reference
• Absolute Reference
• Arithmetic Operators
• Parentheses
• Format
• Format Painter
• Format Colors
• Format Fonts
• Format Borders
• Format Numbers
• Format Grids
• Format Settings
• Data Analysis
• Sort
• Filter
• Tables
• Conditional Format
• Highlight Cell Rules
• Top Bottom Rules
• Data Bars
• Color Scales
• Icon Sets
• Manage Rules
• Charts
• Functions & Formulas
• AND, OR, NOT
• AVERAGE, AVERAGEIF, AVERAGEIFS
• CONCAT, COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS
• IF, IFS, IFERROR, IFNA
• LEFT, RIGHT
• LOWER
• MAX, MEDIAN, MIN, MODE
• Net Presend Value (NPV)
• RAND, RANDBETWEEN, RADIANS, RATE, etc
• STDEV.P, STDEV.S
• SUM, SUMIF, SUMIFS, SUBTOTAL, SUMPRODUCT, etc
• TRIM, TRANSPOSE, TREND, TRUNC, etc
• XOR
• Remove Duplicate
• Pivot Table
• VLOOKUP, HLOOKUP
• Basic Macros
• Assignments
• Project