Learn with Elen 📖📚 - VideoAndMovie

Together, we will learn on Accounting, Microsoft Excel, Power BI, Power Query and Dashboard.

Creating a simple #PowerBI Report

3:59

Creating a simple #PowerBI Report

Power Query Magic: Consolidate 300+ Excel Files with Different Sheet Names

12:15

Power Query Magic: Consolidate 300+ Excel Files with Different Sheet Names

💡𝗖𝗮𝗹𝗰𝘂𝗹𝗮𝘁𝗲 𝗠𝗼𝗻𝘁𝗵𝗹𝘆 𝗧𝗿𝗲𝗻𝗱𝗶𝗻𝗴 via #𝗣𝗼𝘄𝗲𝗿𝗤𝘂𝗲𝗿𝘆 💡

8:24

💡𝗖𝗮𝗹𝗰𝘂𝗹𝗮𝘁𝗲 𝗠𝗼𝗻𝘁𝗵𝗹𝘆 𝗧𝗿𝗲𝗻𝗱𝗶𝗻𝗴 via #𝗣𝗼𝘄𝗲𝗿𝗤𝘂𝗲𝗿𝘆 💡

🗓️ Capturing #Leap Years via #PowerQuery

17:04

🗓️ Capturing #Leap Years via #PowerQuery

📚 𝗗𝗮𝘁𝗮 𝗧𝗿𝗮𝗻𝘀𝗳𝗼𝗿𝗺𝗮𝘁𝗶𝗼𝗻 𝘃𝗶𝗮 𝗣𝗼𝘄𝗲𝗿 𝗤𝘂𝗲𝗿𝘆 📚

4:49

📚 𝗗𝗮𝘁𝗮 𝗧𝗿𝗮𝗻𝘀𝗳𝗼𝗿𝗺𝗮𝘁𝗶𝗼𝗻 𝘃𝗶𝗮 𝗣𝗼𝘄𝗲𝗿 𝗤𝘂𝗲𝗿𝘆 📚

Prepare Summarize Leave Records by Department via #PowerQuery & #PivotTable

7:28

Prepare Summarize Leave Records by Department via #PowerQuery & #PivotTable

💡𝗧𝗿𝗮𝗻𝘀𝗽𝗼𝘀𝗶𝗻𝗴 𝗗𝗮𝘁𝗮 𝘃𝗶𝗮 𝗣𝗼𝘄𝗲𝗿 𝗤𝘂𝗲𝗿𝘆 💡

6:58

💡𝗧𝗿𝗮𝗻𝘀𝗽𝗼𝘀𝗶𝗻𝗴 𝗗𝗮𝘁𝗮 𝘃𝗶𝗮 𝗣𝗼𝘄𝗲𝗿 𝗤𝘂𝗲𝗿𝘆 💡

Using Power Query for Data Transformation

4:14

Using Power Query for Data Transformation

𝗤𝘂𝗮𝗻𝘁𝗶𝘁𝘆 𝗚𝗿𝗼𝘂𝗽𝗶𝗻𝗴 𝗮𝗻𝗱 𝗦𝘂𝗺𝗺𝗮𝘁𝗶𝗼𝗻 𝗖𝗵𝗮𝗹𝗹𝗲𝗻𝗴𝗲 𝘃𝗶𝗮 𝗣𝗼𝘄𝗲𝗿 𝗤𝘂𝗲𝗿𝘆

7:37

𝗤𝘂𝗮𝗻𝘁𝗶𝘁𝘆 𝗚𝗿𝗼𝘂𝗽𝗶𝗻𝗴 𝗮𝗻𝗱 𝗦𝘂𝗺𝗺𝗮𝘁𝗶𝗼𝗻 𝗖𝗵𝗮𝗹𝗹𝗲𝗻𝗴𝗲 𝘃𝗶𝗮 𝗣𝗼𝘄𝗲𝗿 𝗤𝘂𝗲𝗿𝘆

💡𝗨𝘀𝗶𝗻𝗴 𝗣𝗼𝘄𝗲𝗿 𝗤𝘂𝗲𝗿𝘆 𝘁𝗼 𝗖𝗮𝗽𝘁𝘂𝗿𝗲 𝗗𝗮𝘁𝗲 , 𝗗𝗮𝘆 𝗮𝗻𝗱 𝗧𝗶𝗺𝗲 💡

7:01

💡𝗨𝘀𝗶𝗻𝗴 𝗣𝗼𝘄𝗲𝗿 𝗤𝘂𝗲𝗿𝘆 𝘁𝗼 𝗖𝗮𝗽𝘁𝘂𝗿𝗲 𝗗𝗮𝘁𝗲 , 𝗗𝗮𝘆 𝗮𝗻𝗱 𝗧𝗶𝗺𝗲 💡

Completing #Dashboard in Microsoft Excel

7:49

Completing #Dashboard in Microsoft Excel

Understanding #PivotTable (Part 3)

9:31

Understanding #PivotTable (Part 3)

Understanding #PivotTables (Part 2)

2:18

Understanding #PivotTables (Part 2)

Understanding #PivotTable (Part 1)

11:07

Understanding #PivotTable (Part 1)

Data Bars in Conditional Formatting

