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 learned in the course.
The course will provide you with a comprehensive understanding of the following:
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
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
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.