Microsoft OfficeApply Now

Course Information

• Course Price 5000TK
• Place SETCOLBD Training Center
• Course Duration 12 weeks
• Course Start July 25, 2019

Details

Microsoft Office is the #1 office software used by +1 billion people worldwide. While many are familiar with Microsoft Office's basic features, few people know about its more advanced capabilities that are designed to save you time, money, and effort. For example, Visual Basic for Applications (VBA) for Excel will show you how to automate repetitive tasks and operations that you perform frequently. This valuable time saving tool and productivity enhancer is a critical tool for anyone who uses Excel frequently.

Most work today happens on a computer – optimize your effort by learning useful software tips and tricks that you'll apply for decades to come! And that will save you valuable time, money and effort. Want to get noticed by your boss or earn the respect of your colleagues? Become the office superstar by becoming the go-to expert on everything related to MS Office 2013!

Course Outline

Lesson-1

1. Microsoft Excel Essentials: Learn Excel Fundamentals!
2. Opening Excel and creating a shortcut
3. Using the Ribbon
4. Workbook Structure
5. Writing Formulas
6. Lists and Sorting

Lesson-2

1. Microsoft word Essentials: Learn word Fundamentals!
2. Exercise files, completed files and cheat sheets
3. Creating a formal business letter in ms word
4. Formatting a text like a pro
5. How to put text next to each other using a text box
6. How to add images and positioning the image
7. Beautiful design inspiration
8. creating a monthly company newsletter
9. Adding and croping images
10. Fixing and coloring images
11. Installing new fonts
12. Adding drop cap
13. How to change headings
14. How to make own custom styles
15. Work with multiple column layouts
16. How to work with comments & changes
17. How to work with tables

Lesson-3

1. Increase Your PowerPoint knowledge
2. Improve Your workflow & design skills
3. Shorten the time you need to complete a high quality presentation
4. Be able to brand and build templates for you, your company or your clients

Lesson-4

Microsoft Outlook

1. Introduction
2. Getting familiar with the Outlook interface
3. Explore and customize the status and navigation bar
4. Add, remove and sync an email account
5. Manually adding an IMAP
6. Syncing incoming and outgoing email
7. Add, remove and sync an email account
8. Connecting OneDrive to Outlook

Receiving Mail

1. Reading your email
2. Customize and explore different views
3. Working with file attachments
4. Searching sent and received emails
5. Creating a search folder
6. Syncing incoming and outgoing email
7. Flagging spam emails as junk
8. Using search and filter options

Organize and Arrange Mail

1. Using conditional formatting to distinguish emails
2. Categorizing emails and creating flags
3. Sort and Organize mail using folders
4. Using Quick Steps to control messages
5. Creating a search folder
6. Using mail rules to control messages
7. Archive and clean mailbox

Creating and Sending Mail

1. Compose a new email message
2. Replying to and forwarding a received message
3. Formatting a message
4. Creating voting buttons in a message
5. Adding a signature
6. Creating personal stationery
7. Exploring other mail settings

Calendar, Tasks, and Notes

1. Quick overview of the calendar
2. Explore and customize views
3. Creating a new meeting
4. Manage and Update meeting
5. Handling meeting requests
6. Emailing and printing a calendar
7. Create and switch between calendars
8. Creating more than one calendar
9. Changing the calendar options
10. Overview of tasks
11. Create and follow up on tasks
12. Create and customize notes

Backup, Restore and Advanced Options

1. Backup and export Outlook files
2. Creating Quick Parts
3. Changing general Outlook options