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
This course is suitable for the SAS BASE certifications including SAS Certified Specialist and SAS Certified Associate (Exam ID A00-231, A00-233, A00-215)
All critical and essential SAS BASE Data manipulation and data preparation skills
Handle Error by identify and solve SAS errors
Combine, merge and restructure data sets
SAS Statistical Procedures
Reports generating
SAS advanced topic: Proc SQL Essentials
SAS advanced topic: SAS Macros Essentials
What you'll learn
Installing R and R Studio
Manipulating R Vectors, Arrays and Matrixes
Manipulating R Data Frames
Plotting Data Using R
Analyzing Real Datasets using R
Organizing your Code in R
Develop your own Functions in R
Summarizing Data with R
Load Excel Files with R
Compute Basic Statistics about a Dataset
Install External Libraries to Power up R
Aggregate and Sort Data
Subset Data
Power BI Course
In this course, you’ll be playing the role of Lead Business Intelligence …
What you'll learn
Build professional-quality business intelligence reports from the ground up
Blend and transform raw data into beautiful interactive dashboards
Design and implement the same B.I. tools used by professional analysts and data scientists
Showcase your skills with two full-scale course projects (with step-by-step solutions)
Understand the business intelligence workflow from end-to-end
Learn from a best-selling instructor and professional BI developer
Excel VBA Macros Course
Excel VBA programming can seem baffling, especially when you don’t fully …
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.
Adobe Premiere Pro CC Course
If you are looking for a video editing application that …
What you'll learn
Master Premiere Pro and be CONFIDENT Editing Your Own Videos
Edit an entire video from beginning to end, using professional and efficient techniques.
By the end of the course, you'll have edited your promo video with the supplied footage (video clips, photos, graphics, music, etc.), or your own footage!
Start a project with the right settings for any type of video, from any camera.
Export and save your videos for 4K & High Definition playback.
Edit your videos, and make them more dynamic with cutaway footage and photos.
Design clean and professional titles for your videos.
Add motion to your titles, photos, and videos... making them more visually interesting.
Color correct your video to fix issues with white balance and exposure.
Add a feeling to your video with color grading.
Apply visual effects such as stabilizing shaky video, removing grain, and making video more cinematic with overlays.
Edit green screen footage and, add backgrounds that actually look good.
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.
E-Accounting Institute in Delhi
E-Accounting Institute in Delhi in which you would learn all …
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
