tag:blogger.com,1999:blog-24066970568137990362012-02-21T21:47:41.830+06:00LEARN COMPUTERMS EXCEL TIPS , FUNCTION ,TUTORIAL ETC.Md.shaiful islam Talukderhttps://profiles.google.com/117404868291467117409noreply@blogger.comBlogger441100tag:blogger.com,1999:blog-2406697056813799036.post-81405465998473500802012-02-08T23:32:00.000+06:002012-02-08T23:32:04.986+06:00Attendance Record Maintain by click .
Attendance Record Maintain by click . First click under date row visible Pop up Calendar than date select click insert date . After that attendant row double click Auto Cheek mark insert .At the working day include working day cell find attendance percentage.Download the sheet find details.Download.Md.shaiful islam Talukderhttps://profiles.google.com/117404868291467117409noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-56354367028695669342012-02-02T22:48:00.000+06:002012-02-02T22:48:29.757+06:00Grade Point and Letter Grade Calculation Actual way .
Different time we face how to calculation Letter grade . If Examination held 6(six) subject, one student find for this six subject out of 600 Marks 480(90+80+80+80+75+75) His grade A+ .Another student find 480(80+80+80+80+80+80) also his letter grade A+ . Which is right officiously second student right letter grade find. Because he/She individually subject-wary find 80 Marks. So, anybody Md.shaiful islam Talukderhttps://profiles.google.com/117404868291467117409noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-67237336647824728942012-01-27T22:49:00.002+06:002012-01-27T22:56:05.223+06:00Ms Excel Chart/Graph Templates .Ms Excel Chart/Graph Templates here include .Because ,Some time we are face trouble which way chart Designee . So , I post this . Download .Md.shaiful islam Talukderhttps://profiles.google.com/117404868291467117409noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-16742915895962620392012-01-18T23:31:00.001+06:002012-01-18T23:36:43.501+06:00Ranking easy way by Rank function .Ranking easy way by Rank Function and First , Second ,Third...... Coloring by conditional formatting . DownloadMd.shaiful islam Talukderhttps://profiles.google.com/117404868291467117409noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-52950408597166834542012-01-17T21:12:00.002+06:002012-01-18T23:37:43.677+06:00Multiple condition Sum in Ms Excel.Multiplecondition sum. It is a array formula first in formula cell double click than CTRL+Shift+Enter it will add {} to the formulawhich will be visible in the formula bar only.DownloadMd.shaiful islam Talukderhttps://profiles.google.com/117404868291467117409noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-22833054628126892212012-01-12T22:59:00.000+06:002012-01-12T23:00:02.339+06:00Mail Marge In Ms Excel .
Mail Marge in Ms Excel very easy way. At first in data sheet include all address than another sheet(form) letter body create . Please carefully follow help sheet and start . I hope it is effective and helpful you .DownloadMd.shaiful islam Talukderhttps://profiles.google.com/117404868291467117409noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-46033389935642290002011-12-30T11:18:00.002+06:002011-12-30T12:28:12.253+06:001900-2100 Calendar with notes optionCalendar 1900-2100 with Notes and Month wary Calendar option for print and use monthly schedule.DownloadMd.shaiful islam Talukderhttps://profiles.google.com/117404868291467117409noreply@blogger.com1tag:blogger.com,1999:blog-2406697056813799036.post-87825164892074520862011-12-25T12:55:00.001+06:002011-12-30T11:49:42.015+06:00Protect cell contain formulas.Protect cell contain formulas in an unprotected sheet use Validation .DownloadMd.shaiful islam Talukderhttps://profiles.google.com/117404868291467117409noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-91761813945240021052011-12-23T13:55:00.003+06:002011-12-30T11:53:08.916+06:00Bar Chart using REPT functionBar chart make very easy way by REPT function . I made by use "I" , in REPT function ,if you wish use another letter that no problem . DownloadMd.shaiful islam Talukderhttps://profiles.google.com/117404868291467117409noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-66784484201949142632011-12-18T16:31:00.001+06:002011-12-30T11:53:08.923+06:00Positive/condition value sum by formula.Positive/condition value sum by formula. DownloadMd.shaiful islam Talukderhttps://profiles.google.com/117404868291467117409noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-79444009973727612082011-12-16T11:48:00.003+06:002011-12-30T12:26:33.992+06:00Leap year or Not a leap year functionLeap year or Not a leap year function .DownloadMd.shaiful islam Talukderhttps://profiles.google.com/117404868291467117409noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-33007099821727679962011-12-13T19:12:00.004+06:002012-01-15T22:19:25.680+06:00Index file Maker .Index file Make very easy way not folder index .DownloadMd.shaiful islam Talukderhttps://profiles.google.com/117404868291467117409noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-90514052231310270422011-12-08T21:41:00.001+06:002011-12-24T13:42:02.757+06:00Employee weekly time sheet.
Employee weekly time sheet .DownloadMd.shaiful islam Talukderhttps://profiles.google.com/117404868291467117409noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-84465179474746307512011-12-05T21:52:00.001+06:002011-12-30T11:53:08.914+06:00Both side (column and row sum) equal or wrong formula.
Both side (column and row sum) equal or wrong formula.DownloadMd.shaiful islam Talukderhttps://profiles.google.com/117404868291467117409noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-88802888182742243182011-12-02T12:19:00.001+06:002011-12-30T11:53:08.913+06:00Subtotal function Use different way.
Subtotal function Use different way only change function number and calculation smoothly. DownloadMd.shaiful islam Talukderhttps://profiles.google.com/117404868291467117409noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-74125746588696757902011-11-25T10:43:00.001+06:002011-12-30T11:53:08.917+06:00Roman Number from General Number by function.
Roman Number from General Number by easy function.DownloadMd.shaiful islam Talukderhttps://profiles.google.com/117404868291467117409noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-45288736922456673722011-11-18T20:59:00.002+06:002011-12-24T16:38:42.763+06:00Appointment calendar by Ms Excel.Appointment calendar by Ms Excel select date than print and easy way maintain appointment. DownloadMd.shaiful islam Talukderhttps://profiles.google.com/117404868291467117409noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-75357400271049113192011-11-15T22:34:00.001+06:002011-12-30T11:53:08.915+06:00How Ms Excel Works with Dates.
How Ms Excel Works With dates some function find here . DownloadMd.shaiful islam Talukderhttps://profiles.google.com/117404868291467117409noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-26642346139755245872011-11-14T23:11:00.001+06:002011-12-30T11:53:08.919+06:00Ms Excel square and other power function .
Ms Excel any Number square and other power value calculation by this function.DownloadMd.shaiful islam Talukderhttps://profiles.google.com/117404868291467117409noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-86409996164621498512011-11-10T21:30:00.001+06:002011-12-24T13:46:12.616+06:00Ms Excel Double click a column auto cheek mark.
Ms Excel Double click a column auto cheek mark by VB .DownloadMd.shaiful islam Talukderhttps://profiles.google.com/117404868291467117409noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-18334789652289096962011-11-10T21:13:00.001+06:002011-12-30T11:53:08.920+06:00Ms excel Factorial function use.
Ms excel Factorial function use.DownloadMd.shaiful islam Talukderhttps://profiles.google.com/117404868291467117409noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-63584560403215746192011-11-10T21:03:00.002+06:002011-12-30T12:15:12.614+06:00Ms Excel Duplicate value delete by one click.Ms Excel Duplicate value delete by one click.DownloadMd.shaiful islam Talukderhttps://profiles.google.com/117404868291467117409noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-34445253530180377182011-11-09T11:10:00.002+06:002011-12-30T12:19:38.130+06:00Ms Excel duplicate value highlights very easy way.Ms Excel duplicate value highlights very easy way. Download .Md.shaiful islam Talukderhttps://profiles.google.com/117404868291467117409noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-17852178323302699632011-11-05T17:51:00.000+06:002011-12-24T13:49:26.274+06:00By Ms Excel check writing ,printing and register maintain .
Check writing ,printing and register maintain by Ms excel at dollar and Bangladeshi currency .DownloadMd.shaiful islam Talukderhttps://profiles.google.com/117404868291467117409noreply@blogger.com1tag:blogger.com,1999:blog-2406697056813799036.post-60019974636866103482011-11-04T16:20:00.001+06:002012-02-08T21:33:17.768+06:00Ms excel date write easy way by calendar. Ms excel date write easy way by calendar.DownloadMd.shaiful islam Talukderhttps://profiles.google.com/117404868291467117409noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-82694139274070929112011-11-04T16:14:00.000+06:002011-12-30T11:53:08.922+06:00Ms Excel last day of month Know by formula .
Ms Excel last day of month Know by formula .DownloadMd.shaiful islam Talukderhttps://profiles.google.com/117404868291467117409noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-79787814103617327162011-11-04T16:05:00.000+06:002012-01-15T22:25:15.992+06:00Ms excel filter by Input box.
Ms excel filter by Input box. DownloadMd.shaiful islam Talukderhttps://profiles.google.com/117404868291467117409noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-18396357917020748302011-11-04T14:34:00.000+06:002012-01-15T22:25:49.095+06:00Ms excel filter by one click category wary different sheet.
Ms excel filter by one click category wary different sheet .DownloadMd.shaiful islam Talukderhttps://profiles.google.com/117404868291467117409noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-10897197428722140132011-11-04T14:25:00.000+06:002012-01-15T22:25:38.111+06:00Ms excel filter by Month wary .
Ms excel filter by Month wary . Very nice way filter your monthly , yearly budget .DownloadMd.shaiful islam Talukderhttps://profiles.google.com/117404868291467117409noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-54050248897292207792011-11-04T10:44:00.001+06:002011-12-30T12:22:05.328+06:00Ms excel Duplicate Thing find by Function.Ms excel Duplicate Thing find by Function .DownloadMd.shaiful islam Talukderhttps://profiles.google.com/117404868291467117409noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-57358927683218241682011-11-01T00:17:00.000+06:002011-12-24T13:54:52.711+06:00Ms Excel Yearly calendar 1900-2100 .
Ms Excel Yearly calendar 1900-2100 . you are easily Date and day Know 1900-2100 and easy way solve different thing related date. DownloadMd.shaiful islam Talukderhttps://profiles.google.com/117404868291467117409noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-66427289286539151522011-10-30T23:13:00.000+06:002011-12-24T13:55:22.394+06:00Ms excel Search by Form.
Ms Excel Search In Sheet Very Easy way by Form . DownloadMd.shaiful islam Talukderhttps://profiles.google.com/117404868291467117409noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-68815392938761050932011-10-29T17:22:00.001+06:002011-12-30T12:36:42.863+06:00Ms excel Active row coloure .Ms Excel some time need Active row coloure so i Include my publish . DownloadMd.shaiful islam Talukderhttps://profiles.google.com/117404868291467117409noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-31613308051581280122011-10-29T13:02:00.001+06:002011-12-30T12:34:02.167+06:00Ms Excel Active cell coloure.When Large Number of data entry in Ms excel sheet ,where cell cursorActivate Know very difficult so this easily solve by this postDownloadMd.shaiful islam Talukderhttps://profiles.google.com/117404868291467117409noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-76487464869797636652011-10-28T15:59:00.000+06:002011-12-30T11:53:08.918+06:00Ms Excel Age or Date differ calculation function
Ms Excel Age or Date differ calculation function , by this function very easy way calculate date different...DownloadMd.shaiful islam Talukderhttps://profiles.google.com/117404868291467117409noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-17094578456540015462011-10-28T11:55:00.000+06:002011-12-24T13:57:29.760+06:00Ms excel Some Tips .
Some tips of Ms excel , I hope this are helpful . DownloadMd.shaiful islam Talukderhttps://profiles.google.com/117404868291467117409noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-84381138538967344682011-10-28T00:10:00.000+06:002011-12-24T13:57:50.678+06:00Ms excel Know Face id .
when open ms excel file find a form here write Number suppose 1-10 you find face picture
when cursor over you know face id , this id use different type of program .
If you try Download this fileDownloadMd.shaiful islam Talukderhttps://profiles.google.com/117404868291467117409noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-30291061583869237102011-10-27T23:38:00.000+06:002011-12-24T13:58:27.361+06:00Ms excel Magnify Active cell
Ms excel Magnify Active cell for good viewing .DownloadMd.shaiful islam Talukderhttps://profiles.google.com/117404868291467117409noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-48110680089901719092011-10-25T23:58:00.000+06:002012-01-27T23:24:42.900+06:00Ms excel keyboard sort cut .
Ms excel key board sort cut very useful to us so post it.DownloadMd.shaiful islam Talukderhttps://profiles.google.com/117404868291467117409noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-41366915144819352662011-10-25T22:33:00.000+06:002011-12-24T13:59:59.721+06:00Ms Excel user form with lightening
Very Nice way Ms excel 2003 user form develop by lightening
just like below picture....DownloadMd.shaiful islam Talukderhttps://profiles.google.com/117404868291467117409noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-20352554007361936212011-10-24T17:17:00.000+06:002011-12-24T14:00:45.014+06:00Ms Excel Number to text by Bangladeshi currency
How Number to text by bangladeshi currency ( Example : 100/= - "hundred taka") find here DownloadMd.shaiful islam Talukderhttps://profiles.google.com/117404868291467117409noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-55517664097354238872011-10-24T13:49:00.000+06:002011-12-24T14:01:22.300+06:00Ms excel Date to text .
How date to Text Details find zip file DownloadMd.shaiful islam Talukderhttps://profiles.google.com/117404868291467117409noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-53221224849161144142011-10-23T23:26:00.000+06:002011-10-25T23:28:51.321+06:00Ms excel age ,colour count, and colour sorting Add InIf Ms excel include this Add in Use Easy way Calculation Age , colour count , colour sorting
.DownloadMd.shaiful islam Talukderhttps://profiles.google.com/117404868291467117409noreply@blogger.com0tag:blogger.com,1999:blog-2406697056813799036.post-77466422354669528182011-10-22T20:40:00.001+06:002011-12-30T11:54:57.218+06:00Ms excel Age Calculation , Coloure sort and coloure countHow to in excel Age Calculation , Coloure sort and coloure count .DownloadMd.shaiful islam Talukderhttps://profiles.google.com/117404868291467117409noreply@blogger.com0