Classbaze

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

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
(1,823 reviews)
6,520 students
Created by
Ian Littlejohn

9.8

Classbaze Grade®

9.9

Freshness

9.5

Popularity

9.3

Material

Detailed Analysis »

Learn to use tables and create powerful formulas in Excel. Learn SumIF
Go to course »
Platform: Udemy
Price: check current price
Video: 3h 6m
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®

9.8 / 10

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

Freshness

9.9 / 10
This course was last updated on 3/2022.

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

9.5 / 10
We analyzed factors such as the rating (4.4/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

9.3 / 10
Video Score: 8.0 / 10
The course includes 3h 6m 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: 10.0 / 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: 9.9 / 10

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

This course contains:

13 articles.
6 resources.
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

In this course you will learn how to use a number of formulas that will help you get your work done with less effort, as well as how to leverage the benefits of Excel tables.  You will also learn about using conditional formatting. 
This course is lead by Ian Littlejohn – an international trainer, consultant and data analyst with over 125 000 enrollments & 100 000 students on Udemy. Ian specializes in teaching data analysis techniques, Excel Pivot Tables, Power Pivot, Microsoft Power BI, Google Data Studio & Amazon Quicksight & his courses average over 4.5 stars out of 5.
Recent reviews:
“This training was very helpful in upgrading knowledge in Excel with the help of practical exercises. I would definitely recommend this course.”
“Excellent, efficient and informative course. The exercises after each set of videos was particularly useful.”
“I found the course very informative. I am pretty good with excel but I learned quite a few tips and tricks that I can implement.”
In this course you will learn how to use a number of formulas that will help you get your work done with less effort, as well as how to leverage the benefits of Excel tables.  You will also learn about using conditional formatting. 
This course is lead by Ian Littlejohn – an international trainer, consultant and data analyst with over 125 000 enrollments & 100 000 students on Udemy. Ian specializes in teaching data analysis techniques, Excel Pivot Tables, Power Pivot, Microsoft Power BI, Google Data Studio & Amazon Quicksight & his courses average over 4.5 stars out of 5. 
**** Life time access to course materials and practice activities. ****
Welcome to this course on Tables, Conditional Formatting and Excel formulas.  This course is for all Excel users who want to take their Excel skills and capabilities to the next level. 
This course will increase your productivity as you use tables, conditional formatting and formulas with ease in your Excel spreadsheets.  The course is presented in an easy to follow step by step approach.  The course also includes practical activities for you to practice the skills that you have been learnt on the course.
The course will provide you with a comprehensive understanding of the following:
Tables
•How to create and format Tables
•How to easily filter data in text, numeric and date fields
•Easily Sum, Average, Count and use Max and Min in your tables
•Use Slicers to easily filter Table data
Conditional Formatting
•How to apply conditional formatting rules
•How to easily highlight the Top 10
•Learn to use Data Bars and Color Scales
•Learn to apply icons
Formulas
•Learn SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS, COUNTIF and COUNTIFS
•Learn a range of Date formula such as Year, Month, WeekDay, NetWorkDays amd WorkDay
•Learn Text formulas such as LEFT, MID, RIGHT and TRIM
•Learn to use the IF formula to create powerful ‘IF Then’ logic
•Learn the HLOOKUP and VLOOKUP
This course is presented in Excel 2013. A minimum of Excel 2007 is required to be able to work with the Tables, Conditional Formatting and some of the formula functions.

What can you learn from this course?

✓ Easily create, manage and filter tables to answer key questions of your data
✓ Learn the IF, HLOOKUP, VLOOKUP and other functions for powerful capabilities
✓ Easily aggregate data in Tables using Sum, Count, Average, Max and Min
✓ Use Conditional Formatting to highlight data according to a range of conditions
✓ Learn to use Data Bars, Color Scales and Icons in Spreadsheets
✓ Use the SUMIF, COUNTIF and AVERAGEIF functions to easily calculate filtered data
✓ Use Date formulas to calculate time / date intelligence
✓ Use Text formulas to manipulate text entries

What you need to start the course?

• Users should be familiar with Excel and entering data into Excel

Who is this course is made for?

• Excel users and people learning Excel

Are there coupons or discounts for Tables and Formulas with Excel ? What is the current price?

The course costs $14.99. And currently there is a 50% discount on the original price of the course, which was $29.99. So you save $15 if you enroll the course now.
The average price is $14.7 of 66 Excel Formulas and Functions courses. So this course is 2% more expensive than the average Excel Formulas and Functions course on Udemy.

Will I be refunded if I'm not satisfied with the Tables and Formulas with Excel course?

YES, Tables and Formulas with Excel 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 Tables and Formulas with Excel course, but there is a $15 discount from the original price ($29.99). So the current price is just $14.99.

Who will teach this course? Can I trust Ian Littlejohn?

Ian Littlejohn has created 17 courses that got 57,137 reviews which are generally positive. Ian Littlejohn has taught 172,770 students and received a 4.6 average review out of 57,137 reviews. Depending on the information available, we think that Ian Littlejohn is an instructor that you can trust.

Learn everything about

Ian Littlejohn

Excel Power Tools, Power BI and Google Data Studio Trainer
Ian is a trainer that specializes in Microsoft Power BI, Excel Pivot Tables, Power Pivot, Power Query, Google Data Studio and AWS QuickSight.
 Ian is an experienced trainer that teaches techniques and tools making it easy for learners to harness the power of business intelligence tools to easily turn data into insight and intelligence.
Ian has been training learners on these powerful technologies for over 10 years making it easy for business users to easily create management reports, develop interactive dashboards and generate new insight and intelligence from business data. 
Ian has over 10 years of Management Consulting experience and he brings this knowledge and skills to his training course showing Excel and Google Data Studio users how to easily create sophisticated management reports, perform data analysis and create amazing interactive dashboards without using any complex programming or specialized tools. 
Ian has consulted and worked with major organizations in the Banking, Insurance, Manufacturing, Telecommunications and Logistics industries across a number of countries and continents. 
Browse all courses by on Classbaze.
Ian Littlejohn's full profile and courses »
Go to class »

9.8

Classbaze Grade®

9.9

Freshness

9.5

Popularity

9.3

Material

Detailed Analysis »

Learn to use tables and create powerful formulas in Excel. Learn SumIF
Go to course »
Platform: Udemy
Price: check current price
Video: 3h 6m
Language: English
Next start: On Demand

Classbaze recommendations for you

Learn 40 Microsoft Excel Functions Step by Step

Excel Functions

Learn 40 Microsoft Excel Functions Step by Step
4.2
★★★★★ 4.2/5
8,067 students

Other courses by ​Ian Littlejohn

Go to class »