- Session Details
- How to Watch the Course
- Views and Validity
- 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
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 two 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.
Still having Confusion ? We’d Love to hear from You
MS Excel - Basic to Advanced - Online Course
This teaching is most effective in my working life..