Akhil Kakroo's Latest 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

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

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

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

Next Page
Prev Page

• Hot
• Latest