MS Excel - AUTOMATE with POWER QUERY - NO Functions, NO VBA!

Q) Power Query - what is that?

I know MS Excel. Why should I bother to know about Power Query? 

A) Power Query is a New Age Tool - a Simple & a Powerful UI (User Interface), Minimal Effort for User. 

Say . . Power Query can Save You a Lot of Time & Effort . . without Much Sweat. 

Isn't it enough reason to Join this Workshop and get Introduced to Power Query? 

Of course, there is more to Power Query. It combines the Best of Many Worlds. 

- Click & Do - like PivotTable. 

Power Query User Interface is Very Intuitive. 

- Automate - like Macro Recorder OR VBA. 

Without Advance Formulas, Without VBA Code. 

- Short Learning Curve 

Q) What is it in this Workshop for Me?

A) You will be Solving 2-3 Real-World Situations . . in Power Query. 

The situations are well thought out so as to give You a Significant Exposure to Power Query. 

To solve the Qs, You will use quite a lot of Power Query features. 

Q) What are the pre-requisites? If, as You say, Power Query is a Powerful Tool, there must be some pre-requisite to attend the Workshop? 

A) Correct. 

(1) You must have an Attitude to Learn. 

'coz You are reading this, You already have it. Check-marked! 

(2) You must have used MS Excel. 

(3) You should have a Sound Logical Aptitude. 

Well . . You can do a quick evaluation here. 

- If You are able to solve the following 3 Qs successfully OR if You enjoyed solving the following 3 Qs, chances are high You will Benefit from the Session. 

Answers are posted at the end. 

(Q.1) There are 2 Datasets: Dataset A & Dataset B. 

There are 10 Entries that are Common in Both Dataset A & Dataset B. 

Dataset A has 12 Entries in Total. 

Dataset B has 17 Entries in Total. 

Combining Dataset A & Dataset B, how many Unique Entries are there in Total? 

(Q.2) In a row of children, Divya is 7th from the left and Vijay is 9th from the right. 

When They interchange their places among Themselves, Divya becomes 18th From the left. 

Then what will be Vijay's present position from the right ? 

(Q.3) I have to buy Indulekha Hair Oil. Of the following Options, which Size should I buy? Where should I buy from? 

Option 1) BigBasket 

- 50 ml. = Rs.234 

- 100 ml. = Rs.410.20 

Option 2) Flipkart 

- 50 ml. = Rs.233 

- 100 ml. = Rs.389 

- 250 ml. = Rs.936 

Option 3) Grofers 

- 50 ml. = Rs.231 

- 100 ml. = Rs.398 

Q) How would I know whether I have Power Query in My PC?

A) MS Excel Version on Your PC should be 2010 OR Later Version. 

- Power Query is known as Get & Transform in Excel 2016. 

Please watch following Video to install Power Query. Duration of Video is 3 mns. 21 secs. 

Q) What can I expect from this Workshop?

A) (1) If You have not used Power Query before, consider this Workshop as Your Introduction to Power Query.

(2) Entry is restricted to 5 Participants only to ensure You receive Individual Attention.

(3) Useful Resources (YouTube Video Links + Website Links) will be e-mailed after the Session.

Q) What NOT to expect from this Workshop?

A) At the end of the Workshop, You will NOT have become an Expert in Power Query.

Q) Finally, what will You discuss in the Session?

A) As mentioned earlier, You will be Solving 2-3 Real-World Situations . . in Power Query.

In the Session, more OR less, Power Query Equivalent of following will be discussed.

- UNIQUE OR Advance Filter

- SUMIFS

- &

- TRIM

- VLOOKUP

- IF

- Re-arrange/Delete Columns

- Find & Replace

- Multiplication

- Text to Columns

- Filter

- Copy-&-Paste

See You at the Workshop!

Stay Curious, Keep Learning . .