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
Slider

VLOOKUP Approximate Match

Posted on December 5, 2018October 5, 2019 by Abiola David | No Comments

Welcome to Excel Jet Consult blog post. In this short video tutorial, we will to learn how to use the VLOOKUP function approximate match. Enjoy

Continue reading→

Dynamic Advanced Conditional Formatting With Data Validation

Posted on November 29, 2018October 5, 2019 by Abiola David | No Comments

Welcome to Excel Jet Consult blog post. In this short video tutorial, we will learn how to dynamically apply conditional formatting to our  data with List Data Validation drop-down. Enjoy the video

Continue reading→

Array Formula: SUM Contiguous & Non-Contiguous Values With VLOOKUP

Posted on November 29, 2018October 9, 2019 by Abiola David | No Comments

Welcome to Excel Jet Consult. In this video tutorial, we will learn how to sum contiguous and non_contiguous values using VLOOKUP & SUM functions with array formula. Enjoy the video

Continue reading→

Post navigation

« Previous 1 … 18 19 20 21 22 23

Blog Posts

  • Calculator in Excel VBA Coding Part 2
  • Create Animated GIF in PowerPoint
  • Calculator in Excel VBA (User Interface Design) Part One
  • Linear Equation Computation and Graph in Excel
  • Get & Append Data From GOOGLE SHEETS and MICROSOFT ACCESS to Create Excel PivotTable Report
  • Merry Christmas in Random Font Colors
  • CONDITIONALFORMATTING Custom Function using XLOOKUP & LAMBDA Functions
  • SUMBETWEENMONTH Custom Function using SUMIFS | LET | LAMBDA Functions
  • TEXTSPLIT Custom Function using New LAMBDA Function
  • Spearman’s Rank Correlation Coefficient in Excel with Geography Data Type
  • New Auto-expand Drop-down List Technique in Excel
  • Stunning Stacked Column Chart with Heart
  • Send Bulk Email in Excel using Power Automate
  • Cross Tabular Report using VLOOKUP Function
  • 5 Keyboard Shortcuts To Format Data As Excel Tables

Copyright 2019 © Excel Jet Consult. All Rights Reserved

A SiteOrigin Theme