Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu. In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi.
Meaning Of Body Language
Gestures
Positives Of Body Language
Negatives Of Body Language
Its Importance In Daily Life
Meaning And Understanding Of Communication
Communication Process
Importance of Verbal Communication
Effective Ways Of Wriing
Best Practices Of Communication
Games to Improve communication And Listening Skills
Tricks to Improve Your memory
Games to improve Your Memory Power
Techniques to Study And Score Well
Memory Retrieval
Food , Nutrition’s & Exercise details to Improve Memory
Effective Study Habits during Exams.
Importance of email writing
Steps to send Email
Steps to Forward Emails
How to send Business Emails
Importance of Chat, IM, Texting
Importance of Email and Perception, Privacy, Copyright
Importance of Social Media, Blogs and Forums
Email Considerations...
Information on Time Management
Skills required for time management
How to Organize time
Information On Priority Matrix
Management Lessons
Spreadsheet basics
Creating, editing, saving and printing spreadsheets
Working with functions & formulae
Graphically representing data : Charts & Graphs
Analysing data : Data Menu, Subtotal, Filtering Data
Formatting worksheets , Securing & Protecting spreadsheets
Formulas & Macros Formulas:
Use the Function Wizard, Common functions (AVERAGE, MIN, MAX, COUNT,COUNTA, ROUND, INT)
Nested functions , Name cells /ranges /constants
Relative, Absolute, Mixed cell references : >,<,= operators
Logical functions using IF, AND, OR, NOT
The LOOKUP function , Date and time functions , Annotating formulas
Sub Total Reports, Auto Filter
Password Protecting Worksheets
Linking Multiple Sheets
Sheet Referencing
Linking Between Word/Excel/Ppt
Functions:- LOOKUP, VLOOKUP, HLOOKUP, COUNTIF, SUMIF
What-if-analysis, GOAL SEEK
PIVOT Tables, NESTED IF
Reporting
Character Functions
Date Functions
Age Calculations
Consolidation of Data
Data Validation
Definition and use , Record a macro
Assign a macro , Run a macro
Store a macro, Introduction to VBA Prog.
Develop the Worksheet:
Plan a worksheet , Row and Column labels
Split worksheet /box /bar, Copy data and formulas
Display /move toolbars , Enhance worksheet Appearance
Special Operations:
Use multiple windows : Copy/ paste between Worksheets
Link worksheets , Consolidate worksheets
Import and link from other Applications
Use AutoFormat : Create, use and modify styles and templates
Print features : Create /edit an outline
Create charts , Enhance charts, Drawing toolbar features