Excel Introduction •
An overview of the screen, navigation and basic spreadsheet concepts • Various selection techniques • Shortcut Keys Customizing Excel • Customizing the Ribbon • Using and Customizing AutoCorrect • Changing Excel’s Default Options Using Basic Functions • Using Functions – Sum, Average, Max,Min, Count, Counta • Absolute, Mixed and Relative Referencing
"Formatting and Proofing
• Currency Format • Format Painter • Formatting Dates • Custom and Special Formats • Formatting Cells with Number formats, Font formats, Alignment, Borders, etc • Basic conditional formatting
Mathematical Functions
• SumIf, SumIfs CountIf, CountIfs AverageIf, AverageIfs, Nested IF, IFERROR Statement, AND, OR, NOT
Protecting Excel •
File Level Protection • Workbook, Worksheet Protection Text Functions • Upper, Lower, Proper • Left, Mid, Right • Trim, Len, Exact • Concatenate • Find, Substitute