• Learning about excel interface
• Understanding the basic features of excel
• Use of cell and inserting data in different formats
• Transposing cells
• Moving and copying worksheets and cells
• Opening and saving new workbooks
• Formatting Text
• Fonts and Borders
• Relevance of different fonts
• Designing option
• Create a new template
• Saving template with customized features
• Mastering basic formulas and functions
• Hands on exercises and applications of different functions and formulas
• Inserting and deleting Table
• Formatting table options
• Inserting data in table
• Formatting text in table
• Introduction to charts
• Learning about most commonly used charts
• Inserting and deleting shapes
• Use of complex shapes
• Combining shapes to create process flow, flow charts, hierarchies, etc
• Inserting and deleting objects
• Formatting objects
• Improving presentation if data
• Creating and inserting hyperlinks
• Modifying hyperlinks and use in practical framework

Who should attend

All those who use excel in their day to day work and use them for data entry creating simple reports, data mining, etc.

Our aim is to make all of you learn excel shortcuts and excel techniques in a way that helps you enhance your productivity and speed to make your work much easier and easy to interpret

Pre-requisites

All participants should have their laptop with preinstalled MS office