Rakesh Patel
Friday, January 23, 2015

Essential keyboard shortcuts for MS-EXCEL

›
Keyboard shortcuts are the best way to navigate cells or enter formulas more quickly. Control-Down/Up Arrow = Moves to the top or bottom...
Wednesday, January 21, 2015

Difference Between 1D, 2D & 3D Barcode

›
1D Barcodes One dimensional barcodes, also called 1D barcodes or linear barcodes are the original.The parallel black lines on the white ba...
1 comment:
Monday, September 1, 2014

SharePoint 2013 - Top 10 benefits

›
A new and simplified user experience.  Drag and drop content into document libraries, see live previews of your content, edit lists inli...
Friday, August 29, 2014

Calculated Fields formulas used in SharePoint

›
Get Week of the year =DATE(YEAR([Start Time]),MONTH([Start Time]),DAY([Start Time]))+0.5-WEEKDAY(DATE(YEAR([Start Time]),MONTH([Start Time...
Tuesday, August 5, 2014

Add a number of months to a date in Excel

›
Many of my friends have query about how to add / Subtract month in excel, Simple way of doing as below =Date( Year ( Start_Date ) + add_...
Thursday, July 3, 2014

Calculate Time in Excel

›
The simple way to calculate the time is sum the two time inputs, shown in below example: Use Excel built-in function SUM to calculate. Us...
Monday, June 16, 2014

How To Get Last Row in Excel VBA code

›
There are many programmatic way to find last row of data input, but the simplest is.... Dim LastRow  LastRow = ws.Range("A1")....
‹
›
Home
View web version
Powered by Blogger.