About Akhil Kakroo
- Location: Noida, India
- Website: kakrooakhil.blogspot.com
Akhil Kakroo's Popular Posts
Forum Thread : How to Make a Simple Report Card Template in Excel
This tutorial will teach you how to Create print ready reports from an excel list Download the sample report here https://goo.gl/Zt8HTz Video: .
Forum Thread : How to Insert 'NESTED if' with Ease
Nesting of the IF formula is quite tricky but after using the methodology shown in this video, you can be a master at using multiple IF conditions. This tutorial will teach you How to use Multiple IF conditions in a single formula Video: .
Forum Thread : How to Memorise the Excel Formula Syntax
How do you learn all excel formulas? A super simple explanation of the syntax of excel function and the usage of mathematical operators.See it yourself how putting an equal to (=) sign brings a cell into the calculation mode. Video: .
Forum Thread : How to Remove Line Breaks in Excel
This tutorial will teach you How to remove line breaks in excel. There can be different reasons for line breaks occurring in your text. Usually, carriage returns appear when you copy text from a webpage, get a workbook that already contains line breaks from a customer, or you ...more
Forum Thread : How to Create a Speedometer Chart or Gauge Chart in Excel
Create a gauge chart or speedometer chart in excel using these simple steps in less than 10 minutes. All you need is to hack a donut chart and pie chart and superimpose them. Video: . Link to download the xls file: https://drive.google.com/file/d/0ByEbABzPDhXIMGpYSUFZY3JSUjg/v ...more
Forum Thread : How to Add Dependent Data Validations in Excel
A common question from Excel users is along the lines of; I have a list in a cell that has used Data-Validation with the "List" option. I would like to have another cell display a list that is depended on the item chosen in my first list. There are quite a few ways to achieve ...more
Forum Thread : How to Create a Task Tracker in Excel
Check this step by step tutorial for a task tracker or to do list. It will also guide you to create dashboards, reports and charts easily. Video: . Download the sample spreadsheet from the link here: https://drive.google.com/file/d/0ByEbABzPDhXIRWFRREVNVTk1anc/view?usp=sharing
Forum Thread : How to use AND, OR with the IF function
Check out this video tutorial on how to nest the AND, OR functions with IF function Video: .
Forum Thread : How to Draw a Butterfly Tattoo
Butterfly Tattoos look glamorous and make a girl look more appealing. Butterfly tattoo holds significance in various cultures. It signifies beauty, love, change, freedom and feminity. Inking a Temporary Butterfly Tattoo is easier than you might think! At the same time, it req ...more
Forum Thread : Please Excuse My Dear Aunt Sally
Be very careful while using the mathematical operators in excel. Use parenthesis to group the numbers. Excel follows the mathematical order of operators BODMAS B: Bracket O: Order/ Power of D: Division M: Multiply A: Addition S: Subtraction Some people may also call it PEDMA ...more
Forum Thread : How to Get a Dynamic Dropdown List in Excel
When working with lists and reports, you sometimes have repetitive data which you want to enter again and again. While you have the excel autocomplete function but if you have similar tellers at the beginning of the data, the autocomplete wont function properly. A very good s ...more
Forum Thread : How to Work with Excel Keyboard Shortcuts
Excel keyboard shortcuts generally start with by pressing the “Alt” key. So, once you press the “Alt” key, you will see a shortcut or in fact an alphabet for each tab in the ribbon. Like F is for File, H is for Home, N for insert and so on. In the old excel interface, I mean ...more
Forum Thread : How to Work with Excel Formula
Video: . How to use the excel formula..this is the easiest way to understand it
Forum Thread : How to Get Current Date and Time in Excel with a Click
Many times you are supposed to enter the current date or time in excel so here is what you do; simply go to the cell and enter control + colon and the current date is added. If you want the time to be recorded, it is control + shift + colon. If you want both; it is control + ...more
How To: Use MS Excel Effectively
Sites
- Hot
- Latest
-
Forum Thread: How to Make a Simple Report Card Template in Excel 0 Replies
6 yrs ago -
Forum Thread: How to Insert 'NESTED if' with Ease 0 Replies
6 yrs ago -
Forum Thread: How to Memorise the Excel Formula Syntax 0 Replies
6 yrs ago -
Forum Thread: How to Remove Line Breaks in Excel 0 Replies
6 yrs ago -
Forum Thread: How to Create a Speedometer Chart or Gauge Chart in Excel 0 Replies
6 yrs ago -
Forum Thread: How to Add Dependent Data Validations in Excel 0 Replies
6 yrs ago -
Forum Thread: How to Create a Task Tracker in Excel 0 Replies
6 yrs ago -
Forum Thread: How to use AND, OR with the IF function 1 Replies
8 yrs ago -
How To: Use the if Function in Excel
-
Forum Thread: How to Draw a Butterfly Tattoo 0 Replies
9 yrs ago -
Forum Thread: Please Excuse My Dear Aunt Sally 0 Replies
9 yrs ago -
Forum Thread: How to Get a Dynamic Dropdown List in Excel 0 Replies
9 yrs ago -
Forum Thread: How to Work with Excel Keyboard Shortcuts 0 Replies
9 yrs ago -
Forum Thread: How to Work with Excel Formula 0 Replies
9 yrs ago -
Forum Thread: How to Get Current Date and Time in Excel with a Click 0 Replies
9 yrs ago -
How To: Use MS Excel Effectively
-
How To: Use the if Function in Excel
-
Forum Thread: How to Make a Simple Report Card Template in Excel 0 Replies
6 yrs ago -
Forum Thread: How to Insert 'NESTED if' with Ease 0 Replies
6 yrs ago -
Forum Thread: How to Memorise the Excel Formula Syntax 0 Replies
6 yrs ago -
Forum Thread: How to Remove Line Breaks in Excel 0 Replies
6 yrs ago -
Forum Thread: How to Create a Speedometer Chart or Gauge Chart in Excel 0 Replies
6 yrs ago -
Forum Thread: How to Add Dependent Data Validations in Excel 0 Replies
6 yrs ago -
Forum Thread: How to Create a Task Tracker in Excel 0 Replies
6 yrs ago -
Forum Thread: How to use AND, OR with the IF function 1 Replies
8 yrs ago -
Forum Thread: How to Draw a Butterfly Tattoo 0 Replies
9 yrs ago -
Forum Thread: Please Excuse My Dear Aunt Sally 0 Replies
9 yrs ago -
Forum Thread: How to Get a Dynamic Dropdown List in Excel 0 Replies
9 yrs ago -
Forum Thread: How to Work with Excel Keyboard Shortcuts 0 Replies
9 yrs ago -
Forum Thread: How to Work with Excel Formula 0 Replies
9 yrs ago -
Forum Thread: How to Get Current Date and Time in Excel with a Click 0 Replies
9 yrs ago -
How To: Use MS Excel Effectively