DEV Community

Judith-Excel-Sharing profile picture

Judith-Excel-Sharing

esProc Desktop is a desktop data processing & analytics tool and is specifically designed for ordinary business people, which significantly lowers the technical threshold for data analytics.

Joined Joined on  Email address judithliu@scudata.com Personal website http://www.scudata.com/judith-excel/ twitter website
In Excel, Search A Target Value And Hide Columns To Its Right
judith677 profile

In Excel, Search A Target Value And Hide Columns To Its Right

#programming #beginners #tutorial #productivity
5
Comments 2
1 min read

Want to connect with Judith-Excel-Sharing?

Create an account to connect with Judith-Excel-Sharing. You can also sign in below to proceed if you already have an account.

Create Account
Already have an account? Sign in
In Excel, Parse Hexadecimal Numbers And Make Queries
judith677 profile

In Excel, Parse Hexadecimal Numbers And Make Queries

#beginners #programming #tutorial #productivity
7
Comments 1
1 min read
New Course Launch: SPL Programming on esProc Desktop
judith677 profile

New Course Launch: SPL Programming on esProc Desktop

#beginners #programming #tutorial #productivity
6
Comments 1
1 min read
In Excel, Judge Whether A Word Has Duplicate Letters
judith677 profile

In Excel, Judge Whether A Word Has Duplicate Letters

#beginners #programming #tutorial #productivity
10
Comments 2
1 min read
In Excel, Find the Maximum Value and the Neighboring N Members Before and After
judith677 profile

In Excel, Find the Maximum Value and the Neighboring N Members Before and After

#beginners #programming #tutorial #productivity
7
Comments 2
1 min read
In Excel, Combine Multiple Detail Data Columns into One Row in Each Group
judith677 profile

In Excel, Combine Multiple Detail Data Columns into One Row in Each Group

#beginners #programming #tutorial #productivity
5
Comments 2
1 min read
In Excel, Identify Data Layers Correctly and Convert Them to a Standardized Table
judith677 profile

In Excel, Identify Data Layers Correctly and Convert Them to a Standardized Table

#beginners #programming #tutorial #productivity
5
Comments 2
2 min read
In Excel, Concatenate the Top 3 Members in Each Group into a String
judith677 profile

In Excel, Concatenate the Top 3 Members in Each Group into a String

#beginners #programming #tutorial #productivity
6
Comments 4
1 min read
In Excel, Expand All Combinations of Multiple Columns
judith677 profile

In Excel, Expand All Combinations of Multiple Columns

#beginners #programming #tutorial #productivity
5
Comments 2
1 min read
In Excel, Generate a List of All Days of the Month Where a Specified Data Belongs
judith677 profile

In Excel, Generate a List of All Days of the Month Where a Specified Data Belongs

#beginners #tutorial #productivity #database
5
Comments 2
3 min read
In Excel, Enter Values of the same Category in Cells on the Right of the Grouping Cell in Order
judith677 profile

In Excel, Enter Values of the same Category in Cells on the Right of the Grouping Cell in Order

#programming #tutorial #productivity #datascience
5
Comments 2
1 min read
In Excel, Combine Every N Row into A New Row
judith677 profile

In Excel, Combine Every N Row into A New Row

#beginners #programming #tutorial #productivity
7
Comments 6
1 min read
In Excel Crosstab, Transpose Cross Cells to Columns and Rows to Cross Cells Respectively
judith677 profile

In Excel Crosstab, Transpose Cross Cells to Columns and Rows to Cross Cells Respectively

#beginners #programming #tutorial #productivity
5
Comments 2
1 min read
Excel Perform COUNT on Each Category and Concatenate Results into a String
judith677 profile

Excel Perform COUNT on Each Category and Concatenate Results into a String

#beginners #tutorial #programming #productivity
3
Comments 2
1 min read
In Excel, Align Every Two Columns to Present Them While Setting Missing Values as 0
judith677 profile

