Your Page Title

This course is part of the Excel Skills for Business Specialization

Excel Skills for Business: 

Advanced

 Intermediate - Advanced Level Excel

4.2

326 already enrolled

Offered By

EXXPERTSCM

(A UNIT OF THOUGHTWARE TRAINING PVT.LTD.)

About this Course

This program is designed for anyone who is looking to enhance their career by learning one of the most critical and fundamental skills of our times. Microsoft excel is a widely used business application with huge number of applications and uses. It remains as the most used application worldwide. Learning Excel and understanding its applications to use it extensively is an added advantage to show on your CV. It is an easy way to stand out from the crowd and a handy skill to showoff. Learning this digital skill will surely help you to get better opportunities, leading to a better compensation.

 

This 4-day, online and interactive program is designed to equip you with the knowledge required to manage the professional dashboard and perform complex calculations using advanced Excel features and techniques. You will be able to manage large datasets efficiently, extract meaningful information from datasets, present data and extract information effectively. In addition, you will be able to master the skills needed to validate data and prevent errors in spreadsheets, create automation, apply advanced formulas and conditional logic to help make decisions and create spreadsheets that help forecast and model data.

SKILLS YOU WILL GAIN

Dashboard (Business)

Financial Modeling

Microsoft Excel

Data Cleansing

Learner Career Outcomes

42%

started a new career after completing these courses

38%

got a tangible career benefit from this course

32%

got a pay increase or promotion

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at home

26 hours to complete

Language -English

Intermediate Level -

Advanced Level

Instructor

CPIM®,CSCP®,CLTD®, DDFP®,DDPP®

Offered by

EXXPERTSCM

(A UNIT OF THOUGHTWARE TRAINING PVT.LTD.)

Exxpert SCM is formed by a group of Supply Chain Experts with vast industry experience and Data scientists with two decades of practice in the field of Data Science.

 

The primary objective of the organization is to provide consultation and training to companies and career enhancement coaching and classes to individuals who aspire to become better at their professional life.

Nishant Mishra

Blueprint Technology Pvt LTD

Thank you for everything. The course is amazing! It really improved my skills, and actually I've made some great analysis at work thanks to this, so it's more than useful. Thank you once again.

Arti Tripathi

NIDM, National Institute of Digital Marketing

It has been a journey for me and I am glad that I have learned so much in these courses. Also I want to thank all learners who have helped me through the exercises, challenges and assessments.

Raju

This course is overall easier to understand\n\nonly thing i felt was under explained in term of an individual concept was Indirect function,\n\nrest everything is top notch\n\n#EVERYONE_SAY_WOW

Syllabus - What you will learn from this course

Content Rating         94% (326 ratings)

LIVE ONLINE CLASSES

DAY - 1

1. Basic Spread sheet modelling

2. Range names

3. Look-up functions

4. Index functions

5. Match functions

6. Text functions

7. Date functions

DAY - 3

15. Auditing tools

16. Count functions

17. Sum & Average functions

18. Offset functions

19. Indirect function

20. Conditional formatting

21. Sorting

22. Tables

DAY - 5

30. Creating sub-totals

31. Recording macros

32. Sensitivity analysis with data tables 33. Goal seek command

34. Using scenario manager for sensitivity analysis

35. An introduction to optimisation with excel solver

36. Using solver for capital budgeting

DAY - 2

8. NPV calculations

9. IRR calculations

10. Circular references

11. If Statements

12. Time functions

13. Paste special command

14. Three dimensional formulas & hyperlinks

DAY - 4

23. Buttons, Bars & Boxes

24. Importing data from text files or document

25. Validating data

26. Summarizing data using Histograms & Pareto Charts

27. Using Pivot tables and slicers

28. Filtering data and removing duplicates

29. Consolidating data

DAY - 6

37. Using solver for financial planning 38. Travelling sales man problem

39. The data model

40. Power pivot

41. Spark lines

42. Summarizing data with database statistical functions

43. Charting tricks

44. Funs & Games

45. Pricing stock options

46. Array formulas & Functions

About the Excel Skills for Business

This specialization is intended for anyone who seeks to develop one of the most critical and fundamental digital skills today. Spreadsheet software remains one of the most ubiquitous pieces of software used in workplaces across the world. Learning to confidently operate this software means adding a highly valuable asset to your employability portfolio. In the United States alone, millions of job advertisements requiring Excel skills are posted every day. Research by Burning Glass Technologies and Capital One shows that digital skills lead to higher income and better employment opportunities. At a time when digital skills jobs are growing much faster than non-digital jobs, completing this specialization will position you way ahead of others. In this Specialization, learners develop advanced Excel Skills for Business. Upon completing the four courses in this Specialization, learners can design sophisticated spreadsheets, including professional dashboards, and perform complex calculations using advanced Excel features and techniques. Learners have acquired the skills to manage large datasets efficiently, extract meaningful information from datasets, present data and extract information effectively. In addition, learners have mastered the skills needed to validate data and prevent errors in spreadsheets, create automation, apply advanced formulas and conditional logic to help make decisions and create spreadsheets that help forecast and model data. 

Start Learning Today

  • This Course Plus the Full Specialization

  • Shareable Certificates

  • Self-Paced Learning Option

  • Course Videos & Readings

  • Practice Quizzes

  • Graded Assignments with Peer Feedback

  • Graded Quizzes with Feedback

  • Graded Programming Assignments

Shareable on

You can share your Course Certificates in the Certifications section of your LinkedIn profile, on printed resumes, CVs, or other documents.

Exxpert SCM, 

An unit of 

Thoughtware Training Pvt Ltd

Supply Chain Management education and consultancy. A team of supply chain experts offering quality, affordable certification training

Certification Education
Links
Contact

#130 Nehru Main Road
St. Thomas Town Post
Kammanahalli
Bangalore – 560084, India

 6362121253

       9380463997

  • Facebook
  • exxpertscm
Copyright ©2020 All rights reserved | www.exxpertscm.net
An unit of Thoughtware Training Pvt Ltd