Mastering Excel- Formulas & Tables

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.

Tables and Formulas with Excel



 Overview of Tables and Formulas in Excel






 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




 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




 Introduction to IF HLookUP and VLookUP


 IF Formula


 The VLOOKUP and HLOOKUP Formulas


 An Example of VLOOKUP Formula




More than 20000 students on Udemy

  • 4.1 Instructor Rating
  • Best Seller Course
  • Highest Rated Course
  • Courses used by udemy for business clients.

210K students on our platform

  • Unlimited access to all courses.
  • Top Courses for every trending technologies.
  • 4.5 Average ratings for all the courses.
  • Certificate Internationally accepted.

Learn at your pace

Courses Made By Industry Experts

Enhance your career

Enroll NowContact us