Mastering MS Office

Bittu Kumar

Description

Learn the simplest ways to get things done with Microsoft Office 20101. Learn faster and easier2. Contains all relevant information with visuals3. Step-by step approach with screen shots4. Written in plain EnglishComplete guide to learn in a methodical manner how to first install Microsoft Office 2010 on your system, the author Bittu Kumar describes in Step-by-Step way and explains important commands and important features of MS Office 2010, Visual Approach to Learning MS Office 2010 Package, MS Word 2010, MS Excel 2010, DTP using MS Word, MS Publisher, MS Access 2010, MS PowerPoint 2010, MS Outlook 2010, besides keyboard short cuts, creation of contacts, calendar item or task etc

Sujets

• Informatique
• Computer science

Informations

• Publié par: V & S Publishers
• Date de parution: 09 janvier 2017
• Nombre de lectures: 1
• EAN13: 9789350578780
• Langue: English
• Poids de l'ouvrage: 1 Mo

Extrait

Mastering Ms Office • Installing Ms Office 2010 • Indtroduction to Ms Office Programs • DTP Using Ms Word • Microsoft Power Point 2010
by Bittu Kumar
Published by:

F-2/16, Ansari Road, Daryaganj, New Delhi-110002
☎ 011-23240026, 011-23240027 • Fax: [phone]
Email: [e-mail] • Website: www.vspublishers.com
Branch : Hyderabad
5-1-707/1, Brij Bhawan (Beside Central Bank of India Lane)
Bank Street, Koti, Hyderabad - 500 095
☎ 040-24737290
E-mail: [e-mail]
Branch Office : Mumbai
Jaywant Industrial Estate, 2nd Floor–222, Tardeo Road
Opposite Sobo Central Mall, Mumbai – 400 034
☎ 022-23510736
E-mail: [e-mail]
Follow us on:
All books available at www.vspublishers.com
© Copyright:
Edition 2017 The Copyright of this book, as well as all matter contained herein (including illustrations) rests with the Publishers. No person shall copy the name of the book, its title design, matter and illustrations in any form and in any language, totally or partially or in any distorted form. Anybody doing so shall face legal action and will be responsible for damages.
Publisher's Note

