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: .
About Akhil Kakroo
- Location: Noida, India
- Website: kakrooakhil.blogspot.com
Akhil Kakroo's Latest Posts
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: .
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: .
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
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
Check out this video tutorial on how to nest the AND, OR functions with IF function Video: .
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
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
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
Video: . How to use the excel formula..this is the easiest way to understand it
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