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: Sort from left to right

How To Horizontally Sort Data In Excel

Posted on November 25, 2019November 25, 2019 by Abiola David | No Comments

Welcome to Excel Jet Consult. In this tutorial, we will learn how to achieve horizontal sorting of data in Excel. Let’s get started In the caption below, we want to sort the Account Manager in Row 3 from A to Z     To sort the data horizontally, I selected the data from B3:O6 Execute: ALT + ASS to open […]

Continue reading→

Blog Posts

  • 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
  • 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]

Copyright 2019 © Excel Jet Consult. All Rights Reserved

A SiteOrigin Theme