Directory
Maximizing the use of Microsoft word, Spreadsheets and Publisher
Used to make professional-quality documents, letters, reports, etc., MS Word is a word processor developed by Microsoft. It has advanced features which allow you to format and edit your files and documents in the best possible way.
Microsoft Excel is arguably one of the most popular spreadsheet applications and has long since played a role in businesses.
Microsoft Publisher is a desktop publishing program that allows users to create professional quality publications, according to Microsoft.
What are the uses of MS Word?
In Education: It is considered as one of the simplest tools which can be used by both teachers and students. Creating notes is easier using MS Word as they can be made more interactive by adding shapes and images. It is also convenient to make assignments on MS Word and submitting them online
In Workplace: Submitting letters, bills, creating reports, letterheads, sample documents, can all easily be done using MS Word
Creating & Updating Resume: One of the best tools to create your resumes and is easy to edit and make changes in it as per your experience
For Authors: Since separate options are available for bibliography, table of contents, etc., it is the best tool which can be used by authors for writing books and adjusting it as per the layout and alignment of your choice
Home
This has options like font colour, font size, font style, alignment, bullets, line spacing, etc. All the basic elements which one may need to edit their document is available under the Home option.
Insert
Tables, shapes, images, charts, graphs, header, footer, page number, etc. can all be entered in the document. They are included in the “Insert” category.
Design
The template or the design in which you want your document to be created can be selected under the Design tab. Choosing an appropriate tab will enhance the appearance of your document.
Page Layout
Under the Page Layout tab comes options like margins, orientation, columns, lines, indentation, spacing, etc.
References
This tab is the most useful for those who are creating a thesis or writing books or lengthy documents. Options like citation, footnote, table of contents, caption, bibliography, etc. can be found under this tab.
Review
Spell check, grammar, Thesaurus, word count, language, translation, comments, etc. can all be tracked under the review tab. This acts as an advantage for those who get their documents reviewed on MS Word.
Tips to Maximize the use of Microsoft word
Auto Recovery and Auto Save Departure
Recover Unsaved Documents
Customize Paste Option
Using the clipboard
Maintain Format Consistency with Text Styles
Applying Styles Quickly
Use Table of Contents
Navigation Pane to Move Content Blocks
Insert Screenshot Quickly
Adding Divider
Insert Pull Quotes
Master Keyboard Shortcuts
Note: Refer to the 0:33 to 5:00 to learn more about the Microsoft word
Excel is a spreadsheet program from Microsoft and a component of its Office product group for business applications. Microsoft Excel enables users to format, organize and calculate data in a spreadsheet.
Use of Microsoft Excel in Education
Excel is a great resource for teaching students many important skills, like data visualization, data organization and information restructuring, filtration, quick calculations, data interpretation, and tabulation,
Home
Comprises options like font size, font styles, font colour, background colour, alignment, formatting options and styles, insertion and deletion of cells and editing options
Insert
Comprises options like table format and style, inserting images and figures, adding graphs, charts and sparklines, header and footer option, equation and symbols
Page Layout
Themes, orientation and page setup options are available under the page layout option
Formulas
Since tables with a large amount of data can be created in MS excel, under this feature, you can add formulas to your table and get quicker solutions
Data
Adding external data (from the web), filtering options and data tools are available under this category
Review
Proofreading can be done for an excel sheet (like spell check) in the review category and a reader can add comments in this part
View
Different views in which we want the spreadsheet to be displayed can be edited here. Options to zoom in and out and pane arrangement are available under this category
10 spreadsheet tips and tricks to maximize Google Excel sheets
Freeze rows and columns
Use conditional and alternative formatting
Use add-ons
Use a template
Learn how to use comments and notes
Use Google forms with google sheets
Check the version History
Find and replace
Create Filters
Protected sheets and ranges
Note: Refer to the 5:02 to 8:48 of the video to learn more about the Microsoft excel
Microsoft publisher
The specialty of the publisher is that it has many other pre-published editions available in it. Like Newsletters, Brochure, Invitation Card, Greeting Cards, Mailing Label, Banner, Web Page, etc. all this is there in it. You can prepare all this within few minutes with the help of a wizard available on the Microsoft publisher.
These are the features available with Microsoft publisher:
Technical-level effects for texts, shapes, and images.
Capability to use high-quality image backgrounds.
Mail merge tools.
Personalization tools.
Drag-and-drop picture importing and interchanging.
Detailed ruler and guides for correct measurements.
Document-sharing abilities.
One of the important benefits of using Microsoft Publisher can be measured in time saved. No longer do students get frustrated searching for photos and information. Frequently used content is stored in a searchable library for easy access.
10 tips to use Microsoft publisher flawlessly
Page Sizes
The Nudge Option
Absolute Positioning
Putting Things in the Background
Remember to Print a Hardcopy
Spacing and Alignment
Spelling and Punctuation
Note: Refer to the 8:56 to 12:31 of the video to learn more about the Microsoft publisher
Content Sources:
https://www.geeksforgeeks.org/what-is-microsoft-publisher/
https://byjus.com/govt-exams/ms-excel-basics/
https://youtu.be/XTxzPWzb5P4?si=_aA6Te8FR0UW_HSl
https://www.computerhope.com/jargon/m/microsoft-word.htm
Image sources:
https://i.pinimg.com/474x/ea/df/2b/eadf2b6c5a7bd35174721f7eedc70615.jpg
https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcREDn46013eFffXjvN9v7O5toAggbNV5oU021p5k9xbBA&s
https://vectorseek.com/wp-content/uploads/2022/02/Microsoft-Publisher-Logo-Vector.jpg
https://davescomputertips.com/wp-content/uploads/2019/10/AutoSave-switch.jpg
https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcRc4RtcapLYV-2go9kn-5PP16pyqzHghnLmdjbKnyIrWw&s
https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcSK716_J_9Koqr6bDQR-gPyzPGtzyLHow8mM6M7lXqRbA&s
https://cdn.gtricks.com/2022/02/extensions-menu-1.jpg
https://assets.materialup.com/uploads/714b6e3f-aee3-48bc-87db-b7fd3e2cdf35/attachment.png
https://assets.materialup.com/uploads/714b6e3f-aee3-48bc-87db-b7fd3e2cdf35/attachment.png
https://i.pinimg.com/474x/fa/87/f2/fa87f2add71777a2414b5f6e554883e4.jpg
About the Creators