2:25

Data Bars in Conditional Formatting

Using Conditional Formatting as #Presentation

4:50

Using Conditional Formatting as #Presentation

Using #PowerQuery to calculate #Total Sales

3:24

Using #PowerQuery to calculate #Total Sales

Conditional Formatting - #TEXT that #CONTAINS

5:32

Conditional Formatting - #TEXT that #CONTAINS

Mastering Conditional #Formatting

5:39

Mastering Conditional #Formatting

Understanding #Conditional Formatting

5:20

Understanding #Conditional Formatting

Understanding Sort and #Filter (Ctrl Shift L)

9:20

Understanding Sort and #Filter (Ctrl Shift L)

Understanding #Hyperlink ( Ctrl + K)

9:28

Understanding #Hyperlink ( Ctrl + K)

Using #PivotTables to Prepare #Dashboard

9:01

Using #PivotTables to Prepare #Dashboard

🚀 𝗟𝗲𝗮𝗿𝗻𝗶𝗻𝗴 #𝗣𝗼𝘄𝗲𝗿𝗣𝗶𝘃𝗼𝘁 🚀

10:11

🚀 𝗟𝗲𝗮𝗿𝗻𝗶𝗻𝗴 #𝗣𝗼𝘄𝗲𝗿𝗣𝗶𝘃𝗼𝘁 🚀

Transforming Summary to #Detailed Report via #PowerQuery

3:28

Transforming Summary to #Detailed Report via #PowerQuery

🚀 𝗗𝗮𝘁𝗮 𝗧𝗿𝗮𝗻𝗳𝗼𝗿𝗺𝗮𝘁𝗶𝗼𝗻 𝘄𝗶𝘁𝗵 𝗣𝗼𝘄𝗲𝗿 𝗤𝘂𝗲𝗿𝘆 🚀

7:21

🚀 𝗗𝗮𝘁𝗮 𝗧𝗿𝗮𝗻𝗳𝗼𝗿𝗺𝗮𝘁𝗶𝗼𝗻 𝘄𝗶𝘁𝗵 𝗣𝗼𝘄𝗲𝗿 𝗤𝘂𝗲𝗿𝘆 🚀

⚡𝗣𝗿𝗲𝗽𝗮𝗿𝗶𝗻𝗴 𝗠𝗼𝗻𝘁𝗵𝗹𝘆 𝗦𝘁𝗮𝗳𝗳 𝗖𝗼𝘀𝘁 𝗣𝗹𝗮𝗻𝗻𝗶𝗻𝗴 ⚡(Part 3)

3:52

⚡𝗣𝗿𝗲𝗽𝗮𝗿𝗶𝗻𝗴 𝗠𝗼𝗻𝘁𝗵𝗹𝘆 𝗦𝘁𝗮𝗳𝗳 𝗖𝗼𝘀𝘁 𝗣𝗹𝗮𝗻𝗻𝗶𝗻𝗴 ⚡(Part 3)

⚡𝗣𝗿𝗲𝗽𝗮𝗿𝗶𝗻𝗴 𝗠𝗼𝗻𝘁𝗵𝗹𝘆 𝗦𝘁𝗮𝗳𝗳 𝗖𝗼𝘀𝘁 𝗣𝗹𝗮𝗻𝗻𝗶𝗻𝗴 ⚡(Part 2)

4:12

⚡𝗣𝗿𝗲𝗽𝗮𝗿𝗶𝗻𝗴 𝗠𝗼𝗻𝘁𝗵𝗹𝘆 𝗦𝘁𝗮𝗳𝗳 𝗖𝗼𝘀𝘁 𝗣𝗹𝗮𝗻𝗻𝗶𝗻𝗴 ⚡(Part 2)

⚡𝗣𝗿𝗲𝗽𝗮𝗿𝗶𝗻𝗴 𝗠𝗼𝗻𝘁𝗵𝗹𝘆 𝗦𝘁𝗮𝗳𝗳 𝗖𝗼𝘀𝘁 𝗣𝗹𝗮𝗻𝗻𝗶𝗻𝗴 ⚡(Part 1)

4:11

⚡𝗣𝗿𝗲𝗽𝗮𝗿𝗶𝗻𝗴 𝗠𝗼𝗻𝘁𝗵𝗹𝘆 𝗦𝘁𝗮𝗳𝗳 𝗖𝗼𝘀𝘁 𝗣𝗹𝗮𝗻𝗻𝗶𝗻𝗴 ⚡(Part 1)

💡𝗗𝗮𝘁𝗮 𝗧𝗿𝗮𝗻𝘀𝗳𝗼𝗿𝗺𝗮𝘁𝗶𝗼𝗻 𝘄𝗶𝘁𝗵 𝗣𝗼𝘄𝗲𝗿 𝗤𝘂𝗲𝗿𝘆 💡

3:39

💡𝗗𝗮𝘁𝗮 𝗧𝗿𝗮𝗻𝘀𝗳𝗼𝗿𝗺𝗮𝘁𝗶𝗼𝗻 𝘄𝗶𝘁𝗵 𝗣𝗼𝘄𝗲𝗿 𝗤𝘂𝗲𝗿𝘆 💡