INTRA-INSTITUTIONAL INTERNSHIP TRAINING
Report on 3 weeks intra institutional intership program:-
Microsoft Word
Microsoft word is a word processor software developed by Microsoft in 1983. It is the most commonly used word processor software. It is used to create professional quality documents, letters, reports, resumes, etc and also allows you to edit or modify your new or existing document. The file saved in Ms Word has .docx extension. It is a component of the Microsoft Office suite, but you can buy it separately and is available for both Windows and macOS. The latest version of Ms Word is 2019. In this article we will learn the features of Ms Word Word
How to open MS Word?
The following step shows how to open MS words:
Step 1: Type Ms Word in the search bar.
Step 2: Select Ms Word application.
Step 3: Select a blank document and press create button.
Then you will get a window like in the image below where you can write your content and perform different types of operations on that content, like font type, style, bold, italic, etc. You can also add images, tables, charts to your document.
Features of MS Word
Now let us discuss the features or components of the Ms Word. Using these features, you can perform different types of operations on your documents, like you can create, delete, style, modify, or view the content of your document.
1. File
It contains options related to the file, like New(used to create a new document), Open(used to open an existing document), Save(used to save document), Save As(used to save documents), History, Print, Share, Export, Info, etc.
2. Home
It is the default tab of Ms Word and it is generally divided into five groups, i.e., Clipboard, Font, Paragraph, Style and Editing. It allows you to select the color, font, emphasis, bullets, position of your text. It also contains options like cut, copy, and paste. After selecting the home tab you will get below options:
3. Insert
It is the second tab present on the menu bar or ribbon. It contains various items that you may want to insert into a Microsoft word. It includes options like tables, word art, hyperlinks, symbols, charts, signature line, date and time, shapes, header, footer, text boxes, links, boxes, equations, etc., as shown in the below image:
4. Draw
It is the third tab present in the menu bar or ribbon. It is used for freehand drawing in Ms Word. It provides different types of pens for drawing as shown below:
5.Design
It is the fourth tab present in the menu bar or ribbon. The design tab contains document designs that you can select, such as documents with centered titles, offset headings, left-justified text, page borders, watermarks, page color, etc., as shown in the below image:
6. Layout
It is the fifth tab present on the menu bar or ribbon. It holds all the options that allow you to arrange your Microsoft Word document pages just the way you want them. It includes options like set margins, display line numbers, set paragraph indentation, and lines apply themes, control page orientation and size, line breaks, etc., as shown in the below image:
7. References
It is the sixth tab present in the menu bar or ribbon. The references tab lets you add references to a document, then create a bibliography at the end of the text. The references are generally stored in a master list, which is used to add references to further documents. It includes options like, Table of Contents, Footnotes, Citations & Bibliography, Captions, Index, Table of Authorities, smart look, etc. After selecting References tab, you will get the below options:
8. Mailings
It is the seventh tab present in the menu bar or ribbon. It is a least used tab in the menu bar. This tab is where you would create labels, print them on envelopes, do mail merge, etc. After selecting mailing, you will get the below options:
9. Review
It is the eighth tab present in the menu bar or ribbon. The review tab contains, commenting, language, translation, spell check, word count tools. It is good for quickly locating and editing comments. After selecting a review tab, you will get the options below:
10. View
It is the ninth tab present in the menu bar or ribbon. View tab allows you to switch between single page or double page and also allows you to control the layout tools It includes print layout, outline, web layout, task pane, toolbars, ruler, header and footer, footnotes, full-screen view, zoom, etc. as shown in the below image:
Article Tags :Class 6School LearningSchool Programming
Recommended Articles
1. How to Insert SmartArt in Microsoft Word?
2. Change Text Case in Microsoft Word
3. Change Font Color in Microsoft Word
4. Save a Document in Microsoft Word
5. How to Close a Document in Microsoft Word?
6. Change Text Font in Microsoft Word
7. How to Insert Page Breaks in Microsoft Word?
8. Add Columns in Microsoft Word
9. Delete Text in Microsoft Word
10. Moving Text in Microsoft Word
11. How to Add a Page Border in Microsoft Word?
12. How to Password Protect a Microsoft Word Document?
13. How to Insert a Picture in Microsoft Word Document?
How to Add a Watermark in Microsoft Word?
16. How to Insert Symbols and Special Characters in Microsoft Word?
17. How to Double Underline a Text in Microsoft Word?
18. Introduction to Microsoft PowerPoint
19. Change Page Orientation in MS Word
20. Check if a word is present in a sentence
21. Working with Envelopes and Labels in MS Word
22. Print last character of each word in a string
23. Print the first and last character of each word in a String
24. Python program for word guessing game
25. Program to find the Encrypted word
GEEKSFORGEEKS
Introduction to MS-Excel
.svg.png)
MS-EXCEL is a part of Microsoft Office suite software. It is an electronic spreadsheet with numerous rows and columns, used for organizing data, graphically represent data(s), and performing different calculations. It consists of 1048576 rows and 16384 columns, a row and column together make a cell. Each cell has an address defined by column name and row number example A1, D2, etc. this is also known as a cell reference.
Cell references: The address or name of a cell or a range of cells is known as Cell reference. It helps the software to identify the cell from where the data/value is to be used in the formula. We can reference the cell of other worksheets and also of other programs.
Referencing the cell of other worksheets is known as External referencing.
Referencing the cell of other programs is known as Remote referencing.
There are three types of cell references in Excel:
Relative reference.
Absolute reference.
Mixed reference.
The Ribbon in MS-Excel is the topmost row of tabs that provide the user with different facilities/functionalities. These tabs are:
Home Tab: It provides the basic facilities like changing the font, size of text, editing the cells in the spreadsheet, autosum, etc.
Insert Tab: It provides the facilities like inserting tables, pivot tables, images, clip art, charts, links, etc.
Page layout: It provides all the facilities related to the spreadsheet-like margins, orientation, height, width, background etc. The worksheet appearance will be the same in the hard copy as well.
Formulas: It is a package of different in-built formulas/functions which can be used by user just by selecting the cell or range of cells for values.
Data: The Data Tab helps to perform different operations on a vast set of data like analysis through what-if analysis tools and many other data analysis tools, removing duplicate data, transpose the row and column, etc. It also helps to access data(s) from different sources as well, such as from Ms-Access, from web, etc.
Review: This tab provides the facility of thesaurus, checking spellings, translating the text, and helps to protect and share the worksheet and workbook.
View: It contains the commands to manage the view of the workbook, show/hide ruler, gridlines, etc, freezing panes, and adding macros.
Creating a new spreadsheet:
In Excel 3 sheets are already opened by default, now to add a new sheet
In the lowermost pane in Excel, you can find a button.
Click on that button to add a new sheet.
We can also achieve the same by Right-clicking on the sheet number before which you want to insert the sheet.
Select Worksheet.
Opening previous spreadsheet:
On the lowermost pane in Excel, you can find the name of the current sheet you have opened.
On the left side of this sheet, the name of previous sheets are also available like Sheet 2, Sheet 3 will be available at the left of sheet4, click on the number/name of the sheet you want to open and the sheet will open in the same workbook.
For example, we are on Sheet 4, and we want to open Sheet 2 then simply just click on Sheet2 to open it.
Managing the spreadsheets:
You can easily manage the spreadsheets in Excel simply by :
Simply navigating between the sheets.
Right-clicking on the sheet name or number on the pane.
Choose among the various options available like, move, copy, rename, add, delete etc.
You can move/copy your sheet to other workbooks as well just by selecting the workbook in the To workbook and the sheet before you want to insert the sheet in Before sheet.
To save the workbook:
Click on the Office Button or the File tab.
Click on Save As option.
Write the desired name of your file.
Click OK.
To share your workbook:
Click on the Review tab on the Ribbon.
Click on the share workbook (under Changes group).
If you want to protect your workbook and then make it available for another user then click on Protect and Share Workbook option.
Now check the option “Allow changes by more than one user at the same time. This also allows workbook merging” in the Share Workbook dialog box.
Many other options are also available in the Advanced like track, update changes.
Click OK.
Ms-Excel shortcuts:
Ctrl+N: To open a new workbook.
Ctrl+O: To open a saved workbook.
Ctrl+S: To save a workbook.
Ctrl+O: To open a saved workbook.
Ctrl+S: To save a workbook.
Ctrl+C: To copy the selected cells.
Ctrl+V: To paste the copied cells.
Ctrl+X: To cut the selected cells.
Ctrl+W: To close the workbook.
Delete: To remove all the contents from the cell.
Ctrl+P: To print the workbook.
Ctrl+Z: To undo.
Article Tags :Excel
Recommended Articles
1. Editing Excel Macros in Excel
2. Scenario Manager in Excel
3. Excel VBA | count() functions
4. How to Sum Diagonal Cells in a range in Excel?
5. Matrix Visualization in Excel Power View
6. How to Find Duplicates in Excel
7. How to Group Adjacent Columns or Rows Separately or Independently in Excel?
8. Advanced Excel - Chart Design
9. How to Use for Each Loop in Excel VBA?
10. How to Hide ZeroSome rights reser
Start of main content
1 Improve fundamentals
Irrespective of the programming language, it is essential to make sure you understand the programming fundamentals.
When I say programming fundamentals, I am talking about basics like if statement, if-else, for loop, while loop, do-while loop, switch statement, and so on.
Understanding the basics will help you write the building blocks of the program.
#2 Join Coding Community
This is another important thing that many aspiring coders choose to ignore. The logic here is very simple.
If you want to become a great coder, you will have to be surrounded by like-minded people. Doing this will make sure you get the right feedback from the community. You will also learn and understand the thought process of the coders in your community.
There are many online coding forums on Reddit and Facebook where people share their code and ask for feedback. Join a few of them, be active for a few weeks, and see the difference.
#3 Analyze the code written by someone else
You will learn a lot about programming logic if you spend some time analyzing the code written by someone else. This point is related to the previous one.
Spend some time analyzing someone else’s code. By doing this, you will understand how others are thinking and building the programming logic. While analyzing, ask yourself why they are writing the code this way. The answer to your question will lead you one step ahead of others.
Try it out, and you will thank me later
#4 Solve Puzzles
Top 11 Pros and Cons of Being a Lawyer
12 Common Types of Human Resources Jobs
How To Become an Online Professor in 5 Steps
12 Types of Medical Office Jobs (With Salaries)
20 Types of Real Estate Jobs (With Salaries and Job Duties
If you want to learn how to create a flowchart, let me know in the comments below.
#7 Practice
Follow all the above steps and practice to build your programming logic. Solve as many programming problems as possible every day. If you do not practice, it will be impossible to improve your programming logic.
Practicing daily will help you understand your shortcomings and improve on them. Hence, it is very important to practice daily to improve
#8 Patience
Patience is the key here. Based on my programming experience, I can tell you that it is not difficult to build programming logic.
When I first started, I was clueless for the initial 3-4 months. I could not understand even the basics of programming.
Comments
Post a Comment