Sat 29 Oct 2016

Tips & Tricks 148 - Get Battery Charging Status

By |Saturday, October 29th, 2016|Categories: Tips and Tricks, VBA|Tags: , , , , , , |0 Comments

1. Make a backup of your workbook.
2. Open your workbook and ALT+F11
3. Locate your Workbook name in Project Explorer Window
4. Right click on your workbook name > Insert > Module
(more…)

Mon 24 Oct 2016

Solution - Challenge 52 - Generate the Sequence 1,2,2,3,3,3,4,4,4,4,5,5,5,5,5...

By |Monday, October 24th, 2016|Categories: Solutions|Tags: , , , , |0 Comments

Below is a possible solution to the challenge Challenge 52 - Generate the Sequence 1,2,2,3,3,3,4,4,4,4,5,5,5,5,5...

Put following formula and drag down

=FLOOR((1+((1+8*ROWS($1:1)-1)^0.5))/2,1)

Sat 22 Oct 2016

Challenge 54 - Make a Sequence like A_B__C___D____E_____F......

By |Saturday, October 22nd, 2016|Categories: Challenges|Tags: , , , , , , |1 Comment

This time challenge before you is to write a formula which can be dragged down and leaves so many blank cells - 1 before that alphabet's position in English Language. Hence, the sequence will start with A, will leave 1 blank cell, then B, then 2 blank cells, then C, then 3 blank cells, then D, then 4 blank cells, then E, then 5 blank cells, then F....................................................................then 24 blank cells, then Y and finally 25 blank cells and then Z.

(more…)

Sat 22 Oct 2016

Downloads 08 - Template 08 - Thermometer Chart Template

By |Saturday, October 22nd, 2016|Categories: Downloads|Tags: , , , , , , , |0 Comments

< The template can be downloaded from Template 08 - Thermometer Chart >

Thermometer Chart is used to show the progress towards a goal. It is generally used to reflect on the percentage achievement.

The template here gives many different type of Thermometer charts. You can create many more and / or format existing ones to meet your requirements.

(more…)

Sat 15 Oct 2016

Tips & Tricks 147 - Find the Location of Excel.Exe

By |Saturday, October 15th, 2016|Categories: Tips and Tricks, VBA|Tags: , , , , , |1 Comment

Generally Excel.Exe will be located in C:\Program Files (x86)\Microsoft Office\Office15 in case of Excel 2013 / Windows 7. During installation, if another path is chosen, Excel.Exe's location changes. Default Path is also dependent upon Office and Windows combinations. Sometimes, it may not be locatable at all.

To find the location of Excel.Exe -

1. Start Excel
2. Right click on Windows Task Bar > Start Task Manager > Processes tab (Task Manager can also be opened by pressing CTRL+SHIFT+ESC)
(more…)

Mon 10 Oct 2016

Solution - Challenge 51 - Another Word Challenge - Whether Given Words are Anagram or not

By |Monday, October 10th, 2016|Categories: Solutions|Tags: , , , , , , , , , |0 Comments

Below is a possible solution to the Challenge 51 - Another Word Challenge - Whether Given Words are Anagram or not

Use following formula -

=IF(AND(LEN(A1)=LEN(B1),SUMPRODUCT(--(LEN(A1)-LEN(SUBSTITUTE(UPPER(A1),
UPPER(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)),""))=LEN(B1)-LEN(SUBSTITUTE(
UPPER(B1),UPPER(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)),""))))=LEN(A1)),"Anagram","Not Anagram")

Sat 08 Oct 2016

Excel Quiz 46

By |Saturday, October 08th, 2016|Categories: Quizzes|Tags: , , , , , , , |0 Comments

Excel Quiz 46

A general quiz on Excel.

Sat 08 Oct 2016

Challenge 53 - Cryptography Challenge 4 - Caesar's Shift Cipher Decrypter

By |Saturday, October 08th, 2016|Categories: Challenges|Tags: , , , , , , , , , , , |2 Comments

We published a cryptography challenge Challenge 39 - Cryptography Challenge 1 - Caesar's Shift Cipher. The purpose of the challenge was to create an Excel based Encrypter.

This time, we need to create the de-crypter for the same. The Excel file related to this challenge can be downloaded from Challenge 53 - Decryption - Caesar's Shift Cipher

(more…)

Sat 01 Oct 2016

Tips & Tricks 146 - When I input a number, Excel automatically inserts a decimal with 2 decimal points

By |Saturday, October 01st, 2016|Categories: Tips and Tricks|Tags: , , , , |0 Comments

Sometimes, you might face a problem that you input a number say 567 and it automatically becomes 5.67. If you enter 8, it becomes 0.08.

To correct this problem > File > Options > Advanced and uncheck Red Zone

1