Skip to main content

Posts

Showing posts from April, 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 ADVANCED OPERATIONS Tips and Tricks-12

Email Workbooks MS Excel 2010 Email Workbook MS Excel allows you to email the workbook very easily. To email the workbook to anyone, follow the below mentioned steps. Choose  File » Save and Send . It basically saves the document first and then the emails. Click on Send using E-mail if your email system is configured. MS Outlook will open with the file as attachment in the New Email Window. You can send mail this workbook to anyone with valid email address. The beginner to advance and start up step-12 Thank you all very much
Post a Comment
Read more

Microsoft Excel-office ADVANCED OPERATIONS Tips and Tricks-11

Printing Worksheets in Excel 2010 Quick Print If you want to print a copy of a worksheet with no layout adjustment, use the Quick Print option. There are two ways in which we can use this option. Choose  File » Print  (which displays the Print pane), and then click the Print button. Press Ctrl+P and then click the Print button (or press Enter). Adjusting Common Page Setup Settings You can adjust the print settings available in the Page setup dialogue in different ways as discussed below. Page setup options include Page orientation, Page Size, Page Margins, etc. The Print screen in Backstage View, displayed when you choose  File » Print . The  Page Layout tab  of the Ribbon. Choosing Your Printer To switch to a different printer, choose  File » Print  and use the drop-down control in the Printer section to select any other installed printer. Specifying What You Want to Print Sometimes you may want to print only a part of the worksheet rather than the en...
Post a Comment
Read more

Microsoft Excel-office ADVANCED OPERATIONS Tips and Tricks-10

Cross Referencing in Excel 2010 Graphic Objects in MS Excel When you have information spread across several different spreadsheets, it can seem a daunting task to bring all these different sets of data together into one meaningful list or table. This is where the Vlookup function comes into its own. VLOOKUP VlookUp searches for a value vertically down for the lookup table. VLOOKUP(lookup_value,table_array,col_index6_num,range_lookup) has 4 parameters as below. lookup_value  − It is the user input. This is the value that the function uses to search on. The table_array  − It is the area of cells in which the table is located. This includes not only the column being searched on, but the data columns for which you are going to get the values that you need. Col_index6_num  − It is the column of data that contains the answer that you want. Range_lookup  − It is a TRUE or FALSE value. When set to TRUE, the lookup function gives the closest match to the lookup_value without ...
Post a Comment
Read more

Microsoft Excel-office ADVANCED OPERATIONS Tips and Tricks-9

Adding Graphics in Excel 2010 Graphic Objects in MS Excel MS Excel supports various types of graphic objects like Shapes gallery, SmartArt, Text Box, and WordArt available on the Insert tab of the Ribbon.Graphics are available in the  Insert Tab . See the screenshots below for various available graphics in MS Excel 2010. Insert Shape Choose Insert Tab » Shapes dropdown. Select the shape you want to insert. Click on shape to insert it. To edit the inserted shape just drag the shape with the mouse. Shape will adjust the shape. Insert Smart Art Choose Insert Tab » SmartArt. Clicking SmartArt will open the SmartArt dialogue as shown below in the screen-shot. Choose from the list of available smartArts. Click on SmartArt to Insert it in the worksheet. Edit the SmartArt as per your need. Insert Clip Art Choose Insert Tab » Clip Art. Clicking Clip Art will open the search box as shown in the below screen-shot. Choose from the list of available Clip Arts. Click on Clip Art to Insert it in ...
Post a Comment
Read more

Microsoft Excel-office ADVANCED OPERATIONS Tips and Tricks-8

Using Macros in Excel 2010 Macros in MS Excel Macros enable you to automate almost any task that you can undertake in Excel 2010. By using macro recorder from  View Tab » Macro Dropdown  to record tasks that you perform routinely, you not only speed up the procedure considerably but you are assured that each step in a task is carried out the same way each and every time you perform a task. To view macros choose  View Tab » Macro dropdown . Macro Options View tab contains a Macros command button to which a dropdown menu containing the following three options. View Macros  − Opens the Macro dialog box where you can select a macro to run or edit. Record Macro  − Opens the Record Macro dialog box where you define the settings for your new macro and then start the macro recorder; this is the same as clicking the Record Macro button on the Status bar. Use Relative References  − Uses relative cell addresses when recording a macro, making the macro more versatile b...
10 comments
Read more

Microsoft Excel-office ADVANCED OPERATIONS Tips and Tricks-7

