Advance Excel Part 1 Course Information Categories: Advanced Excel Exclusively Discounted KSh2,999.00 3 months of access Excel Introduction Overview of Screen, Navigation and Spreadsheet Concepts Various Selection Techniques Shortcut Keys Customizing Excel Customizing the Ribbon Using and Customizing AutoCorrect Changing Excel’s Default Options Using Basic Functions Functions: Sum, Average, Max, Min, Count, Counta Absolute, Mixed and Relative Referencing Mathematical Functions SumIf, SumIfs, CountIf, CountIfs, AverageIf, AverageIfs Protecting Excel File level Protection Workbook, Worksheet Protection Text Functions Upper, Lower,Proper Left, Mid, Right Trim, Len, Exact Concatenate Find, Substitute Date and Time Functions Today, Now Day, Month, Year Date,DateIf,DateAdd EOMonth,Weekday Advanced Paste Special Techniques Paste Formulas, Paste Fomats Paste Validations Transpose Tables Sorting & Filtering Filtering on Text, Numbers & Colors Sorting Options Advanced Filters