In Excel, Align Every Two Columns to Present Them While Setting Missing Values as 0

#beginners #programming #tutorial #datascience
6
Comments 3
3 min read
In Excel, Insert Group Headers to Detail Data Rows in Each Group
judith677 profile

In Excel, Insert Group Headers to Detail Data Rows in Each Group

#excel #spreadsheet #tutorial #productivity
6
Comments 1
3 min read
Actually, you will never be able to master Python
judith677 profile

Actually, you will never be able to master Python

#python #excel #programming #tutorial
Comments
7 min read
ReportLite Practice: Multi-layered cross-reports with complex formats
judith677 profile

ReportLite Practice: Multi-layered cross-reports with complex formats

#excel #report #pivot #datascience
Comments
3 min read
How to do Excel table association – You are out if you know only VLOOKUP
judith677 profile

How to do Excel table association – You are out if you know only VLOOKUP

#excel #vlookup #vba #dataanalysis
Comments
4 min read
SPL XLL Practice: Almighty Text Splitting in Excel
judith677 profile

SPL XLL Practice: Almighty Text Splitting in Excel

#programming #tutorial #excel #vba
Comments
5 min read
SPL XLL Practice: Excel Interval Association
judith677 profile

SPL XLL Practice: Excel Interval Association

#excel #vba #datascience #tutorial
Comments
3 min read
Excel Advanced Group and Summary Method
judith677 profile

Excel Advanced Group and Summary Method

#excel #dataanalysis #vba #programming
Comments
5 min read
How to Automatically Extract Eligible Rows in Excel
judith677 profile

How to Automatically Extract Eligible Rows in Excel

#excel #vba #dataanalytics #powerbi
Comments
4 min read
Set operations of Excel inter row data (intersection, union, difference)
judith677 profile

Set operations of Excel inter row data (intersection, union, difference)

#excel #vba #powerbi #tutorial
Comments
5 min read
Set operations of data between Excel columns (intersection, union, and difference)
judith677 profile

Set operations of data between Excel columns (intersection, union, and difference)

#excel #spreadsheet #tutorial #dataanalysis
Comments
4 min read
How to Quickly Split an Excel into Multiple Excels
judith677 profile

How to Quickly Split an Excel into Multiple Excels

#tutorial #excel #spreadsheet #powerbi
6
Comments 1
3 min read
Batch Summary of Multiple Excel Spreadsheet Data – Done in 1 Minute
judith677 profile

Batch Summary of Multiple Excel Spreadsheet Data – Done in 1 Minute

#excel #spreadsheet #programming #opensource
1
Comments 1
4 min read
How to Merge Excel Sheets Horizontally
judith677 profile

How to Merge Excel Sheets Horizontally

#vba #powerbi #excel #tutorial
Comments
4 min read
How to Quickly Merge Multiple Excel Files
judith677 profile

How to Quickly Merge Multiple Excel Files

#excel #tutorial #database #opensource
1
Comments 1
4 min read
The Very Tool to Liberate an Excelman from Working Overtime – SPL
judith677 profile

The Very Tool to Liberate an Excelman from Working Overtime – SPL

#excel #programming #tutorial #beginners
1
Comments 1
8 min read
A Laymen’s Roadmap for Data Analysis and Processing Technology
judith677 profile

A Laymen’s Roadmap for Data Analysis and Processing Technology

#excel #beginners #sql #python
Comments
12 min read
A Correct Method for Complete Novice to Self-study of Programming
judith677 profile

A Correct Method for Complete Novice to Self-study of Programming

#beginners #tutorial #excel #sql
Comments 1
12 min read
What Programming Language Should Business People Learn?
judith677 profile

What Programming Language Should Business People Learn?

#beginners #tutorial #excel #vba
Comments
9 min read
How do beginners learn SQL quickly?
judith677 profile

How do beginners learn SQL quickly?

Comments
5 min read
loading...