Skip to main content

Posts

Showing posts from October, 2020

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

Microsoft Excel-office MS EXCEL BASIC Tips and Tricks-10

  Delete Worksheet in Excel 2010 Delete Worksheet Here is the step to delete a worksheet. Step  − Right Click the  Sheet Name  and select the  Delete  option. Sheet will get deleted if it is empty, otherwise you'll see a confirmation message. Press the  Delete  Button. Now your worksheet will get deleted.   The beginner to advance and start  up step-10 Thank you all very much.

Microsoft Excel-office MS EXCEL BASIC Tips and Tricks-9

  Hiding Worksheet in Excel 2010 Hiding Worksheet Here is the step to hide a worksheet. Step  − Right Click the  Sheet Name  and select the  Hide  option. Sheet will get hidden. Unhiding Worksheet Here are the steps to unhide a worksheet. Step 1  − Right Click on any  Sheet Name  and select the  Unhide...  option. Step 2  − Select  Sheet Name  to unhide in  Unhide  dialog to unhide the sheet. Press the  Ok  Button. Now you will have your hidden sheet back. The beginner to advance and start up step-9 Thank you all very much.

Microsoft Excel-office MS EXCEL BASIC Tips and Tricks-8

  Copy Worksheet in Excel 2010 Copy Worksheet First of all, let us create some sample text before we proceed. Open a new excel sheet and type any data. We've shown a sample data in the screenshot. OrderDate Region Rep Item Units Unit Cost Total 1/6/2010 East Jones Pencil 95 1.99 189.05 1/23/2010 Central Kivell Binder 50 19.99 999.5 2/9/2010 Central Jardine Pencil 36 4.99 179.64 2/26/2010 Central Gill Pen 27 19.99 539.73 3/15/2010 West Sorvino Pencil 56 2.99 167.44 4/1/2010 East Jones Binder 60 4.99 299.4 4/18/2010 Central Andrews Pencil 75 1.99 149.25 5/5/2010 Central Jardine Pencil 90 4.99 449.1 5/22/2010 West Thompson Pencil 32 1.99 63.68 6/8/2010 East Jones Binder 60 8.99 539.4 6/25/2010 Central Morgan Pencil 90 4.99 449.1 7/12/2010 East Howard Binder 29 1.99 57.71 7/29/2010 East Parent Binder 81 19.99 1,619.19 8/15/2010 East Jones Pencil 35 4.99 174.65 Here are the steps to copy an entire worksheet. Step 1  − Right Click the  Sheet Name  and select the  Move or Copy  option. St

Microsoft Excel-office MS EXCEL BASIC Tips and Tricks-7

  Creating New Worksheet Three new blank sheets always open when you start Microsoft Excel. Below steps explain you how to create a new worksheet if you want to start another new worksheet while you are working on a worksheet, or you closed an already opened worksheet and want to start a new worksheet. Step 1  − Right Click the  Sheet Name  and select  Insert  option. Step 2  − Now you'll see the Insert dialog with select  Worksheet  option as selected from the general tab. Click the  Ok  button. Now you should have your blank sheet as shown below ready to start typing your text. You can use a short cut to create a blank sheet anytime. Try using the Shift+F11  keys and you will see a new blank sheet similar to the above sheet is opened. The beginner to advance and start up step-7 Thank you all very much.

Microsoft Excel-office MS EXCEL BASIC Tips and Tricks-6

  Save Workbook in Excel 2010 Saving New Sheet Once you are done with typing in your new excel sheet, it is time to save your sheet/workbook to avoid losing work you have done on an Excel sheet. Following are the steps to save an edited excel sheet − Step 1  − Click the  File tab  and select  Save As  option. Step 2  − Select a folder where you would like to save the sheet, Enter file name, which you want to give to your sheet and Select a Save as type, by default it is  .docx  format. Step 3  − Finally, click on  Save  button and your sheet will be saved with the entered name in the selected folder. Saving New Changes There may be a situation when you open an existing sheet and edit it partially or completely, or even you would like to save the changes in between editing of the sheet. If you want to save this sheet with the same name, then you can use either of the following simple options − Just press  Ctrl + S  keys to save the changes. Optionally, you can click on the floppy icon a

Microsoft Excel-office MS EXCEL BASIC Tips and Tricks-5

  Move Around in Excel 2010 Excel provides a number of ways to move around a sheet using the mouse and the keyboard. First of all, let us create some sample text before we proceed. Open a new excel sheet and type any data. We've shown a sample data in the screenshot. OrderDate Region Rep Item Units Unit Cost Total 1/6/2010 East Jones Pencil 95 1.99 189.05 1/23/2010 Central Kivell Binder 50 19.99 999.5 2/9/2010 Central Jardine Pencil 36 4.99 179.64 2/26/2010 Central Gill Pen 27 19.99 539.73 3/15/2010 West Sorvino Pencil 56 2.99 167.44 4/1/2010 East Jones Binder 60 4.99 299.4 4/18/2010 Central Andrews Pencil 75 1.99 149.25 5/5/2010 Central Jardine Pencil 90 4.99 449.1 5/22/2010 West Thompson Pencil 32 1.99 63.68 6/8/2010 East Jones Binder 60 8.99 539.4 6/25/2010 Central Morgan Pencil 90 4.99 449.1 7/12/2010 East Howard Binder 29 1.99 57.71 7/29/2010 East Parent Binder 81 19.99 1,619.19 8/15/2010 East Jones Pencil 35 4.99 174.65 Moving with Mouse You can easily move the insertion poin

Microsoft Excel-office MS EXCEL BASIC Tips and Tricks-4

  Entering Values in Excel 2010 Entering values in excel sheet is a child’s play and this chapter shows how to enter values in an excel sheet. A new sheet is displayed by default when you open an excel sheet as shown in the below screen shot. Sheet area is the place where you type your text. The flashing vertical bar is called the insertion point and it represents the location where text will appear when you type. When you click on a box then the box is highlighted. When you double click the box, the flashing vertical bar appears and you can start entering your data. So, just keep your mouse cursor at the text insertion point and start typing whatever text you would like to type. We have typed only two words "Hello Excel" as shown below. The text appears to the left of the insertion point as you type. There are following three important points, which would help you while typing − Press Tab to go to next column. Press Enter to go to next row. Press Alt + Enter to enter a new l

Microsoft Excel-office MS EXCEL BASIC Tips and Tricks-3

  BackStage View in Excel 2010 The  Backstage view  has been introduced in Excel 2010 and acts as the central place for managing your sheets. The backstage view helps in creating new sheets, saving and opening sheets, printing and sharing sheets, and so on. Getting to the Backstage View is easy. Just click the  File tab  located in the upper-left corner of the Excel Ribbon. If you already do not have any opened sheet then you will see a window listing down all the recently opened sheets as follows − If you already have an opened sheet then it will display a window showing the details about the opened sheet as shown below. Backstage view shows three columns when you select most of the available options in the first column. First column of the backstage view will have the following options − S.No. Option & Description 1 Save If an existing sheet is opened, it would be saved as is, otherwise it will display a dialogue box asking for the sheet name. 2 Save As A dialogue box will be dis