Mastering Excel- Formulas & Tables

  • Duration – 15 hours

Data is being collected all the time and for increasingly detailed transactions. This can lead to an overwhelming amount of data, which brings about a need for people who can analyze large amounts of data quickly. 

Excel provides Power Pivot to help you organize, manipulate, and report on your data in the best way possible. Since a tool is only as good as the person using it, it is important to gain a solid understanding of Power Pivot to maximize your effectiveness when analyzing data.

All MS EXCEL Courses bundle

$40

Tables and Formulas with Excel

Introduction

 

 Overview of Tables and Formulas in Excel

 

 Introduction

 

Tables

 

 Overview of Tables

 

 Employee Master

 

 Create a Table

 

 Filtering Text Tables

 

 Filtering Numeric Tables

 

 Date Filters in Excel

 

 Aggregating Data in Tables

 

 Slicers with Tables

 

 Sales Data

 

 Practical Activity Tables

 

 Practical Activity Tables

 

Conditional Formatting

 

 Overview of Conditional Formatting

 

 Highlight Cell Rules

 

 Conditional Formatting Top  Analysis

 

 Data Bars Colour Scales and Icons

 

 Manage Rules

 

 Practical Activity Conditional Formatting

 

 Practical Activities Conditional Formatting

 

SUMIF, AVERAGEIF and COUNTIF Formulas

 

 Introduction to SUMIF Formulas

 

 SumIf Formulas

 

 Sumifs CountIfs and AverageIfs

 

 Practical Activity SUMIF

 

 SUMIF Practical Activity

 

Date Formulas

 

 Introduction to Date Formulas

 

 Year Month and Day

 

 WeekDay and WeekNum Formulas

 

 Date and Today Formulas

 

 Formula File

 

 WorkDay and NetWorkDays Formulas

 

 How to Correct a Date Field in Excel

 

 Practical Activity Date Formulas

 

 Practical Activity Date Formulas – Answers  

 

 Practical Activity Date Formulas – Answers  

 

Text Formulas

 

 Working with Text Formulas

 

IF, HLOOKUP and VLOOKUP Formulas

 

 Introduction to IF HLookUP and VLookUP

 

 IF Formula

 

 The VLOOKUP and HLOOKUP Formulas

 

 An Example of VLOOKUP Formula

 

 Conclusion

 

300+ Courses

After your course completion, we provide course completion certificate as well.

Lifetime Access

All courses are for lifetime access.

l

Priority Support

All queries are answered 24/7.

What People Are Saying

Abhilash -

A very good match. i am enjoying every bit.

Sonal-

Experience was quite good and it was very useful and well elaborated course.

Karan-

I FEEL AS IF I AM ATTENDING A WORLD CLASS TRAINING AND THE LECTURER HAS BEEN AWESOME!

Gilbert-

I find that the explanation is good and also understandable.

Seyed-

Really helpful, recommended to everyone to grow up your future skills for next level especially in this competitive market.

Mayur-

I really like this course, it was a good match for me :))

Mahesh-

Standard process and hands on covered nicely.

 

Emily-

Perfect, with complete hands on. Well structured and nicely covered.

Kevin-

Great Content, nice and up to the mark course.

Mayuresh-

 

Great courses. Beginner friendly and the explanations are clear and very easy to understand.

Saket-

Instructor showed multiple ways of using a concept and how to solve the problem. Excellent course and lecture by the instructor.

Tushar-

A very detailed explanation and quite handy tips and tricks! loved it

Sourabh-

 

Excellent lecture, pace of the instructor is very good, easy to understand

Rishi-

Instructor showed multiple ways of using a concept and how to solve the problem. Excellent course and lecture by the instructor.

Mahima-

This Courses is really useful for my career and surely i will recommend other to fulfill their career goals.

 Mauricio Roldan -

A pesar de no dominar perfectamente el idioma, se entiende bien.

Emile-

Yes lessons are very good. Not so fast, well explained

Kishore-

Worth course for the beginner to invest their time to learn this demanding skills.

Learn at your pace

Courses Made By Industry Experts

Enhance your career

Enroll NowContact us