# Get & Transform: Scrape Data From the Web

Welcome to Excel Jet Consult. In this tutorial, we will learn how to important data from a website table. Let’s get started. The first thing we want to do is visit the website we want to import data from and copy the url. In the caption below, we want to import the African Countries By Population (2019) Secondly, we will […]

Continue reading

# How To Display Four Excel Workbooks At Once

Welcome to Excel Jet Consult blog. In this short tutorial, we will learn how to display four workbooks at a go which is important to perform a seamless linking workbook. Enjoy the video

Continue reading

# Microsoft Excel Training @ University of Benin, Edo, Nigeria (1st Session)

Microsoft Excel Training in collaboration with Rehoboth Dream Solid Foundation for graduates and undergraduates at University of Benin, Edo Nigeria (1st Session) Date: May 16th, 2019 Time: 9am – 12:30pm Topics covered General Excel Formatting Freezing Panes and Splitting windows Using Arithmetic Operators in formulas Using SUM, AUTOSUM, AVERAGE, MAX, MIN Functions Enabling Nigeria Naira Currency Symbol in Excel Using […]

Continue reading

# Microsoft Excel Training @ University of Benin, Edo, Nigeria (2nd Session)

Microsoft Excel Training in collaboration with Rehoboth Dream Solid Foundation for graduates and undergraduates at University of Benin, Edo Nigeria (1st Session) Date: May 16th, 2019 Time: 1pm – 5:30pm Topics Covered: Create Pivot Table Working with Pivot Tables Field List Tabular Pivot Table Report How to Report Pivot Table Filter Pages Pivot Charts Working with Pivot Charts Using CHOOSE, […]

Continue reading

# How To Use DSUM & MATCH Functions With Structured Referencing & Data Validation To Create Dynamic Calculation

Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to nest match function inside rarely known DSUM database function coupled with Tables Structured Referencing & List Data Validation to create a dynamic Total Sales. Let’s get started. Before we delve into the formula, let us consider what is DSUM and MATCH functions and their syntax […]

Continue reading

# Excel VBA: Open and Close Multiple Excel Workbooks Using Command Buttons

Welcome to Excel Jet Consult. In this tutorial, we will learn how to automatically open and close multiple Excel workbooks with a single click. Let’s get started Below are the two Excel workbooks we want to write VBA code and assigned to Command Buttons which will automatically open Note, the two workbooks is located in the 3D Objects on my […]

Continue reading

# 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