Convert Number to Date Format

excel_usage, Excel Tips

Hi there,

 

 

Here, I am going to tell you a simple trick but highly used by our reporting folks. Especially, while extracting dates using VLOOKUP function there are many dates which formats as general rather date. It is very difficult to change the values to dates manually while large amount of data.

Convert Number to Date Format; Not this dates dude!

 

To avoid such instances, here is a trick which can be done before brushing your teeth. :)

Full story »

120 + Excel websites on net

MyBookStore, Tutorial, Trainings

Hi there,

 

 

Many viewers are tired browsing through the net to find the Best Online Excel Websites who give Excel Trainings, Excel Tutorials, Free Videos, Excel shortcuts, Excel tips and so on right?


120+ Excel Websites on the go!

 

Funny thing here is they are asking with the website owners, who runs tutorials and who shares free stuff and also who gives sample free videos via youtube, to share some websites which provides the free stuff. When we ourself does all these still they want the better one. To be little frugal how can I give other websites yar? But still, to make all of you happy and easy to browse through the links, here are almost 120+ websites who share their knowledge to the world of Excel Lovers.


 1.   http://www.datapigtechnologies.com

 2.   http://www.vbaexpress.com

 3.   http://www.andrewsexceltips.net/

 4.   http://www.excelhero.com/

 5.   http://akoul.blogspot.com

 6.   http://www.myonlinetraininghub.com/

 7.   http://spreadsheetpage.com

 8.   http://excel.tips.net

 9.   http://www.mrexcel.com

10.  http://excelexposure.com/



Pages: 1· 2· 3· 4· 5· 6· 7· 8· 9· 10· 11· 12

Three Simple & Powerful Shortcuts (Windows & Excel)

Shortcuts, Excel Tips

Hi,

 



Today, I have learnt three beautiful and powerful shortcuts which helps for windows as well as Excel. Here we go:

 

Strong & Powerful YOU

1. Show Desktop: In Excel 2013, we can open and view multiple workbooks at a time with different screens or multi screens so, it is difficult to see desktop when more worksheets are opened. To avoid this, we can use the shortcut in windows taskbar which is placed completely on the leftside.

Full story »

Special Symbols on the Keyboard (helps in Excel)

Shortcuts

Hi there,

 

 

This is a special post where you get some names of the special characters or symbols that are placed on the keyboard, LAPTOP or DESKTOP.

Special characters or symbols used on KEYBOARD (LAPTOP or DESKTOP)
 

Here we go:

 

~ tilde

!  exclamation mark 

@ 'at' symbol 

# hash 

$ dollar

% per cent 

^ caret 

Full story »

Missing Comma in millions place (quick tip)

How-to's, Excel Tips

Hi there,

 

 

I have a small tip for you today. Do you know why comma is missing in millions place for this number 12345,678.90. Yes, even I wasn't know since yesterday.


I Miss Teeth; You Miss Comma

 

Nothing to worry! here is how we can avoid such dragons in Excel. 

Full story »

EXCEL an application of NO USE!!!

excel_usage

Hi there,

 



A weekend is arising to all of us right?. Heyyyy Oooooh Ayyyyyyeeeee ....


Ok, now enough


Now, let me ask a Brain Storming Question to all of you.

Excel is no use!

There are many features in Excel which are used on day-to-day reporting. Out of them, let us discuss few here:

 

First Importance per the viewers are 

 

1. DATA TABLES & Its Features

 

and then it proceeds with:

Full story »

Contact / Help. ©2020 by Abhilash VK. Design & icons by N.Design Studio. Skin by Tender Feelings / Skin Faktory.