0
Total:
Need Support

Advanced Ms Excel with Google Sheets - Certification

Instructor

Course Mode

Online Streaming Live 3,000
Intro Video Enroll

33 Students Enrolled

Course Review

  • Description
  • Session Details
  • How to join the course
  • Views and Validity
  • Reviews
  • Enroll Now

This is an online course on Advanced MS Excel with Google Sheet.

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.

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

Several multi national organisation has already started migrating all its workings on Google widgets. Its high time for any professional now to include in its work style.


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

 

Session 11: Google Sheet 

The link of joining webinar will be shared two hours before the webinar .

You can join with your Smart Phone and Laptop as well.

 

Follow the email received after your registration for joining link of webinar.

 

The access to video recording will be available till one week after the course completion date.

 

Views – 2 times each video

 

One view will be counted after watching 80% of the video.

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