Skip to main content

Posts

Name Rang in Excel and it's use.

Object of This block: How We Can Define Name Range in Excel , How it's Useful to us. What is Name Range? Name Range: Giving One Custom Name to One or More than One Cell in Excel . Ex.  A2 = net profit        C1:C10 = productlist How to Create Name Range: 1. First Select One or More Cell Which of Those, You want to Give a Name.  2. Go to Name box 3. Give a Name to Selected Cell or Cells.    ( In this C1:C10 = Productlist ) The following Characters are not allowed as Name: Space is Not Allowed as Part of a Name. Names can't look like Cell addresses, Such as A$2 or A2C2 C, c, R, r -- Can't be Used as Names --  Excel Uses Them as Selection Shortcuts Names are not Case Sensitive. For example, PROUCTLIST and productlist are treated as the same name. Now, We Understand  Use of Name Range: 1. On data validation: While Creating a  dr...
Post a Comment
Read more
Recent posts

Excel Ctrl +

Object of This Block: To Get Knowledge of MS Excel “Ctrl + Letter” Shortcuts, That will Increase our work speed in excel. Ctrl + ·         Ctrl + A -   selects the whole worksheet or the whole date ·         Ctrl + B -   bold the selected data ·         Ctrl + C -   copy the selected data  ·         Ctrl + D -   copy the above cell data in current cell  ·         Ctrl + F -   open Find dialog box ·         Ctrl + G - open  Go To dialog box ·         Ctrl + H - open  the Replace dialog box ·         Ctrl + I   -   italics the selected data ·         Ctrl + K - open  Insert Hyperlink dialo...
Post a Comment
Read more

How to Stop Back Dated Entries In Tally ?

The object of This Block : You Can Stop Create/alter Entry in Tally from Date Specified By You.  (I.e. you are in 18-19 and you want to stop create/alter entry before 31.03.2018) Block of Info : Useful Term: "Current Date for tally": Menace "Date of Last Voucher entry in tally" (you can see on Gateway of tally Also) We are Require to Mack Following two type of login security : 1)  Admin  Login : (Admin name and Password) 2)  User Login :  ( User Name and Password) Let’s, Do it :      1)  To Set Admin Name and Password  ·        Gateway of Tally > Co. Info (Alt + f3) > Alter. ·        Select Company name ·        Mack “yes’ to ‘Use Security Controls” ·        Set: “Name of Admin” and “Password” ·        Reload Company By using Above “Name and “Pas...
Post a Comment
Read more

How to Improve Windows With a Custom Keyboard Shortcut ?

The object of This Block: To Create Custom Shortcut for any programs in windows. 1.      Right-Click The desired Program Icon and Click on “Properties ". 2.   In T he Properties dialogue box > Shortcut, Find the Text box “Shortcut key". 3.  Click in that Text box and enter a Key that You Wish to Use us your shortcut key. (i.e. For MS Excel = "E") Windows will automatically Place “Ctrl + Alt +” in front.   If you choose a Function Key, Then Only that Function Key will be Used and “Ctrl + Alt +” will not be added. (In this I Set Shortcut Key For Excel   “Ctrl + Alt + E”) 4.      Click Apply and Then Click "OK".             Now, You Can Open Excel By Simply Typing "Ctrl + Alt+ E" Grow the Info Comment  + Share + Subscribe 
1 comment
Read more

How to Microsoft office File (I.e. Excel, word, power point, Access ) mack Read only ?

The Object of this block : After working done in any MS office file, we can save it as read only, so in future nobody can change it. In MS office , A Option Call "Mark as Final" will convert file normal file into Read-only file. How to Convert Normal MS Excel Workbook into  Read-only Workbook Using " Mark as Final". 1. On the File tab, 2. Click Prepare > Mark as Final. 3. Click Ok. Now, This Excel Workbook is Read Only and  No one can Change it. If, You Require to Convert Read-only Workbook into Normal Workbook (i.e. Editable Workbook) Follow Above Three Step Again.    Grow The info.
Post a Comment
Read more

Vlookup & Hlookup function of Excel .

Object of this Block:  understanding of Vlookup and Hlookup data analysis function  of Excel . Useful term : Hear, H stands for Horizontal V stands for vertical At, What Point of Data Analysis Vlookup and Hlookup will help us? Mr. B having two table of data with one similar column. both table having following data: Table 1. Column Name Row No. A B C 1 Country Capital National Language 2 India Delhi Hindi 3 Japan Tokyo Japanese 4 UK London English 5 Italy Rome Italian 6 France Paris French Table 2. Column Name Row No. A B 1 Country National Language 2 India 3 Japan 4 UK 5 Italy 6 France Requirement of Mr.B: Now, Mr.B wants to f...
Post a Comment
Read more