Advanced Excel Training In Kolkata

Paid Courses for Advanced Learning Services

MS. Office & Advance Excel

advanced Abacus training

Referencing in Excel – Concept of Relative Referencing, Absolute Referencing and Mixed Referencing. SUMPRODUCT () SUBTOTAL() Linking Excel to Website What – If – Analysis Multi Level Sorting Advanced Filter Feature PASTE SPECIAL Feature HLOOKUP () VLOOKUP () MATCH () Function INDEX () Function MATCH WITH INDEX CHOOSE VLOOKUP WITH CHOOSE TWO WAY TABLE LOOKUP Conditional Formatting DATA VALIDATION MACRO PIVOT TABLE AND PIVOT CHART   SPECIAL TIPS AND TRICKS

Advanced Excel and VBA Macros VBA, which stands for Visual Basic for Applications, is a programming language developed by Microsoft you know, the company run by the richest man in the world. Excel, along with the other members of Microsoft Office 2003, includes the VBA language (at no extra charge). In a nutshell, VBA [...]

Join our comprehensive computer courses Basic/Tally /DCA/DFA /EXCEL/Web Design & Development /VIDEO EDITING /GRAPHIC DESIGN /DCA/DFA /Tally /excel at Career Speak Education call and master the art of crafting captivating websites. Learn HTML, CSS, JavaScript, PHP, and MySQL to create visually stunning and functional designs. Develop responsive websites, enhance user experience

Advance Excel Training Institute Service

TallyTally is a financial accounting and inventory software developed by Tally Solutions, Bangalore, India. It is trusted by Chartered Accountants, Government Departments and Business alike. Currently its used in 88 countries beyond its native India, including the United Kingdom, and the Middle East. Tally financial accounting software offers several benefits to provide you with hassle-free accounting. The highly integrated approach, coupled with real-time updates allows you to view the latest and up to the minute reports without running any posting.Advanced ExcelThese days, any managerial or analyst role requires that you work with data. Excel remains one of the most powerful and easy to use tools when it comes to crunching data. Learning Excel in a proper, structured way can not only help you save time, but it will also help you become better at your job and can give you time to focus on things and people that matter.As a professional in your field, you already know the benefits of using Microsoft Excel. There is a way to make it an even more powerful tool in the management of your business. The benefit of additional Microsoft Excel training will give you a more efficient vision of your operation as well as improve your bottom line. Advanced Microsoft Excel training courses can help improve employee productivity by allowing mundane tasks to be completed more efficiently Candidates Eligibility (Who Should Attend):The course is all based in Finance and Accounts so if anyone who has knowledge of account can do this course. But thats not mean that one who do not know about accounts cannot do this just he need a little knowledge of account and then he will do this.But the below is our recommended target audience.1. Students and Professionals who already have prior exposure to Finance and accounting.2. Students who completed Graduation or studying in college preferably from the commerce, BBA, MBA backgrounds.3. Organizations who want to provide training to their employees.4. Anyone interested in learning accounting processes within Tally.5. IT staff and Accounting and Finance department managers and staff.6. Executives and managers who have already been using Microsoft Excel, but now feel the need for learning more powerful features and options of Excel, to manage their worksheet-related tasks more efficiently.Course Outline:Tally1. Accounting Software2. Why use Tally to maintain Account3. Advantage over manual Accounting4. Creation of Company / Accounts only?5. Accounts with Inventory6. Alt the company7. Creation of password / security8. Opening the company making it active9. Altering individual ledger a/c10. Viewing / Altering multiple ledger on screen11. Inventory creation / Altering stock group /stock items12. Entering Voucher13. Payment voucher / Receipt Voucher / Contra voucher/ journal voucher14. Purchase voucher / Sales voucher / Purchase return/ Sales Return15. Purchase Order / Sales order / Stock Journal /Voucher physical16. Stock voucher / Rejection out voucher / Rejection In voucher17. Easy Access to the various Books of Account18. Cash Book / Bank Book / Purchase Book / sales Book /19. Journal voucher book / Debit Note book / Credit Note Book20. Day Book / Ledger Book21. Automatic Creation of Financial Accounting Statement22. Trial Balance23. Trading A/c24. Profit & Loss A/c25. Balance Sheet26. Stock Summary27. Ratio Analysis28. POS

Spreadsheets are the most common tools employed globally for storing data. But there is more to spreadsheets than just being a repository of data. Spreadsheets can be effectively used to convert raw data into meaningful information, so that it can be optimally used for various purposes and shared with greater confidence. Since MS Excel is the most common software used for spreadsheet, the Workshop on MS Excel has been designed to provide hands-on experience. The workshop aims to impart the basic and advanced techniques of Excel to acquaint users with the latest technology as well as lessen their work load. We, at Career Skills Academy, believe in practical oriented training methodology, and thus we conduct a hands on workshop to enrich the existing knowledge in professionals and help them explore unimaginable possibilities. Who Should Attend This Workshop? Why? Workshop on MS Excel is a common platform for all to learn the nitty-grittys of spreadsheet application. It is for Executives, who are familiar with the basic functionality of spreadsheets, yet are unaware of its advanced techniques. It is for students of professional courses, who use spreadsheet at on elementary level and will have to graduate to advanced features during their academic and career pursuits. Ordinary laymen, who use spreadsheets in their day to day lives, can also take part in this workshop to learn more about the application and thus expand the horizons of their knowledge and possibilities. Workshop on Advanced Spreadsheet is an endeavor by Career Skills Academy to spread awareness about the application and thus help the users to utilize it optimally. Course Content This workshop is specifically designed for professionals and graduate students who need to learn about the advanced ways of using spreadsheets for complex issues. This knowledge packed workshop starts with an introduction to MS Excel. Tentative list of topics which are covered in the seminar.