EXCEL INTRODUCTION

EXCEL FORMATTING

EXCEL LOGICAL FUNCTION

• EXCEL OVERVIEW
• EXCEL WORKSHEET
• EXCEL RANGES
• EXCEL RELATIVE REFERENCE
• EXCEL ABSOLUTE REFERENCE

• EXCEL FORMAT PAINTER
• EXCEL FONT
• EXCEL ALIGNMENT
• EXCEL NUMBER FORMAT

• AND
• OR
• IF
• IFS
• IFNA
• IFERROR

EXCEL BASIC STATISTICAL FUNCTION

EXCEL ADVANCE STATISTICAL FUNC

EXCEL DATABASE FUNCTION

• MIN
• MAX
• SUM
• COUNT
• COUNTA
• COUNTBLANK
• AVERAGE

• COUNTIF
• COUNTIFS
• SUMIF
• SUMIFS
• AVERAGEIF
• AVERAGEIFS

• DCOUNT
• DCOUNTA
• DSUM
• DAVERAGE

ALTER CONSTRAINT

EXCEL DATA ANALYSIS

EXCEL PIVOT

• HLOOKUP
• VLOOKUP
• MATCH
• INDEX
• OFFSET
• SUMPRODUCT

• SORT
• FILTER

• EXCEL PIVOT