Courses Infomation

Integrity Training – Tables and Formulas with Excel

**More information:

Description

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.

We guarantee that all our online courses will meet or exceed your expectations. If you are not 100% satisfied with a course – for any reason at all – simply request a full refund.

That’s our promise to you. We hate games, gimmicks and tricks as much as you do. We guarantee no hassles if you want a refund, so ahead and order with confidence. You have absolutely nothing to lose.

Course Curriculum

Introduction

Start

Overview of Tables and Formulas in Excel
Start

Introduction (4:52)

Tables

Start

Overview of Tables
Start

Employee Master
Start

Create a Table (4:32)
Preview

Filtering Text Tables (3:50)
Start

Filtering Numeric Tables (4:02)
Start

Date Filters in Excel (3:18)
Start

Aggregating Data in Tables (6:14)
Start

Slicers with Tables (4:52)
Start

Sales Data
Preview

Practical Activity Tables
Start

Practical Activity Tables (6:49)

Conditional Formatting

Start

Overview of Conditional Formatting
Start

Highlight Cell Rules (5:23)
Preview

Conditional Formatting Top 10 Analysis (3:30)
Start

Data Bars Colour Scales and Icons (4:02)
Start

Manage Rules (7:54)
Start

Practical Activity Conditional Formatting
Start

Practical Activities Conditional Formatting (6:04)

SUMIF, AVERAGEIF and COUNTIF Formulas

Start

Introduction to SUMIF Formulas
Start

SumIf Formulas (9:45)
Preview

Sumifs CountIfs and AverageIfs (8:29)
Start

Practical Activity SUMIF
Start

SUMIF Practical Activity (8:42)

Date Formulas

Start

Introduction to Date Formulas
Start

Year Month and Day (8:47)
Start

WeekDay and WeekNum Formulas (5:40)
Start

Date and Today Formulas (3:55)
Preview

Formula File
Start

WorkDay and NetWorkDays Formulas (4:50)
Start

How to Correct a Date Field in Excel (11:28)
Start

Practical Activity Date Formulas
Start

Practical Activity Date Formulas – Answers 1 (4:46)
Preview

Practical Activity Date Formulas – Answers 2 (7:05)

Text Formulas

Start

Working with Text Formulas (5:48)

IF, HLOOKUP and VLOOKUP Formulas

Start

Introduction to IF HLookUP and VLookUP
Start

IF Formula (5:07)
Preview

The VLOOKUP and HLOOKUP Formulas (7:14)
Start

An Example of VLOOKUP Formula (5:23)

Conclusion

Start

Conclusion (0:51)

Forex Trading – Foreign Exchange Course

Want to learn about Forex?

Foreign exchange, or forex, is the conversion of one country’s currency into another.
In a free economy, a country’s currency is valued according to the laws of supply and demand.
In other words, a currency’s value can be pegged to another country’s currency, such as the U.S. dollar, or even to a basket of currencies.
A country’s currency value may also be set by the country’s government.
However, most countries float their currencies freely against those of other countries, which keeps them in constant fluctuation.

Salepage : Integrity Training – Tables and Formulas with Excel