How to Navigate to another page without bookmarks! Power BI - Say NO to ...

How to get next week and last week date in Power BI? QUICK AND EASY WAY!

Use a simple function called WeekDay() to Get next week(Monday) and last week(Tuesday) dates in Power BI!!

Super quick, easy and Amazing!!

Click here for the video

Input box on click of drop down and update cells - EXCEL

Display input box when a value is selected from drop down and replace existing cell values with input from user. Check out the video for very simple method to achieve this! 

If you missed how this feature can be used, you can refer the below video: https://www.youtube.com/watch?v=nJf-c... ---------------------------------------------------------------------------- Also, check out an amazing and easiest way to track files. No more missing corporate files - https://www.youtube.com/watch?v=nNX48... ----------------------------------------------------------------------------- Dont forget to subscribe :) https://www.youtube.com/channel/UC-iW... ------------------------------------------------------------------------------ VBA code: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 18 And Target.Value = "RESCHEDULED" Then Dim schedule As Date Dim SDate As String Dim IntDate As String Dim LValue As String LValue = Format(Date, "dd/mm/yyyy") schedule = DateValue(Target.Offset(0, -5).Value) SDate = Format(Target.Offset(0, -5).Value, "dd/mm/yyyy") IntDate = Format(Target.Offset(0, -3).Value, "dd/mm/yyyy") Target.Offset(0, 16).Value = Target.Offset(0, 16).Value + " , " + LValue + "- Rescheduled: Assessment from " + SDate + " &" + " Interview from " + IntDate Set DateCell = Target.Offset(0, -5) Set DateCellInt = Target.Offset(0, -3) frmRescheduled.Show schedule = DateValue(Target.Offset(0, -5).Value) ElseIf Target.Column = 18 And Target.Value = "CLOSED" Then End If End Sub

Say NO to Do's and Dont's! Simple and easy way to save time in entering data in EXCEL!

Don't blame your staff if the data entered is not as per the required guidelines!

Help them record data more efficiently and become more productive.

This video shows some simple tricks used to overcome day to day challenge of using excel!

Guide user at every cell - every step of the way! AMAZING!! 

VBA, input box on click of drop down, update cells.

Subscribe to get more solutions and tips and tricks! GET STARTED!

Check out how to create the input box shown in the above video here

No more SOP's and bulky documents of guidelines and Do's and Dont's or even steps to follow! 

Also check out amazing way to track files. No more missing corporate files! Click here!

Save time, work smart!

Subscribe to get more solutions and tips and tricks! GET STARTED!

Missing Corporate Files? Not anymore with this FILE TRACKER using Excel and Scan-IT Office

File tracker uses simple QR codes to track important files or documents. It uses Scan - IT office application and excel add in. The result? is AMAZING!

Simply scan the QR code and get the details auto updated in excel from sender and receiver. Its as simple as that! 

Step 1 - Sender scans the QR code from mobile camera. Sender name, date, time is auto captured in excel. 

Step 2 - Receiver scans the QR code. Receiver name, date and time is auto captured in excel.

Woila you have your file tracker all set and ready!!! 

Let me know what you think about this and if you have a better solution! 

Also check out amazing way to track projects and EASY SIMPLE way to DATA ENTRY 

- Say No to SOP's and excel guidelines to record data! https://www.youtube.com/watch?v=nJf-c...

Don't forget to subscribe :) https://www.youtube.com/channel/UC-iW...