Welcome to Excel Jet Consult blog post. In this Excel video, we learn how to use the Power Query to combine multiple tables from multiple sheets and using SUMIFS & PivotTables to create sales report by country!
Continue readingTag Archives: Microsoft Excel
Total Working Days Excluding Weekends & Holidays using Power Query
Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to calculate total working days excluding weekends and holidays using Power Query. Let’s get started Tutorial Video I recommend you watch the video for more in-depth explanation Sample Data In the caption below, we have list of dates from 01/01/2020 to 31/12/2020 in column A. In […]
Continue reading
SUMIFS/INDEX/MATCH VS. SUMPRODUCT Functions: HR Data Example
Welcome to Excel Jet Consult blog post. In this tutorial, we want to learn how we can use SUMIFS/INDEX/MATCH and SUMPRODUCT differently to achieve the same result. Let’s get started In the captions below, we have HR Salary Data in Dynamic SUMPRODUCT and Dynamic SUMIFS sheet Note, we have list data validation in cells M2 (List of unique department), and […]
Continue reading
Excel Office 365: Ideas
Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to use the new Ideas tool in Excel available to Office 365 users. The Ideas enables users to have a deeper understanding of data through high-level visual and summaries, trends and patterns. The Ideas tool is in the Home tab as seen in the caption below […]
Continue reading