Tables and Formulas with Excel [2021 Edition] (Udemy.com)

Learn to use tables and create powerful formulas in Excel. Learn SumIF, Date, IF, VLOOKUP and Text formulas

4.6
( 151 Reviews )

Created by: Ian Littlejohn

Produced in 2021

icon
What you will learn

  • 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

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 92 / 100

icon
Course Description

**** Updated Feb 2021 - This best selling Excel course has been updated **** 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 100 000 enrollments on Udemy and consistently high reviews. Ian specialises in teaching data analysis techniques, Excel Pivot Tables, Power Pivot, Microsoft Power BIand Google Data Studio. **** 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:
TablesHow to create and format TablesHow to easily filter data in text, numeric and date fieldsEasily Sum, Average, Count and use Max and Min in your tablesUse Slicers to easily filter Table dataConditional FormattingHow to apply conditional formatting rulesHow to easily highlight the Top 10 Learn to use Data Bars and Color ScalesLearn to apply iconsFormulasLearn SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS, COUNTIF and COUNTIFSLearn a range of Date formula such as Year, Month, WeekDay, NetWorkDays amd WorkDayLearn Text formulas such as LEFT, MID, RIGHT and TRIMLearn to use the IF formula to create powerful 'IF Then' logicLearn the HLOOKUP and VLOOKUPThis 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.
Who this course is for:
Excel users and people learning Excel
Read More product length iconTime: 3h

icon
Instructor Details

Ian Littlejohn

Ian is a trainer that specializes in Microsoft Excel Business Intelligence tools, Power BI and Google Data Studio.
Ian is an experienced trainer that teachestechniques and tools making it easy for learners to harness the power of Excel PivotTables, PowerPivot, Power Query,Power BI and Google Data Studio.
Ian has been training learners on these powerful technologies for over 10 yearsmaking 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 Studiousers 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.

Read More

icon
More courses by Ian Littlejohn

Complete Introduction to Microsoft Power BI [2021 Edition]

$11.99

Complete Introduction to Google Data Studio 2021 Edition

$11.99

Power BI Master Class-Data Models and DAX Formulas 2021

$11.99

Power BI Master Class - Query Editor [2021 Edition]

$11.99

Complete Introduction to Excel Pivot Tables and Pivot Charts

$11.99

Google Analytics Reports and Dashboards with Data Studio

$11.99

All courses by Ian Littlejohn

icon
More excel courses

Excel Skills for Business: Essentials

Free

Excel Skills for Business: Intermediate I

Free

Excel Dynamic Arrays - Beginner to Expert (Microsoft 365)

$11.99

Visually Stunning Microsoft Excel Dynamic Dashboard Course

$11.99

Excel with Top Microsoft Excel Hacks

$11.99

Microsoft Excel Complete Excel Guide (Excel 2007 2021)

$11.99

All excel courses

icon
Reviews

4.6

151 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete
Reset Filter
Write a Review arrow

By Rotich Kipkirui Amos on 11/15/2020

GREAT

By Ann Claeson on 11/15/2020

Learned a LOT of new things. Very thorough.

By Daniyal Faheem on 9/14/2020

Absolutely cleared all my doubts regarding V-Lookup !! Thank you.

By Refilwe Lekalakala on 8/14/2020

The course was a good match learning a lot in terms of using the excel sheet for reports and capturing data .

By Wendy Joosen on 8/7/2020

Easy to understand with the examples and you can do the examples together with them, so that's good.

By Marcia Malpas on 8/4/2020

This was helpful learning for me. It was a little fast paced for a non-excel expert like me but would recommend this course to colleagues.

By Neha Jaeel on 8/3/2020

nice course

By April Hunsaker on 7/16/2020

I wish the Vlook up and Hlook up covered pulling from mulit tabs.

By salim nadaf on 6/27/2020

Each&every topics contained in this session explained well & its good for beginners those wants to learn excel topics from basics. It was good experince to me related to this course. hope so i am looking to take further course related to excel. Thank you sir.

By Anonymized User on 6/7/2020

It was a good course but for me personally I would have liked more time on VLookUp and less on Index and Match

By Jeannetta Visser on 5/24/2020

I can follow the steps well, and I have learned lots of new things

By Arches Arun Purav on 5/22/2020

IT WAS GOOD AS FAR AS CONSIDERING ALL MY REQUIREMENT

Load More

Tables and Formulas with Excel [2021 Edition]
Visit Course Write a Review
  • Video Duration: icon 3h
  • Price: 11.99 Track Price 11.99 Track Price
  • Provider: icon Udemy
  • Year: icon 2021
  • Language: icon English
  • Certificate: icon Yes
30-Day Money-Back Guarantee

Udemy Coupon Price Tracker

For any issues or feature requests please email CourseDuck's Co-Founder at michaelk@courseduck.com