Skip to content
Data Analytics Logo
  • Home
  • About Us
  • Course Portfolio
    • Microsoft Excel for Professionals
    • Microsoft Excel Advanced Master Class
    • Power BI
  • Blog
  • Photo Gallery
  • Register
  • Menu

Tag Archives: Conditional Formatting

VLOOKUP & INDEX/MATCH Inside Conditional Formatting

Posted on August 1, 2020August 2, 2020 by Abiola David | No Comments

Welcome to Excel Jet Consult. In this blog post, we will learn how to use VLOOKUP & INDEX/MATCH Inside Conditional Formatting. Let’s get started Video You can watch the video of this tutorial below. Do subscribe to my YouTube channel for more videos Sample Data In the caption below, we have Date, Items, States and Actual from columns A to […]

Continue reading→

Blog Posts

  • #MsSQLServer: Calculate Total Revenue by Brand
  • Track Forbes MPP Birthday Status using IFS Function in #Excel
  • MID and SEARCH Text Functions Inside SUMIFS plus List Data Validation
  • Retrieve Single and Multiple Non contiguous columns in MS SQL Server
  • Connect and Import Data from Excel to SQL Server
  • Combo Chart in PowerPoint using Excel Data
  • Recursive LAMBDA with Structured Reference
  • Total Sales in Excel & Tableau
  • Array Constants with VLOOKUP in Excel and Google Sheets Compared
  • Calculator in Excel VBA Coding Part 2
  • Calculator in Excel VBA Coding Part 2
  • How to Create Animated GIF in PowerPoint (Covid-19 Slides)
  • Create Animated GIF in PowerPoint
  • Excel Hash Challenge 2021
  • Calculator in Excel VBA (User Interface Design) Part One

Copyright 2019 © Excel Jet Consult. All Rights Reserved

A SiteOrigin Theme