BOOM!!! Excel 2016 is coming soon...

Excel 2016

Hi there,

 

Its a great news for all the Excel Lovers like you and me listening to this right? Yes, Microsoft is planning to release his next new version of Office, which is Office 2016. I hope, we can see lots of new features in this version as well, like we saw in existing versions. This Office 2016 is coming in the middle of the year, 2015.

To glance few of the new features, it works richer in Windows 10 on versions like Desktop version, Android versions, Ipads and Tabs. The richer, which means, touch and activate mode with lots of ease in using the features on Windows 10.

Full story »

Sort Data Based On Words (using formulas)

Formulas

Hi there,

 


Today, I have learnt how to sort data based on words or letters. Let me brief how to achieve this results.

sort data based on words


HOW TO GO ABOUT IT?

I have used an helper column where the formula used is =COUNTIF(B5:$B$12,">="&B5)

This formula will display the position of the word based on first letter. The position of the word should be either greater than or equal to the first letter of the word when compared to other words in the range of words or dept. names.

Full story »

Move/Copy/Duplicate A Sheet (3 ways to do)

excel_usage, Shortcuts

Hi there,

 

Reporting team will have to work on weekly, bi-weekly, monthly or yearly reports on day-to-day reporting. This reporting mostly involves in duplicating worksheets except 5% of manual changes.

Let me explain with example: Say, we are working on Attendance report. Each sheet is renamed with Date, starting from 01-01-2015 till 01-31-2015. Here we require 31 sheets to display. The change between one sheet to the another is nothing except renaming the sheet name with different date. 

To do this, we will work on one sheet and then we will copy and insert the sheet next to the existing by renaming the sheet to next date. Similarly we will do it for the rest of the sheets.

Full story »

sum top two values in a range

Formulas, Arrays

Hi there,

 

In this post, you can learn how to use sum function for the top two values in a range of cells. Before proceeding to what this post is about, let me show you a video explaining about this post.

 

Please leave your message in the below comments if you have different method to do this. 

Full story »

Happy Sankranthi

website updates

Hi there,

 


Happy Makara Sankranti To You and Your Family :)


Today is a very big festival for Indians. Few name it differently but we pray for one god and we celebrate equally  among each other. Basically, according to the Hindu calendar Makar Sankranti is a festival celebrated for the happiness of getting new crops for farmers. There are many scientifical reasons why this festival is also called as a New Year. 

 

Happy Sankranthi To all Our Viewers of "exceltoxl"


WHAT IS SANKRANTHI?

Full story »

RANDOM DATES without DUPLICATES

Formulas

Hi there,

 

In addition to the previous post Random Numbers without Duplicates, one of our user asked this question in our forum and also in linkedin. So, thought of sharing this tip as well.

To create a random dates without any duplicates, use the below formula:

Full story »

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