Thursday, December 29, 2011
Computer Tips & Trick: Download Rupee_Font_Installer and install it.Rupe...
Computer Tips & Trick: Download Rupee_Font_Installer and install it.Rupe...: Download Rupee_Font_Installer and install it. Rupee_Font_Installer click here Then go to control panel open region and language. Chang...
In Excel How To Repeat First Column In Every Pages
Go to page layout - page setup
In Page setup Dilog Box Just click On Sheet Tab.
In Print Area- Just Select Which Area Do You Want To Take Print Out.
In Column To Repeat At Left - Just Select Which Area Do You Want To Repeat.
Note-(If You Want To Repeat Row Header, In Row To Repeat At Top- Just Select Which Area Do You Want To Repeat).
Then See The Print Preview ( And Change The Margin If Its required )
You Can See SlNo And Name Will Appear In Every Pages.
Friday, December 16, 2011
How to Create A Presentation
Open Microsoft Powerpoint
Step I - Just Type Your Presentation Title And Sub Title (Just Like Image)
Step II- Insert New Slide.
Goto Insert Menu- New Slide - Chose Slide Design In the Right hand Side.
Insert Multiple Slides
Step I - Just Type Your Presentation Title And Sub Title (Just Like Image)
Step II- Insert New Slide.
Goto Insert Menu- New Slide - Chose Slide Design In the Right hand Side.
Insert Multiple Slides
Question & Answar About Excel
(1) Name wise balance?
Sorted by name, data-subtotal-name-sum-bill.
(2) Sales of particulars?
Sorted by particular data -subtotal particular sum unit.
(3) Date wise report?
Sorted by date, data -subtotal date- sum- bill.
(4) Every particular sale to every person?
Data sort by particular then by name.
Data- subtotal name- sum –unit- bill.
(5) Date wise sales of every person?
Data sorted by name then by date.
Data- subtotal date- sum- bill.
(6) Report of every date/persons/particulars?
Date sorted by particular/person/date.
Data- subtotal-date –sum- unit- bill.
(7) One item report of every person?
Sorted by name.
Auto filter by one particular.
Data- subtotal- name- sum –unit, bill.
(8) One person report of every item?
Sorted by particular.
Auto filter by name.
Data -subtotal –particular- sum –unit, bill
(9) One date report of one particular of every person?
Sorted by name, data auto filter date, particulars.
Data –subtotal- name- sum -unit -bill.
(10) Top ten unit report of one particular?
Data auto filters by particulars.
Units top ten.
(11) Minimum unit sales of every particular?
Sorted by particular
Data -subtotal –particulars- minimum- unit.
Sorted by name, data-subtotal-name-sum-bill.
(2) Sales of particulars?
Sorted by particular data -subtotal particular sum unit.
(3) Date wise report?
Sorted by date, data -subtotal date- sum- bill.
(4) Every particular sale to every person?
Data sort by particular then by name.
Data- subtotal name- sum –unit- bill.
(5) Date wise sales of every person?
Data sorted by name then by date.
Data- subtotal date- sum- bill.
(6) Report of every date/persons/particulars?
Date sorted by particular/person/date.
Data- subtotal-date –sum- unit- bill.
(7) One item report of every person?
Sorted by name.
Auto filter by one particular.
Data- subtotal- name- sum –unit, bill.
(8) One person report of every item?
Sorted by particular.
Auto filter by name.
Data -subtotal –particular- sum –unit, bill
(9) One date report of one particular of every person?
Sorted by name, data auto filter date, particulars.
Data –subtotal- name- sum -unit -bill.
(10) Top ten unit report of one particular?
Data auto filters by particulars.
Units top ten.
(11) Minimum unit sales of every particular?
Sorted by particular
Data -subtotal –particulars- minimum- unit.
HOW TO DESIGN & PLAY POWER POINT PRESENTATION
HOW TO DESIGN & PLAY POWER POINT PRESENTATION
FORMAT- Slide layout:
To change the slide format of your presentation which you previously selected. Select your slide and click on format slide lay out- in the dialogue box select a slide lay out and click on reapply. The previous format will change to new selected format.
Apply design template: or Slide design (office XP, 2007)
Format apply design template to enhance your slide by applying various kind of design template. Select your slide to apply design template and click on format. Apply design template- in the dialogue box select a design available to your computer- click apply button. It would format your slide.
SLIDE SHOW MENU:
View show: F5: slide show- view show- To see the slide presentation serially in full screen. Open your presentation file, click on slide show- view show- to see your slide presentation in full screen or press F5 function key.
Custom animation: slide show- custom animation- To apply animation and sound effect with order and timing. There are four tabs order and timing effect, chart effect, and multimedia setting.
In this custom animation dialogue box click on effect tab to apply animation and sound e.g. crawl & sleeping, spiral & chime after selecting a slide object then click on order and timing to select animation order time for a slide presentation and whether slide presentation either by mouse clicking or automatically. You can see the preview by clicking on preview button then click on ok.
SLIDE TRANSITION:
Slide show- slide transition- what you have done in custom animation you can do those also in slide transition.
CUSTOM SHOWS:
Slide show-custom show- to see the only selected slide presentation among all the slides of your presentation. Click on custom shows of slide show menu new button select a slide among the slides in slide in presentation and click n add ok then click on show by selecting custom show number.
SETUP SHOW:
Slide show- setup show- to setup slide show by entering number of the slide made by you in your presentation. Suppose your presentation contains 15 slides and you want to see only 7 to 12 then click on slide show setup show option. I the setup show dialogue box insert number in from 7 to 12 box and click ok.
FORMAT- Slide layout:
To change the slide format of your presentation which you previously selected. Select your slide and click on format slide lay out- in the dialogue box select a slide lay out and click on reapply. The previous format will change to new selected format.
Apply design template: or Slide design (office XP, 2007)
Format apply design template to enhance your slide by applying various kind of design template. Select your slide to apply design template and click on format. Apply design template- in the dialogue box select a design available to your computer- click apply button. It would format your slide.
SLIDE SHOW MENU:
View show: F5: slide show- view show- To see the slide presentation serially in full screen. Open your presentation file, click on slide show- view show- to see your slide presentation in full screen or press F5 function key.
Custom animation: slide show- custom animation- To apply animation and sound effect with order and timing. There are four tabs order and timing effect, chart effect, and multimedia setting.
In this custom animation dialogue box click on effect tab to apply animation and sound e.g. crawl & sleeping, spiral & chime after selecting a slide object then click on order and timing to select animation order time for a slide presentation and whether slide presentation either by mouse clicking or automatically. You can see the preview by clicking on preview button then click on ok.
SLIDE TRANSITION:
Slide show- slide transition- what you have done in custom animation you can do those also in slide transition.
CUSTOM SHOWS:
Slide show-custom show- to see the only selected slide presentation among all the slides of your presentation. Click on custom shows of slide show menu new button select a slide among the slides in slide in presentation and click n add ok then click on show by selecting custom show number.
SETUP SHOW:
Slide show- setup show- to setup slide show by entering number of the slide made by you in your presentation. Suppose your presentation contains 15 slides and you want to see only 7 to 12 then click on slide show setup show option. I the setup show dialogue box insert number in from 7 to 12 box and click ok.
Friday, November 18, 2011
Monday, June 6, 2011
Tally ERP.9 HOW TO ENTR MULTIPLE VAT IN A SINGLE VOUCHER
1.First you have to create unit, stock item.
2.Activate vat
3.Create sales 4%(choose sales@4%) and sales 12.5%(choose sales@12.5%) legd.
4.Create output vat4%, outputvat12.5% ledger.
5.Goto configuration(f12) chose no on common ledger A/c for item allocation.
6.Then enter sales voucher.
2.Activate vat
3.Create sales 4%(choose sales@4%) and sales 12.5%(choose sales@12.5%) legd.
4.Create output vat4%, outputvat12.5% ledger.
5.Goto configuration(f12) chose no on common ledger A/c for item allocation.
6.Then enter sales voucher.
Subscribe to:
Posts (Atom)