Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

"Microsoft Excel - includes VBA practitioner level" is no longer available

No Reviews Yet

Ramapuram, Chennai

Course ID: 42758

Ramapuram, Chennai

Kothai picture
Kothai
No Reviews Yet

About the Course

Learner level: Novice/ Practitioner in Excel.


Course outcome: Learn to access salient features of Excel including VBA macro.
 


� 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.


â?¢ Excel macro using VBA enabling automation within excel.


 


 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


13. Excel macro - Introduction


14. Recording macro


15. VBA - Forms and controls


16. Automation strategizing


17. Macro examples


18. VBA optimization

Date and Time

Not decided yet.

About the Trainer

Kothai picture

Avg Rating

Reviews

Students

Courses

Kothai

MCA

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

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