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.
PHP & My SQL Course – Beginner to Advance
In the training of our advanced PHP course, you will be …
What you'll learn
You will learn to create a (CMS) Content Management System like WordPress, Drupal or Joomla
You will learn how to use Databases
You will learn MySQL
Object Oriented Programming
You will learn how to launch your application online
How to use forms to submit data to databases
How to use AJAX to submit data to the server without refreshing the page
You will learn about PHP security
You will learn about sessions
Password hashing
Email sending
You will learn to use composer (PHP package manager)
You will learn to create clean URL's and remove the .php from files
You will learn to use bootstrap by getting experience from the project
You will learn to debug your code
You will learn to create pagination
You will code refactoring
You will learn to debug (fix your code)
You will learn to use an API to bring data from a database to a graphical interface
There is so much more and my hands are just tired of typing :)
Development Bootcamp Course
Development Bootcamp Course Course Overview The development Bootcamp course is …
What you'll learn
Be able to build ANY website you want.
Craft a portfolio of websites to apply for junior developer jobs.
Build fully-fledged websites and web apps for your startup or business.
Work as a freelance web developer.
Master backend development with Node
Master frontend development with React
Learn the latest frameworks and technologies, including Javascript ES6, Bootstrap 4, MongoDB.
Learn professional developer best practices.
What you'll learn
Learn to use Python professionally, learning both Python 2 and Python 3!
Create games with Python, like Tic Tac Toe and Blackjack!
Learn advanced Python features, like the collections module and how to work with timestamps!
Learn to use Object Oriented Programming with classes!
Understand complex topics, like decorators.
Understand how to use both the Jupyter Notebook and create .py files
Get an understanding of how to create GUIs in the Jupyter Notebook system!
Build a complete understanding of Python from the ground up!
