Advanced Microsoft Excel Applications with SQL

Learn how to apply SQL to your Microsoft Excel tables for high-performing, complex business insight.

Advanced Microsoft Excel Applications with SQL

Learn how to apply SQL to your Microsoft Excel tables for high-performing, complex business insight.
46
views
Share the link to this page
Copied

About the Class

Enhance your Microsoft Excel VBA programs

Excel VBA Course with Mor Sagmon

You thought you have seen it all with Microsoft Excel

If you're skilled in Microsoft Excel you know you can achieve a lot. However, the problem is that Excel cannot handle large tables very efficiently and poorly joins data from many tables to answer sophisticated business questions.

The bomb game-changer here is kicking-in the power of SQL when asking complex business questions from our Microsoft Excel tables.

This course will take your Microsoft Excel VBA skills to the next level by allowing you to apply your knowledge of SQL over Microsoft Excel tables to achieve extremely fast results when querying your large, joined Microsoft Excel tables.

Did you know you can

Design dashboards that refresh quickly. Query massive amounts of data directly from your Excel tables as if they were stored in a relational database.

With Microsoft Excel VBA you can use the powerful MS-Access Database Engine to query your Microsoft Excel tables. In this course, you will learn everything you need to know about working with the VBA flavor of SQL using Excel Excel VBA. The below dynamic Dashboard is your assignment at the end of this course.

Excel VBA to MySQL Dashboard Course


What will you learn in this course?

  • Microsoft Excel VBA SQL syntax
  • Applying complex SQL commands, including multiple tables joins, to Microsoft Excel tables and ranges
  • Design and develop a dynamic sales dashboard to accelerate care, the customer we're serving throughout the program. Changing filters immediately refresh the dashboard's elements from the Microsoft Excel tables.

Author

Mor Sagmon

Business Information Systems leader. Excel VBA Business Applications Expert
✔ World-class business software consultant ✔ Delivering Excel-based solutions for real life business challenges ✔ Serving customers such as Alstom, Tuttnauer, St. Croix Sensory, Hospitality Designs ✔ Developer of The Ultimate Excel Date Picker ✔ Author of the Computer Programming and Databases with Excel VBA and SQL online training program ✔...

School

Mor Sagmon's School

Requirements

