CERTIFICATE OF COMPLETION – MD. SOHEL RANA

This is to certify that Md. Sohel Rana successfully completed the hands-on training on Microsoft Office Applications (Computer Basic).

Taught by: Sadhan Verma, Data Science Instructor at NBICT LAB’s e-learning platform
Course Duration: 6 Month
Learner’s Email Address: rana.sohel.1226@gmail.com

Course Contents:

Subject: Windows

Lesson – 1: Boost up Your Windows Performance

1. Why does Windows become slow?
2. How to clean the temporary junk files
3. How to clean the memory
4. How to disable unnecessary startup applications
5. How to take action against malware

Lesson – 2: Windows 10/11 Installation

1. How to download Windows 10/11
2. How to download Rufus for creating a bootable Pendrive
3. How to check the hard disk partition scheme
4. How to make a Pendrive bootable for installing Windows 10/11
5. Precautions before installing Windows 10/11
6. Removing the necessary files to the safe location
7. Checking the SSD to see if it exists
8. Checking the size of the C: partition
9. How to install Windows 10/11 using a bootable Pendrive
10. How to bring the “This PC” icon on the desktop
11. How to install Microsoft Office 2019
12. How to activate Windows 10/11
13. How to check for Windows 10/11 updates

Lesson – 3: Miscellaneous

1. Creating a guest user account
2. Customization & Personalization of Windows Account
3. How to uninstall unnecessary applications
4. Signing in to Windows using Microsoft Account
5. How to take screenshots
6. BitLocker drive encryption

Subject: Internet

Lesson – 1: How to Use OneDrive

1. What is OneDrive?
2. Downloading OneDrive
3. Installing OneDrive
4. Setting up OneDrive Desktop
5. Understanding OneDrive on Browser
6. Assignment submission procedure

Lesson – 2: Microsoft Edge Browser Personalization

1. Downloading & installing Microsoft Edge
2. Adding a Microsoft account to Edge
3. Setting the home page & startup page
4. Changing the search engine used in the address bar
5. Working with bookmarks
6. Assignment submission procedure

Lesson – 3: Emailing with Etiquettes and Best Practices

1. Introducing Grammarly
2. Understanding to, cc, & bcc
3. Writing a message body
4. Creating an email signature
5. Creating email templates
6. Schedule emailing
7. Assignment submission procedure

Lesson – 4: Google Account Management

1. How to personalize Google account
2. How to maintain the security of a Google account
3. How to maintain the privacy of a Google account
4. How to manage the history settings of the Google account

Lesson – 5: LinkedIn Account Management

1. What is LinkedIn?
2. Why LinkedIn account is essential?
3. Criteria of a complete LinkedIn profile
4. Assignment submission procedure

Subject: Typing Speed

Lesson – 1: How to Improve Typing Speed

1. Creating an account on the RataType
2. How to progress on RataType
3. How to boost up your typing speed
4. How to get a typing speed certificate from RataType
5. Assignment submission procedure

Subject: Microsoft Word

Lesson – 1: Getting Familiar with the Microsoft Word Environment

1. How to open the Microsoft Word program
2. The start screen
3. The quick access toolbar
4. The ribbon and tabs
5. Ribbon display options
6. The Ruler
7. The status bar
8. Page view options
9. Zoom control
10. The backstage view

Lesson – 2: Writing Bangla with Avro & Bijoy

1. Installing Avro
2. Installing some Avro fonts
3. How to write Bangla using Avro
4. Installing Bijoy
5. Installing some Bijoy fonts
6. How to write Bangla using Bijoy
7. Avro to Bijoy conversion

Lesson – 3: Making a Resume & CV

1. Saving the document
2. Working with shapes
3. Working with images
4. Working with text boxes
5. Working with tables
6. Working with lists
7. …..
8. …..

Subject: Microsoft PowerPoint

Lesson – 1: Presentation & Slide Basics

1. What is a presentation?
2. Getting familiar with the PowerPoint environment
3. How to insert a new slide
4. Duplicating, moving, & deleting slides
5. How to copy & paste slides
6. How to play the presentation
7. How to change the slide size
8. How to format the slide background
9. How to apply a theme

