Learn MS Excel -Video 429- VBA- Case Study – IF and Collection LOOPS

Learn how to prepare summary report using collection loops and IF function. -~-~~-~~~-~~-~- Please watch: “Learn Excel – Video 594[…]

Read More...

Case Study Part 3 – Ms Powerpoint Executive Presentation

Case Study Part 3 – Ms Powerpoint Executive Presentation PowerPoint is an outstanding program to use in creating a business[…]

Read More...

Learn MS Excel – Video 374- VBA – Case Study -Loop in Loop – Collection and DO For Next Loops

In this video we are using collection loops with for next and do loops. See how you can write sub[…]

Read More...

Learn MS Excel -Video 418- Case study- VBA Send Email based date range and subject

You can move the emails from one folder to another basis date range you select and subject line you provide.[…]

Read More...

Learn MS Excel – Video 375- Arrays – Case study – Indirect address Offset row

Another puzzle solved using fantastic array technique where we combined INDIRECT ADDRESS OFFSET ROW LARGE in one powerful formula -~-~~-~~~-~~-~-[…]

Read More...