What-if Analysis: Two Variable Data Table For Multiple Outcomes

Welcome to Excel Jet Consult. In this tutorial, we will learn how to use the What-if analysis tool called Data Table Data Table returns multiple outcomes that enhances informed decision making given under different scenarios. The Data Table is in the What-if Analysis drop-down of the Forecast group under Data tab Company XYZ manufacture Samsung Galaxy X4. They planned to […]

Continue reading

Multiple Filtering in Excel VBA

Welcome to Excel Jet Consult Blog Post. In this blog post, we will learn how to perform multiple filtering by writing Exccel VBA code. Let’s get started We want to filter the data in the caption below. The filter criteria are: All the Order Date in 2017 from the States of Alabama and Arizona with Sales that is greater than […]

Continue reading

How to Import Multiple Access Database Table Directly into Excel Pivot Table

Welcome to Excel Jet Consult blog post. In this blog post, we want to learn how to succinctly import multiple Access Database table directly into Excel Pivot Table and create a relationship for further analysis. The caption below is one of the Access Database table we want to import To import the tables: Open a new Excel workbook and executive […]

Continue reading

New Functions and Features in Microsoft Office 2019 and Office 365

Welcome to Excel Jet Consult blog post. Recently, Microsoft rolled-out six new functions, one new chart, new theme in Office 2019 and 365. Undoubtedly, the new functions will simplify many difficult operations in Excel NEW FUNCTIONS IFS Function – evaluates whether one or more conditions is satisfied and delivers a value corresponding to the first TRUE condition. IFS Syntax                          =IFS(logical_test1, […]

Continue reading

Diagnosis: How to Discover Cells With Data Validation In Excel Using ALT + HFDV

Welcome to Excel Jet Consult blog post. In this post we will learn how to perform diagnosis to discover cell with data validation in Excel. Succinctly, Data Validation is a feature that enables users to control data that is entered in Excel. Data Validation is located in the Data Tools group of the Data tab In the data caption below, […]

Continue reading

How to Generate Random Contact Numbers & Dates Using RANDBETWEEN Function

Welcome to Excel Jet Consult blog post. In this tutorial, we want to learn how to use one of the sophisticated functions in Excel named RANDBETWEEN RANDBETWEEN returns a random number between numbers specified. The function is elegant to generate random date. RANDBETWEEN Syntax                  =RANDBETWEEN(bottom, top) We want to generate random contact number and dates in columns B and C […]

Continue reading

LARGE & SMALL Array Functions: Return Top 8 and Bottom 8 Values

Welcome to Excel Jet Consult blog post. In this tutorial, we want to learn how to use LARGE and SMALL functions to display Top 8 and Bottom 8 values LARGE Function returns the k-th largest value in a data set LARGE Syntax                    =LARGE(array, k) SMALL Function returns the k-th smallest value in a data set SMALL Syntax                    =SMALL(array, k) In […]

Continue reading

Power Query Mash-up Function: Unpivot Columns using Table.Unpivot

Welcome to Excel Jet Consult blog post. In this tutorial, we want to learn how to unpivot columns in Power Query using mash-up function Table.Unpivot M Function translates a set of columns in a table into attribute-value pairs combined with the rest of the values in each row Table.Unpivot Syntax                     =Table.Unpivot( table, pivotColumns, attributeColumn, valueColumn) We want to unpivot the […]

Continue reading