by Ian Littlejohn | Publisher: Stone River eLearning | Release Date: January 2018 | ISBN: 200000006A0427

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 the student to practice the skills that have been learnt in 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.

1. Introduction
   • Introduction 00:04:52
2. Tables
   • Create a Table 00:04:32
   • Filtering Text Tables 00:03:51
   • Filtering Numeric Tables 00:04:02
   • Date Filters in Excel 00:03:19
   • Aggregating Data in Tables 00:06:15
   • Slicers with Tables 00:04:53
3. Conditional Formatting
   • Highlight Cell Rules 00:05:23
   • Practical Activity Tables 00:06:49
   • Conditional Formatting Top 10 Analysis 00:03:31
   • Data Bars Colour Scales and Icons 00:04:03
   • Manage Rules 00:07:54
   • Practical Activities Conditional Formatting 00:06:04
4. SUMIF, AVERAGEIF and COUNTIF Formulas
   • SumIf Formulas 00:09:46
   • Sumifs CountIfs and AverageIfs 00:08:29
   • SUMIF Practical Activity 00:08:43
5. Date Formulas
   • Year Month and Day 00:08:48
   • WeekDay and WeekNum Formulas 00:05:40
   • Date and Today Formulas 00:04:51
   • WorkDay and NetWorkDays Formulas 00:03:55
   • How to Correct a Date Field in Excel 00:11:28
   • Practical Activity Date Formulas - Answers 1 00:04:47
   • Practical Activity Date Formulas - Answers 2 00:07:05
6. Text Formulas
   • Working with Text Formulas 00:05:48
7. IF, HLOOKUP and VLOOKUP Formulas
   • IF Formula 00:05:07
   • The VLOOKUP and HLOOKUP Formulas 00:07:14
   • An Example of VLOOKUP Formula 00:05:23
8. Conclusion
   • Conclusion 00:00:51