Classbaze

Disclosure: when you buy through links on our site, we may earn an affiliate commission.

Excel: Power Functions

10 Functions Recommended by the Experts
0.0
☆☆☆☆☆ 0.0/5
(0 reviews)
7 students
Created by
Chip Reaves

7.2

Classbaze Grade®

6.4

Freshness

N/A

Popularity

7.5

Material

Detailed Analysis »

10 Functions Recommended by the Experts
Go to course »
Platform: Udemy
Price: check current price
Video: 48m
Language: English
Next start: On Demand

Best Excel Formulas and Functions classes:

Skillshare_logo_2020
Best Excel Formulas and Functions classes on Skillshare »
Coursera Logo
Best Excel Formulas and Functions classes on Coursera »
Pluralsight Logo
BestExcel Formulas and Functions classes on PluralSight »
Udemy logo
Best Excel Formulas and Functions classes on Udemy »
linkedin
Best Excel Formulas and Functions classes on LinkedIn (Free trial) »

Classbaze Rating

Classbaze Grade®

7.2 / 10

CourseMarks Score® helps students to find the best classes. We aggregate 18 factors, including freshness, student feedback and content diversity.

Freshness

6.4 / 10
This course was last updated on 5/2019.

Course content can become outdated quite quickly. After analysing 71,530 courses, we found that the highest rated courses are updated every year. If a course has not been updated for more than 2 years, you should carefully evaluate the course before enrolling.

Popularity

We analyzed factors such as the rating (0.0/5) and the ratio between the number of reviews and the number of students, which is a great signal of student commitment.

New courses are hard to evaluate because there are no or just a few student ratings, but Student Feedback Score helps you find great courses even with fewer reviews.

Material

7.5 / 10
Video Score: 7.7 / 10
The course includes 48m video content. Courses with more videos usually have a higher average rating. We have found that the sweet spot is 16 hours of video, which is long enough to teach a topic comprehensively, but not overwhelming. Courses over 16 hours of video gets the maximum score.
The average video length is 3 hours 34 minutes of 66 Excel Formulas and Functions courses on Udemy.
Detail Score: 9.4 / 10

The top online course contains a detailed description of the course, what you will learn and also a detailed description about the instructor.

Extra Content Score: 5.5 / 10

Tests, exercises, articles and other resources help students to better understand and deepen their understanding of the topic.

This course contains:

0 article.
0 resource.
0 exercise.
0 test.

In this page

About this course

  The course will teach you this
  What you need to START the course
  Who can start this course?
General questions
  Coupons & Discounts
  Guarantees & money back
  Financial aid
Teacher
Classbaze hand picked recommendations

About the course

Learn to Use the 10 Excel Functions Recommended by the Experts
Excel provides over 400 functions to perform a variety of calculations within your data. With this many functions, it’s guaranteed you’re missing out on some powerhouse formulas that can make your day easier. This course explores 10 functions the experts recommend to expedite your data analysis.
Long Description:
Ask any Excel expert to name their favorite Excel functions, and you’ll receive a variety of suggestions. Some you’ll recognize, others you won’t. This course examines 10 of the functions more commonly listed by the experts and removes the mystery of how and why to use them.
With over 450 functions available in Excel, odds are you aren’t getting the full power of Excel in your workbooks. This course steps you through functions that can increase your productivity and simplify your spreadsheets.
Do you work with dates? Learn how to generate anniversary dates, renewal dates, and end-of-month dates.
Do you need to locate values within a large array of data? Explore options that allow you to locate data anywhere within the database without the VLOOKUP limitation of looking in the leftmost column.
Do you create rolling averages? Learn which functions will help you calculate them.
Once you explore these functions, your spreadsheets will never be the same.

What can you learn from this course?

