LEARN EXCEL QUICKLY!Event title: One-Day Excel Workshop
Location: No. 9,
Savitri Cinema Commercial Complex,
Greater Kailash-2,
New Delhi-110048
Phone: 011-29213339
Cell: 9810081867
Details: Workshop conducted by Dr. Dinesh K Takyar (Ph. D., Germany).
It will make you a comfortable Excel user.
Topics covered include:
- Structure of an Excel worksheet
- Understanding cell address
- Data types used in Excel
- Formatting Data
- Inputting data accurately
- Data Validation
- Getting information from Excel Data
- Autofilter
- Advanced Filter
- Presenting your data
- Charts
- Pivot Tables
- What-if analysis
- Goal Seek
- Solver
- Scenarios
- Formulas
- Functions
- User Forms
- Using Dates
- Using Time
- Manipulating Text
- In cell graphs
Event title: One-day Macros workshop
Location: No. 9
Savitri Cinema Complex
Greater Kailash-2
New Delhi-110048
Details: Macros Workshop by Dr. Dinesh Takyar:
- Recording a macro
- Understanding the recorded macro
- Creating a simple macro
- Acessing cells and cell ranges using a macro
- Performing calculations using a macro
- Active cell concept
- Accessing the first empty row
- Using loops
- User forms
- Transferring data and calculations from userforms to the Excel worksheet
- Custom queries
Event title: PERSONALIZED TRAINING FOR TOP MANAGERS
Location:
Dr. Dinesh K Takyar
S-203,
Greater Kailash-2
New Delhi-110048
Phone: 9810081867
OR
No. 9, Savitri Cinema Complex,
Greater Kailash - 2,
New Delhi-110048
Cell: 9810081867
Details:
- Guidelines for entering data
- Data Validation
- Formatting data
- Working with large worksheets
- Copying and pasting data
- Creating Charts
- Using Functions
- Getting information from your data
- Advanced Filter
- Pivot Tables
- Vlookup
- Goal Seek
- Solver
- Printing
Learn important practical aspects of Excel quickly!
FREE EXCEL TRAINING
|