Advanced Excel Course
What you'll learn
Learn how to THINK like Excel, and write powerful and dynamic Excel formulas from scratch
Automate, streamline, and completely revolutionize your workflow with Excel
Master unique tips & techniques that you won't find in ANY other course, guaranteed
Explore fun, interactive, and highly effective demos from a best-selling Excel instructor
Get LIFETIME access to project files, quizzes, homework exercises, and 1-on-1 expert support
Write advanced conditional, text, date, and lookup functions, including XLOOKUP & Dynamic Arrays
Tally Prime Course in Delhi
What you'll learn
You will learn How to manage the Accounting of any Company with GST Independently
You will learn how to Manage Payroll with PF, ESI, EPF, Statutory Payment
You will learn how to compute TDS & extract TDS Reports
How to manage Accounting of Manufacturing Firm
Banking
You will learn how to Create MIS Reports for Managerial Level
How to create GST Computation & Reports in Tally.Erp9 with GST
You will learn how to manage the accounting of Goods Transport Agency(GTA) in Tally .Erp9 with GST
RCM - Reverse Charge Mechanism in Tally Erp9 with GST Training
You will learn how to manage the accounting of Composition Dealer under GST in Tally.Erp9 with GST Course
How to avail Input GST Credit
Import & Export Entries under GST
You will learn how to apply GST at Multiple Level
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
-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
E-Accounting Institute in Delhi
What you'll learn
An Introduction to Accounting, The Double Entry Accounting System, & Recording Transactions using Debits and Credits
Analyze, use, and create from scratch financial statements including a balance sheet, income statement, statement of equity, and statement of cash flows
Use the concepts of the double entry accounting system
Record financial transactions using the accounting equation
Record financial transactions using debits and credits
Learn when and how to use accounting methods such a the accrual method and cash method
Apply the concepts related to the revenue recognition principle and the matching principle to recording transactions and reading financial statements
Record period end adjusting entries and be able to explain why adjusting entries are necessary is a well designed accounting system
Record merchandising transactions. Record transactions involving inventory
Track inventory using cost flow methods like FIFO, LIFO, and Weighted Average Methods
Create and use subsidiary ledgers like accounts receivable by customer and accounts payable by vendor subsidiary ledgers
Learn how to create and use special journals and how they can be part of an accounting system
Construct and interpret a bank reconciliation, one of the most critical internal controls
Be able to implement internal controls over cash
Value account receivable and record bad debt expense using either the allowance method or direct write off method
Calculate depreciation using different depreciation methods including straight line depreciation, double declining balance, & units of production depreciation
Record payroll transactions and calculate net pay and income tax withholding
Record transaction specific to partnerships including methods to allocate net income to the partners, adding a new partner, and a partner leaving or selling a partnership interest
Record transaction specific to a corporation including selling capital stock, selling preferred stock, buying treasury stock, issuing cash dividends, and issuing stock dividends
Record transactions related to the issuance of bonds
Record transactions related to notes payable. Learn to create an amortization table.
Construct a statement of cash flows using the direct method and indirect method. We go into more detail about best practices to construct a statement of cash flows than any other course we have seen
Direct and Indirect taxes
What you'll learn
Understanding Indian Income Tax in the most simple manner
Become an expert in computing Total Income and Tax Liability of various assessees
Learn how to easily memorise sections of income tax, and put them to use in case studies
Efficiently prepare yourself for Professional exams like CA, CMA, CS, MBA , MCom, BCom etc.
-13%
Complete Graphic Designing Course
What you'll learn
Introduction to the graphic design
Fundamentals of Graphic design.
Adobe Photoshop, Illustrator, and Indesign 3 stages (Basic, Intermediate, and Advanced)
Adobe Dimension Basics
Introduction to Advertising
Working with stock images and vectors
Print-based designing and web-based designing.
Advanced design controls
Working with different file formats
Working as a graphic designer in different sectors
Start your carrier as a freelance graphic designer
Managing clients
Practical modules for each level
Advanced Photoshop Course in Delhi
What you'll learn
You will be able to start earning money from your Photoshop Skills.
You will be able to add Photoshop to your CV
You will have over 20 of your own projects to add to your portfolio.
You will create social media post images for Facebook, Instagram, Twitter, Pintrest & Youtube.
You will be able to mask anything… including the dreaded hair!
Clearcut images.
Create amazing typography.
You will create popular visual styles.
You will create distorted images.
You will create graphics from scratch.
You will retouch photographs like a professional.
You will create a postcard.
Create posters.
Create advertising.
Resize Images.
Build a flyer.
Change the color or images.
Fix the colors in photographs
You will change eye & hair colors.
You will combine 2 photographs to create amazing compositions.
You will put a storm in a teacup.
You will create text that looks like stone.
You will build a logo with a type that wraps around it like a badge.
You will create text that wraps around a woman.
You will build a multipage banner advertising project.
You will create more background in an image from thin air.
You will remove people from images.
You will remove graffiti from a wall.
You will clear cut images of people, shoes & other products.
You will create realistic shadows
You will create text that wraps around colored smoke.
You will build duotone images like the Spotify effect
You will create images with an anaglyph effect
You'll turn your images into realistic oil paintings
You'll know how to add halftone effects to your images.
You will bend images to reveal background images.
You will distort a logo to bend around real-life photographs and objects.
You retouch an overweight person to make them appear slim.
You'll build spray paint-style graffiti using brushes.
You'll make a galaxy appear out of a man's head.
Create paper cut effects inside of a font.
Build text with 3D paint dripping from it.
You'll retouch a face to move pimples & freckles.
You'll remove dust & scratches from an old photograph.
Change yellow teeth to white teeth.
You'll build a fantasy image where you put an island, ocean & clouds inside a small bottle.
Corel Draw Course
What you'll learn
By the end of this course, you will create your own business card in CorelDRAW
Create unique color palettes to be used in future projects
Distort and apply drop shadow and 3D effects to objects
Design clean and professional business cards
Organizing a brochure layout by learning how to manage pages
Combining vector shapes to use them in logos and graphics
-20%
Adobe Illustrator CC Course
What you'll learn
You will be able to add Illustrator to your CV
You will be able to start earning money from your Illustrator Skills.
You will have over 30 of your own projects to add to your portfolio.
Feel comfortable using Adobe Illustrator to design your own graphics from scratch.
Navigate Adobe Illustrator CC like a pro.
Design your own graphics, without any experience.
Draw beginner to advanced shapes and icons.
Learn all of the key skills of Illustrator: shapes, text, masking, effects, and exporting.
Master advanced Illustrator tools and techniques.
Export your projects for print, web, or other design projects.
Make your ideas come to life.
Create your own logos.
Draw existing famous logos.
Illustrate animals.
Draw with paint brushes.
Draw with pens & pencils.
Create custom typography.
Take hand drawings and recreate them using Illustrator.
Create a logo badge with text that wraps around.
Create type that follows a curving line.
Put images inside of text for cool effects.
Create beautiful gradients and apply them to icons, text & illustrations.
Find the secrets to choosing color combinations for your work.
Create a paper cut effect.
Pull, push & cut text to make interesting styles.
Repeat patterns to create vector flowers.
You will redraw yourself as an illustration.
Create many different icons styles.
Build a repeating pattern to be used as wallpaper or fabric designs.
Find many templates for posters, stationery & UI designs to save you time.
You'll build create assets like colors, patterns & drawings using the Illustrator mobile app.
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
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
-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
QTP Software Testing
What you'll learn
Perform API Testing for any application with ease and efficiency
Create 100s of API Tests for their applications
Understand what API tests to create, when to create them, and how to make management happy
Create Data Driven automated API tests
Set up checkpoints for their API tests
Apply real world examples to their learning
Create a UFT solution and nest UFT tests in the solution
Test SOAP Web Services
Test the very popular REST Services
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.
