Two weeks
Monday – Friday
1hr
250,000/=
Practical and Theory Exams
Prerequisite:
– Willingness to Learn
– Must know English Language
– Must know Ms.Office Basic Excel
Overview:
Microsoft Office Excel is a spreadsheet application that is part of the Microsoft Office suite. It is widely used for data organization, analysis, and visualization. Excel is available for both Windows and Mac, and it offers a range of features for managing numerical data, performing calculations, and creating reports. Here’s an overview of the basic features of Excel.
Course outline
Logical Function
Nesting Function
Rank and RankAverage Function
Mathematical Function
-(Round-Up, Round-Down and Sum-if, Average-if, Count-if Function
Text Function
-(Left, Right, Trim, Upper, Lower and Concatenate function
Conditional Formatting
Chart/Graph formatting
Mail merge in Excel
Filters, Paste special functions
Statistical Function
-Mean, Median, Mode, Standard deviation
Freeze Panes
Lookup Function
-Horizontal and Vertical lookup function