Using Templates in Excel 2010 Using Templates in MS Excel Template is essentially a model that serves as the basis for something. An Excel template is a workbook that’s used to create other workbooks. Viewing Available Templates To view the Excel templates, choose  File » New  to display the available templates screen in Backstage View. You can select a template stored on your hard drive, or a template from Microsoft Office Online. If you choose a template from Microsoft Office Online, you must be connected to the Internet to download it. The Office Online Templates section contains a number of icons, which represents various categories of templates. Click an icon, and you’ll see the available templates. When you select a template thumbnail, you can see a preview in the right panel. On-line Templates These template data is available online at the Microsoft server. When you select the template and click on it, it will download the template data from Microsoft server and opens i...
Post a Comment
Read more

Microsoft Excel-office ADVANCED OPERATIONS Tips and Tricks-6

Using Themes in Excel 2010 Using Themes in MS Excel To help users create more professional-looking documents, MS Excel has incorporated a concept known as document themes. By using themes, it is easy to specify the colors, fonts, and a variety of graphic effects in a document. And best of all, changing the entire look of your document is a breeze. A few mouse clicks is all it takes to apply a different theme and change the look of your workbook. Applying Themes Choose  Page layout Tab » Themes Dropdown . Note that this display is a live preview, that is, as you move your mouse over the Theme, it temporarily displays the theme effect. When you see a style you like, click it to apply the style to the selection. Creating Custom Theme in MS Excel We can create new custom Theme in Excel 2010. To create a new style, follow these steps − Click on the  save current theme option  under Theme in Page Layout Tab. This will save the current theme to office folder. You can browse the ...
Post a Comment
Read more

Microsoft Excel-office ADVANCED OPERATIONS Tips and Tricks-5

Using Styles in Excel 2010 Using Styles in MS Excel With MS Excel 2010  Named styles  make it very easy to apply a set of predefined formatting options to a cell or range. It saves time as well as make sure that look of the cells are consistent. A Style can consist of settings for up to six different attributes − Number format Font (type, size, and color) Alignment (vertical and horizontal) Borders Pattern Protection (locked and hidden) Now, let us see how styles are helpful. Suppose that you apply a particular style to some twenty cells scattered throughout your worksheet. Later, you realize that these cells should have a font size of 12 pt. rather than 14 pt. Rather than changing each cell, simply edit the style. All cells with that particular style change automatically. Applying Styles Choose  Home » Styles » Cell Styles . Note that this display is a live preview, that is, as you move your mouse over the style choices, the selected cell or range temporarily displays th...
Post a Comment
Read more

Microsoft Excel-office ADVANCED OPERATIONS Tips and Tricks-4

Data Validation in Excel 2010 Data Validation MS Excel data validation feature allows you to set up certain rules that dictate what can be entered into a cell. For example, you may want to limit data entry in a particular cell to whole numbers between 0 and 10. If the user makes an invalid entry, you can display a custom message as shown below. Validation Criteria To specify the type of data allowable in a cell or range, follow the steps below, which shows all the three tabs of the Data Validation dialog box. Select the cell or range. Choose Data » Data Tools » Data Validation. Excel displays its Data Validation dialog box having 3 tabs settings, Input Message and Error alert. Settings Tab Here you can set the type of validation you need. Choose an option from the Allow drop-down list. The contents of the Data Validation dialog box will change, displaying controls based on your choice. Any Value  − Selecting this option removes any existing data validation. Whole Number  − The...
Post a Comment
Read more

Microsoft Excel-office ADVANCED OPERATIONS Tips and Tricks-3

Using Ranges in Excel 2010 Ranges in MS Excel A cell is a single element in a worksheet that can hold a value, some text, or a formula. A cell is identified by its address, which consists of its column letter and row number. For example, cell B1 is the cell in the second column and the first row. A group of cells is called a range. You designate a range address by specifying its upper-left cell address and its lower-right cell address, separated by a colon. Example of Ranges − C24  − A range that consists of a single cell. A1:B1  − Two cells that occupy one row and two columns. A1:A100  − 100 cells in column A. A1:D4  − 16 cells (four rows by four columns). Selecting Ranges You can select a range in several ways − Press the left mouse button and drag, highlighting the range. Then release the mouse button. If you drag to the end of the screen, the worksheet will scroll. Press the Shift key while you use the navigation keys to select a range. Press F8 and then move the...
2 comments
Read more