Skip to main content

Posts

Showing posts from May, 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

Microsoft PowerPoint MS POWERPOINT BASICS Tips and Tricks-3

Backstage View in Powerpoint 2010 In Office 2010, Microsoft replaced the traditional file menu with the new  Backstage  view. This view not only offers all the menu items under the file menu, but additional details which makes management of your files a lot easier. Accessing Backstage view You can access the Backstage view simply by clicking on the File tab. You can exit this view by clicking on any tab (including the File tab again). You can also press 'Esc' button on the keyboard. Organisation of Backstage view The backstage view has three sections or panes. First Pane:  This is the commands pane which consists of all the commands you would typically find in the file menu of older versions. You also have  Options  menu which lets you edit the options on the program like customising the ribbon. Various commands under the first pane are described in the table below Command Description Save Allows you to save a new file or an existing file in standard format. If you are working

Microsoft PowerPoint MS POWERPOINT BASICS Tips and Tricks-2

Explore Windows in Powerpoint 2010 The screenshot below shows the various regions in a standard PowerPoint file. It is important to familiarise with these regions as it makes learning and using PowerPoint easier. File Tab This tab opens the  Backstage  view which basically allows you to manage the file and settings in PowerPoint. You can save presentations, open existing ones and create new presentations based on blank or predefined templates. There are other file related operations that can be executed from this view too. Ribbon The ribbon contains three components: Tabs:  They appear across the top of the Ribbon and contain groups of related commands. Home, Insert, Page Layout are example of ribbon tabs. Groups:  They organize related commands; each group name appears below the group on the Ribbon. For example group of commands related to fonts or or group of commands related to alignment etc. Commands:  Commands appear within each group as mentioned above. Title Bar This is the top

Microsoft PowerPoint MS POWERPOINT BASICS Tips and Tricks-1

Getting Started with Powerpoint 2010 This chapter will teach you how to start PowerPoint 2010 application in simple steps. To access PowerPoint 2010, you must have Microsoft Office 2010 installed in your PC. Only Office 2010 Home and Student, Home and Business, Standard, Professional and Professional Plus packages have PowerPoint included in them. Other packages may have a viewer, but you cannot create presentations with them. Step (1):  Click  Start  button. Step (2):  Click  All Programs  option from the menu. Step (3):  Search for  Microsoft Office  from the sub menu and click it. Step (4):  Search for  Microsoft PowerPoint 2010  from the submenu and click it. This will launch Microsoft PowerPoint 2010 application and you will see the following presentation window. The beginner to advance and start up step-1 Thank you all very much

Microsoft Excel-office ADVANCED OPERATIONS Tips and Tricks-19

Keyboard Shortcuts in Excel 2010 MS Excel Keyboard Short-cuts MS Excel offers many keyboard short-cuts. If you are familiar with windows operating system, you should be aware of most of them. Below is the list of all the major shortcut keys in Microsoft Excel. Ctrl + A  − Selects all contents of the worksheet. Ctrl + B  − Bold highlighted selection. Ctrl + I  − Italicizes the highlighted selection. Ctrl + K  − Inserts link. Ctrl + U  − Underlines the highlighted selection. Ctrl + 1  − Changes the format of selected cells. Ctrl + 5  − Strikethrough the highlighted selection. Ctrl + P  − Brings up the print dialog box to begin printing. Ctrl + Z  − Undo last action. Ctrl + F3  − Opens Excel Name Manager. Ctrl + F9  − Minimizes the current window. Ctrl + F10  − Maximize currently selected window. Ctrl + F6  − Switches between open workbooks or windows. Ctrl + Page up  − Moves between Excel work sheets in the same Excel document. Ctrl + Page down  − Moves between Excel work sheets in the s

Microsoft Excel-office ADVANCED OPERATIONS Tips and Tricks-18

Pivot Charts Excel 2010 Pivot Charts A pivot chart is a graphical representation of a data summary, displayed in a pivot table. A pivot chart is always based on a pivot table. Although Excel lets you create a pivot table and a pivot chart at the same time, you can’t create a pivot chart without a pivot table. All Excel charting features are available in a pivot chart. Pivot charts are available under  Insert tab » PivotTable dropdown » PivotChart . Pivot Chart Example Now, let us see Pivot table with the help of an example. Suppose you have huge data of voters and you want to see the summarized view of the data of voter Information per party in the form of charts, then you can use the Pivot chart for it. Choose  Insert tab » Pivot Chart  to insert the pivot table. MS Excel selects the data of the table. You can select the pivot chart location as an existing sheet or a new sheet. Pivot chart depends on automatically created pivot table by the MS Excel. You can generate the pivot chart i

