DAY 1: Microsoft Excel Basic Workshop

Good Morning, Dear Participants…!
Welcome to Day-1 Session of Microsoft Excel Basic Workshop. Please watch following video lectures in sequence…!

Contents

Watch this introductory video first so that you will get complete idea of the workshop content for 3 days duration.

• File tab
  • How to Create New Excel Sheet?
  • How to Save, open, share, and print the Excel worksheet?
  • Difference between ‘Save’ and ‘SaveAs’.
• Home tab
  • Alignments
  • Wrap Text
  • Merge and Center
  • How to insert/delete rows, columns and sheet?
  • Sort and Filter
  • Find and Replace
• Insert tab
  • How to insert and format tables in Excel?
  • How to insert pictures?
  • How to insert and format charts?
  • How to change one chart type to another?
  • What is Sparkline? How to use it?
  • What is Hyperlink?
  • How to insert Header and Footer?
• Page-Layout Tab
  • Margins
  • Orientation
  • Page Size
  • How to set the print area?
• Some extra tips and tricks of Excel
  • Basic Shortcuts
  • Auto fill
  • Spreadsheet Views

Lesson-1

Details of File Tab

The content of this lesson is given below:

1. Creating a New Worksheet.
2. Saving a Worksheet.
3. Opening already saved Worksheet.
4. Sharing the Worksheet.
5. Printing the Worksheet.
6. Creating the PDF file of the Worksheet.
7. Checking the Location of the saved Worksheet.
8. Difference between ‘Save’ and ‘Save As’ commands.

Lesson-2

Details of Home Tab

The content of this lesson is given below:

1. Clipboard Group – (Cut, Copy, Paste, Format Painter)
2. Font Group – (Font Color, Cell Color, Font Size, Font Family, Borders)
3. Alignment Group – (Alignments, Wrap Text, Merge and Center)
4. Cells Group – (Inserting, Deleting and Formatting Rows, Columns and Sheets)
5. Editing Group – (Sort and Filter, Find and Replace)

Lesson-3.1

Details of Insert Tab

The content of this lesson is given below:

1. Inserting Pictures.
2. Inserting Online Pictures.
3. Inserting Spark Lines.
4. Inserting Hyperlinks.
5. Appling WordArt Effects.

Instructor

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-2 Content
2. Day-3 Content