EDUCBA

EDUCBA

MENUMENU
  • Blog
  • Free Tutorials
  • All Courses
  • Login
Home Advanced Excel Formulas and Functions

Advanced Excel Formulas and Functions

32+ Hours | 11 Online Courses | Verifiable Certificate of Completion | Lifetime Access

  • 4.6

Self-Paced Training

  • Learning Path
  • Certificate
  • Reviews
  • FAQ

Enroll Now
*Please provide your correct email id. Free Course details will be emailed to you

This Learning Path includes:

  • 32+ Hours
  • 11 Online Courses
  • Lifetime Access
  • Certificate
  • Learning Path

    Courses No. of Hours Certificates Details

    Section 1

    Microsoft Excel Charts and SmartArt Graphi...6h 4m✔
    Power Excel Training5h 15m✔
    MS Excel Shortcuts8h 22m✔

    Section 2

    Mastering Microsoft Excel Date and Time2h 47m✔

    Section 3

    Date and Time Functions Microsoft Excel Tr...2h 37m✔
    Shortcuts in Microsoft Excel24m✔
    Graphs & Charts in Microsoft Excel 201...2h 6m✔
    Financial Functions In MS Excel2h 36m✔
    Statistical Tools in Microsoft Excel1h 11m✔

    Section 4

    Microsoft Excel Solver Tutorial48m✔
    Microsoft Excel for Financial Analysis49m✔

    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

    certificate
  • reviews

    Himanshu Sharma

    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

    Keerthi Vasan

    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

    Ayush Sharma

    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

    Uday Shankar

    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

    HIMAVATH KUMAR KANUMURI

    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

    Jim Nixon

    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

    Lucia Lopez Otal

    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

    PUVVADA ADITYA CHANDRA

    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

    Sumari Hattingh Van Niekerk

    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

    Michelle Esber

    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

    Keerthi Vasan

    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

    Ganesh Raju J

    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

    Ayush Sharma

    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

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

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

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

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

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

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

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

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

    1. What if I have more Queries?

    Just drop us a mail on [email protected]

    Back to top ▴


Footer
Follow us!
  • Refer and Earn
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedIN
  • EDUCBA InstagramEDUCBA Youtube
Company
  • About us
  • Alumni Speak
  • Contact Us
  • Sign In
Work with us
  • Careers
  • Become an Instructor
  • Become a Partner
  • Become an Affiliate
Resources
  • Blog
  • Self-Paced Training
  • ExamTurf
  • Verifiable Certificate
  • Popular Skills Catalogue
  • Exam Prep Catalogue
Popular Categories
  • Lifetime Membership
  • Finance
  • Data Science
  • Software and Tech
  • Design and Drawing
  • Excel
  • Project Management
  • Marketing
  • Personal Development
  • Human Resource
  • Exam Prep
  • SkillUP 101 @ FREE
Trending Resources
Blog | Python Tutorial | Java Tutorial | C sharp Tutorial | HTML Tutorial | JavaScript Tutorial | PHP Tutorial | Big Data Tutorial | Hadoop Tutorial | Machine Learning Tutorial | Artificial Intelligence Tutorial | DevOps Tutorial | Tableau Tutorial | Photoshop Tutorial | After Effects Tutorial | Illustrator Tutorial | AutoCAD Tutorial | 3ds Max Tutorial | CorelDraw Tutorial |
Apps
EDUCBA Android AppEDUCBA iOS App
  • Terms & Conditions
  • Disclaimer
  • Privacy Policy & Cookie Policy
  • Shipping Policy

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy