Advanced Excel Formulas and Functions
32+ Hours | 11 Online Courses | Verifiable Certificate of Completion | Lifetime Access
Self-Paced Training
-
Learning Path
Courses No. of Hours Certificates Details Section 1
Microsoft Excel Charts and SmartArt Graphi... 6h 4m ✔ Power Excel Training 5h 15m ✔ MS Excel Shortcuts 8h 22m ✔ Section 2
Mastering Microsoft Excel Date and Time 2h 47m ✔ Section 3
Date and Time Functions Microsoft Excel Tr... 2h 37m ✔ Shortcuts in Microsoft Excel 24m ✔ Graphs & Charts in Microsoft Excel 201... 2h 6m ✔ Financial Functions In MS Excel 2h 36m ✔ Statistical Tools in Microsoft Excel 1h 11m ✔ Section 4
Microsoft Excel Solver Tutorial 48m ✔ Microsoft Excel for Financial Analysis 49m ✔ Section 5
Test - Excel Exam - Complete Test - Excel Complete Test Series Test - Excel Essential Exam Test - Amazing Excel Practice Test Test - Microsoft Excel Beginner Exam Test - Mock Excel Test Series Test - Excel 2023 Complete Test Series Test - Microsoft Excel Practice Test Test - Basic Excel Practice Test Test - Advanced Excel Practice Test Course Curriculum
-
certificate
-
reviews
Excel Charts and SmartArt Graphics
The course is a comprehensive tutorial on excel chart and smart graphics. The videos give in depth explanation of various types of charts and how to use them for presenting data. Then it moves on to smart arts and graphics which can be used to enhance appearance of data. After going through the videos, one can gain confidence in handling various types of graphics and charts. I thank educba for providing the set of videos on this topic.
Himanshu Sharma Linked
Power Excel Training
The course was good. It gave insights into the various ways in which the functions available in excel can be used. The various ways to create a pivot table, design a pivot table, make changes to existing pivot table and various other useful things which can be done in pivot table was also taught in this course
Keerthi Vasan
Power Excel Tools
The course is focused mainly on pivot tables. If you have a large data set and you want to analyse it, Pivot table will come handy and is an extremely strong tool. The course is well designed and explains all the features and uses of pivot table in a nice way. I would like to recommend it for anyone looking to learn data analysis.
Ayush Sharma Linked
Date Time Function in Excel
This was wonderful crash course on date and time function in SQL. This is quite helpful also if you are working with the DB or MS. All the functions have been illustrated with the help of examples, which can be very useful and helped me to understand the concept quickly. Also have noted down the functions in a stored place.
Uday Shankar Linked
Charts and Graphs in 2013
As an advanced user of excel it's mandate to update my knoledge on regular basis. This course is crisp and clear,well designed. Real time examples and practice files are very help full. Continuous practice is important, just watching videos we can't learn excel. It will be really help full if there is any discussion platform.
HIMAVATH KUMAR KANUMURI Linked
Wow again! I'm still learning more and more.
These products are well done and worth the money I spent to learn. eduCBA has so many interesting courses and new courses being offered regularly, that I look forward to seeing what is next and that I can apply to the Excel foundation I have now. Since owning the other more courses dealing with the specific specialty aspects in the Excel program, such as Macros, VBA’s (basic and advanced) and financial functions, I feel very confident that I will accelerate to a more advanced understanding to easily analyze data for my position in my field of work. I would recommend the life time access to these courses and others offered by eduCBA if it is practical for you to do.
Jim Nixon
A very informative course
This was a very informative course on financial functions in Excel that introduces formulas to determine Future Value, Present Value, Simple Interest, Compound Interest, NPER, Interest Rate, Multiple and Discounted Cash Flows, Rate of Return, PMT, and Bond Valuation among other Excel features. I appreciated the instructor's pace as well as the inclusion of multiple practice exercises.
Lucia Lopez Otal
Excellent course on Financial functions
Excel sheets provided are very helpful in practising the functions at the end of each module. Add a pdf document comprising of all the Financial Functions that had been taught in the course.It is very educational and I enjoyed every bit of it and recommend this course 100%.
PUVVADA ADITYA CHANDRA
Statistical Tools in Excel: Review
This course was great to attend and learn about Excel's "Data Analytics" add-in function!
Sumari Hattingh Van Niekerk Linked
Comprehensive course for refresher
Great course for someone like me who's been using Excel everyday but didn't know about data analysis tool available in it. I've always have to open JMP for analysis even just for simple charting and correlation plotting. Now I know I can do that in Excel too. Thanks! :)
Michelle Esber Linked
Excel solver tutorial
Even more content can be added. Very few examples very solved when compared to the extent solver can be used. The way of teaching, communication skills and application of solver was good. If the entire application of solver is allowed, this course would be perfect.
Keerthi Vasan
Excel for Financial Analysis
This module gives an good idea of Financial functions in excel. This course gives an over all picture regarding important financial functions like NPV, PV, IRR (by using Goal seek function). Stock prices analysis is very useful & easy to understand. I recommend to go through this module, to get good hold on Financial Analysis, by using financial functions.
Ganesh Raju J Linked
Excel for financial analysis
The course is very well written. All the basic used tools and functions of financial analysis are explained in a very simple manner. The best part about the course is that All the explanation has been done using the Excel live throughout the course. The basic concepts and usage of NPVs and IRRs has also been explained well. The criteria for selection of projects, which is one of the main learning in corporate finance is also clear after this video.
Ayush Sharma Linked
-
faqs
- Can I access this course from anywhere?
Yes, you can definitely access this course from anywhere & everywhere. Once you are registered for this Online Training Bundle, you will get your own login credentials which you can use to access the video materials and other contents from anywhere.
- Is there a Classroom Training available for this Online Training?
All our courses are available online so as to enable any user, who may have limited time, to study his courses of choice online. The training materials are accessible 24*7 for the users.
- Who are the Instructors for this Online Training?
The instructors are Industry based professional who have had tons of experience in the field of Online Training. All the courses in this bundle are based on Industry based standards. Also the courses have been started from Scratch to get the participant well-acquainted with each and every Online Training concept.
- Are there any Certification Courses for Online Training available in this Online Training bundle?
Yes, there are certification courses available for the same in this Ultimate Online Training Bundle. To name a few- PMI-ACP Exam Prep – PMI Agile Certified Practitioner Training, PMP Exam Prep Training, NCFM based Modules, ITIL Modules, CFA Training etc.
- When will I receive my certificate for any course?
You will receive certificate for completing each course in the Online Training Bundle. Once you have seen more than 70% of the training material in any course, you can issue your certificate.
- Are there any Pre-requisites for enrolling to this Online Training Bundle?
No, there are no pre-requisites for this training. Anyone who is keen to learn about specific Industry based domains can enroll for this Ultimate bundle.
- Will I get any technical Support during my Training at eduCBA?
Yes, you will be getting technical Support from eduCBA. In case you have any technical issue, you can drop us a mail or call us to get your doubts cleared.
- What are the Payment Options?
There are both Online & Offline Payment options available. In online payment options you pay by Credit Card, Debit Card or Net Banking. In offline payment option you can deposit Cash, Cheque or Demand Draft.
- What if I have more Queries?
Just drop us a mail on [email protected]