This course provides a complete introduction to Microsoft Excel, starting from the basics and progressing to advanced features. Each lecture in the list below covers key concepts such as worksheets, formulas, functions, charts, data management, and more — designed to help students master Excel for both academic and professional use.
Lecture # 01
MS Excel Software
Information
What are MS Excel,
History of MS Excel, and Benefits of MS Excel?
Click here to Find →Class
Notes | →Video Lecture
Lecture # 02
MS Excel Downloading
and Installation
How to Free Download
and Install MS Excel Software on Computer
Click here to Find →Class
Notes | →Video Lecture
Lecture # 03
MS Excel Basic
Overview or Screen Elements
Title Bar, Tab Bar,
Property Bar, Formula Bar, Cell Name Box, Worksheet, States Bar, Scroll
Click here to Find →Class
Notes | →Video Lecture
Lecture # 04
MS Excel Worksheet
Overview
Worksheet, Rows,
Columns and Cells information
Click here to Find →Class
Notes | →Video Lecture
Lecture # 05
MS Excel Arithmetic
Series
How or Draw
Arithmetic Series in Excel
Click here to Find →Class
Notes | →Video Lecture
Lecture # 06
MS Excel – Home Tab →
Font Group
Font Face, Font Size,
Grow Font, Shrink Font, Clear Formatting, Bold, Italic etc…
Click here to Find →Class
Notes | →Video Lecture
Lecture # 07
MS Excel – Home Tab →
Alignment Group
Bullets, Numbering,
Multilevel List, Decrease & Increase Indent, Text Direction etc…
Click here to Find →Class
Notes | →Video Lecture
Lecture # 08
MS Excel – Home Tab →
Clipboard Group
Format Painter, Cut,
Copy, Past and Past Special.
Click here to Find →Class
Notes | →Video Lecture
Lecture # 09
MS Excel – Home Tab →
Number Group
Number Format,
Accounting Mumber Format, Percent Style, Comma Style etc…
Click here to Find →Class
Notes | →Video Lecture
Lecture # 10
MS Excel – Home Tab →
Styles Group
Conditional
Formatting, Format as Table, Cell Styles.
Click here to Find →Class
Notes | →Video Lecture
Lecture # 11
MS Excel – Home Tab →
Cells Group
Insert Cells, Delete
Cells, Format, Cell Size, Visibility, Organize Sheets, Protection.
Click here to Find →Class
Notes | →Video Lecture
Lecture # 12
MS Excel – Home Tab →
Editing Group
Sum, Fill, Clear,
Sort & Filter, Find & Select etc...
Click here to Find →Class
Notes | →Video Lecture
Lecture # 13
MS Excel – Important
Formulas
Basic Calcolation,
Income & Expences Sheet, Very Important Formulas.
Click here to Find →Class
Notes | →Video Lecture
Lecture # 14
MS Excel – List
Making
Any Type of List
Making like Rate List, Employee List etc…
Click here to Find →Class
Notes | →Video Lecture
Lecture # 15
MS Excel – Data Entry
and Data Base Sheet
Student Record Data
Entry and Data Base Sheet Making.
Click here to Find →Class
Notes | →Video Lecture
Lecture # 16
MS Excel – Reference
Sheet
Uses of Variable
Reference and Fix Reference, Table of 2 basic Calculation.
Click here to Find →Class
Notes | →Video Lecture
Lecture # 17
MS Excel – Insert Tab
→ Tables Group
Uses of Table and
Pivot Table, Pivot Chart.
Click here to Find →Class
Notes | →Video Lecture
Lecture # 18
MS Excel – Insert Tab
→ Illustrations Group – Picture & Clip Art
How to Insert Picture
and Clip Art in Microsoft Excel.
Click here to Find →Class
Notes | →Video Lecture
Lecture # 19
MS Excel – Insert Tab
→ Illustrations Group – Shapes & Smart Art
How to Insert Shapes
and Smart Art in Microsoft Excel.
Click here to Find →Class
Notes | →Video Lecture
Lecture # 20
MS Excel – Insert Tab
→ Illustrations Group - Chart
How to create and
format Chart in MS Excel.
Click here to Find →Class
Notes | →Video Lecture
Lecture # 21
MS Excel – Insert Tab
→ Links Group
Insert Hyperlink,
Bookmark, Cross-reference
Click here to Find →Class
Notes | →Video Lecture
Lecture # 22
MS Excel – Insert Tab
→ Text Group
Text Box, Word Art,
Signature Line, Symbols.
Click here to Find →Class
Notes | →Video Lecture
Lecture # 23
MS Excel – Page
Layout Tab → Themes Group
Uses of Theme Colors,
Themes Fonts and Themes Effects
Click here to Find →Class
Notes | →Video Lecture
Lecture # 24
MS Excel – Page
Layout Tab → Page Setup Group
Uses of Margins,
Orientation, Page Size, Columns, Breaks, Line Numbers, Hyphenation
Click here to Find →Class
Notes | →Video Lecture
Lecture # 25
MS Excel – Page
Layout Tab → Scale to Fit
Width, Hight and
Scale Sheet Options in Excel
Click here to Find →Class
Notes | →Video Lecture
Lecture # 26
MS Excel – Page
Layout Tab → Sheet Options
Sheet Right to Left,
View Grid lines, Print Grid-lines, View Heading, Print Headings.
Click here to Find →Class
Notes | →Video Lecture
Lecture # 27
MS Excel – Page
Layout Tab → Arrange Group
Position, Bring to
Front, Sent to Back, Text Wrapping, Align, Group or Ungroup, Rotate
Click here to Find →Class
Notes | →Video Lecture
Lecture # 28
MS Excel – Account
Work Part 1
Bill Book, Invoice,
Result Sheet, Report Card etc…
Click here to Find →Class
Notes | →Video Lecture
Lecture # 29
MS Excel – Account
Work Part 2
Daily Balance Sheet
and Monthly Balance Sheet Making.
Click here to Find →Class
Notes | →Video Lecture
Lecture # 30
MS Excel – Result /
Marks Sheet Making Part 1
Result Sheet
Parentage and Result Making.
Click here to Find →Class
Notes | →Video Lecture
Lecture # 31
MS Excel – Result /
Marks Sheet Making Part 2
If Can-diction Grade
Sheet Making.
Click here to Find →Class
Notes | →Video Lecture
Lecture # 32
MS Excel – Office
Button
Save and Print
setting, Page range, Number of copies and Printer Properties
Click here to Find →Class
Notes | →Video Lecture
No comments:
Post a Comment