0
Total:
Need Support

MS Excel with Google Sheets - Basics to Advanced

Instructor

Course Mode

Download 8,200
Intro Video Enroll

106 Students Enrolled

Course Review

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

Google Drive - Recorded Videos - avail anytime - 6 months validity, 3 views per video with 3 Live Webinars.

 

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.

 

Special discount of 20% for SJC Students. Write email to care@sjc.co.in with your registration details of any course studied with SJC, to avail the coupon.

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.

 

With Google Sheets, you further escalate yourself in working collaboratively on the cloud with a minimum of hassles. Google sheet also reduces the multiplicity of excel files in an office.

 

Several multinational organizations have already started migrating all its workings on Google widgets. Its high time for any professional now to include in its work style. 

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

 


Cross Application in Google Sheets are also taught. 

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.

  • 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.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.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
  • Test audio

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