DAY 2: Microsoft Excel Basic Workshop

Good Morning, Dear Participants…!
Welcome to Day-2 Session of Microsoft Excel Basic Workshop. Please browse the following video lectures in sequence and also watch them in sequence…!

Lesson-3.2

Details of Insert tab

The content of this lesson is given below:

1. Inserting Charts.
2. Formatting the Charts.
3. Changing Chart Types from one to another.
4. Changing Chart Styles.
5. Changing Position of the Legends.
6. Changing Chart Title.

Lesson-4

Details of Page-Layout Tab

The content of this lesson is given below:

1. Adjusting the Margins of the worksheet.
2. Changing Page Orientation of the worksheet.
3. Adjusting Page Size of the worksheet.
4. Inserting Header and Footer. (Including Header/Footer Margins)
5. Setting the Print Area of the worksheet.
6. Sheet Options – (Viewing / Hiding Gridlines and Headings of the sheet)

Lesson-5

Details of View Tab

The content of this lesson is given below:

1. Different Sheet Views
2. Show/Hide Group – (Ruler, Formula Bar, Gridlines, Headings)
3. Zoom Group
4. Windows Group

MCQ Test

Solve this MCQ Test and test your performance. After submitting the test paper, you can instantly view scored marks. You can retake the test as many times as you like.

Solve Test Paper

Course Links

1. Day-1 Content
2. Day-3 Content