Tips & Tricks 148 - Get Battery Charging Status
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…)
By eforexcel|2017-06-08T17:48:34+00:00Saturday, October 29th, 2016|Categories: Tips and Tricks, VBA|Tags: BatterStatus, Battery, Charging, Status, Win32_Battery, Winmgmts, WMI|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…)
By eforexcel|2016-08-23T09:13:08+00:00Monday, October 24th, 2016|Categories: Solutions|Tags: MOD, Modulus, Repeat, sequence, series|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)
By eforexcel|2016-08-24T17:36:11+00:00Saturday, October 22nd, 2016|Categories: Challenges|Tags: Mathematics, maths, MOD, Modulus, Progressions, Sequences, series|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.
By eforexcel|2017-04-28T13:11:38+00:00Saturday, October 22nd, 2016|Categories: Downloads|Tags: Achievement, Goal, Mercury, PMI, PMP, Project Management, Target, Thermometer Chart|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.
By eforexcel|2017-06-08T17:50:32+00:00Saturday, October 15th, 2016|Categories: Tips and Tricks, VBA|Tags: CTRL+SHIFT+ESC, Excel.exe, Program Files, Program Files(86), Task Bar, Task Manager|4 Comments
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…)
By eforexcel|2016-08-23T09:13:58+00:00Monday, October 10th, 2016|Categories: Solutions|Tags: 26, Alphabets, Anagram, English, Isogram, Languages, Letters, Pandrome, Pangram, Sentences|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")
By eforexcel|2017-01-27T22:11:28+00:00Saturday, October 08th, 2016|Categories: Quizzes|Tags: Button, Excel Exam, Excel Exams, Excel Quiz, Excel Quizzes, Excel Tests, Excel Tutorial, Ribbon|0 Comments
0 of 10 questions completed
Questions:
A general quiz on Excel.
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading...
You must sign in or sign up to start the quiz.
You have to finish following quiz, to start this quiz:
0 of 10 questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 points, (0)
The shortcut for Insert Function dialog box is
How many maximum records can be shown in a filtered list?
Calculate Sheet can be invoked through following shortcut
Mail Merge is a functionality of Excel
The syntax for Custom Format in Excel is
What is the answer for following
=QUOTIENT(50,3)
By eforexcel|2016-08-24T16:44:53+00:00Saturday, October 08th, 2016|Categories: Challenges|Tags: Casesar, Cipher, Code, Crypt, Cryptography, Decrypt, Decryption, Encrypt, Encryption, Julian, SHIFT, Substitution|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
By eforexcel|2017-01-27T21:57:46+00:00Saturday, October 01st, 2016|Categories: Tips and Tricks|Tags: Advanced, Decimal, insert, Options, Points|0 Comments