Our Courses
Schedule
Morning
Afternoon
Evening
Advance Excel
Advanced Excel courses provide comprehensive training in advanced features and functions of Microsoft Excel, equipping individuals with the skills to excel in data analysis, reporting, and automation. Students delve into advanced formulae, data visualization, and pivot tables. They also gain proficiency in VBA programming for automating tasks and creating customized macros. The courses often cover advanced data modeling and extensive charting techniques, ensuring participants can handle large datasets and generate insightful reports efficiently. By the end of the course, students are adept at data manipulation, which is invaluable for making informed decisions and streamlining business processes. Moreover, these courses emphasize collaboration and data protection, offering insights into sharing and securing Excel workbooks. They may also explore Excel's integration with other Microsoft Office applications and external data sources, making the software even more versatile. Whether you're a business professional, analyst, or student, an advanced Excel course can significantly enhance your spreadsheet skills and open doors to more advanced and efficient data management and analysis techniques.
Schedule
Morning
Afternoon
Evening
Advanced Excel and Power BI
The "Advanced Excel & Power BI" course is designed to enhance your data analysis skills by diving deep into both Excel and Power BI. You'll master sophisticated Excel techniques, including complex formulas, advanced PivotTables, and automation with macros and VBA. In Power BI, you'll learn to import and transform data, build intricate data models, and create dynamic visualizations and interactive dashboards. The course focuses on practical applications, using real-world scenarios to ensure you can effectively apply these skills in your professional environment.Through hands-on exercises and expert guidance, this course will empower you to handle complex data challenges and create insightful reports that drive decision-making. By integrating advanced features of Excel and Power BI, you'll be equipped to turn data into actionable intelligence, elevating your capabilities and opening up new opportunities for career growth.
Schedule
Morning
Afternoon
Evening
Data Analysis and Visualization with Microsoft Power BI
Course SynopsisData Analysis and Visualization with Microsoft Power BI is a comprehensive 60-hour training program designed to build proficiency in using Power BI for insightful and interactive data analytics. Power BI is an affordable, user-friendly business intelligence tool that simplifies the data analysis process. It empowers users to connect to various data sources, transform raw data, and create visually compelling dashboards and reports. The course requires no prior coding knowledge—though basic SQL can be helpful for data connections—and is ideal for professionals and students alike seeking practical, hands-on data analysis skills. Required TextbooksBrett Powell, Mastering Microsoft Power BI, Packt.Roger F. Silva, Power BI: Create and Learn, Business Intelligence Clinic. Completion CriteriaA student will be considered to have successfully completed the module upon fulfilling all the following conditions:Minimum 90% attendance in all scheduled classes.An average grade of 80% or higher on all assignments.An average of 60% or higher in formal assessments.Positive evaluation from the tutor confirming the student has grasped key concepts and is ready for the next level. PrerequisitesA basic understanding of mathematics and logical thinking.A willingness to commit at least 10 hours per week to learning, including hands-on practice.Familiarity with Microsoft Excel and basic database concepts is beneficial.Most importantly, a strong desire to learn and apply data analysis skills.
Schedule
Morning
Afternoon
Evening
DIPLOMA IN TALLY, THE ACCOUNTING APP CHANGE
Course SummaryTally accounting software has been highly used for monetary control, invoicing, reporting, and sales management. Globally, many firms have adopted Tally accounting software as a part of their financial management system. The Tally Course at DTC will familiarize you with all the concepts, rules and features of accounting making you efficient at bookkeeping using Tally ERP 9. Required TextbooksAshok K. Nadhani, “Implementing Tally. ERP 9”, BPB Publications. Completion Criteria After fulfilling all of the following criteria, the student will be deemed to have finished the Module: Has attended 90% of all classes held. Has received an average grade of 80% on all assignments Has received an average of 60% in assessments. The tutor believes the student has grasped all of the concepts and is ready to go on the next module. Prerequisites Fundamental understanding of basic accounting concepts. If you are only interested in theory and have no interest/patience in spending at least 10hours every week throughout the duration of the course, then this course might not be for you. If you have absolutely no idea about accounting or do not see yourself doing accounting tasks in the next six -odd months, then this class may not be for you.
Schedule
Morning
Afternoon
Evening
FINANCIAL ACCOUNTING
Course SynopsisTally accounting software has been highly used for monetary control, invoicing, reporting, and sales management. Globally, many firms have adopted Tally accounting software as a part of their financial management system. The Tally Course at DTC will familiarize you with all the concepts, rules and features of accounting making you efficient at bookkeeping using Tally ERP 9. Required Textbooks Ashok K. Nadhani, “Implementing Tally. ERP 9”, BPB Publications. Completion CriteriaAfter fulfilling all of the following criteria, the student will be deemed to have finished the Module:Has attended 90% of all classes held.Has received an average grade of 80% on all assignments.Has received an average of 60% in assessments.The tutor believes the student has grasped all of the concepts and is ready to go on to the next module. PrerequisitesFundamental understanding of basic accounting concepts.If you are only interested in theory and have no interest/patience in spending at least 10 hours every week throughout the duration of the course, then this course might not be for you.If you have absolutely no idea about accounting or do not see yourself doing accounting tasks in the next six -odd months, then this class may not be for you.
