0
Total:
Need Support

MS Excel - Basic to Advanced - Online Course

Course Mode

Online Streaming Recorded 3,000
Intro Video Enroll

111 Students Enrolled

Course Review

  • Description
  • Session Details
  • How to Watch the Course
  • Views and Validity
  • 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.

 

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 with 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.

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.

  • Introduction Video
  • 00:06: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
  • 1.6.a Excel - Mathematical Functions
  • 00:09:00
  • 1.6.b Excel - Mathematical Functions
  • 00:10:00
  • 1.6.c Excel - Mathematical Functions
  • 00:07:00
  • 2.1 Excel - Freeze Panes
  • 00:09:00
  • 2.2 Excel - Group Ungroup
  • 00:09: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
  • 3.1 Excel - Paste Special Types
  • 00:12:00
  • 3.2 Excel - Sorting
  • 00:13:00
  • 3.3.a Excel - Filter
  • 00:14:00
  • 3.3.b Excel - Filter
  • 00:09:00
  • 3.4 Excel - Concatenate, And
  • 00:09:00
  • 3.5 Excel - Comments
  • 00:09:00
  • 4.1 Excel - Printing Techniques
  • 00:17:00
  • 4.2.a Excel - Vlookup - Exact Match
  • 00:16:00
  • 4.2.b Excel - Vlookup - Exact Match
  • 00:04:00
  • 4.3 Excel - Vlookup - Approximate Match
  • 00:07:00
  • 4.4 Excel - Hlookup
  • 00:05:00
  • 5.1.a Excel - Conditional Formatting
  • 00:15:00
  • 5.1.b Excel - Conditional Formatting
  • 00:08:00
  • 5.1.c Excel - Conditional Formatting
  • 00:13:00
  • 5.2 Excel - Removing Duplicates
  • 00:16:00
  • 5.3 Excel - Protect & Unprotect Data Sheets
  • 00:21:00
  • 6.1 Excel - Pivot Table
  • 00:22:00
  • 6.2.a Excel - Data Validation
  • 00:11:00
  • 6.2.b Excel - Data Validation
  • 00:08:00
  • 6.2.c Excel - Data Validation
  • 00:07: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.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
  • 8.1.a Excel - Subtotal
  • 00:11: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.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
  • 10.3.b Excel - Macros
  • 00:11: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