Microsoft Office Bundle

Self Paced Learning

Learn at your convenience anytime, anywhere

For 180 days access

USD 107.78

USD 113.78

Enrol Now

Courses included in the bundle

Excel 2013 for Beginners

WIN Corporate Training

Leading Excel Corporate Trainer with 14+ yrs training experience.

View WIN Corporate Training's Profile

LEARN MORE

Course Overview

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.

Curriculum

Excel 2013 for Beginners

1	Introduction to Excel Application	10:46
2	Working with Excel File	11:13
3	Formatting the Worksheet data	16:44
4	Editing options in Excel	17:13
5	Formatting the Worksheet and Workbook	10:45
6	Customizing the Views of Worksheet and Workbook	17:14
7	Creating Tables in Excel Preview	06:02
8	Functions and formulas in Excel	25:30
9	Creating Charts and Objects	20:52
10	Print Options in Excel	05:30
11	Summary of the Course	01:14

Excel Final Exam

Course Eligibility

Freshers to Excel 2013, College students, higher school students, professionals wanting to understand the basics of Excel are intended audience to this course.

LESS

Excel 2016 Advanced

WIN Corporate Training

Leading Excel Corporate Trainer with 14+ yrs training experience.

View WIN Corporate Training's Profile

LEARN MORE

Course Overview

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

Curriculum

Excel 2013 Advanced

1	Working with Formulas Part 1	21:57
2	Working with Formulas Part 2	18:22
3	Learning Function Categories Part 1 Preview	15:55
4	Learning Function Categories Part 2	28:35
5	Learning Function Categories Part 3	19:18
6	Learning Function Categories Part 4	28:04
7	Database Management in Excel 2016 Part 1	14:23
8	Database Management in Excel 2016 Part 2	20:54
9	Working with charts	16:50
10	Other features	15:31
11	Working with Pivot tables Part 1	15:38
12	Working with Pivot tables Part 2	16:56
13	Enhancing pivot tables	09:12
14	Cell and Workbook protections	20:07
15	Working with more formatting features	04:48
16	Data validation	20:19
17	Consolidating worksheets	07:30
18	Performing spreadsheet What-if analysis tools	12:09
19	New features in MS-Excel 2016	17:17
20	Summary	01:45

Excel 2016 Advanced

21	General Features Excel 2016	29:05
22	Functions Excel 2016	28:16
23	Charts Excel 2016	28:33

Advanced Excel Final Exam

Course Eligibility

Participants to this course are required to have a basic understanding of Excel 2016 and its features.

LESS

Excel 2013 Expert - VBA and Macros

WIN Corporate Training

Leading Excel Corporate Trainer with 14+ yrs training experience.

View WIN Corporate Training's Profile

LEARN MORE

Course Overview

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

Curriculum

Excel 2013 Expert - VBA and Macros

1	Macro VBA basics Part 1	17:37
2	Macro VBA basics Part 2 Preview	14:19
3	Variable Datatype	23:12
4	Comparison Operators	24:57
5	Condition Statement Part 1	20:37
6	Condition Statement Part 2	11:55
7	Loops	27:56
8	Excel VBA Objects	04:46
9	Workbook Object	32:10
10	Worksheet Object Part 1	07:16
11	Worksheet Object Part 2	23:41
12	Range Object Part 1	28:19
13	Range Object Part 2	22:11
14	Range Object Part 3	23:23
15	Range Object Part 4	21:30
16	Range Object Part 5	19:50
17	Range Object Part 6	18:07
18	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

LESS

Time Management with MS Project

Akshaya Centre of Excellence

A project delivery excellence training and consulting team

View Akshaya Centre of Excellence 's Profile

LEARN MORE

Course Overview

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

Introduction to the Course

Plan Schedule Management

III

Define Activities

Sequence Activities Process

Estimate Activity Resource Process

Estimate Activity Duration Process

VII

Develop Schedule Process

29	Process structure of develop schedule process	04:31
30	Why develop schedule process is most important of all	10:29
31	Critical path method Preview	08:27
32	Forward pass, Early start and Early Finish	07:11
33	Backward pass, Late start and Late finish, Float	21:24
34	Critical chain method	02:22
35	Resource optimization	03:50
36	Schedule compression Crashing and Fast tracking	08:56
37	Illustration using live project schedule	15:11
38	Summary of module 7	04:22
	House construction project with resources auto levelled
	Quiz for module 7 - Develop schedule process

VIII

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.

LESS

Microsoft Project 2013

Haripriya Durairaj

PMP® with strong project management experience

View Haripriya Durairaj 's Profile

LEARN MORE

Course Overview

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

Mock Exams

1 Online Simulator Exams of 54 Questions each

Curriculum

Microsoft Project 2013

1	Microsoft Project 2013 Course overview Preview	04:52
2	Introduction to Microsoft project 2013	05:13
3	Explanation on the features, options and screens	09:38
4	How to create Task list and set dependencies	10:11
5	How to set up Resources and assign them to tasks	10:36
6	Scheduling and Resources Leveling	15:55
7	Critical Path and Network Diagram	08:28
8	Formatting Gantt Chart	08:54
9	Setting up Costs and Creating Sub-projects	14:41
10	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.

LESS

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

4	Process Structure - Inputs, tools and techniques and output	03:09
5	Important points to be noted	05:49

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

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

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