Download Digital Productivity: An Overview and more Lecture notes Engineering in PDF only on Docsity! Digital Productivity: An Overview This course helps learners to enhance skills in using the three most important Microsoft Office Tools - MS Word, MS Excel, and MS PowerPoint. MS Word: You can create and save a word document in MS word and MS Word easy way to edit and make changes in your documents. Use the components of ribbon in word document. MS Word allows you to create professional quality documents, reports, letters, and resumes Microsoft Word has features including spell check, grammar, image support, advanced page layout, etc. The word interface consists of the following main elements like: The Title bar, Quick Access Toolbar, Ribbon Ruler, Status Bar You can edit involves making changes to the text by adding/inserting, deleting and rearranging words, sentences or paragraphs in an existing document. In MS word you can edit a word document (cut, copy, paste, delete, find and replace text in a word document). You can easily format your document with help of these tools 1. Create text in a word document 2. Create a list (bulleted and numbered) 3. Apply line spacing 4. Add border to the document 5. Set orientation and margins of the document MS Excel: Microsoft Excel or MS Excel is a commonly used Microsoft office application, Excel stores data in tablets, it has several rows and columns. It is a spread sheet program which is used to save and analyze numerical data, a spreadsheet is a software application that enables a user to save, sort and manage data in an arranged form of rows and columns. A file in Excel is called a “Workbook”, and each workbook can contain several ‘Sheets’, A sheet is a table with rows are numbered and whose columns are labeled with letters from A to Z….and so on. We can save a large amount of information in a spreadsheet, the data saved in excel can be made secured using the password. You can use Headers and Footers are inserted in a spreadsheet to display repetitive information at the top and bottom margins of each page. You can either use the standard headers and footers in an Excel spreadsheet or create custom headers and footers. You can print your document on the worksheet, click and drag to select the cells you want to print. To print only the selected area, in Print Options, select Current Selection. If the print preview shows what you want printed, select Print. There are following tabs on the ribbon of MS Excel: Home, Insert, Page Layout, Formulas, Data, Review, View etc. Microsoft Excel seems the best option to record, store, and analyze any such data from small to large. You can prepare charts in Excel using data like: 1. Pie chart 2. Line chart 3. Scatter chart 4. Bar chart 5. Column chart 6. Area chart Chart help you visualize your data in a way that creates maximum impact on your audience, chart enable you to present information in a graphical format that is easy to comprehend, they help you to understand the trends for information and analysis. Chart in Excel are linked to a data series and are automatically updated whenever the data is modified. Formulas and Function in Excel: A formula is an expression which calculates the value of a cell, it operates on values in a range of cell and these formulas return a result, even when it is an error. Excel formulas enables you to perform calculations such as addition, subtraction, multiplication, and division. One such feature that allows Excel to stand out is Excel function and formulas. These formulas and functions enable you to perform calculations and data analysis faster. Formula are self-defined instruction for performing calculation, Functions are predefined formulas and are already available in Excel.
