Favourite Tech Notes

Hiiiiiii , and a very good day to all my readers. I have been receiving queries related to Advanced Excel features including, GOAL SEEK, SCENARIO, PIVOT TABLE, SUBTOTAL, FORMULA etc. We shall be discussing each and every feature of Advance Excel in Detail. Firstly we'll be learning the GOAL SEEK Feature Goal Seek Goal Seek is used t o determine the value of   any  input cell(cell being used in the formula) new value for formula cell is known. Suppose we have following table available with us having details of employees along with Salary figure and computed bonus value as 12 % of Salary Here in the above table, if you would like to determine the new Salary for employee name "SOFT" , for a new Bonus value of 4100 (where Bonus is calculated as 12 % of salary) . To do so,follow the steps mentioned below,   Place cell pointer in formula cell(in our case, Bonus Cell) Data > What If Analysis> Goal Seek  Goal Seek dialog box appears in which supply following deta...

Printing Controls provide a great way to programmer to perform Print Related Tasks. We need to draw following controls on our Windows Form PrintDialog PrintDocument PrintPreviewDialog Rich Text Box A PrintDialog control is used to open the WINDOWS Print Dialog. The PrintDialog allows user to send and output to Pinter. With the help of Print Preview Dialog, you can preview what and how it is going to be printed How to Print Document and Check Print Preview in VB.NET Print Document The PrintDocument objects holds all the information that is required to print a Pag. THey are to be associated with the control whose contents are to be printed. PrintDocument handles the concerned EVENTS and OPERATIONS We need to handle the Print_Page event of the Print Document. Write following statements at Print_Page Event of Print Document1      e.Graphics.DrawString(RichTextBox1.Text, RichTextBox1.Font, Brushes.Black, 100,100)      e. Graphics.PageUnit=Graph...

Recap : We have studied the concept of Debit(Account whose value is increasing because of any transaction) and Credit (Account whose value is decreasing because of any transaction) Today, we are going to understand ,                      what is LIFE CYCLE of a MANUAL ACCOUNTING SYSTEM?? Accounting begins with Transaction,  For which we have VOUCHER( defined as a Piece of Paper holding complete details of Transaction ) And we need to perform VOUCHER POSTING ( defined as a process to input voucher details in corresponding Accounting Books) Accounting Books Journal/ Journal Proper ( A Common Book in which you can enter any kind of transaction) Subsidiary Books (Secondary/ Alternate books in which we can post voucher for bifurcated maintenance.) Trial Balance: Process to Check the correctness of amount being entered during Voucher Entry Balance Sheet and Profit & Loss : Final Accounts Statements prepared at End of ...

Before we begin,                         we need to know the Basic Accounting Concepts,prior to start working with TALLY. This would definitely help in easier understanding of TALLY and several ACCOUNTING FUNDAAS... What is Accounting? Accounting can be defined as a process to maintain routine transactions in any field systematically. Maintenance helps us in following ways: 1. Future Prediction : i.e. one can judge how its business is going on and what measures can be taken out for the progress and betterment of it. 2. Error and Fraud Tracing : Systematic and Regular maintenance helps us to find out INVALID or ILLEGAL  transactions  or any kind of FRAUDS . What are Account and Accounts? Account is the individual entity which takes part in your business transactions. Account is also known as LEDGER and खाता in Hindi Accounts or Accounting books are actually a collection of Account (Ledger) which are ...

"Cookies can be defined as a small text files that are created by Web Server and saved by Web Browser on Client's Machine" However, if clients machine has disabled 'Cookies' , the script to create & store cookies will lose its effect. Here, we are going to create a LOGIN page, that ask user to enter it's ID and PASSWORD. Also, if user selects, 'Keep me Signed in' for next visit, we'll save its ID & Password Following are the name of controls on our LOGIN Page: 1. idlbl for Your Id Label 2. idtxt for textbox where User ID will be entered. Also set its AUTOPOSTBACK property to TRUE 3. passlbl for Password Label 4. Passtxt for textbox where password will be entered. 5. loginbtn for LOGIN button Write following declaration statement in General Section Dim uid as HttpCookie Write following code at LOGIN Button if checkbox1.chcked=true then     uid = New HttpCookie(idtxt.text)     uid.value=passtxt.text      Response.Cooki...

Following steps needs to be followed if you want to have a manual database connectivity 1. Dim cn as New Data.SqlClient.SqlConnection 2. Dim cm as New Data.SqlClient.SqlCommand 3. Dim str as String 4. cn.ConnectionString="Data Source = servername\sqlexpress;Initial Catalog=databasename;Integrated Security=True" 5. cm.Connection =cn 6. cm.CommandType=Data.CommandType.Text 7. str="your Insert SQL statement goes here" 8. cm.commandText=str 9. cn.open() 10. cm.ExecuteNonQuery 11. cn.Close() I have given above statements taken into considerations your VB/ASP .net interface. You are required to change the statements accordingly, depending on the language you're working on