"Microsoft Excel - Intermediate level" is no longer available

No Reviews Yet

Ramapuram, Chennai

Course ID: 42757

Ramapuram, Chennai

Kothai picture
Kothai
No Reviews Yet

Date and Time

Not decided yet.

Kothai picture
Kothai

MCA

About Kothai

Corporate trainer for Microsoft applications.
Specialized in Excel formulae, Shortcuts & macro.
No reviews currently

About the Course

Learner level: Novice/ Practitioner in Excel.


Course outcome: Learn to access basic and salient features of Excel.
 


� Excel application basics - File properties, user settings and object reference.


� Access information from textual data like length of the text, find whether the given text contains any specific term, extract required part of the string, etc.


� Access date values to find day/ week/ month of specific date, calculate duration between two dates in required format considering official calendar, calculate age/ experience/ upcoming dues which are helpful in planning tasks.


� Enables to manipulate data using aggregate functions like counting/ sum up given values, find maximum/ minimum from set of values and verify data using logical functions like AND, OR, IF, etc.


� Search specific value and Look up related information of the searched value in collection of data or huge table.


� Format excel data that includes font sizing, font format and font color, cell highlighting with colors, vertical alignment and horizontal alignment within a cell, border coverage and border thickness.


â?¢ Dynamic formatting using one or more rules


â?¢ Structure data into meaningful information by presenting it as tables. Using pivot functions to handle table updates and output with drag and drop options and aggregate functions.


â?¢ Create visual outputs of the tabulated data using excel graphs with variety of templates and designs.


� Covers shortcuts required for frequently used excel actions.


� Includes practice exercises for each topic.


 


 Syllabus:


1. Excel application - Basics


2. Text functions


3. Date functions


4. Aggregate and Logical functions


5. Search/ Look up functions


6. Formatting - basics


7. Formatting - Dynamic/ Conditional


8. Tables


9. Graphs


10. Frequently used Short cuts


11. Practice exercises


12. Excel best practices

Reviews

No reviews currently

Discussions

Post your requirement and let us connect you with best possible matches for Microsoft Excel Training classes Post your requirement now

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more