Microsoft Word is easily the biggest, most popular word processing program available, but it does a lot more than just edit text. If you’ve been telling yourself that you’ll finally learn Word’s ins and outs, now’s the time to actually learn how to edit styles, add a table of contents, and more.
V&S Publishers has done just that for you to through this book Mastering MS Office authored by Bittu Kumar, an expert on all matters connected with Computers. Microsoft Outlook is the de facto email and calendaring client in most offices—and it can help manage your tasks and notes as well. Beyond just clicking Send and Receive, there are lots of things you can do to improve your Outlook workflow, such as sharing your calendar, auto-filtering emails, and more.
Spreadsheets are a nerd’s data-driven dream. For most regular people, though, they’re a complicated mess. Fortunately, they don’t need to be.
Spreadsheets are a nerd’s data-driven dream. For most regular people, though, they’re a complicated mess. Fortunately, they don’t need to be. This book shows you how to bend data to your will with Microsoft Excel. And so on with other MS programs included in this book.
Bittu Kumar is taking you through the world of MS Office 2010 programs in simple and straight forward way – and helping you master it.
Contents Chapter 1 - Installing MS Office 2010 Chapter 2 - Introduction to MS Office Programs Starting an Office Program User Interface in Microsoft Office The GUI The Ribbon and its tabs The Description of a tab Keyboard Shortcuts Saving Your Files To save a file: The Save As and Open Dialog Boxes Opening a file File Properties Removing Password Formatting Text Moving and Copying text Deleting text Changing the Look of Text Finding and Replacing Text Creating Hyperlinks Chapter 3 - Get more from MS Office Undoing and Repeating Commands Zooming Viewing a File through more than One Window Opening Auto Correct dialog box Tables Creating a Table Merging and Splitting Cells Charts Anatomy of Charts The Basics: Creating a Chart Inserting a picture Annotating a chart SmartArt Creating a diagram Creating a diagram Changing Size and Position of a diagram Adding shapes to diagrams apart from hierarchy diagrams Adding an Organization Chart shape Entering text on a diagram shape Entering bulleted lists on diagram shapes Changing a Diagram’s direction Changing the size of a diagram shape The Basics: Drawing Lines, Arrows, and Shapes Handling Lines, Arrows, and Connectors Changing the length and position of a line or arrow Changing the appearance of a line, arrow, or connector Making the connection Handling Rectangles, Ovals, Stars, and Other Shapes Drawing a shape Changing a shape’s size and shape Choosing a different shape Changing a shape’s symmetry WordArt for Bending, Spindling, and Mutilating Text Creating a WordArt image Editing a WordArt image Chapter 4 - Welcome to MS Word 2010 Introducing the Word Screen Creating a New Document Get a Better Look at Your Documents Changing views Print Layout view Full Screen Reading view Web Layout view. Outline view Draft view Splitting the screen Moving in Documents Keys for Navigation Navigating from page to page or heading to heading Using ‘Go To’ command Bookmarks Inserting a Whole File into a Document Creating a computerized form Creating a template to hold the form Creating the form and data-entry controls Entering Information Quickly in a Computerized Form Entering data in the form Entering Information Quickly in a Computerized Form Composing Text and Pages Format text and pages Paragraphs and Formatting Starting a New Page Setting Up and Changing the Margins Indenting Paragraphs and First Lines Numbering the Pages Indenting in Paragraph dialog box Numbering with page numbers only Including a page number in header or footer Changing page number formats Putting Headers and Footers on Pages Creating, editing, and removing headers and footers Fine-tuning a header or footer Adjusting Space between Lines Creating Numbered and Bulleted Lists Simple numbered and bulleted lists Chapter 5 - DTP using MS Word Making Use of Charts, Diagrams, Shapes, Clip Art, and Photos Positioning and Wrapping Objects Relative to the Page Text Wrapping text around an object Positioning an object on a page Working with Text Boxes Inserting a text box Making text flow from text box to text box Decorating a page with a border Putting a background colour on pages Dropping in a Drop Cap Watermark Landscape Documents Printing on different sizes of paper Chapter 6 - Welcome to Microsoft PowerPoint 2010 Creating PowerPoint Presentation Creating a New Presentation Creating New Slides for Your Presentation Selecting, Moving, and Deleting Slides Selecting slides Moving slides Deleting slides Let’s Start PowerPoint Choosing a Theme for Your Presentation Selecting a theme Tweaking a theme Creating Slide Backgrounds on Your Own Using a solid (or transparent) colour for the slide background Follow these steps to create a gradient background for slides: Creating Slide Backgrounds on Your Own Placing a clip-art image in the slide background Follow these steps to use a picture as a slide background: Using a texture for a slide background Text & Powerpoint Entering Text Positioning Text in Frames and Text Boxes Transition & Animations Tools for tweaking a transition: Altering and removing slide transitions Animating parts of a slide Audio Part of Your Presentation Inserting an audio file on a slide Playing audio during a presentation Inserting a video on a slide Showing Your Presentation Going from slide to slide Wielding a pen or highlighter in a presentation Packaging a presentation on a CD Creating a presentation video Chapter 7 - Welcome to MS Excel Creating a New Excel Workbook Rows, columns, and cell addresses Workbooks and worksheets Entering Data in a Worksheet Procedure Entering date values Entering Lists and Serial Data with the AutoFill Command Formatting Numbers, Dates, and Time Values Conditional Formats Dealing with Your Worksheet Editing Worksheet Data Moving in a Worksheet Keyboard Shortcuts for Worksheets Giving the Split or Freeze Panes command Unsplitting and unfreezing Hiding columns and rows Comments for Your Worksheet Hiding a worksheet Protecting a worksheet Formulas and Functions Referring to cells in formulas Operators Table Creating a cell range name Entering a range name as part of a formula Managing cell range names Common Formula Error Messages Common Functions and Their Use Entering a function in a formula Excel’s help in entering a function as part of a formula: Chapter 8 - Welcome to Publisher Creating a Publication Setting up your pages A Screen Shot of a Template Entering Text on the Pages Making Text Fit in Text Frames Fitting overflow text in a single frame Making Text Fit in Text Frames Making text flow from frame to frame Formatting Text Wrapping Text Inserting, Removing, and Moving Pages Chapter 9 - MS Outlook What is Microsoft Outlook? Add an e-mail account Create a new e-mail message Forward or reply to an e-mail message Add an attachment to an e-mail message Open or save an e-mail message attachment Open an attachment Save an attachment Add an e-mail signature to messages Create a signature Add a signature Create a calendar appointment Schedule a meeting with other people Set a reminder For appointments or meetings For e-mail messages, contacts, and tasks Create a contact Create a task Create a note Print an e-mail message, contact, calendar item, or task
Chapter 1
Installing MS Office 2010
The Most important thing is installing the Microsoft Office on your Systems first. You can do it by purchasing a genuine copy of Microsoft Office from nearest software outlet, or simply download it from the Microsoft’s official website. Here we are discussing setup instructions for Microsoft Office Professional Plus 2010.
After buying CD/Downloading files, follow these Instructions:
❐ Go to the File directory where the Microsoft office setup is.

❐ Now click on Setup.exe and click on yes (In the case you are using Windows 7 or Vista).
❐ After sometime, the following dialog box will appear on your computer, Click “Install Now”.
❐ The following box will appear on clicking “Install Now”, wait for a few minutes and let Microsoft office 2011 be installed on your system.
❐ Then Click “Close” and Cheers; you are done!

Now you have successfully Installed Microsoft office 2010 on your Computer. Now we shall begin Microsoft Office 2010 Basic Course.


Points to Remember

" Always use genuine software from Microsoft. Pirated software may contain Viruses & other Malwares.
" Your Serial-Key is personal to you; don’t share it with anyone before installing and activating the Product.
" Never download the Microsoft Product from any other website other than Mi