MS-Office
ADVANCE EXCEL
ADVANCE EXCEL
MICROSOFT WORD:
- Working with Documents and Keyboard
- Navigating Through a Word Document
- Basic Text Editing
- Text Formatting
- Paragraph Formatting
- More ways to format text and paragraphs
- Style formatting
- Page formatting
- Templates
- Working with Graphics and Pictures -Tables
MICROSOFT POWER POINT:
- Introduction to PowerPoint
- Exploring the power
- P
MICROSOFT WORD:
- Working with Documents and Keyboard
- Navigating Through a Word Document
- Basic Text Editing
- Text Formatting
- Paragraph Formatting
- More ways to format text and paragraphs
- Style formatting
- Page formatting
- Templates
- Working with Graphics and Pictures -Tables
MICROSOFT POWER POINT:
- Introduction to PowerPoint
- Exploring the power
- Point interface
- Views
- Navigation & Keyboard shortcut
- Opening & Saving files
- Setting up a New file
- Changing Backgrounds
- Place holders & bullets
- Adjusting Placeholders
- Adding Headers & Footers
- Transition & Animation effects
- Power Point Design Essentials
MICROSOFT EXCEL:
- The Basics of data
- Managing workbook structure
- Formatting cells
- The basics of functions
- Working with formulas
- Working with graphics
- Working with hyperlink
- Working with chart
- Sorting, Filtration and Validation
- Customizing excel
- Preparing files for distribution
MICROSOFT OUTLOOK:
- Introduction to Outlook
- Navigating Outlook
- Email Id creation
- Sending & Receiving messages
- Formatting messages & Others
ADVANCE EXCEL
ADVANCE EXCEL
ADVANCE EXCEL
INTRODUCTION TO ADVANCE EXCEL
- Get a head start with templates and set up an Excel Template
- Create new default workbook and work sheet templates
- Learn how modular templates can make your spread sheets more consistent and much quicker to set up
- Customizing the Excel interface to put the tools that you need at your finger tips
- How to bui
INTRODUCTION TO ADVANCE EXCEL
- Get a head start with templates and set up an Excel Template
- Create new default workbook and work sheet templates
- Learn how modular templates can make your spread sheets more consistent and much quicker to set up
- Customizing the Excel interface to put the tools that you need at your finger tips
- How to build in checks and controls from the outset
- Key techniques that reduce risk and increase automation and efficiency
- Documentation and review tools
GROUPING & OUTLINING AND SUBTOTALS:
- Outlining & grouping data
- Using the subtotals tool
WHAT- IF ANALYSIS:
- Exploring Scenarios
- Goal Seek and Data tables
- Using Solver, Data Validation
PIVOT TABLES:
- Getting Started with Pivot Tables
- Displaying data in Pivot Table
- Formatting a Pivot Table
- Using the Classic Pivot Table
CHARTING PIVOT TABLE:
- Getting Started with Pivot charts
- Using Pivot chart tools tabs
- Formatting a Pivot Chart
ADVANCED EXCEL TASKS:
- Hyperlinks
- Custom AutoFill list
- Sharing workbooks
VLOOKUP AND HLOOKUP
- Vlookup and Hlookup functions
- Nested Vlookup
FUNCITONS & FORMULAS
- Stats formulas
- Text functions
- Lookup and reference functions
- Other formulas- ( tax calculation, interest, debit & credit, depreciations etc)
MACROS
- Recording and Playing Macros
- Copying and Deleting Macro
- Visual Basic and Macros
TALLY PRIME
ADVANCE EXCEL
TALLY PRIME
- User Interface and Company Management
- Masters – Groups and Ledgers (chart of Account)
- Inventory Masters-Stock group, Stock category, stock Item etc
- F11 and F12 features
- Masters – Various Vouchers (Accounting, Inventory, Pay roll and Non accounting) Account Payables and Account receivables
- Purchase Order Processing Sales Order Processing
- User Interface and Company Management
- Masters – Groups and Ledgers (chart of Account)
- Inventory Masters-Stock group, Stock category, stock Item etc
- F11 and F12 features
- Masters – Various Vouchers (Accounting, Inventory, Pay roll and Non accounting) Account Payables and Account receivables
- Purchase Order Processing Sales Order Processing
- Goods and Services Tax (GST)
- Processing of Purchase and sales with GST
- Purchase and sales return with GST
- Bank Reconciliation
- Manufacturing Journal
- Cost center and Cost Category
- Banking Aspects- chequeprinting, Reconciliation etc
- Batch wise details in tally
- Interest calculation
- Multi currency transactions
- Tax Deducted at Source
- Payroll in tally
- Closing entries-how to finalize
- Various reports- Financial, Inventory and Statutory
- Export of data
- Backup and Restore
- Tally vault and user level security features
- Edit log
6a. Powerful Placement Strategy
We follow a simple & powerful WIN WIN WIN Strategy. We encourage our students to make activities on daily basis, examination & Support in development of projects using the respective software's.
6b. Resume Writing Sessions
A good resume is important because it helps our CADDESk/ITDESK students to create first positive impression, demonstrate qualifications, and show a good fit for the job with all the the required skills
6c. Speed Up Examinations
6c. Speed Up Examinations
Speed up examinations makes the students to understand the Practical CAD Interview examinations
6d.Technical Sessions
6f. Awareness & Confidence Development Sessions
6c. Speed Up Examinations
Technical Sessions gives technical knowledge, practical awareness & important interview questions which a Design Engineer will be facing during the Interviews & Career.
6e. Aptitude Sessions
6f. Awareness & Confidence Development Sessions
6f. Awareness & Confidence Development Sessions
Aptitude sessions can be beneficial in a number of ways for our CADDESK/ITDESK Students.
Aptitude sessions make the student active and participative and develops the ability of problem-solving skills.
6f. Awareness & Confidence Development Sessions
6f. Awareness & Confidence Development Sessions
6f. Awareness & Confidence Development Sessions
General awareness sessions gives the career guidelines and directional advices of how important are appointment letters, relieving letters, exp. certificates etc. and how to avoid career gaps. Steps to take in the organization for fast and quick growth, there by develops the confidence to students.
Low Communication Skills
Lack of Technical Knowledge
Low Communication Skills
We observe few of the students have the issue with communication.
- Problem of fluency
- Problem of sentence formation
- Nervousness during Interview
- Stage fear
We give separately english communication classes to weak students in english
Lack of Sofware skills
Lack of Technical Knowledge
Low Communication Skills
Few students does not have software knowledge & Few students may have software knowledge in 1-2 softwares.
But the students who have basic software knowledge in 1-2 softwares lag in speed, accuracy & perfection which lead to Failure during interviews.
To avoid this failure, we make our students to practice the software every day and develop project works.
Lack of Technical Knowledge
Lack of Technical Knowledge
Lack of Technical Knowledge
Few students believe that with only software knowledge they can get the jobs, but practically majority of the organizations take the Technical Interviews.
Technical Interviews focus on overall grip in the Fundamentals & Practical knowledge.
To avoid failure in Technical area, we specailly teach Technical and practical aspects to the students included with the software course programs.
Career Gap
Lack of Technical Knowledge
Lack of Technical Knowledge
Many students knowingly or unknowingly enter into the trap of Career gap, due which majority of rejections are observed.
We give special sessions to the students, how to show in resumes and present during the Inteview's about career gap.