Skip to content

Latest commit

 

History

History
61 lines (34 loc) · 1.76 KB

README.md

File metadata and controls

61 lines (34 loc) · 1.76 KB
Raw

xtremeExcel

This respository contains content related to Excel formula and VBA. I upload some utilities, macros, dashboards, reports etc to share with community.

  1. Start Stop Timer

    Description

     You can add start stop timer buttons dynamically as per number of records in your worksheet
 which can help you in tracking of each record in terms of time.

    Important Links

     Demo		:	https://youtu.be/HW9_Mkmf09g

 Tutorial	:	https://youtu.be/x1g0NGIsVig

  2. Calendar

    Description

     In this example, a calendar is created using formula in excel. It is a dynamic calendar and gives
 you flexibility to select month and year. You can follow the video tutorial to understand how this
 was created from scratch.

    Important Links

     Demo		:	https://www.youtube.com/watch?v=phzgipX3Q2g

 Tutorial	:	http://exceltalk.blogspot.com/2014/08/calender-using-formula-in-excel.html=

  3. Shapes using keywords

    Description

     This is a prototype in which it is highlighted that how easily we can plot flocharts and other graphical 
 structures with the help of keywords. This can be extended to create wonderful applications. Feel free to
 use and share it in any way. However, you can not sell this directly or indirectly in any modified form to
 anyone without permission from Kamal Girdher(xtremeExcel).

    Important Links

     Demo/Tutorial		:	https://youtu.be/-_lVoCMNfdE

  4. File Name Changer

    Description

     Renaming files in bulk is easy using vba. In this tutorial, you'll learn how to rename thousands of files
 (may be of a specific extension) in one go.

 There are two sub procedures explained in this example. One fetches names of all files in a folder and the
 other one helps in renaming them.

    Important Links

     Demo/Tutorial		:	https://youtu.be/9PPVWGJUtZ4