Integrity Training – Tables and Formulas with Excel
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
-
Start
Overview of Tables and Formulas in Excel
-
Start
Introduction (4:52)
-
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)
-
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)
![Mark Douglas – Trading Psychology [4 mp3]](https://vincourse.info/wp-content/uploads/2020/01/Mark-Douglas-–-Trading-Psychology-4-mp3-350x350.jpg)
Lord –
This is Digital Download service, the course is available at Coursecui.com and Email download delivery.