Module 2 - Introduction to MS Office

["","","To move the chart to a different worksheet: \u2022 Select the Design tab. \u2022 Click the Move Chart command. A dialog box appears. The current location of the chart is selected. \u2022 Select the desired location for the chart (choose an existing worksheet, or select New Sheet and name it). \u2022 Click OK. The chart will appear in the new location. Keeping charts up to date \u2022 By default, when you add more data to your spreadsheet, the chart may not include the new data. To fix this, you can adjust the data range. Simply click the chart, and it will highlight the data range in your spreadsheet. You can then click and drag the handle in the lower-right corner to change the data range. If you frequently add more data to your spreadsheet, it may become tedious to update the data range. Luckily, there is an easier way. Simply format your source data as a table, then create a chart based on that table. When you add more data below the table, it will automatically be included in both the table and the chart, keeping everything consistent and up to date.","","Basic features of Microsoft PowerPoint \u2022 PowerPoint is a presentation graphics package. \u2022 It can be used to attractively support talks and lectures, by projection from a PC or by preparing transparencies for OHPs (by printing from PowerPoint and transferring the pages to acetate). \u2022 It can also be used for unattended 'rolling demonstrations' on a computer screen (eg in a Foyer area or at an exhibition). \u2022 PowerPoint can also be used to prepare speaker's notes and handouts. \u2022 In this section you will see an example PowerPoint presentation. \u2022 You will then have a chance to experiment briefly with changing parts of the presentation.","To start PowerPoint: \u2022 Click the Start button. \u2022 Point at Programs and, from the Programs panel, click on Microsoft PowerPoint. \u2022 In PowerPoint's opening dialog box, click on Open an Existing Presentation and then click OK. The Open dialog box appears. The example document for this practical work is in a file called city talk. In Computer Centre Training Rooms this file is in the folder C:\/User\/Office and to open the document from there: \u2022 In the Folder List box, double-click the Office folder. The file city talk should now be visible in the Folder List box. \u2022 Click on the file city talk. \u2022 Click on Open. The first slide of the presentation is displayed.","Selecting the PowerPoint view \u2022 PowerPoint starts in Slide View, which is the view to use when editing a presentation. Other views are for giving a presentation, arranging slides, preparing an outline and preparing notes. The view can be selected from the View menu. Alternatively use the View Toolbar (at the bottom left of the screen). If using the Toolbar remember that ScreenTips can be used to identify buttons. Slide Show View \u2022 Select Slide Show view. \u2022 Click the left mouse button to advance the slide show and the right mouse button to go back. During the show notice the various transitions (special effects as a new slide appears) and builds (the way that bullet points on a slide can be made to appear one-at-a-time). When the slide show has finished you are returned to Slide view (Note: In Slide Show view, the Esc key can be used to abandon the show at any point).","Slide Sorter View Slide Sorter View can be used, for example, to change the order of presentation of slides and the special effects. \u2022 From the View Menu (or View Toolbar) choose Slide Sorter view. \u2022 The Slide Sorter Toolbar shows the transition and build of the highlighted slide. \u2022 Click on any slide and experiment with its transition. A list of transitions is obtained by clicking the arrow to the right of the Transition box. The Transition button (to the left of the transition box) allows you to vary, eg the speed of the transition. \u2022 Similarly with the Build box and Build button you can change the slides build effects. Notice that there is a slide that you did not see during the slide show (slide number 5). The Hide button to the right of the Build box allows you to 'hide' slides (this is useful if you want to give a slightly different presentation to different audiences). \u2022 Click on the hidden slide and click on the Hide button to restore it to the slide show. \u2022 To re-arrange the presentation: \u2022 Drag a slide to a different position in the slide sorter. Experiment with this. \u2022 A slide can be deleted by clicking on it and then pressing the Del key. \u2022 To view a slide in detail: \u2022 Double-clicking on the slide.","Slide View Slide View is used to create or edit slides. As a brief illustration on How to format and align text and images on a slide and how to create and style a slide and a slide show from scratch is shown: \u2022 Click anywhere on the text of a slide to edit the text at that point. \u2022 Click on a graphic (picture) and notice that handles appear around the picture; these can be used to alter the size of the graphic (by dragging a handle). Note: Holding down the Ctrl key while dragging a sizing handle preserves the correct horizontal and vertical proportions of the graphic. \u2022 A graphic can be moved to a different location by clicking anywhere within it and dragging. Slide Master View The Slide Master controls the overall appearance of every slide (unless for an individual slide the master is deliberately not applied). To see the components of each slide that come from the Slide Master: \u2022 From the View menu, choose Master and then Slide Master.","Notes Pages View You can use PowerPoint to produce and print notes to accompany your talk. To see the notes: \u2022 From the View menu (or View Toolbar), choose Notes Pages. \u2022 Scroll through the presentation to see the notes. Outline view You may find outlining useful in when preparing a talk. Outline view condenses the text content of the slides to make it easier to follow and change the content of the presentation. \u2022 From the View menu (or View Toolbar), choose Outline. \u2022 Click in any part of the text to edit it at that point.","Spell checking and printing from PowerPoint PowerPoint has a spelling checker but does not have a Print Preview. To save paper please do not print the entire slideshow during the following exercise (if you would like to see an example handout, please print 6 slides per page to save paper). \u2022 From the File menu, choose Print. \u2022 For a list of print options click on the arrow to the right of the Print What box. Slides Prints as Slide Show view \u2013 one complete slide per page, full-size. (without Builds) These can be photocopied onto acetate for OHPs. Slides (with Builds) Prints one page for each build on the slide (Note: can be very wasteful of Notes Pages paper). Handouts Prints as Notes Pages view - a reduced-size slide with any speaker's notes below, one slide per page. Outline Prints reduced-size slides for audience handouts (select the required number of slides per page). Prints the condensed text content of the slides. \u2022 From the File menu, choose Exit. You need not save any changes you have made","Basic features of Microsoft Outlook \u2022 Microsoft Outlook is a personal information manager from Microsoft, available as a part of the Microsoft Office suite. \u2022 Although often used mainly as an email application, it also includes a calendar, task manager, contact manager, note taking, journal, and web browsing","You need to fill in the appropriate information about your email account. Here\u2019s a brief explanation of the different fields and what you should add in them: \u2022 Your Name: provide your name in this field; \u2022 E-mail address: type in your email address \u2013 [email protected] for example; \u2022 Account Type: select whether you want to use the IMAP or the POP3 protocol. We recommend that you use the IMAP protocol since it keeps your emails on the server and it\u2019s harder to lose information; \u2022 Incoming mail server: the server for incoming mails should be the mail subdomain of your domain name \u2013 yourdomain.com for example; \u2022 Outgoing mail server: again, use yourdomain.com as you entered for the incoming server; \u2022 User name: the username is your full email address. It will be used for both incoming and outgoing connections; \u2022 Password: enter the password for your email account;","Create a new email message 1. From any mail folder (such as your Inbox), choose New Email. Keyboard shortcut: To create an email message, press Ctrl+Shift+M. 2. When you\u2019re done composing your email, choose Send.","Add an email signature to messages Create personalized signatures that appear at the bottom of your messages. Signatures can include text, images, your Electronic Business Card, a logo, or even an image of your handwritten signature. Create a signature 1) In a new message, choose Signature >Signatures. 2) On the Email Signature tab, choose New. 3) Type a name and then choose OK. 4) Under Choose default signature, do the following: \u2022 In the E-mail account list, choose an email account to associate with the signature. \u2022 In the New messages list, choose the signature that you want to be added automatically to all new email messages. If you don't want to auto sign your email messages, you can ignore this option as (none) is the default value. \u2022 In the Replies\/forwards list, choose the signature that you want to be added automatically (auto sign) when you reply to or forward messages. Otherwise, accept the default option of (none). 5) Under Edit signature, type the signature, and then choose OK. Add a signature \u2022 In a new message, choose Signature, and then choose the signature that you want.","Forward or reply to an email message 1. On the ribbon or in the reading pane, choose Reply, Reply All, or Forward 2. In the To, Cc, or Bcc box, do one of the following: \u2022 To add a recipient, click in the appropriate box and enter the recipient's name. \u2022 To remove a recipient, click in the appropriate box, choose the recipient's name, and then press Delete.","Add an attachment to an email message \u2022 To share a file, you can attach it to your message. You can also attach other Outlook items, such as messages, contacts, or tasks. 1. Create a new message, or choose an existing message and choose Reply, Reply All, or Forward. 2. In the message window, choose Message > Attach File.","Open or save an email message attachment You can open an attachment from the reading pane or from an open message. After opening and viewing an attachment, you can save it. If a message has more than one attachment, you can save them as a group or one at a time. \u2022 Open an attachment \u2022 Depending on the version of Outlook you're using, there might be multiple options available to open an attachment. \u2022 Double-click the attachment. \u2022 Save an attachment \u2022 Choose the attachment in the reading pane or the open message. \u2022 On the Attachments tab, in the Actions group, choose Save As. You can also right-click the attachment, and then choose Save As.","Create a calendar appointment In Outlook, appointments aren\u2019t the same as meetings. Appointments are activities that you schedule in your calendar that don\u2019t involve inviting other people or reserving resources, such as a conference room or equipment. Click Calendar: In a Calendar folder, choose New Appointment. You can also right-click a time block in your calendar grid, and then choose New Appointment. Keyboard shortcut: To create an appointment, press Ctrl+Shift+A. Schedule a meeting: In Outlook, a meeting includes other people and can include resources such as conference rooms. You\u2019ll get responses to your meeting requests in your Inbox. \u2022 In a Calendar folder, choose New Meeting. Keyboard shortcut: To create a new meeting request from any folder in Outlook, press Ctrl+Shift+Q.","Set a reminder Reminders pop-up in an alert window so you don\u2019t miss an important deadline. You can set or remove reminders for almost anything in Outlook, including email messages, appointments, and contacts. \u2022 For appointments or meetings \u2022 Open an Appointment or Meeting, and then in the Reminder list box, choose the amount of time before the appointment or meeting when you want the reminder to appear. To turn off a reminder, choose None. \u2022 For email messages, contacts, and tasks \u2022 Choose Follow Up > Add Reminder.","Print an email message, contact, or calendar item In Outlook, you can print items such as email messages, contacts, calendar items, or larger views, such as calendars, address books, or content lists for Mail folders. 1. Choose an item or folder in Outlook that you want to print. 2. Choose File > Print.","Videos:- Video:- Beginner's Guide to Microsoft Office Web Apps: Excel, PowerPoint & Word : https:\/\/www.youtube.com\/watch?v=qNbX1qIz1uQ Video:- Microsoft Word in Just 30 minutes 2019 : https:\/\/www.youtube.com\/watch?v=AMpzKl72ULI Video:- Microsoft Excel 2019 Tutorial for Beginners #1 Overview - MS Office 365 : https:\/\/www.youtube.com\/watch?v=2xX-pUtSGmI Video:- Microsoft Excel Tutorial for Beginners : https:\/\/www.youtube.com\/watch?v=RdTozKPY_OQ Video:- MS PowerPoint in Just 30 minutes 2019 : https:\/\/www.youtube.com\/watch?v=L2kW-Bh9fjc Video:- Microsoft Outlook 2019 - Full Tutorial for Beginners : https:\/\/www.youtube.com\/watch?v=KfVORz5SsaU Video:- Microsoft Access 2016 Tutorial: A Comprehensive Guide to Access : https:\/\/www.youtube.com\/watch?v=1IA4SeajZRw","Making India Employable"]