Lesson – 2: A Project on Presentation Slides Design

1. Saving an image background to your computer
2. Setting an image as a slide background
3. Working with the slide master view
4. Working with text shadows
5. Changing cases
6. Creating text box outlines
7. How to draw and resize a shape
8. How to change the fill color of a shape
9. How to change the outline color of a shape
10. How to write in a shape
11. Working with text boxes
12. How to adjust text alignment in a box
13. How to insert and resize a picture
14. Adding glowing effects to a shape
15. Modifying shapes
16. Modifying shadow effects
17. How to edit a shape by using the editing handles
18. How to make shape edge soft
19. How to customize shadow options

Lesson – 3: Animations & Transitions

1. Collecting necessary practice files
2. How to apply an animation to an object
3. How to remove an animation
4. How to add multiple animations to an object
5. How to reorder the animations
6. How to copy animations with the animation painter
7. Working in the animation pane
8. How to change effects start option
9. How to change the effect timing

Lesson – 4: Hyperlinks, Action Buttons, and SmartArt Graphics

1. Collecting necessary practice files
2. How to insert a hyperlink
3. How to open and test a hyperlink
4. How to remove hyperlinks
5. How to insert an action button on one slide
6. How to insert the action button on all slides
7. How to edit the action button
8. Working with SmartArt Graphics

Lesson – 5: Rehearsing and Recording Your Presentation

1. How to rehearse timings
2. How to record a slide show
3. How to remove slide timings

Subject: Microsoft Excel

Lesson – 1: Cell Basics & Formatting

1. Getting familiar with the Microsoft Excel environment
2. How to enter data in Microsoft Excel
3. How to insert new rows/columns
4. How to change row height & column width
5. How to merge cells
6. How to use the fill handle
7. How to align text in cells
8. How to change the fill color & text color
9. How to set borders around cells
10. How to change border color & style
11. How to wrap texts
12. How to generate random numbers
13. How to format paste options
14. How to set currency symbol

Lesson – 2: Formulas, Functions, & Cell References

1. How to create a formula using cell references
2. How to use a function
3. Basic functions of Microsoft Excel: SUM, AVERAGE, MAX, MIN
4. Using cell references with multiple worksheets
5. Difference between relative & absolute cell references

Lesson – 3: The Practical Uses of IF() Function

1. How to use the IF() function
2. How to prepare a result sheet using the IF() function

Lesson – 4: The Practical Uses of VLOOKUP() Function

1. How to use the VLOOKUP() function
2. How to prepare a result sheet using the VLOOKUP() function

Lesson – 5: The Practical Uses of SUMIF() Function

1. Basic understanding of the SUMIF() function
2. Understanding data validation
3. Creating a name for a range
4. Practical uses of the SUMIF() function

Lesson – 6: Freezing and Sorting

1. How to freeze columns
2. How to freeze rows
3. How to sort a column in ascending/descending order
4. How to sort a cell range
5. How to create a custom sort
6. How to sort by multiple levels

Lesson – 7: Filtering Data

1. How to filter data
2. How to apply multiple filters
3. How to clear a filter
4. How to filter with a search
5. How to use the advanced text filters
6. How to use advanced number filters
7. How to use the advanced date filters

Lesson – 8: Charts and Conditional Formatting

1. Understanding charts
2. How to insert a chart
3. Working with chart layout and style
4. Adding chart elements
5. Editing chart elements
6. Quick Layout
7. Changing chart styles
8. Switching row and column data
9. Changing the chart type
10. Moving a chart
11. Keeping charts up to date
12. Understanding conditional formatting
13. How to create a conditional formatting rule
14. How to apply multiple conditional formatting rules
15. How to use preset conditional formatting
16. How to remove conditional formatting

Lesson – 9: PivotTables

1. Conditions for creating a PivotTable
2. How to insert a PivotTable
3. Inserting a PivotTable on the same worksheet
4. Inserting a PivotTable on a different/new worksheet
5. Getting familiar with PivotTable fields
6. Working with count
7. Working with calculated field
8. How to change the value field settings
9. Working with the value-showing options
10. Graphical visualization of data
11. Working with the chart options