MS Excel 2013 Bundle

Self Paced Learning

Learn at your convenience anytime, anywhere

For 365 days access

USD 88.89

USD 71.11

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	12:35
22	Functions Excel 2016	15:19
23	Charts Excel 2016	15:31

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