Skip to main content

Posts

Showing posts from January, 2021

Microsoft Access MS Access Basics Tips and Trick-7

Adding Data An Access database is not a file in the same sense as a Microsoft Office Word document or a Microsoft Office PowerPoint are. Instead, an Access database is a collection of objects like tables, forms, reports, queries etc. that must work together for a database to function properly. We have now created two tables with all of the fields and field properties necessary in our database. To view, change, insert, or delete data in a table within Access, you can use the table’s Datasheet View. A datasheet is a simple way to look at your data in rows and columns without any special formatting. Whenever you create a new web table, Access automatically creates two views that you can start using immediately for data entry. A table open in Datasheet View resembles an Excel worksheet, and you can type or paste data into one or more fields. You do not need to explicitly save your data. Access commits your changes to the table when you move the cursor to a new field in the same row, or whe
Post a Comment
Read more

Microsoft Excel-office FORMATTING CELLS Tips and Tricks-5

  Setting Colors in Excel 2010 You can change the background color of the cell or text color. Changing Background Color By default the background color of the cell is white in MS Excel. You can change it as per your need from  Home tab » Font group » Background color . Changing Foreground Color By default, the foreground or text color is black in MS Excel. You can change it as per your need from  Home tab » Font group » Foreground color . Also you can change the foreground color by selecting the cell  Right click » Format cells » Font Tab » Color . The beginner to advance and start up step-5 Thank you all very much  
Post a Comment
Read more

Microsoft Excel-office FORMATTING CELLS Tips and Tricks-4

 Rotate Cells in Excel 2010 You can rotate the cell by any degree to change the orientation of the cell. Rotating Cell from Home Tab Click on the  orientation  in the  Home tab . Choose options available like Angle CounterClockwise, Angle Clockwise, etc. Rotating Cell from Formatting Cell Right Click on the cell. Choose Format cells » Alignment » Set the degree for rotation. The beginner to advance and start up step-4 Thank you all very much  
Post a Comment
Read more

Microsoft Excel-office FORMATTING CELLS Tips and Tricks-3

  Text Decoration in Excel 2010 You can change the text decoration of the cell to change its look and feel. Text Decoration Various options are available in Home tab of the ribbon as mentioned below. Bold  − It makes the text in bold by choosing  Home » Font Group » Click B  or Press  Control + B . Italic  − It makes the text italic by choosing  Home » Font Group » Click I  or Press  Control + B . Underline  − It makes the text to be underlined by choosing  Home » Font Group » Click U  or Press  Control + B . Double Underline  − It makes the text highlighted as double underlined by choose  Home » Font Group » Click arrow near U » Select Double Underline . More Text Decoration Options There are more options available for text decoration in Formatting cells » Font Tab » Effects cells as mentioned below. Strike-through  − It strikes the text in the center vertically. Super Script  − It makes the content to appear as a super script. Sub Script  − It makes content to appear as a sub script.
Post a Comment
Read more

Microsoft Excel-office FORMATTING CELLS Tips and Tricks-2

  Setting Fonts in Excel 2010 You can assign any of the fonts that is installed for your printer to cells in a worksheet. Setting Font from Home You can set the font of the selected text from  Home » Font group » select the font . Setting Font From Format Cell Dialogue Right click on cell » Format cells » Font Tab Press Control + 1 or Shift + Control + F The beginner to advance and start up step-2 Thank you all very much    
Post a Comment
Read more

Microsoft Excel-office FORMATTING CELLS Tips and Tricks-1

  Setting Cell Type in Excel 2010 Formatting Cell MS Excel Cell can hold different types of data like Numbers, Currency, Dates, etc. You can set the cell type in various ways as shown below − Right Click on the cell » Format cells » Number. Click on the Ribbon from the ribbon. Various Cell Formats Below are the various cell formats. General  − This is the default cell format of Cell. Number  − This displays cell as number with separator. Currency  − This displays cell as currency i.e. with currency sign. Accounting  − Similar to Currency, used for accounting purpose. Date  − Various date formats are available under this like 17-01-2020, 17 th -Jan-2020, etc. Time  − Various Time formats are available under this, like 1.30PM, 13.30, etc. Percentage  − This displays cell as percentage with decimal places like 50.00%. Fraction  − This displays cell as fraction like 1/4, 1/2 etc. Scientific  − This displays cell as exponential like 5.6E+01. Text  − This displays cell as normal text. Specia
Post a Comment
Read more

Microsoft Excel-office EDITING WORKSHEETS Tips and Tricks-13

  Undo Changes in Excel 2010 Undo Changes You can reverse almost every action in Excel by using the Undo command. We can undo changes in following two ways. From the Quick access tool-bar » Click Undo. Press Control + Z. You can reverse the effects of the past 100 actions that you performed by executing Undo more than once. If you click the arrow on the right side of the Undo button, you see a list of the actions that you can reverse. Click an item in that list to undo that action and all the subsequent actions you performed. Redo Changes You can again reverse back the action done with undo in Excel by using the Redo command. We can redo changes in following two ways. From the Quick access tool-bar » Click Redo. Press Control + Y.   The beginner to advance and start up step-13 Thank you all very much
Post a Comment
Read more

Microsoft Excel-office EDITING WORKSHEETS Tips and Tricks-12

  Add Text Box in Excel 2010 Text Boxes Text boxes are special graphic objects that combine the text with a rectangular graphic object. Text boxes and cell comments are similar in displaying the text in rectangular box. But text boxes are always visible, while cell comments become visible after selecting the cell. Adding Text Boxes To add a text box, perform the below actions. Choose Insert » Text Box » choose text box or draw it. Initially, the comment consists of Computer's user name. You have to modify it with text for the cell comment. Formatting Text Box After you have added the text box, you can format it by changing the font, font size, font style, and alignment, etc. Let us see some of the important options of formatting a text box. Fill  − Specifies the filling of text box like No fill, solid fill. Also specifying the transparency of text box fill. Line Colour  − Specifies the line colour and transparency of the line. Line Style  − Specifies the line style and width. Size
Post a Comment
Read more

Microsoft Excel-office EDITING WORKSHEETS Tips and Tricks-11

  Insert Comments in Excel 2010 Adding Comment to Cell Adding comment to cell helps in understanding the purpose of cell, what input it should have, etc. It helps in proper documentation. To add comment to a cell, select the cell and perform any of the actions mentioned below. Choose Review » Comments » New Comment. Right-click the cell and choose Insert Comment from available options. Press Shift+F2. Initially, a comment consists of Computer's user name. You have to modify it with text for the cell comment. Modifying Comment You can modify the comment you have entered before as mentioned below. Select the cell on which the comment appears. Right-click the cell and choose the Edit Comment from the available options. Modify the comment. Formatting Comment Various formatting options are available for comments. For formatting a comment,  Right click on cell » Edit comment » Select comment » Right click on it » Format comment . With formatting of comment you can change the color, font,
Post a Comment
Read more

Microsoft Excel-office EDITING WORKSHEETS Tips and Tricks-10

  Special Symbols in Excel 2010 If you want to insert some symbols or special characters that are not found on the keyboard in that case you need to use the  Symbols option . Using Symbols Go to  Insert » Symbols » Symbol  to view available symbols. You can see many symbols available there like Pi, alpha, beta, etc. Select the symbol you want to add and click insert to use the symbol. Using Special Characters Go to  Insert » Symbols » Special Characters  to view the available special characters. You can see many special characters available there like Copyright, Registered etc. Select the special character you want to add and click insert, to use the special character. The beginner to advance and start up step-10 Thank you all very much    
Post a Comment
Read more