Online
eduCBA SkillUP in Excel 2019 eduCBA

Course details

For professionals who are unfamiliar with Microsoft Excel, one of the simple courses. The course continues along at a steady speed and covers all of MS Excel's features, from creating new files to saving them. The third segment will cover a portion of mathematical functions. We'll cover SUBTOTAL (returns subtotal in a list or database), SUM (adds its arguments), SUMIF (adds the cells in a range that meet multiple criteria), SUMPRODUCT (returns the sum of the products of corresponding array components), SUMSQ (returns the sum of the squares of the arguments), and SUMX2MY2 (returns the sum of the squares of the arguments) (returns the sum of the difference of squares of corresponding values in two arrays). Mathematical Functions' second section will concentrate on RANDARRAY, which returns an array of random values between 0 and 1. RANDBETWEEN (returns a random number between the numbers you provide) and RAND (returns a random number between 0 and 1). The function SUMX2PY2 returns the squared sum of the matching values in two arrays. The function SUMXMY2 returns the squared difference between the matching values in two arrays. The first portion will now discuss the logical section. There will be discussion of the following formulas: IF (Use this function to return one value if a condition is true and another value if its false), IFS (checks whether one or more conditions are met and returns a value that corresponds to the first True condition). The course includes material including conditional formatting, working with mathematical operations, functions for computations and analysis. Additionally, to help them with the functions covered in class, students will have access to reference files. Updated on 09 February, 2023

About eduCBA

An initiative by IIT IIM Graduates, eduCBA is a leading global provider of skill based education addressing the needs 500,000+ members across 40+ Countries. Our unique step-by-step, online learning model along with amazing 5421 courses prepared by top notch professionals from the Industry help participants achieve their goals successfully. All our training programs are Job oriented skill based programs demanded by the Industry. At eduCBA, it is a matter of pride to us to make job oriented hands on courses available to anyone, any time and anywhere. Therefore we ensure that you can enroll 24 hours a day, seven days a week, 365 days a year. Learn at a time and place, and pace that is of your choice. Plan your study to suit your convenience and schedule.

What we do : We teach you real world skills on everything from Investment Banking to Programming to Project Management to Design – and much, much more.

How we do it : Through online video training. Our high-quality, skill-based 5421 video training programs help members achieve their goals successfully.

589 students have enrolled with eduCBA through Laimoon
See all eduCBA courses

Rate this page

80% Off for Laimoon Users! Get This Deal
AED 77
Money Back Guarantee