You should have good VBA programming skills.
One-time Fee
$57
List Price:  $97
You save:  $40
€53.12
List Price:  €90.40
You save:  €37.27
£45.45
List Price:  £77.35
You save:  £31.89
CA$78.01
List Price:  CA$132.76
You save:  CA$54.74
A$87.35
List Price:  A$148.65
You save:  A$61.30
S$77.13
List Price:  S$131.26
You save:  S$54.13
HK$446.56
List Price:  HK$759.95
You save:  HK$313.38
CHF 51.99
List Price:  CHF 88.48
You save:  CHF 36.48
NOK kr617.01
List Price:  NOK kr1,050.01
You save:  NOK kr432.99
DKK kr396.30
List Price:  DKK kr674.40
You save:  DKK kr278.10
NZ$95.15
List Price:  NZ$161.92
You save:  NZ$66.77
د.إ209.31
List Price:  د.إ356.20
You save:  د.إ146.89
৳6,262.99
List Price:  ৳10,658.07
You save:  ৳4,395.08
₹4,752.63
List Price:  ₹8,087.81
You save:  ₹3,335.18
RM270.63
List Price:  RM460.55
You save:  RM189.91
₦71,019.15
List Price:  ₦120,857.15
You save:  ₦49,838
₨15,853.02
List Price:  ₨26,977.95
You save:  ₨11,124.93
฿2,084.74
List Price:  ฿3,547.72
You save:  ฿1,462.98
₺1,839.25
List Price:  ₺3,129.95
You save:  ₺1,290.70
B$288.76
List Price:  B$491.40
You save:  B$202.64
R1,072.31
List Price:  R1,824.81
You save:  R752.49
Лв103.81
List Price:  Лв176.67
You save:  Лв72.85
₩78,050.10
List Price:  ₩132,822.11
You save:  ₩54,772
₪214.09
List Price:  ₪364.34
You save:  ₪150.24
₱3,221.07
List Price:  ₱5,481.47
You save:  ₱2,260.40
¥8,725.27
List Price:  ¥14,848.27
You save:  ¥6,123
MX$939.10
List Price:  MX$1,598.12
You save:  MX$659.01
QR207.67
List Price:  QR353.41
You save:  QR145.73
P773.69
List Price:  P1,316.63
You save:  P542.94
KSh7,410
List Price:  KSh12,610
You save:  KSh5,200
E£2,710.20
List Price:  E£4,612.10
You save:  E£1,901.90
ብር3,246.68
List Price:  ብር5,525.05
You save:  ብር2,278.37
Kz47,645.29
List Price:  Kz81,080.58
You save:  Kz33,435.29
CLP$54,035.43
List Price:  CLP$91,955.03
You save:  CLP$37,919.60
CN¥412.51
List Price:  CN¥701.99
You save:  CN¥289.48
RD$3,381.12
List Price:  RD$5,753.83
You save:  RD$2,372.71
DA7,685.28
List Price:  DA13,078.47
You save:  DA5,393.18
FJ$128.64
List Price:  FJ$218.91
You save:  FJ$90.27
Q444.35
List Price:  Q756.18
You save:  Q311.82
GY$11,949.08
List Price:  GY$20,334.40
You save:  GY$8,385.32
ISK kr7,984.56
List Price:  ISK kr13,587.76
You save:  ISK kr5,603.20
DH578.88
List Price:  DH985.12
You save:  DH406.23
L1,006.62
List Price:  L1,713.03
You save:  L706.40
ден3,269.33
List Price:  ден5,563.60
You save:  ден2,294.27
MOP$460.22
List Price:  MOP$783.18
You save:  MOP$322.96
N$1,054.64
List Price:  N$1,794.73
You save:  N$740.09
C$2,098.94
List Price:  C$3,571.89
You save:  C$1,472.94
रु7,588.43
List Price:  रु12,913.65
You save:  रु5,325.21
S/212.95
List Price:  S/362.39
You save:  S/149.44
K218.33
List Price:  K371.55
You save:  K153.21
SAR213.81
List Price:  SAR363.85
You save:  SAR150.04
ZK1,413.67
List Price:  ZK2,405.72
You save:  ZK992.05
L264.05
List Price:  L449.36
You save:  L185.30
Kč1,348.49
List Price:  Kč2,294.81
You save:  Kč946.31
Ft20,747.03
List Price:  Ft35,306.35
You save:  Ft14,559.32
SEK kr611.98
List Price:  SEK kr1,041.44
You save:  SEK kr429.46
ARS$49,320.62
List Price:  ARS$83,931.59
You save:  ARS$34,610.96
Bs394.27
List Price:  Bs670.96
You save:  Bs276.68
COP$217,768.36
List Price:  COP$370,588.27
You save:  COP$152,819.90
₡29,004.74
List Price:  ₡49,358.94
You save:  ₡20,354.20
L1,408.46
List Price:  L2,396.86
You save:  L988.39
₲420,461.66
List Price:  ₲715,522.48
You save:  ₲295,060.81
$U2,194.78
List Price:  $U3,734.98
You save:  $U1,540.19
zł226.33
List Price:  zł385.17
You save:  zł158.83

What's Included

Language: English
Level: Intermediate
Skills: SQL Programming Skills, Database, Excel Applications, SQL Query, Microsoft Excel, Excel, VBA Programs, SQL Commands, Excel Tables
Age groups: All ages
Duration: 1 hour 30 minutes
7 Videos
4 Documents
0
Saves
46
Views
This class has not been saved

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.