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: Curly Braces in Excel

Role of Comma and Semicolon in Curley Braces{}

Posted on April 15, 2020May 4, 2020 by Abiola David | No Comments

Introduction Welcome to Excel Jet Consult blog post. In this video tutorial, we learn about when to use comma and semicolon to achieve the same result in different way. Sample Data In the caption below, we have sample data that has Account Manager and Total Sales. Note, the data is formatted in Excel Tables Top 5: Spill To Cells Below […]

Continue reading→

Blog Posts

  • Linear Equation Computation and Graph in Excel
  • Get & Append Data From GOOGLE SHEETS and MICROSOFT ACCESS to Create Excel PivotTable Report
  • Dynamic FILTER BETWEEN YEARS using Power Query and Data Validation
  • 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
  • Power Query Data Types [The Game Changer]
  • VLOOKUP with Array Constants

Copyright 2019 © Excel Jet Consult. All Rights Reserved

A SiteOrigin Theme