Experiglot.com Website Review

the recurring type of requests that i receive through managing this blog is trying to calculate a commission or bonus structure, especially by managers that have a sales force. i did touch on the subject a bit but i thought i’d do a quick review of the different type of commissions and how i’d calculate them in excel. i am also providing an excel file that you can view here if you can’t wait:) in this structure, a sales person would get a % of sales no matter what. this is the most simple case: in this structure, a sales person would get a % of sales but only under the condition that they reach a minimum of sales: as much as companies like to reward star employees, some are worried about the idea that a sales guy would end up making more than the here is a common system that is used. if you generate 10k in sales, you will earn x%. if you earn 25%, you will earn x% of your sales,. =if(a10 using excel keyboard (and other) shortcuts to dramatically increase productivity. this blog but i`ve never actually discussed one of the primary ways that i save time when working in excel. in the past, i`ve talked about adding the most common things that i do to save time. there`s no doubt that creating macros and using powerful functions in order to automate some processes are key but i probably save as much if not more time by simply “not searching” for functions in the excel spreadsheets. how? you’ve probably heard of the most famous keyboard shortcuts: these are clearly the ones i use most, not only in excel but on my computer in general. here are a few others that i use a lot: ctrl+pgup:switches between worksheet tabs, from left-to-right. ctrl-f: find this certainly solves most of my issues but there are some functions that are more complex to use as shortcuts but that i use over and over. what do i do with those? simply add the icons to the top of my excel bar in order to make it much easier to do. how? let’s take the example of “paste as values” which i tend to do all the time. how?