✓ Locate the syntax of an Excel function and explain the basics of function syntax design.
✓ Explain why function criteria should produce a True result.
✓ Understand and use wildcards in an Excel formula.
✓ Create formula with nested functions.
✓ Write a formula that combines the EDATE and DATEDIF functions to determine anniversary dates.
✓ Write a formula using the EOMONTH function to calculate expiration dates or due dates.
✓ Write a formula using the CONVERT function to convert data from one unit of measure to another (e.g., miles to kilometers).
✓ Find a value in a large array of data without knowing which row or column to search using the INDEX and MATCH functions.
✓ Debug or trace through an Excel formula using the “Evaluate Formula” feature or the Excel Formula Beautifier online tool.
✓ Create a rolling average using the OFFSET function or OFFSET and MATCH.
✓ Write a formula that combines OFFSET with COUNT or COUNTA to expand a range rather than revise the formula to fit the new range.
✓ Calculate totals and subtotals using SUMPRODUCT and describe how this can be used as an alternative to pivot tables.

What you need to start the course?

• Intermediate experience with Microsoft Excel is recommended.

Who is this course is made for?

• Excel users who want to improve their skills.

Are there coupons or discounts for Excel: Power Functions ? What is the current price?

The course costs $11.99. And currently there is a 70% discount on the original price of the course, which was $39.99. So you save $28 if you enroll the course now.
The average price is $14.7 of 66 Excel Formulas and Functions courses. So this course is 18% cheaper than the average Excel Formulas and Functions course on Udemy.

Will I be refunded if I'm not satisfied with the Excel: Power Functions course?

YES, Excel: Power Functions has a 30-day money back guarantee. The 30-day refund policy is designed to allow students to study without risk.

Are there any financial aid for this course?

Currently we could not find a scholarship for the Excel: Power Functions course, but there is a $28 discount from the original price ($39.99). So the current price is just $11.99.

Who will teach this course? Can I trust Chip Reaves?

Chip Reaves has created 93 courses that got 20,010 reviews which are generally positive. Chip Reaves has taught 159,879 students and received a 4.4 average review out of 20,010 reviews. Depending on the information available, we think that Chip Reaves is an instructor that you can trust.

Learn everything about

Chip Reaves

Bigger Brains
     Bigger Brains Founder and President Chip Reaves is a serial entrepreneur who has started five successful companies. An Atlanta native, Chip began fixing computers for small businesses in the 1980’s while studying Computer Science at Georgia Tech. After 10 years building a successful IT Service Practice in Atlanta, Chip founded the Computer Troubleshooters franchise system alongside Wilson & Suzanne McOrist, which became the world’s largest computer service franchise and received multiple awards from Entrepreneur Magazine, Franchise Business Review, and AllBusiness.       Chip has been interviewed on TV and other major media on topics related to small business technology and entrepreneurship, including ABC News, BusinessWeek TV, the Wall Street Journal, and the New York Times, and is a member of Jim Blasingame’s “Brain Trust” on SmallBusinessAdvocate. In 2010 Chip was listed among the Top 150 most influential people in small business IT by SMB PC magazine.       Chip lives with his wife Maren and step-daughter Meg in Anderson, South Carolina where they also co-own a Computer Troubleshooters franchise location. In his spare time Chip is very active with his church and local charities, and consults with two aid organizations serving Rwanda and the Democratic Republic of Congo in Africa. 
Browse all courses by on Classbaze.
Chip Reaves's full profile and courses »
Go to class »

7.2

Classbaze Grade®

6.4

Freshness

N/A

Popularity

7.5

Material

Detailed Analysis »

10 Functions Recommended by the Experts
Go to course »
Platform: Udemy
Price: check current price
Video: 48m
Language: English
Next start: On Demand

Classbaze recommendations for you

Learn to use tables and create powerful formulas in Excel. Learn SumIF

Tables and Formulas with Excel

Learn to use tables and create powerful formulas in Excel. Learn SumIF, Date, IF, VLOOKUP and Text formulas
4.4
★★★★★ 4.4/5
6,520 students

Other courses by ​Chip Reaves

Go to class »