Tables and Formulas with Excel
What you'll 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
Requirements
- Users should be familiar with Excel and entering data into Excel
Description
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.
Who this course is for:
- Excel users and people learning Excel
Course content
- Preview02:47
- 00:56Overview of Tables and Formulas in Excel
- Preview01:55
- 00:04Download the Training Data Files
Instructor
![Ian Littlejohn](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.6 Instructor Rating
- 42,496 Reviews
- 132,292 Students
- 17 Courses
Ian is a trainer that specializes in Microsoft Excel Business Intelligence tools, Power BI and Google Data Studio.
Ian is an experienced trainer that teaches techniques 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 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.