Excel Macros VBA + Power Query (2 in 1 course)

سرفصل های دوره

Learn Excel Macros Automation and Power Query (2 in 1 course)

1. Introduction - Getting the Fundamentals right

1. Excel Macros Magician

2. Option Explicit Statement.html

3. Introduction

4.1 understanding the fundamentals of macros.zip

4. The VB editor

5. Range object - Most Important

6. Start writing your first code

7. Absolute Mode Recording

8. Understanding the recorded code in Absolute Mode

9. Recording in Relative Mode

10. Recording in Absolute and Relative Mode

11. Understanding the recorded Macro codes

2. Variables and Using Loops

1. Declaring Variables

2. Scope of Variables

3. Data Types

4.1 Variables and Loops.pptx

4.2 variables and loops.zip

4. Loops in VBA

5. Using Instr

6. IF statements

7. Loops - Final Touches

3. Userform - Message

1.1 1. welcome screen on startup using userform.zip

1. Welcome Message

4. Employee Database Userform

1.1 2. employee database.zip

1. Employee Database Userform

5. How to merge text in a cell

1.1 3. merge text.zip

1. Merge text in a cell

6. How to split Numbers

1.1 4. split numbers.zip

1. Split Numbers

7. Loops

1.1 5. loop over files.zip

1.2 Apr.xlsx

1.3 Feb.xlsx

1.4 Jan.xlsx

1.5 Mar.xlsx

1.6 May.xlsx

1. Looping over Mutliple Files

8. Loop Multiple files and sum totals by date

1.1 6. loop over files and sum totals by date.zip

1.2 Apr.xlsx

1.3 Feb.xlsx

1.4 Jan.xlsx

1.5 Mar.xlsx

1.6 May.xlsx

1. Looping over files and summing by dates

9. Summarize Profits by Weekday

1.1 summarize profits by weekday.zip

1. Summarize Profits by Weekday using Loops

10. Understanding R1C1 referencing

1.1 8. monthly report - jan 2021.zip

1.2 Lookup Data.xlsx

1. R1C1 Referencing

11. Vlookup in VBA

1.1 9. using vlookup.zip

1.2 Lookup Data.xlsx

1. Vlookup - VBA version

12. Formatting Dates

1.1 10. formatting dates and save as table.zip

1. Formatting Dates and save as Table feature

13. Tables and ListObjects

1.1 11. understanding tables as list object.zip

1.2 Tables (ListObjects).pptx

1. Tables - List Objects

14. Calculating Margins and Revenue using Tables

1.1 12. calculating margins and revenue using tables in vba.zip

1.2 Lookup Data.xlsx

1. Using Formulas in VBA

15. Text function in VBA

1.1 13. using the text function in vba.zip

1. Text Function

16. Convert numbers stored as text to Numbers

1.1 14. convert text to numbers.zip

1. Convert numbers stored as text to Numbers

17. Sales Summary report

1.1 15. summary report.zip

1. Sales Summary report in VBA

18. Formatting your Report

1.1 16. format your report.zip

1. Formatting your report

19. Errors in VBA and how to deal with them

1.1 Backup.xlsx

1.2 error handling and debugging.zip

1.3 Errors and Debugging in VBA.pptx

1. Error handling

2. Error Handling Part 2

20. Create Multiple Reports with Unique function

1.1 18. unique function and create multiple reports.zip

1. Multiple reports

21. Multiple Report Generation with Criteria

1.1 19. multiple reports with criteria selection.zip

1. Multiple reports with crtieria

22. Advanced Filter

1.1 20. Advanced Filter

1.2 20. using the advanced filter method.zip

1. Advanced Filter - VBA

23. VBA on Steroids - Arrays

1.1 21. using arrays (part 1).zip

1. Arrays

2.1 21. using arrays (part 2).zip

2. Using Arrays (Part 2)

3.1 21. using arrays (part 3).zip

3. Using Arrays (Part 3)

4.1 21. using arrays (part 4).zip

4. Using Arrays (Part 4)

5.1 21. using arrays (part 5) complete.zip

5. Arrays (Part 5) - Complete

24. Pivot table in VBA

1.1 22. create pivot table using vba.zip

1. Pivot table automation

25. Shapes in VBA

1.1 shapes in vba.zip

1. Using Shapes in VBA

26. Pictures from Folder

1.1 24. inserting pictures from a folder.zip

1.2 Snooker Players.zip

1. Adding pictures from a folder

27. Embedding pictures from a folder

1.1 25. embedding pictures from a folder.zip

1.2 Snooker Players.zip

1. Embedding Pictures

28. Resizing pictures into a grid

1.1 26. resize pictures to grid.zip

1.2 Snooker Players.zip

1. Resizing pictures

29. File System Object

1.1 27. filesystemobject.zip

1. FileSystemObject - Access Files and Folders

30. Adding Hyperlinks to Folder Names

1.1 28. adding hyperlinks.zip

1. Add Hyperlinks

31. Copying Folder and Subfolders

1.1 29. copying folders and subfolders.zip

1. Copy files to folders

32. Embedding the images onto sheets

1.1 Copied Images.zip

1.2 Listing Images.zip

1. Embed images onto sheets

33. Creating Charts in VBA

1. Create a Chart with VBA (Part 1)

2. Creating Multiple Charts (Part 2)

3. Creating Multiple Charts (Part 3)

4.1 31. creating multiple charts in vba.zip

4. Creating Multiple Charts (Part 4)

34. Chart Animation 1

1.1 animate chart.zip

1. Chart Animation using VBA (Part 2)

2. Chart animation using VBA (Part 1)

35. Chart Animation 2

1. Arranging the Data first

2.1 33. chart animation 2.zip

2. Understanding how animation works

3. Using Named Ranges with Loop to create the Animation

4. Applying the Final Touches

36. Chart Animation 3

1. Adjusting the VBA code and Named Ranges

2. Adjusting the Chart series

3. Using a Toggle Switch

4. Final Touches

37. Interactive Sales Dashboard

1. Intro to the Interactive Sales Dashboard

2. Understanding the Data

3. Using Application.Caller method to call shapes

4. Pivot table and Slicer trick

5. Running the Advanced Filter

6. Calculate totals for the Category

7. Cell formatting and Conditional Formatting

8.1 interactive sales dashboard - incomplete.zip

8. Custom Format your Slicer

9.1 interactive sales dashboard.zip

9. Importing the pictures with VBA

10. Adding the Category and SKU cells

11. Using Named Formulas to capture a Dynamic range

12. Conditional Formatting for borders

13. Running the Advanced Filter at SKU level

14. Calculate values for Brand

15. Final Touches

38. Power Query Section

1. Intro to the Course

2.1 Split Column Dilemma.xlsx

2. Split Column Dilemma

3.1 Sales Data.zip

3. Format Multiple Files from a Folder

4.1 ConfirmedUnconfirmedSalesAnalysisReport - 2022-11-01T155838.360.xlsx

4. Category Sales

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training