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.
51
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
€54.65
List Price:  €93
You save:  €38.35
£45.34
List Price:  £77.16
You save:  £31.81
CA$81.84
List Price:  CA$139.27
You save:  CA$57.43
A$91.18
List Price:  A$155.17
You save:  A$63.98
S$77.26
List Price:  S$131.49
You save:  S$54.22
HK$443.17
List Price:  HK$754.17
You save:  HK$310.99
CHF 50.95
List Price:  CHF 86.70
You save:  CHF 35.75
NOK kr645.24
List Price:  NOK kr1,098.04
You save:  NOK kr452.80
DKK kr407.64
List Price:  DKK kr693.70
You save:  DKK kr286.06
NZ$100.77
List Price:  NZ$171.49
You save:  NZ$70.72
د.إ209.36
List Price:  د.إ356.28
You save:  د.إ146.92
৳6,784.16
List Price:  ৳11,544.98
You save:  ৳4,760.81
₹4,842.08
List Price:  ₹8,240.03
You save:  ₹3,397.95
RM256.95
List Price:  RM437.27
You save:  RM180.32
₦88,076.92
List Price:  ₦149,885.29
You save:  ₦61,808.36
₨15,802.27
List Price:  ₨26,891.59
You save:  ₨11,089.31
฿1,949.47
List Price:  ฿3,317.53
You save:  ฿1,368.05
₺1,999.09
List Price:  ₺3,401.96
You save:  ₺1,402.87
B$346.90
List Price:  B$590.34
You save:  B$243.44
R1,044.13
List Price:  R1,776.86
You save:  R732.72
Лв106.81
List Price:  Лв181.77
You save:  Лв74.95
₩82,445.94
List Price:  ₩140,302.74
You save:  ₩57,856.80
₪207.40
List Price:  ₪352.95
You save:  ₪145.55
₱3,353.59
List Price:  ₱5,706.99
You save:  ₱2,353.40
¥8,917.36
List Price:  ¥15,175.16
You save:  ¥6,257.80
MX$1,144.63
List Price:  MX$1,947.88
You save:  MX$803.25
QR206.96
List Price:  QR352.19
You save:  QR145.23
P784.67
List Price:  P1,335.32
You save:  P550.64
KSh7,329.39
List Price:  KSh12,472.82
You save:  KSh5,143.43
E£2,900.34
List Price:  E£4,935.67
You save:  E£2,035.32
ብር7,076.98
List Price:  ብር12,043.29
You save:  ብር4,966.30
Kz52,326
List Price:  Kz89,046
You save:  Kz36,720
CLP$56,310.54
List Price:  CLP$95,826.72
You save:  CLP$39,516.17
CN¥415.89
List Price:  CN¥707.75
You save:  CN¥291.85
RD$3,457.09
List Price:  RD$5,883.12
You save:  RD$2,426.03
DA7,687.98
List Price:  DA13,083.06
You save:  DA5,395.08
FJ$132.04
List Price:  FJ$224.70
You save:  FJ$92.66
Q437.43
List Price:  Q744.40
You save:  Q306.97
GY$11,877.48
List Price:  GY$20,212.55
You save:  GY$8,335.07
ISK kr7,894.28
List Price:  ISK kr13,434.13
You save:  ISK kr5,539.84
DH571.37
List Price:  DH972.34
You save:  DH400.96
L1,047.02
List Price:  L1,781.78
You save:  L734.75
ден3,361.76
List Price:  ден5,720.89
You save:  ден2,359.13
MOP$454.49
List Price:  MOP$773.43
You save:  MOP$318.94
N$1,045.19
List Price:  N$1,778.66
You save:  N$733.47
C$2,089.11
List Price:  C$3,555.16
You save:  C$1,466.04
रु7,722.41
List Price:  रु13,141.64
You save:  रु5,419.23
S/211.40
List Price:  S/359.75
You save:  S/148.35
K230.21
List Price:  K391.77
You save:  K161.55
SAR214.10
List Price:  SAR364.36
You save:  SAR150.25
ZK1,571.15
List Price:  ZK2,673.71
You save:  ZK1,102.56
L271.97
List Price:  L462.83
You save:  L190.86
Kč1,373.26
List Price:  Kč2,336.95
You save:  Kč963.69
Ft22,625.58
List Price:  Ft38,503.18
You save:  Ft15,877.60
SEK kr628.85
List Price:  SEK kr1,070.16
You save:  SEK kr441.30
ARS$58,020.19
List Price:  ARS$98,736.12
You save:  ARS$40,715.92
Bs392.31
List Price:  Bs667.61
You save:  Bs275.30
COP$248,503.28
List Price:  COP$422,891.55
You save:  COP$174,388.27
₡28,643.41
List Price:  ₡48,744.06
You save:  ₡20,100.64
L1,441.13
List Price:  L2,452.44
You save:  L1,011.31
₲442,679.17
List Price:  ₲753,331.22
You save:  ₲310,652.05
$U2,532.18
List Price:  $U4,309.14
You save:  $U1,776.96
zł233.04
List Price:  zł396.58
You save:  zł163.54

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
51
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.