* Cantinho Satkeys

Refresh History
  • FELISCUNHA: dgtgtr   49E09B4F  e bom fim de semana   4tj97u<z
    15 de Fevereiro de 2025, 16:34
  • j.s.: tenham um excelente fim de semana  49E09B4F
    14 de Fevereiro de 2025, 17:06
  • j.s.: dgtgtr a todos  4tj97u<z
    14 de Fevereiro de 2025, 17:06
  • FELISCUNHA: ghyt74  pessoal   49E09B4F
    14 de Fevereiro de 2025, 11:24
  • cereal killa: ghyt74 pessoal  classic
    14 de Fevereiro de 2025, 10:08
  • JPratas: try65hytr Pessoal  classic k7y8j0 h7ft6l
    14 de Fevereiro de 2025, 03:52
  • JPratas: dgtgtr A Todos  4tj97u<z k7y8j0 yu7gh8
    13 de Fevereiro de 2025, 18:08
  • FELISCUNHA: ghyt74  pessoal   49E09B4F
    13 de Fevereiro de 2025, 11:32
  • j.s.: try65hytr a todos  4tj97u<z
    12 de Fevereiro de 2025, 21:00
  • FELISCUNHA: ghyt74   49E09B4F  e bom fim de semana  4tj97u<z
    08 de Fevereiro de 2025, 11:36
  • j.s.: tenham um excelente fim de semana  43e5r6 49E09B4F
    07 de Fevereiro de 2025, 20:23
  • j.s.: try65hytr a todos  4tj97u<z
    07 de Fevereiro de 2025, 20:23
  • FELISCUNHA: ghyt74  pessoal   49E09B4F
    07 de Fevereiro de 2025, 11:24
  • JPratas: try65hytr A Todos  4tj97u<z classic k7y8j0
    07 de Fevereiro de 2025, 04:15
  • j.s.: dgtgtr a todos  49E09B4F
    06 de Fevereiro de 2025, 14:24
  • FELISCUNHA: ghyt74  pessoal   49E09B4F
    05 de Fevereiro de 2025, 11:33
  • JPratas: try65hytr Pessoal  4tj97u<z classic k7y8j0
    05 de Fevereiro de 2025, 02:35
  • FELISCUNHA: ghyt74   49E09B4F  e bom fim de semana   4tj97u<z
    01 de Fevereiro de 2025, 11:59
  • j.s.: tenham um excelente fim de semana  49E09B4F
    31 de Janeiro de 2025, 21:20
  • j.s.: try65hytr a todos  4tj97u<z
    31 de Janeiro de 2025, 21:20

Autor Tópico: Advanced Microsoft Excel Applications with SQL  (Lida 66 vezes)

0 Membros e 1 Visitante estão a ver este tópico.

Offline mitsumi

  • Moderador Global
  • ***
  • Mensagens: 118061
  • Karma: +0/-0
Advanced Microsoft Excel Applications with SQL
« em: 24 de Junho de 2021, 06:07 »
MP4 | Video: h264, 1280x720 | Audio: AAC, 48000 Hz
Language: English | Size: 702 MB | Duration: 1h 30m

What you'll learn
Apply your knowledge of SQL over Microsoft Excel tables
Get extremely fast results when querying your large, joined Microsoft Excel tables
Design and develop a dynamic sales dashboard. Changing filters immediately refresh the dashboard's elements from Excel tables.
Requirements
You should have fair VBA programming skills
The SQL language is not covered in this course
Description
I'm excited to invite you to take the Advanced Microsoft Excel Applications with SQL course.

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 your 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 VBA.

This course covers essential technologies and extensions to meet the business requirements of business solutions.

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. You will discover:

Excel VBA SQL syntax

Applying complex SQL commands, including multiple tables JOINS, to Excel tables and ranges

Assignment: Design and develop a dynamic Sales Dashboard. Changing filters immediately refresh the Dashboard's elements from the DB.

What you will get when enrolling to this course:

1.5 hours in 7 recorded, hands-on sessions

Each session was carefully planned, its code was written and verified and the video was edited to reflect a balanced blend of slides lecture with hands-on demo.

The course is structured to build a gradual learning curve. With each session you conquer another goal, expand your skills and experience.

1 Assignment

Writing code that works for real business needs will earn you the practice and skill you need. The assignments are engineered to confront you with real business challenges and are considered an important part of your training.

I always say: an assignment is your opportunity to express yourself!

Assignment's complete solution: VBA code for download

I explain my solution for each and every assignment in a dedicated, detailed session, so these are important lessons in and of themselves - don't skip those sessions!

Who this course is for:
VBA developers

Screenshots


Download link:
Só visivel para registados e com resposta ao tópico.

Only visible to registered and with a reply to the topic.

Links are Interchangeable - No Password - Single Extraction