0
Total:
Need Support

Course Details

MS Excel - Basics to Advanced

Instructor

Course Mode

Download 4,000
Intro Video Enroll

157 Students Enrolled

Course Review

  • Description
  • Session Details
  • System Specification for Download Mode Classes
  • Views and Validity for Download Mode
  • Reviews
  • Enroll Now

Recorded Video Tutorials - avail anytime - 6 months validity, 3 views per video

 

All Reference Material will be shared in soft copy.

 

Excel is the most important and powerful computer software program used in the workplace today. That's why every professional or executive is 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 for end-users and business professionals.

 

Course Video Tutorials Schedule - 

 

 Session 1 : 

              1-1 Excel Autofill

              1-2 Excel Formatting-Text and Numbers

              1-3 Excel Formatting-Dates

              1-4 Excel Formatting-Text Cases

              1-5 Excel Formatting-Autocorrect

              1-6-1 Excel-Mathematical Functions

              1-6-2 Excel-Mathematical Functions

              1-6-3 Excel-Mathematical Functions

Session 2 : 

              2-1 Excel-Freeze Panes

              2-2 Excel-Group Ungroup

              2-3 Excel-Relative Cell Referencing

              2-4 Excel-Absolute Cell Referencing

              2-5 Excel-Rounding

Session 3 : 

              3-1 Excel-Paste Special Types

              3-2 Excel-Sorting

              3-3-1 Excel-Filter

              3-3-2 Excel-Filter

              3-4 Excel-Concatenate-And

              3-5 Excel-Comments

Session 4 : 

              4-1 Excel-Printing Techniques

              4-2-1 Excel-Vlookup-Exact Match

              4-2-2 Excel-Vlookup-Exact Match

              4-3 Excel-Vlookup-Approximate Match

              4-4 Excel-Hlookup

Session 5 : 

              5-1-1 Excel-Conditional Formatting

              5-1-2 Excel-Conditional Formatting

              5-1-3 Excel-Conditional Formatting

              5-2 Excel-Removing Duplicates

              5-3 Excel-Protect and Unprotect Data Sheets

Session 6 : 

              6-1 Excel-Pivot Table

              6-2-1 Excel-Data Validation

              6-2-2 Excel-Data Validation

              6-2-3 Excel-Data Validation

Session 7 : 

              7-1-1 Excel-Text to Columns-Delimited

              7-1-2 Excel-Text to Columns-Fixed Width

              7-1-3 Excel-Text to Columns-Others

              7-2 Excel-LEN-TRIM-CLEAN-RIGHT-LEFT-MID

Session 8 : 

              8-1-1 Excel-Subtotal

              8-1-2 Excel-Subtotal

              8-1-3 Excel-Subtotal

              8-2 Excel-SUMIFS

              8-3 Excel-Goto Special

Session 9 : 

              9-1-1 Excel-Creating Charts

              9-1-2 Excel-Creating Charts

              9-1-3 Excel-Creating Charts

              9-1-4 Excel-Creating Charts

              9-2 Excel-Hyperlinking

Session 10 :

           10-1-1 Excel-iFS

           10-1-2 Excel-iFS

           10-1-3 Excel-iFS

           10-2 Excel-Goal Seek

           10-3-1 Excel-Macros

           10-3-2 Excel-Macros


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 your Speed, Efficiency, Problem Solving skills, Organisational skills, Presentation skills, Innovative mind, and most importantly your professional growth.

  

For system, installation, access-related queries you can reach us at -

Helpdesk - care@sjc.co.in

 

Helpline - 033 4059 3800 

  • 50+  MS Excel Tools/Formulas
     
  • 90+ MS Excel Shortcuts

  • Access to Free Webinars on other tools, as & when held - for 6 months, if held.

  • Q & A Session - Every Sunday. Details will be shared once registered. 

 

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 Hyperlinking sheets/files/tabs.

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

No Specifications are needed in your mobile phone or laptop to join the live webinars

 

System Specification for Download Mode

 

Videos can be played only on Laptop (not on Desktop CPU)

 

Windows 7 Ultimate,
Windows 8,
Windows 8.1,
Windows 10

 

If you have been provided a laptop from your office, then ensure that all the above specifications are duly met.

 

It shall be completely your responsibility to meet the specifications required for playing the videos.

Views and Validity for Download Mode

 

You will get three views for each video. You can watch the videos for three times as per the video duration. Views depend on the duration of the video which you have watched. If a video is for one hour, you can watch it for three hours by opening it any number of times.

 

The maximum validity of the course is 6 months from the date when the serial key is assigned for your course on your laptop.

Post Review

Course Review

5

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

OR

Popularity
Most Recent