Excel Is Simple

Here is a simple explanation of the various COUNT and IF formulas Here are some of the simple COUNT and IF formulas: COUNT - Counts number of cells with numbers in a range COUNTA - Counts number of non blank cells in a range COUNTBLANK - Counts number of blank cells in a range COUNTIF - Counts if a criteria is met in a range COUNTIFS - Counts if multiple criteria is met in a range SUM - Sum of a range SUMIF - Sum of a range if a single criteria is met SUMIFS - Sum of a range if multiple criteria are met Watch the video to understand the working of these formulas Welcome to Excel is Simple; A channel where we will help you will all your excel problems in the simplest possible way Subscribe to the channel by clicking http://www.youtube.com/user/excelissimple?sub_confirmation=1

Please excuse my dear aunt sally!!! See how the mathematical operators and their order can change your calculations as explained in the video.

A great way to understand the formula. Watch this video to know 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 shortcut for this would be the ctrl+down arrow. It is an easy means to speed through repetitive data entry within a column. Just one thing to remember, this shortcut does not work with numbered lists and here you need to type the entire number. Friends just try this tip while using your excel workbooks and do remember to share your tips that you thin are interesting and should be in the upcoming videos. Subscribe to the channel by clicking http://www.youtube.com/user/excelissimple?sub_confirmation=1

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 2003, you can find an underline under the letter in the menu which denotes the short key. When you press the short key, the ribbon opens up and all the commands in the ribbon appear with the next level of short key. If you use some commands very prominently, I would recommend that do not use the mouse to navigate to the command but use the short key. It will make a lot of difference in the way you work in excel and the efficiency as well. Friends once you start working on excel day in and day out you will see how easier these short keys become for you to work on the commands. Share your experiences with me in the comments section below Now coming to the worksheet, there are some important and easy shortcuts t...

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 + colon space and then control + shift + colon. The hit enter This does save a lot of time for me and am sure will save a lot for you as well Excel Is Simple is an attempt to help people understand the basics of MS Excel. After all excel is not a demon that many have promoted it as. Week on week we will try to help you with this application, the usage, formula and resolve the queries that people might have. " Welcome to Excel is Simple; A channel where we will help you will all your excel problems in the simplest possible way Subscribe to the channel by clicking http://www.youtube.com/user/excelissimple?sub_confirmation=1

Welcome to the first chapter of Excel is Simple. A place where we will burst all myths around excel and try to make it simpler and fun to use. I would like to share an important tip…if you want to be fast with excel, try to avoid using the mouse as much as you can. We will soon be speaking about keyboard shortcuts and how to go to the individual menu’s etc later and there you can see how using the keyboard increases your speed. The main components of the excel user interface are the quick access toolbar, ribbon, formula bar, the worksheet area and the status bar. Let’s look at each one of them individually. The quick access toolbar: This small toolbar can be seen at the top left corner of the excel interface. By default you can see the save, redo and undo commands there but then if you click the small down arrow icon, you get options to customize the quick access tool bar. There are some options like new, open, print that are available plus an option to fully customize the toolb...