Need Support

Course Details

MS Excel - Basic to Advanced - Online Course

Instructor

Course Mode

Online Sreaming Recorded 3,000
Enroll

500 Students Enrolled

Course Review

  • Description
  • Session Details
  • Views and Validity
  • How to Watch the Course
  • Curriculum
  • Reviews
  • Enroll Now

This is an online course on Advanced MS Excel.

Excel is the most important and powerful computer software program used in the workplace today. That's why every professional or executive are required to learn Excel in order to enter or remain in the workplace. Recruiters also prefer candidates having Basic and Advanced Excel knowledge to support their professional knowledge.


It is widely used by businesses, service firms, multinational companies, volunteer groups, private sector organizations, scientists, students, educators, trainers, researchers, journalists, accountants and others. Microsoft Excel has become a staple tool of end users and business professionals.

Today, knowledge of MS Excel is a prerequisite for almost all job positions in the industry in any sector – Finance, HR, Operations, Marketing, Sales, etc. Any academic or professional course is incomplete without the practical knowledge of MS Excel. You would always feel the hard pinch of your ignorance about Excel knowledge when you would see your colleagues outperforming you by applying Excel techniques in their work / output / presentations. 

Learning Excel gives an edge over others and keeps you not one but many steps ahead in the professional world. It improves you Speed, Efficiency, Problem Solving skills, Organisational skills, Presentation skills, Innovative mind and most importantly your professional growth.

“Excel makes you Excellent”

Session 1:  Mathematical Functions, Formatting Functions and Autofill Series.

Session 2:  Freeze Panes, Formulae Cell Referencing and Rounding Numbers/Values.

Session 3:  Data Filter, Data Sorting, Joining Separate Data and Paste Special.

Session 4:  Printing Techniques & Issues, Vlookup and Hlookup.

Session 5:  Conditional Formatting, Protect-Unprotect Data cells/sheets

and Removing Duplicate Entries.

Session 6:  Pivot Table and Data Validation.

Session 7:  Text to Columns, Trimming Data and Extract Text from a Text String.

Session 8:  SUMIFs, Subtotal and Go to Special.

Session 9:  Develop Charts/Graphs and Hyper linking sheets/files/tabs.

Session 10: Designing Macros, Goal Seek Concept for Business and Nested IFS Formulae.

You can view the course for five times each.

A view will be counting only after watching 80% of the video.

There is no validity of the course.

The video will expire once you have used its view.

Step 1 - After subscribing, go to My Courses from your Dashboard.

Step 2 - Click on Go To Course icon in Action Buttons against the course subscribed.

Step 3 - Watch the video in order of the session.

Step 4 - Download the study material given along the video for reference.

Step 5 - Download the Excel Sheets as attached with the applicable videos.

Step 6 - Pause the video and Practice in Excel Sheet Side by Side.

Step 7 - At the end of each session, solve Exercises given in the Course Drive.

  • 1.6 Excel - Mathematical Functions - Part a
  • 00:09:00
  • 1.6 Excel - Mathematical Functions - Part b
  • 00:10:00
  • 1.6 Excel - Mathematical Functions - Part c
  • 00:07:00
  • 1.1 Excel Autofill
  • 00:10:00
  • 1.2 Excel Formatting Text & Numbers
  • 00:15:00
  • 1.3 Excel Formatting Dates
  • 00:09:00
  • 1.4 Excel Formatting Text Cases
  • 00:03:00
  • 1.5 Excel Formatting Auto correct
  • 00:05:00
  • 2.3 Excel - Relative Cell referencing
  • 00:05:00
  • 2.4 Excel - Absolute Cell referencing
  • 00:06:00
  • 2.5 Excel - Rounding
  • 00:07:00
  • 2.1 Excel - Freeze Panes
  • 00:09:00
  • 2.2 Excel - Group Ungroup
  • 00:09:00
  • 3.5 Excel - Comments
  • 00:09:00
  • 3.3 Excel - Filter - Part a
  • 00:14:00
  • 3.3 Excel - Filter - Part b
  • 00:09:00
  • 3.4 Excel - Concatenate, And
  • 00:09:00
  • 3.1 Excel - Paste Special Types
  • 00:12:00
  • 3.2 Excel - Sorting
  • 00:13:00
  • 4.2 Excel - Vlookup - Exact Match - Part a
  • 00:16:00
  • 4.2 Excel - Vlookup - Exact Match - Part b
  • 00:04:00
  • 4.3 Excel - Vlookup - Approximate Match
  • 00:07:00
  • 4.1 Excel - Printing Techniques
  • 00:17:00
  • 4.4 Excel - Hlookup
  • 00:05:00
  • 5.3 Excel - Protect & Unprotect Data Sheets
  • 00:21:00
  • 5.1 Excel - Conditional Formatting - Part c
  • 00:13:00
  • 5.2 Excel - Removing Duplicates
  • 00:16:00
  • 5.1 Excel - Conditional Formatting - Part b
  • 00:08:00
  • 5.1 Excel - Conditional Formatting - Part a
  • 00:15:00
  • 6.2 Excel - Data Validation Part b
  • 00:08:00
  • 6.2 Excel - Data Validation Part c
  • 00:07:00
  • 6.2 Excel - Data Validation Part a
  • 00:11:00
  • 6.1 Excel - Pivot Table
  • 00:22:00
  • 7.1.a Excel - Text to Columns - Delimited
  • 00:08:00
  • 7.1.b Excel - Text to Columns - Fixed Width
  • 00:08:00
  • 7.1.c Excel - Text to Columns - Others
  • 00:12:00
  • 7.2 Excel - LEN, TRIM, CLEAN, RIGHT, LEFT, MID
  • 00:15:00
  • 8.1.a Excel - Subtotal
  • 00:11:00
  • 8.1.b Excel - Subtotal
  • 00:08:00
  • 8.1.c Excel - Subtotal
  • 00:09:00
  • 8.2 Excel - SUMIFS
  • 00:17:00
  • 8.3 Excel - Goto Special
  • 00:14:00
  • 9.1.a Excel - Creating Charts
  • 00:14:00
  • 9.1.b Excel - Creating Charts
  • 00:11:00
  • 9.1.c Excel - Creating Charts
  • 00:16:00
  • 9.1.d Excel - Creating Charts
  • 00:15:00
  • 9.2 Excel - Hyperlinking
  • 00:20:00
  • 10.3.b Excel - Macros
  • 00:11:00
  • 10.1.a Excel - IFS
  • 00:12:00
  • 10.1.b Excel - IFS
  • 00:12:00
  • 10.1.c Excel - IFS
  • 00:16:00
  • 10.2 Excel - Goal Seek
  • 00:18:00
  • 10.3.a Excel - Macros
  • 00:09:00

Post Review

Course Review

0

5
80% Complete (danger)
4
80% Complete (danger)
3
80% Complete (danger)
2
80% Complete (danger)
1
80% Complete (danger)

OR

Popularity
Most Recent