EmTech

• Microsoft Word


  Word processing software
• Formatting Text in Word

  1. Bold: Select text, press Ctrl + B

  2. Italics: Select text, press Ctrl + I

  3. Underline: Select text, press Ctrl + U

  4. Strikethrough: Select text, go to Home tab, Font group, click Strikethrough
• Inserting Images and Tables in Word

  1. Images: Go to Insert tab, click Pictures, select image, click Insert

  2. Tables: Go to Insert tab, click Table, choose table size
• Adding References in Word

  Go to References tab, click Insert Citation, fill in details
• Using Styles and Themes in Word

  1. Styles: Go to Home tab, Styles group, select style

  2. Themes: Go to Design tab, Themes group, select theme
• Creating a Table of Contents in Word

  Go to References tab, click Table of Contents, select style
• Tracking Changes and Adding Comments in Word

  1. Track Changes: Go to Review tab, Tracking group, click Track Changes

  2. Comments: Select text, go to Review tab, Comments group, click New Comment
• Advanced Techniques in Word

  1. Macros: Go to View tab, click Macros, select Record Macro, perform actions, click Stop Recording

  2. Linking and Embedding Objects: Go to Insert tab, click Object, select Create from File, click Browse, select file, check Link to file or Display as icon if needed

  3. Mail Merge: Go to Mailings tab, click Start Mail Merge, follow wizard
• Microsoft Excel


  Spreadsheet software
• Using Formulas and Functions in Excel

  1. Formulas: Start with = sign, followed by formula (e.g. =A1+B1)

  2. Functions: Start with = sign, followed by function name and arguments (e.g. =SUM(A1:A10))
• Creating and Formatting Charts in Excel

  1. Select data, go to Insert tab, choose chart type, select chart

  2. To format chart, select chart, use Chart Tools tabs
• Using Conditional Formatting in Excel

  Select cells, go to Home tab, Styles group, click Conditional Formatting, choose rule
• Sorting and Filtering Data in Excel

  Select data, go to Data tab, click Sort & Filter, choose sorting or filtering option
• Using Pivot Tables in Excel

  Select data, go to Insert tab, click PivotTable, follow wizard
• Data Validation in Excel

  Select cells, go to Data tab, Data Tools group, click Data Validation, set criteria
• Advanced Techniques in Excel

  1. Macros: Go to View tab, click Macros, select Record Macro, perform actions, click Stop Recording

  2. Dynamic Charts: Create chart based on named range that dynamically updates

  3. VLOOKUP and INDEX/MATCH: Use =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) or =INDEX(range, MATCH(lookup_value, lookup_range, match_type))

  4. Interactive Dashboards: Use pivot tables, charts, slicers, other features to create dynamic, interactive dashboards
• Microsoft PowerPoint


  Presentation software
• Adding Transitions and Animations in PowerPoint

  1. Transitions: Select slide, go to Transitions tab, choose transition

  2. Animations: Select object, go to Animations tab, choose animation
• Embedding Videos in PowerPoint

  Go to Insert tab, click Video, choose Video on My PC...
• Using Slide Master in PowerPoint

  Go to View tab, click Slide Master, make changes as needed
• Inserting and Formatting Shapes and Text Boxes in PowerPoint

  1. Shapes: Go to Insert tab, click Shapes, choose shape

  2. Text Boxes: Go to Insert tab, click Text Box, draw text box

  3. To format, select shape or text box, use Format tab
• Hyperlinking in PowerPoint


  Select text or object, right-click, choose Hyperlink..., enter link
• Using Presenter View in PowerPoint

  Go to Slide Show tab, Monitors group, check Use Presenter View
• Advanced Techniques in PowerPoint

  1. Macros: Go to View tab, click Macros, select Record Macro, perform actions, click Stop Recording

  2. Embedding Excel Data: Go to Insert tab, click Object, select Create from File, click Browse, select Excel file, click OK

  3. Interactive Presentations with Action Buttons: Go to Insert tab, click Shapes, choose action button, draw it, set hyperlink or macro
• Microsoft Outlook

  Email and calendar software
• Sending and Receiving Emails in Outlook


  1. Sending: Click New Email, fill in details, click Send

  2. Receiving: Emails appear in Inbox, if not click Send/Receive
• Organizing Emails with Folders and Rules in Outlook

  1. Folders: Right-click Inbox, click New Folder, name it

  2. Rules: Go to Home tab, Move group, click Rules, choose Create Rule
• Scheduling Meetings in Outlook

  Go to Home tab, New group, click New Items, choose Meeting
• Using the Calendar in Outlook

  Click Calendar icon in Navigation Pane, view by day, week, month, or schedule
• Setting Up Automatic Replies in Outlook

  Go to File tab, click Automatic Replies, set options, click OK
• Managing Contacts in Outlook

  Go to People icon in Navigation Pane, click New Contact, fill in details, click Save & Close
• Advanced Techniques in Outlook

  1. Automating Email Management with Rules: Go to Home tab, Move group, click Rules, choose Manage Rules & Alerts

  2. Automating Common Tasks with Quick Steps: Go to Home tab, Quick Steps group, click Create New

  3. Integrating Outlook with Other Applications: Go to File tab, click Options, click Add-Ins, manage add-ins
• What are the other 3 advanced features/ techniques in MS Word?

  Mail merge, macros, linking and embedding objects