This Online Training Course on MS Excel 2013 is a fundamental course covering creation of new worksheets, inputting data into excel, using simple functions and graphs, basic keyboard shortcuts and more. The course is ideal for participants who are new to excel and want to learn the basics.
This course is delivered by WIN Corporate Training, a leading Training Institute on Excel for over 14 years.
Course Offerings
11 lecture topics
Live video interaction
Interactive discussion forum
Special Add-ons (Free with Course)
Certificate
Course Completion Certificate *Important: Course Completion Certificate will be issued by WIN Corporate Training Institute Certificate will be awarded only after completion of all video lectures and the online Final exam.
Freshers to Excel 2013, College students, higher school students, professionals wanting to understand the basics of Excel are intended audience to this course.
This Online Training Course on MS Excel 2016 Advanced level covers the complex features of Excel 2016 including Formulas, Functions, Database connections, Charts, Pivot tables and more. The course is ideal for participants who are know the basics of excel.
This course is delivered by WIN Corporate Training, a leading Training Institute on Excel for over 14 years.
Course Offerings
23 lecture topics
Live video interaction
Interactive discussion forum
Special Add-ons (Free with Course)
Certificate
Course Completion Certificate *Important: Course Completion Certificate will be issued by WIN Corporate Training Institute Certificate will be awarded only after completion of all video lectures and the online Final exam.
This Online Training Course on MS Excel 2013 Expert Level covers the concepts of Macros and VBA in Excel. The Curriculum includes range objects, sub programs, user forms, data writing and more.
This course is delivered by WIN Corporate Training, a leading Training Institute on Excel for over 14 years.
Course Offerings
24 lecture topics
Live video interaction
1+ practise tests with solutions
Interactive discussion forum
Special Add-ons (Free with Course)
Certificate
Course Completion Certificate *Important: Course Completion Certificate will be issued by WIN Corporate Training Institute Certificate will be awarded only after completion of all video lectures, Practise Test and the online Final exam.
Sub Programs in VBA Functions and Procedures Part 1
17:05
19
Sub Programs in VBA Functions and Procedures Part 2
15:11
20
User Forms and Controls Part 1
15:55
21
User Forms and Controls Part 2
07:37
22
Writing Data to the excel File using VBA
10:01
23
Sorting Filtering Charts Pivot Table in VBA Part 1
18:35
24
Sorting Filtering Charts Pivot Table in VBA Part 2
14:21
Excel Practise Test 1
Excel Expert Final Exam
Course Eligibility
Participants should have good knowledge on Excel features. Financial Analysts, MBA grads, Data Analysts and Professionals working on advanced excel functionalities will benefit from this course
This Online training course provides a comprehensive understanding of Time Management module using MS Project, delivered by a PM expert having hands-on experience.
Time Management knowledge area has many tricky topics such as start-to-finish dependency, float calculations, resource optimisation, schedule compression etc. This course uses a multi-step approach using textual explanation, graphical illustrations and a case study based MS Project illustration to ensure a thorough and clear understanding of the topics.
The course contains important examination tips in each module and combined with quizzes, the course acts as a friendly guide. Aspirants going through this course will not have to go through any book or other supplementary material to prepare for Time Management area. The other important benefit of the course is that it helps the participants with detailed illustrations using MS Project case studies to apply Time management concepts in real projects.
This Course includes 7 case study MS project files.
Course Offerings
42 lecture topics
Live video interaction
6+ practise tests with solutions
Interactive discussion forum
7+ course files
Special Add-ons (Free with Course)
Certificate
Course Completion Certificate *Important: Course Completion Certificate will be awarded by Akshaya Centre of Excellence certificate will be awarded only after completion of all video lectures and quizzes
Courseware
Presentation used in the videos lectures in an ebook reader format
( Can be downloaded as pdf )
Curriculum
I
Introduction to the Course
1
Target audience for this course and why this course Preview
08:21
2
Overview of modules covered in this course
03:18
3
Pre requisites for the course
02:53
II
Plan Schedule Management
4
Process Structure - Inputs, tools and techniques and output
03:09
5
Important points to be noted
05:49
III
Define Activities
6
Process Structure - Inputs, tools and techniques and output
03:23
7
Tips from examination point of view
04:55
8
Defining activities of a project using Decomposition and Rolling wave approaches
02:12
9
Practical insights on how to decompose a project into activity list
03:55
10
Creating activity list in MS Project Illustration
17:23
11
Summary of module 3
01:57
Sample software project with V Process
House construction project after define activities
Sample software agile plan
Quiz for module 3 - Define Activities
IV
Sequence Activities Process
12
Process Structure - Inputs, tools and techniques and output
03:02
13
Precedence diagramming method (PDM)
02:17
14
Dependency Determination
09:42
15
Illustration of sequencing activities and creating network diagrams using MS Project Part 1 Preview
19:27
16
Illustration of sequencing activities and creating network diagrams using MS Project Part 2
16:27
17
Summary of Module 4
01:32
House construction project after sequencing
Quiz for module 4 - Sequence activities process
V
Estimate Activity Resource Process
18
Process structure of estimate activity resource process
10:16
19
Methods of estimation M5
05:12
20
Assign resources to the activities
12:32
21
Main points to be noted from examination perspective M5
02:51
22
Summary of module 5
01:59
Quiz for module 5 - Estimate activity resource process
VI
Estimate Activity Duration Process
23
Process structure of estimate activity duration process
03:17
24
Methods of estimation M6
16:30
25
Practical tips to carry out estimate duration
08:15
26
Assign duration to the activities Illustration with MS Project schedule
12:36
27
Main points to be noted from examination perspective M6
03:56
28
Summary of module 6
02:00
House construction project with resource duration
Quiz for module 6 - Estimate activity durations process
VII
Develop Schedule Process
29
Process structure of develop schedule process
04:31
30
Why develop schedule process is most important of all
House construction project with resources auto levelled
Quiz for module 7 - Develop schedule process
VIII
Control Schedule Process
39
Process structure of control schedule process
03:24
40
Tools and techniques of control schedule process
16:58
41
Important examination tips
01:21
42
Summary of module 8
02:47
House construction project for tracking
Quiz for module 8 - Control schedule process
Course Eligibility
This course is best suited for participants looking for a deeper understanding of the time management knowledge area. This course is very detailed and eliminates the necessity of reading text books for this knowledge area. It is also relevant for those who want to understand the real applications of MS Proj or OpenProj in Project Management.
This Online Training Course on Microsoft® Project 2013 (MS Project) Certification, is delivered by a project manager with prior experience at Microsoft, USA.
Microsoft Project is a project management software program, developed and sold by Microsoft Corporation. It helps Project Managers to organize projects by developing a plan, assigning resources to tasks, tracking progress, managing the budget and analysing workloads.
This course aims to help participants know how to use Microsoft® Project 2013 application to help organize their daily project management work, how to begin - plan - execute - monitor - control and close a project, how to effortlessly plan various tasks, schedules, resources and budget to accomplish the project.
At the end of this course, participants will be able to manage projects using MS Project 2013, schedule and organize tasks, manage resources, track project progress, analyse Earned Value, create and manage sub-projects, import export and share data to and from Microsoft Project 2013, create impressive presentations and more. Participants will also be well prepared to take the Microsoft Exam 74-343 on Managing Projects using Microsoft Project 2013 that has credits towards the MCP and Microsoft Specialist certifications. The exam 74-343 is an online exam consisting of 54 multiple choice questions with a duration of 2 hours.
Course Offerings
19 lecture topics
Live video interaction
Interactive discussion forum
1+ course files
Special Add-ons (Free with Course)
Certificate
Course Completion Certificate *Important: Course Completion Certificate will be awarded on completion of all video lectures, mock exams and the Final Exam
Creating Master project and inserting Sub-projects
12:10
11
Creating Resources pool and how to share Resources
10:53
12
Budgeting and Tracking Budget
14:18
13
Earned value Analysis
14:34
14
Import and Export TO and FROM Microsoft Project
09:00
15
Calendar and Other short cuts and tips
10:09
16
Milestones
08:13
17
Baselines
09:38
18
Task type
18:54
19
Types of Dependencies
14:30
Scenario based exercises
MS Project 2013 Mock 1
MS Project 2013 Final Exam
Course Eligibility
Project or Program Managers, Project Leaders, Resource Managers, Schedulers, PMI®-PMPs, PMO, MCP and Microsoft Specialist certification takers for Exam 74-343 Managing projects with Microsoft Project 2013, administrators & business decision makers who need to understand task management, scheduling, timelines etc using MS Project & graduate and post graduate students who want to understand this MS Office tool can enrol into this course. Participants to this course should have ample understanding of Project Management frameworks, key terms and related concepts. It is also recommended to have an experience in managing projects(s) and resources and have basic understanding of other Microsoft applications.