Microsoft Excel-office ADVANCED OPERATIONS Tips and Tricks-17

Simple Charts in Excel 2010 Charts A chart is a visual representation of numeric values. Charts (also known as graphs) have been an integral part of spreadsheets. Charts generated by early spreadsheet products were quite crude, but thy have improved significantly over the years. Excel provides you with the tools to create a wide variety of highly customizable charts. Displaying data in a well-conceived chart can make your numbers more understandable. Because a chart presents a picture, charts are particularly useful for summarizing a series of numbers and their interrelationships. Types of Charts There are various chart types available in MS Excel as shown in the below screen-shot. Column  − Column chart shows data changes over a period of time or illustrates comparisons among items. Bar  − A bar chart illustrates comparisons among individual items. Pie  − A pie chart shows the size of items that make up a data series, proportional to the sum of the items. It always shows only one data

Microsoft Excel-office ADVANCED OPERATIONS Tips and Tricks-16

Pivot Tables in Excel 2010 Pivot Tables A pivot table is essentially a dynamic summary report generated from a database. The database can reside in a worksheet (in the form of a table) or in an external data file. A pivot table can help transform endless rows and columns of numbers into a meaningful presentation of the data. Pivot tables are very powerful tool for summarized analysis of the data. Pivot tables are available under  Insert tab » PivotTable dropdown » PivotTable . Pivot Table Example Now, let us see Pivot table with the help of example. Suppose you have huge data of voters and you want to see the summarized data of voter Information per party, then you can use the Pivot table for it. Choose  Insert tab » Pivot Table  to insert pivot table. MS Excel selects the data of the table. You can select the pivot table location as existing sheet or new sheet. This will generate the Pivot table pane as shown below. You have various options available in the Pivot table pane. You can s

Microsoft Excel-office ADVANCED OPERATIONS Tips and Tricks-15

Data Tables in Excel 2010 Data Tables In Excel, a Data Table is a way to see different results by altering an input cell in your formula. Data tables are available in  Data Tab » What-If analysis dropdown » Data table  in MS Excel. Data Table with Example Now, let us see data table concept with an example. Suppose you have the Price and quantity of many values. Also, you have the discount for that as third variable for calculating the Net Price. You can keep the Net Price value in the organized table format with the help of the data table. Your Price runs horizontally to the right while quantity runs vertically down. We are using a formula to calculate the Net Price as Price multiplied by Quantity minus total discount (Quantity * Discount for each quantity). Now, for creation of data table select the range of data table. Choose  Data Tab » What-If analysis dropdown » Data table . It will give you dialogue asking for Input row and Input Column. Give the Input row as Price cell (In this

Microsoft Excel-office ADVANCED OPERATIONS Tips and Tricks-14

Workbook Security in Excel 2010 Workbook Security We can apply security to the workbook by the concept of protection available in the Review Tab of ribbon. MS Excel's protection-related features fall into three categories. Worksheet protection  − Protecting a worksheet from being modified, or restricting the modifications to certain users. Workbook protection  − Protecting a workbook from having sheets inserted or deleted, and also requiring the use of password to open the workbook. Protect Worksheet You may want to protect a worksheet for a variety of reasons. One reason is to prevent yourself or others from accidentally deleting the formulas or other critical data. A common scenario is to protect a worksheet, so that the data can be changed, but the formulas can’t be changed. To protect a worksheet, choose  Review » Changes group » Protect Sheet . Excel displays the Protect Sheet dialog box. Note that providing a password is optional. If you enter a password, that password will b

Microsoft Excel-office ADVANCED OPERATIONS Tips and Tricks-13

Translate Worksheet in Excel 2010 Translate Worksheet You can translate the text written in a different language, such as phrases or paragraphs, individual words (by using the Mini Translator), or translate your whole file with MS Excel 2010. Translation is available in the review tab of the ribbon in MS Excel 2010. You can quickly translate cell into different language with this option. Performing Translation Step By Step Select the content, which you want to translate to a different language. Choose  review tab » translation . It will open the pane from which you can select the language to which you need to translate. You need to have an internet connection for performing translation. It will translate using the Microsoft Translator. Click on Insert to apply translation changes.   The beginner to advance and start up step-13 Thank you all very much