MIS Training – Advance Excel + Macro + Access + SQL
A Management Information System (MIS) provides organizations with the information they …
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
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
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
Creo Parametric Course
Creo Parametric: The flagship application in the Creo Suite, Creo …
What you'll learn
Understanding Creo Parametric concepts
Create and modify 2D sketches on datum planes.
Sketching geometry and using tools
Create part features using: extrude, revolve, blend, hole, shell and sweep functions.
Creating datum planes and datum axes
Create parametric relationships between features and modify features Laying out drawings and creating views
Comprehensive two part Design Project
Selecting and editing geometry, features, and models
Learn advance modelling process
Learning how to use the Creo Parametric interface
Generate and dimension a multi view orthographic drawing.
Annotate notes and text on drawings.
Build a 3D assembly.
Mechanism (Gear, Cam follower, Piston cylinder, Slider crank etc.)
Animation ( Snapshot)
Manufacturing (Use application vericut)
Basic simulation
Drawing view and BOM (Bill of material)
Control and modify the operating environmental settings.
Complete work accurately, with attention to detail. Assembling with connections
Create Engineering, Industrial Graphics & Design in 3D or 2D
Revit Architecture Course
This course is known as Autodesk Revit Architecture Course. Our institute …
What you'll learn
You will learn all about Revit Architecture 2020-2021-2022 to become professional user
You will learn all the tips-and-tricks of Revit Architecture 2020-2021-2022 to guide you to the Certified Professional Exam
In this course we will create and develop an architectural project with all the necessary elements
RVT and PDF files included with the course will help the trainee gain the right practical skills
What you'll learn
Confidently list your SOLIDWORKS skills in your resume
Use SOLIDWORKS to design/draft your next innovation
Take, with confidence, the SOLIDWORKS Associate Certification test - CSWA
Self-learn advanced functions in SOLIDWORKS
Use SOLIDWORKS to make basic models
- 1
- 2
