Tables and Formulas with Excel 2013

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.

Course Overview

• ​Almost 90 minutes of content, 27 lectures and downloadable training data files
• Learn how to create and format Tables
• Easily filter data in text, numeric and date fields, 
• Easily Sum, Average, Count and use Max and Min in your Table
• 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 formulas such as Year, Month, WeekDay, NewWorkDays and 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

Course Requirements

Excel 2010 or 2013

/

• 1
• 2
• 3
• 4
• 5

So simple while being so effective.

/

• 1
• 2
• 3
• 4
• 5

/

• 1
• 2
• 3
• 4
• 5

Great training with very informative information. The practice excel sheets were very helpful.

/

• 1
• 2
• 3
• 4
• 5

/

• 1
• 2
• 3
• 4
• 5

Great course, easy to understand, instructor takes his time, lots of exercises.

/

• 1
• 2
• 3
• 4
• 5

• 0
• 1
• 2