MIS Training – Advance Excel + Macro + Access + SQL
What you'll learn
Advance Level Excel
Expertise in Using Text Function
Expertise in Using Logical Function
Expertise in Using Math Function
Expertise in Using Lookup & Reference Function
Expertise in Using Date and Time Function
Expertise in Using Pivot Table and Chart
Expertise in Power Pivot and Power Map
Expertise in Using What If Analysis Tools
Many Others Excel Tools
MS Access Knowledge on Table, Form, Queries and Reports
SQL Queries
Macro Recording
Excel VBA Object Handling with practical Project
Excel VBA Variable with practical Project
Excel VBA IF & Case with practical Project
3 Types of Loop with practical Project
Create your own Function
Events in VBA
FSO in Excel VBA
Userform in Excel VBA
Automate Pivot and Outlook in Macro
Many More Macro Topics and Projects
MIS Training – Advance Excel + Macro + Access + SQL
What you'll learn
Advance Level Excel
Expertise in Using Text Function
Expertise in Using Logical Function
Expertise in Using Math Function
Expertise in Using Lookup & Reference Function
Expertise in Using Date and Time Function
Expertise in Using Pivot Table and Chart
Expertise in Power Pivot and Power Map
Expertise in Using What-If Analysis Tools
Many Others Excel Tools
MS Access Knowledge on Table, Form, Queries and Reports
SQL Queries
Macro Recording
Excel VBA Object Handling with practical Project
Excel VBA Variable with practical Project
Excel VBA IF & Case with practical Project
3 Types of Loop with practical Project
Create your own Function
Events in VBA
FSO in Excel VBA
Userform in Excel VBA
Automate Pivot and Outlook in Macro
Many More Macro Topics and Projects
Master Software Testing
What you'll learn
Crystal clear understanding on how Software Projects are handled in real time with Live examples
In Depth understanding of current Software Testing methodologies with Manual testing tools followed in the Industry
Understand JIRA (Project management tool) and Tester activities in the Jira from Scratch
Thorough knowledge on latest Practices like Agile scrum, SDLC, Testdriven, Behaviour driven approaches
In Depth knowledge on writing test cases in Jira using Xray app on Live Project
Strong exposure on designing test cases and defect life cycle process
Complete knowledge on QA process starting from requirement gathering to Project delivery
Testing types and their real time usages in Projects at different stages
Top 50 Frequently asked Software Testing Interview Questions with Solutions
Basic knowledge of SQL
Manual Testing Course
What you'll learn
Crystal clear understanding of how Software Projects are handled in real-time with Live examples
In Depth understanding of current Software Testing methodologies with Manual testing tools followed in the Industry
Understand JIRA (Project management tool) and Tester activities in the Jira from Scratch
Thorough knowledge on latest Practices like Agile scrum, SDLC, Testdriven, Behaviour driven approaches
In Depth knowledge on writing test cases in Jira using Xray app on Live Project
Strong exposure on designing test cases and defect life cycle process
Complete knowledge on QA process starting from requirement gathering to Project delivery
Testing types and their real time usages in Projects at different stages
Top 50 Frequently asked Software Testing Interview Questions with Solutions
Basic knowledge of SQL
-20%
LoadRunner Testing Course
What you'll learn
Students reported that they were able to troubleshoot the issues faced in the real projects after taking this class
Even if you are using any other performance testing tool, this course will provide you core guidelines for utilizing it for maximum benefits in less time.
By end of the course, you will learn to develop a workable strategy for load testing of an enterprise system and be ready to handle any performance testing project
-8%
Jira Training
What you'll learn
In this course you will learn about JIRA from very basic till advanced.
This course will cover SDLC in JIRA and explained how you can do Test Management,
It will cover Agile Software Development, Reporting and much more with JIRA.
This course will cover Project Management, Defect Management,
-25%
Java Development Course
What you'll learn
Be able to program in Java professionally.
Get hands-on experience and solve 100+ coding exercises.
Learn Java best practices from a professional developer.
Become proficient in Java 11.
Learn advanced Java concepts that you can present to prospective employers.
Acquire the Java skills needed to pursue Web Development (Spring Boot), Android Development, Automation, and more!
-30%
Investment Analysis Portfolio Management Course
What you'll learn
Calculate stock returns manually as well as on Excel and Google Sheets, using real-world data obtained from free sources.
Estimate the Expected Returns of Stocks using the Mean Method, State Contingent Weighted Probabilities, as well as Asset Pricing Models.
Calculate the total risk, market risk, and firm-specific risk of stocks from scratch, and explore how the different risks interact.
Understand why the math works, and why equations work the way they do - even if your math is weak and if math freaks you out.
Witness the power of diversification and how the risk of your portfolio can be lower than the individual assets that make up the portfolio!
Measure your investment portfolio's performance by calculating portfolio returns and risks.
Optimize your investment portfolios by maximizing your returns while minimizing your risk.
Decompose Diversification so you understand why it actually works (hint: it's the mathematical "magic" of Rho)
I PHONE Application Development
What you'll learn
IOS Releases
Xcode IDE Installation and Use
MVC Architecture
Objective-C
NeXTStep Object Support
System Event Handling
Multithreading Support
Web Service Support
Multi-Platform Development
Cloud Service
Games and Graphics Support
HTML5 TRAINING
What you'll learn
Become a modern and confident HTML and CSS developer, no prior knowledge needed!
Design and build a stunning real-world project for your portfolio from scratch
Modern, semantic and accessible HTML5
Modern CSS (previous CSS3), including flexbox and CSS Grid for layout
Important CSS concepts such as the box model, positioning schemes, inheritance, solving selector conflicts, etc.
A web design framework with easy-to-use rules and guidelines to design eye-catching websites
How to plan, sketch, design, build, test, and optimize a professional website
How to make websites work on every possible mobile device (responsive design)
How to use common components and layout patterns for professional website design and development
Developer skills such as reading documentation, debugging, and using professional tools
How to find and use free design assets such as images, fonts, and icons
Practice your skills with 10+ challenges (solutions included)
Google Adwords Course
What you'll learn
Run a Google Adwords Campaign that captures high-quality leads for your business or website
-20%
Goods and Services Tax (GST) Course
What you'll learn
GST (Goods and Services Tax) in India
Supply under GST
Charge of GST
Exemptions from GST
Place of Supply - Definitions, Sections 10, 11, 12(i), 12(ii), 13
Time of Supply - Definitions, Sections 12, 13, 14
Value of Supply - Definitions, Provisions, Rules
Input Tax Credit - Definitions, Blocked Credits, Apportionment of Blocked Credits
Blocked Credit in Special Circumstances - Section 18
Distribution of Credit by ISD - Sections 20 & 21
Input Tax Credit - Section 16
Registration - Sections 22, 23, 24, 25, 26 to 30, Rules
Tax Invoice - Definitions, Section 31, e-Invoicing, Special Cases
Credit and Debit Notes
Accounts and Records
Electronic Way Bill
Payment of Tax - Definitions, Sections 49, 50
GST Returns
Import and Export under GST
Import of Goods & Services under GST
Registration and ITC in case of Import of Goods and Services
GST Refunds
Job Work
Assessment and Audit of GST
Inspection, Search, Seizure, Arrest
Demands and Recovery - Definitions, Sections 73, 74, 75, 76, 77, 78 to 84
Liability to pay in certain cases
Offences and Penalties under GST - Definitions, Sections 122, 123, 124, 130, 131, 138, Rules
Advance Ruling
Appeals and Revision
TDS and TCS for GST
Miscellaneous Provisions
Fundamental analysis Crash Course
What you'll learn
Understand the role of a Business Analyst
About tools and techniques you can use as a Business Analyst
Key concepts in Business Analysis
How to kick-start your career as a Business Analyst
How to gather, group, prioritize and validate requirements
Where to find job opportunities as a BA and how much a BA earns
How to continue learning about Business Analysis
Excel VBA Macros Course
What you'll learn
By the end of this course, you will be confidently writing VBA macros which automate procedures in Microsoft Excel.
You will fully understand the purpose and syntax of each line of code that you write.
You will not simply be entering lines of code because you have been told they will produce a certain result.
You will gain a solid understanding of both the VBA and Excel object models which underly VBA programming.
