CERTIFICATE IN ADV EXCEL ( S-STPEX01 )

Advanced Excel Syllabus

Introduction to Excel

A description of the interface, the menu system, and the fundamentals of spreadsheets

• Various methods of selecting
• Short Cut Keys

Personalising Excel

• Changing Excel’s Default Options Using AutoCorrect and Customizing It Customizing the Ribbon

Understanding and Using Basic Functions

• Using Functions – Sum, Average, Max, Min, Count, Counta
• Absolute, Mixed, and Relative Referencing

Text Functions

• Upper, Lower, Proper
• Left, Mid, Right
• Trim, Len, Exact
• Concatenate
• Find, Substitute

Arithmetic Functions

• SumIf, SumIfs CountIf, CountIfs AverageIf, AverageIfs

Proofing and Formatting

• Formatting Cells with Number formats, Font formats, Alignment, Borders, etc
• Basic conditional formatting

Protecting Excel- Excel Security 

• File Level Protection
• Workbook, Worksheet Protection
• datavalidation
• mis report
• vlookup
• hlookup
• pivot table

minimum 10th